Completed

FTP data processing question

Automated servers upload CSV files once a day to a FTP site. These files contain data from measurement devices in the field. Data has timestamps.

At the end of the month the data in these files must be combined to produce a monthly file in chronological order.

The headers in the data files must also be removed where redundant.

Is it better to do this on the FTP server (what are the security concerns as well as scripting language used)? Or is it better to post-process using an Excel Macro, for example? Or is it better to put this into a database and access it from there? In this case it would still be necessary to upload this data into a database.

Skills: Excel Macros, Script Install

See more: ftp-data port, ftp example, ftp protocol, ftp commands, http ftp, ftp block mode, how to use ftp, ftp verbose, sample data processing test question, question data processing, showing data excel internet explorer using excel macro, data processing asp parsing, steps research data processing, data processing copmpany bangladesh, institute data processing management, market reaserch simple system simple data processing, contract bidding canada data processing, excel data processing home, data processing websites, data processing health care

About the Employer:
( 0 reviews ) United States

Project ID: #17150638

Awarded to:

Vlzinch

Hi,prask5! I can create python script that will process csv files, combine them and put to dB. Truly saying I can create any option you described, but I think that put all to dB is most correct way. Please contact More

$700 USD in 3 days
(2 Reviews)
4.4

22 freelancers are bidding on average $474 for this job

SigmaVisual

Hi, I have experience of working on similar projects where I migrated data using automated scripts. I have experience of handling and processing data of 100s of millions of records and 100s of GB of volume. Please s More

$250 USD in 7 days
(20 Reviews)
5.7
TakeReal

Hello, My name is Sergey. I am Freelancer from [login to view URL], Russia. Say, I can create PHP script and run it on schedule (daily). My script will grab CSV file via FTP and store it locally. Next, at the end of m More

$250 USD in 3 days
(39 Reviews)
4.8
schoudhary1553

Hello, I can help with you in your project FTP data processing question. I have more than 5 years of experience in Excel Macros, Script Install. We have worked on several similar projects before! We have worked on More

$500 USD in 10 days
(10 Reviews)
4.6
katilinas

Greetings, I'm ready to work on ftp data processing project. I'm sure the best approach is to use Excel VBA macro. I can write one with advanced 'Connection' object and SQL Queries. Relevant Skills Excel, VBA Miles More

$545 USD in 10 days
(2 Reviews)
3.5
TechnoGuruu

Hi, As your server saving the CSV file on the daily bases to the FTP server and you want to merge all these files to a single excel file on monthly bases. I can assist you in this. I have many years of experience in More

$333 USD in 10 days
(2 Reviews)
2.5
$555 USD in 10 days
(1 Review)
2.6
cranius

Greetings, You project caught my attention because I have experience in CSV merging and cleanup using macros. If you provide samples of your files I can prototype something for your needs. Meanwhile, I made a qu More

$250 USD in 2 days
(0 Reviews)
0.0
PuliLeela

I'm good at macros

$555 USD in 10 days
(0 Reviews)
0.0
$440 USD in 3 days
(0 Reviews)
0.0
$555 USD in 10 days
(0 Reviews)
0.0
jinigo23

Hey there!! I am ready to provide you the great service from the right away. And I will be glad to work with you for long term way. I've well experienced team. I will assure you that you will get a quality work accordi More

$600 USD in 3 days
(0 Reviews)
0.0
Itblast

yes i love to do FTP data processing question for you sir check my profile that i am top 10 in exam sir yes i am top 10 .

$555 USD in 10 days
(0 Reviews)
0.0
cjsoto

i willing to work to you and give my best that i can and i hope you can trust me. Thanks and Good day

$333 USD in 10 days
(0 Reviews)
0.0
$555 USD in 10 days
(0 Reviews)
0.0
irtaxahaider14

I can do it for you as I am an excel macro expert. Inbox me now, give the details and get it done Thanks anyway.

$250 USD in 4 days
(0 Reviews)
0.0
$833 USD in 10 days
(0 Reviews)
0.0
$555 USD in 10 days
(0 Reviews)
0.0
$250 USD in 1 day
(0 Reviews)
0.0
$555 USD in 10 days
(0 Reviews)
0.0
mks786

HI, I am interested in your project and want to participate in it. (What are the security concerns as well as scripting language used)? I prefer to use the C# and .net core Or is it better to post-process usin More

$750 USD in 3 days
(0 Reviews)
0.0