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.
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.