Fermé

Web Application to Automate Manipulation of Spreadsheet / CSV Data using AWS, S3 & Lambda

We're a Healthcare staffing company in the Atlanta, Georgia area. We have a manual process that needs to be automated. This process involves manipulating an input file using reference data from three other reference files to produce an output file. Each of the files is a CSV/XLS file.

There are three(3) reference datasets -- call them REF-A, REF-B, and REF-C. There is an input dataset in another CSV/XLS file (INPUT) which must be manipulated to create the output file (OUTPUT).

The current process involves adding spreadsheet columns, moving data around, inserting lookups to the reference files, and manipulating some fields (eg. adding or removing hyphens from social security number, searching field for a substring, etc. All of these things can be done programmatically while parsing the input file.

What I envision is a password protected web application that allows the three reference files to be uploaded. Then, an input file is uploaded, click a button which causes the file to be processed and provides a link to download the output file. The process can be repeated over and over using additional input files.

I'm open to implementation discussion and various architectural/implementation strategies. But, I have a strong preference to a server less implementation using AWS Lambda functions and S3 object store. Could be implemented in Java, Node.js or python. Can use other AWS services but would like a minimal cost approach.

Compétences : Aws Lambda, HTML5, node.js, Python

en voir plus : php create table csv data, insert data using file csv sysutil, csv data feed web page, import csv mysql using web form, import data csv file using dts wizard, application automate web surfing, capture web site data using robots, sugarcrm click attachment open application, export crm data using web service, retrieve data csv file using javascript, using data csv file using javascript, data manipulation excel csv file, excel csv data manipulation, download web page existing excel spreadsheet using vbscript, import data csv access using vb6, using turbo lister import csv data template, csv data manipulation, fill in a spreadsheet with data using a two tabbed file, simple web scraping fill in a spreadsheet with data, extract data from csv files using R

Concernant l'employeur :
( 0 commentaires ) College Park, United States

Nº du projet : #17986377

21 freelance font une offre moyenne de $217 pour ce travail

bluediscover

Hi, As you can see on my profile, I have expertise in AWS products. I can develop well architectured project with AWS Lambda, S3, etc. For serverless I prefer to use python. Looking forward to discussing in cha Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(59 Commentaires)
7.2
shadabkhan92

https://www.freelancer.com/projects/Python/Qualitative-Comparative-Study-Face-13933384/ https://www.freelancer.com/projects/php/License-Plate-Detection-With-Chinese/ lets chat

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(24 Commentaires)
6.2
leemilun

Hi, Dear. Nice to meet you. I've read your post carefully. I'm Python/Web expert. Please discuss more details on chatting room. Regards. Gao M.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(18 Commentaires)
5.3
schoudhary1553

This is Vibrant Webtech and I was glad to see that you're looking for help for project Web Application to Automate Manipulation of Spreadsheet. I've delivered more than 400 + projects in the last 5 years and this mak Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(21 Commentaires)
5.3
adeelpirzada

Hi, I am a Senior Software with more than 10 years of experience in .Net-stack development. I have developed dozens on Desktop Apps, Utilities, Automation Tools, Machine Learning Tools, Web Apps using Python, C# and Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(7 Commentaires)
5.1
DarkKnight2206

Hello! I am a python developer. I looked at your project and it seems interesting. I have all necessary skills required for this project. Ping me to discuss in detail.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(22 Commentaires)
5.1
novepi

Hi there, The requirement are quite clear and straightforward to implement so no questions really. All I need from your end is detailed instructions for the data manipulations by using sample files if possible. Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(6 Commentaires)
4.3
teguhpanjaitan

Hi, I'm a full stack developer. I'm working with AWS everyday and know how to do it with serverless method (S3 & Lambda). I would propose to modify the spreadsheet using PHP in lambda function. Please consider my bid Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(4 Commentaires)
3.3
Nerdulent

Hi.... By when do you expect it to be delivered?? Thanks

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(5 Commentaires)
2.8
coriandercode

Hi! My name is Mohd. And I am an expert Desiner & Developer. I can do your task as you posted as i am having similar work done exp. That is why i am best fit for [login to view URL] contact me asap so that i serve you b Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(5 Commentaires)
2.9
nagarajdvdg2009

Hi, I have 8 years of experience in Software development. I have good knowledge on AWS and Lamda. Hope we can have more conversation about the requiremnt

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(2 Commentaires)
2.1
gwpuck89

Hi there, I'm a fairly well-experienced AWS devops engineer *and* web developer and I'd be happy to help you with this project. I think your idea of using Lambda/S3 is probably the least expensive route. However, Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(2 Commentaires)
1.8
mkdara

Hi there, I'm grateful that you spared a part of your precious time for having a look at my proposal. I expertise in the field which is required in your project and I will deliver complete satisfactory work. I have en Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(1 Évaluation)
2.0
agrawal92

Hi, I can help you in implementing the mentioned requirements using Python along with AWS services. I've worked on a similar project before where I've integrated services like AWS Lambda, Step Functions, AWS Glue and A Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(3 Commentaires)
1.6
WebDevPro007

I can provide a process with input and output directories I'm already doing it for a client called Ubits You will have mail notification and logs we can also provide SMS notification if you want. Looking forward Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
0.0
freelanceSpider

Hello sir Manipulation of excel/csv is quite possible in browser itself with background web worker, provided files are not too big. Although we can save generated files in S3 and if required further can be automated w Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(0 Commentaires)
0.0
caseyuhrig

Perfect for my skill set, I actually do data conversion for my own personal company. This projects sounds like like what I normally do :)

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
rasta714

You have not talked about how you want the front end presented ( except that password protected web application ), so I am a little concerned on how much work and polish you require on the presentation level.I have bee Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
DimuDesigns

Hello, Interested in the job. I am a Software Engineer specializing in end-to-end Web Development with expertise building applications that utilize Google's Cloud Platform (GCP). GCP is Google's server-less eq Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 21 jours
(0 Commentaires)
0.0
webdevgirl528

We have successfully completed several commercial contracts of varied scope and size in 2018. We specialize in design and building software, Artificial Intelligence, Data Science, Databases, websites, SEO, Graphic and Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0