Generate JSON Files from txt import on Ubuntu Server

Closed Posted 6 years ago Paid on delivery
Closed 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

JSON MySQL PHP Software Architecture Ubuntu

Project ID: #16163064

About the project

11 proposals Remote project Active 6 years ago

11 freelancers are bidding on average $182 for this job

rajeshsonisl

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
(995 Reviews)
8.8
gangabass

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
(449 Reviews)
7.4
jarki2017

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
(38 Reviews)
6.0
ubica

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)
5.5
bishnudev3

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
(46 Reviews)
4.9
deytps86

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
(20 Reviews)
4.7
wbadr

- 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)
0.0