Generate JSON Files from txt import on Ubuntu Server

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

Skills: JSON, MySQL, PHP, Software Architecture, Ubuntu

See more: Need Urgent fix of Mysql server on Ubuntu, backup files ubuntu server, import txt file sql server asp net vb script, import csv files dts wizard sql server, import txt file sql server script, import csv files using microsoft sql server 2005, write script work linux server, generate random files, generate different files paragraphs php, sql txt import, excel script generate text files cells, need help installing php website server, wordpress txt import, generate difference files, server side record script flash media server, server need windows mail setup, need running web crystal report server, java tomcat ubuntu server edition, xml import sql server 2005, install ubuntu server dell 1950

About the Employer:
( 9 reviews ) Jacksonville, United States

Project ID: #16163064

12 freelancers are bidding on average $188 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

$233 USD in 2 days
(940 Reviews)
$155 USD in 3 days
(58 Reviews)

First of all thank you for the excellent description. I can create Linux script (in PHP or Python or Perl) that will work exactly like you want: it will parse text file, check some columns for some conditions and ou More

$150 USD in 1 day
(367 Reviews)

Dear sir I am very glad to meet you on Here I saw interesting your job description and i can do it. I have amazing experience in Web development for 6 years long and I am a expert developer of backend & Frontend. I More

$277 USD in 3 days
(33 Reviews)

Hello. I did something similar before, while building a restful api around mobile number portability CSVs fetched from the operator's server. Since there's no state to maintain (input CSVs are always new, jsons are More

$150 USD in 3 days
(24 Reviews)

Hi, I can do your project at 101% level. I have more than 5 years of experience in ubuntu/apache. If you are looking an expert, I am the right person for you. Don’t worry about your project. Kindly regards. M More

$250 USD in 3 days
(10 Reviews)
$155 USD in 2 days
(5 Reviews)

Pretty interesting json and data parsing project. Seems can be delivered in a day. However can we directly talk on this? Thanks!

$140 USD in 3 days
(15 Reviews)

HI , I have 5 year experience as server admin, if you give opportunity then i will happy to work with you. Thanks

$155 USD in 3 days
(10 Reviews)
$155 USD in 3 days
(8 Reviews)
$155 USD in 2 days
(0 Reviews)

- Architecture Based Implementation: You can contact me to get a power point slide/image that contains the system Architecture. - Professional Implementation using Spring Integration that simplifies the integration More

$277 USD in 5 days
(0 Reviews)