Build Application to import extracted values from TXT file URL downloaded Zipped JSON files into MSSQL Database

Completed Posted 5 years ago Paid on delivery
Completed Paid on delivery

Everyday we get a amazon custom file with additional order informations. In the TAB seperated TXT file mentioned URLs for download a ZIP file for each customized order. Note: Not all orders are customized which means that not for every order is a URL in the list. In the ZIP file is a JSON file with all the customization details. We need several values from all the JSON files imported in MSSQL Database.

1. Extract all URLs from specific Column in TAB separated TXT File

2. Unzip all ZIP Files with JSON files inside (For each customized order is one or more ZIP File. Inside ZIP File is only one JSON)

3. Extract values from JSON files

4. Import extracted values to MSSQL Database

We want to receive a windows application were we can upload everyday the TXT file. The application should do the steps mentioned above and should show result for the finished progress.

Please see attached files and description carefully.

Data Extraction Data Processing JSON Software Development SQL

Project ID: #18522180

About the project

11 proposals Remote project Active 5 years ago

Awarded to:

zhangyingtai

Hello sir Thanks for job posting. The job description is very clear and I am confident with it. I can make a python script to do the actions you want. I can deliver the scrip in 3 days and teach how to use it. I More

€388 EUR in 3 days
(21 Reviews)
5.9

11 freelancers are bidding on average €493 for this job

DebasisB

Hi there, I am interested in the project. Could you please specify the fields you want to import from JSON file? There is array type data under "surfaces", do you want to save each entry as related data in a separate t More

€555 EUR in 5 days
(27 Reviews)
5.4
iramrao

I can write this application to parse imported data. I have already done many of such applications before. Lets speak in detail. Looking forward to hear from you. Thanks

€555 EUR in 10 days
(3 Reviews)
4.7
bestit4u

Hi. I am very interested in your project, because I have much experience in such projects. I have good skills with the program language including C/C++, C#, java, php, asp.net, python, VB.NET. So I have expert and s More

€555 EUR in 10 days
(15 Reviews)
5.4
mahershahmeer

Hi there, We are Team Wurfel, one of the best branding agencies in Islamabad, Pakistan. We own a professional and highly skilled team of developers, designers, coders, Android, iOS, SEO, and SMM experts. We have re More

€555 EUR in 14 days
(11 Reviews)
4.8
brianconey

Hello How are you I have read your job description in detail . I am Xu as It is a piece of cake Please contact me and Let's discuss more thanks for your posting . hope to hear from you .

€555 EUR in 10 days
(11 Reviews)
4.5
gpnr2017

Hello, Hope you are doing well. I have gone through the project requirement of json data download and update in sql sever. I find my self in good position to complete this project using .net technologies. You will More

€350 EUR in 10 days
(8 Reviews)
3.3
nidhicyber

Hello, how are you? I am very interested in your project. I have read your description very carefully. I can do your job on time. I am new on freelancer but I have a positive attitude toward work. Money does More

€250 EUR in 10 days
(2 Reviews)
2.9
ekoomitsolution

Hi, We would like to Design and Build your online store / personal website / simple website / Management CRM application, We would like to provide you Website Design and then you select it and then if changes need we c More

€555 EUR in 10 days
(2 Reviews)
1.7
mohdfarhantahir

i have read all your requirements and we have build many desktop application (.exe) we can do your project in 15 days . we will happy to work with your organization . thanks and regards please consider my message.

€722 EUR in 15 days
(0 Reviews)
0.0