Generate JSON Files from txt import on Ubuntu Server
$30-250 USD
Paid on delivery
Below required on ubuntu/apache virtual web server to achieve:
1. Process every 1-hour txt file received through ftp into ubuntu server.
a. The txt file has 20 columns and about 5000 rows
2. Write software to automatically calculate every 1 hr. data in 3 columns based on system date/time/time zone and holiday schedule YYMMDD (need feature to load holiday schedule from csv file).
eg #1 : input data is "1" and system day of week is weekday (and not holiday) and system time before 12 Noon EST, then change that 1 to specific text,
eg #2 : input data is "1" and system day is weekend or holiday and system time after 12 Noon EST, then change that 1 to specific text
eg # 3 : split data in particular column to 3 fields.
a. Require some server configuration skills including Database programming, Client/Server-side programming
b. Testing/Debugging of json files to ensure correct parsing of data for websites.
3. Output:
a. Generate data based on after above calculation in separate json files (about 400) with filenames as based in 1 column of imported data.
b. The content of json file will have data from 15 columns (imported from txt file) and another 3 fields in each json file of calculation results from step # 2. above
c. JSON files will be updated/overwritten at each processing
d. The processed json data will be accessed by remote server through web.
4. Implement validation checks to each row data.
5. Send status summary after each processing to ftp but json files will remain in server to be accessed by remote website user's browsers.
BID must provide detail proposal including application you shall use for each and process. e.g. database, Web server, scripting language, etc. Also include reference/experience of projects related to this project. If you do NOT have reference, do NOT Bid.
Thank you
Project ID: #16163064
About the project
11 freelancers are bidding on average $182 for this job
Hi there, Does the TXT filename remain the same after it's automatically updated? Do you have a sample file? I have a 99% project completion rate and a 4.99 reputation (out of 5.0 from over a thousand projects. More
HI , I have 5 year experience as server admin, if you give opportunity then i will happy to work with you. Thanks
Pretty interesting json and data parsing project. Seems can be delivered in a day. However can we directly talk on this? Thanks!