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

Suljettu Julkaistu 5 vuotta sitten Maksettu toimituksen yhteydessä
Suljettu 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.

AWS Lambda HTML5 Node.js Python

Projektin tunnus: #17986377

Tietoa projektista

18 ehdotusta Etäprojekti Aktiivinen 5 vuotta sitten

18 freelanceria on tarjonnut keskimäärin $214 tähän työhön

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 Lisää

$35 USD 3 päivässä
(27 arvostelua)
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 3 päivässä
(27 arvostelua)
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 Lisää

$180 USD 3 päivässä
(34 arvostelua)
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. Lisää

$200 USD 3 päivässä
(16 arvostelua)
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 2 päivässä
(30 arvostelua)
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 Lisää

$250 USD 5 päivässä
(7 arvostelua)
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 Lisää

$125 USD 10 päivässä
(6 arvostelua)
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 4 päivässä
(2 arvostelua)
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, Lisää

$250 USD 3 päivässä
(2 arvostelua)
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 Lisää

$333 USD 7 päivässä
(0 arvostelua)
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 Lisää

$155 USD 3 päivässä
(0 arvostelua)
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 Lisää

$150 USD 3 päivässä
(0 arvostelua)
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 Lisää

$111 USD 10 päivässä
(0 arvostelua)
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 3 päivässä
(0 arvostelua)
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 Lisää

$155 USD 3 päivässä
(0 arvostelua)
0.0