Web Application to Automate Manipulation of Spreadsheet / CSV Data using AWS, S3 & Lambda
$30-250 USD
Maksettu toimituksen yhteydessä
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.
Projektin tunnus: #17986377
Tietoa projektista
18 freelanceria on tarjonnut keskimäärin $214 tähän työhön
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 Lisää
https://www.freelancer.com/projects/Python/Qualitative-Comparative-Study-Face-13933384/ https://www.freelancer.com/projects/php/License-Plate-Detection-With-Chinese/ lets chat
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 Lisää
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.
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 Lisää
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
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 Lisää
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 Lisää
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 Lisää
Perfect for my skill set, I actually do data conversion for my own personal company. This projects sounds like like what I normally do :)