Extract data from SQL Database and save in a JSON text file - TO BE CODED IN CLASSIC ASP - 29/04/2018 19:26 EDT
£10-50 GBP
Completed
Posted almost 6 years ago
£10-50 GBP
Paid on delivery
This project will read data from a SQL database and save the output to a JSON text file.
The SQL database consists of 2 tables (repair det & repair hist) and within these 2 tables, 2 columns will be used from 1 table (booking code & fault) and from the other table (repair history).
Here is a brief look at how the tables are structured:
Repair det
Booking_code Fault
11232 No brakes
11233 Working, but no ignition
11234 Flat tyre
Repair Hist
Booking_code Repair_history
11232 Repaired rubber hose going to – outline pipe
11232 Return value stuck in bottom
11232 Replaced all stuck valves
11233 Checked wiring all ok – to be investigated
11233 Found relay stuck in on position
11233 Relay on order
11232 Brakes need bleeding
11234 Found nail in tyre – needs replacing
11233 Fitted relay all working
11232 Brakes done – all fixed
11234 Replaced tyre – work completed
11234 Finished
From the above I require the JSON result to look like this in a text file:
{
"data": [{
"booking_code": "11232",
"fault": " No brakes ",
"product": [
" Repaired rubber hose going to – outline pipe ",
" Return value stuck in bottom ",
" Replaced all stuck valves ",
" Brakes need bleeding ",
" Brakes done – all fixed"
]
},
{
"booking_code": "11233",
"fault": " Working, but no ignition ",
"product": [
" Checked wiring all ok – to be investigated ",
" Relay on order ",
" Fitted relay all working "
]
},
{
"booking_code": "11234",
"fault": " Flat tyre ",
"product": [
" Found nail in tyre – needs replacing ",
" Replaced tyre – work completed ",
"Finished"
]
}
]
}
The above database is only an example, the database that I need converting will have over 2000 records so I require the script to load quickly
• I will supply the connection string to connect to the SQL database
• You must use your own SERVER for testing
• The JSON text file name for saving the output will be called [login to view URL]
• All coding MUST be writing in classic ASP
I require that the programmer be competent and have a very good knowledge in SQL, JSON and Classic ASP. I expect on-time delivery.
Hello, I have good experience in classic asp and can do this job for you as mentioned in description.
will give you Jon output in same format you have mentioned.
Please let me know when to discuss.
£50 GBP in 1 day
4.9 (5 reviews)
3.0
3.0
2 freelancers are bidding on average £50 GBP for this job