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

Închis Postat la acum 5 ani S-au achitat serviciile după ce au fost prestate
Închis S-au achitat serviciile după ce au fost prestate

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.

AWS Lambda HTML5 Node.js Python

ID Proiect: #17986377

Detalii despre proiect

18 propuneri Proiect la distanță Activ acum 5 ani

18 freelanceri plasează o ofertă medie de 214$ pentru proiect

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 Mai multe

$35 USD în 3 zile
(27 recenzii)
6.5
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

$333 USD în 3 zile
(27 recenzii)
6.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 Mai multe

$180 USD în 3 zile
(34 recenzii)
5.8
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. Mai multe

$200 USD în 3 zile
(16 recenzii)
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.

$140 USD în 2 zile
(30 recenzii)
5.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 Mai multe

$250 USD în 5 zile
(7 recenzii)
3.5
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 Mai multe

$125 USD în 10 zile
(6 recenzii)
2.8
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

$111 USD în 4 zile
(2 recenzii)
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, Mai multe

$250 USD în 3 zile
(2 recenzii)
1.8
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 Mai multe

$333 USD în 7 zile
(0 recenzii)
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 Mai multe

$155 USD în 3 zile
(0 recenzii)
0.0
TijanaD81

Hello, Your proposition for a solution is rather reasonable considering the requirements for UI or other functionality are minimal. There would be a small JS UI stored in S3 that would trigger lamda execution via th Mai multe

$150 USD în 3 zile
(0 recenzii)
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 Mai multe

$111 USD în 10 zile
(0 recenzii)
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 :)

$222 USD în 3 zile
(0 recenzii)
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 Mai multe

$155 USD în 3 zile
(0 recenzii)
0.0