Find Jobs
Hire Freelancers

FTP data processing question

$250-750 USD

Finalizat
Data postării: aproape 6 ani în urmă

$250-750 USD

Plata la predare
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.
ID-ul proiectului: 17150638

Despre proiect

21 propuneri
Proiect la distanță
Activ: 6 ani în urmă

Vrei să câștigi bani?

Avantajele de a licita pe platforma Freelancer

Stabilește bugetul și intervalul temporal
Îți primești plata pentru serviciile prestate
Evidențiază-ți propunerea
Te înregistrezi și licitezi gratuit pentru proiecte
Acordat utilizatorului:
Avatarul utilizatorului
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 me to discuss more details. Regards, Vlad
$700 USD în 3 zile
5,0 (4 recenzii)
5,5
5,5
21 freelanceri plasează o ofertă medie de $470 USD pentru proiect
Avatarul utilizatorului
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 see below for your questions: >> 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. Regarding above, I can do this on FTP server as well by database. I can using python or php as scripting language. After discussion and having more details I will be able to provide better suggestion. Please let me know about time when you would be available so we can discuss further.
$250 USD în 7 zile
4,7 (20 recenzii)
5,7
5,7
Avatarul utilizatorului
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 300+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,
$500 USD în 10 zile
4,9 (16 recenzii)
5,0
5,0
Avatarul utilizatorului
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 Milestones 272 USD - project requirements done and delivered 272 USD - last milestone after full checking and testing I can achieve the results that you are asking for.
$545 USD în 10 zile
5,0 (2 recenzii)
3,5
3,5
Avatarul utilizatorului
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 Excel, functions, macros and scripting. To fetch the files from FTP server I have to install one program and will schedule it then my macro will merge all these files to one excel sheet. If you want we can do it for daily bases also so that you can get refreshed data daily. I can customize in any way whichever way you prefer. Please give me opportunity to work on your project. Thanks, Peter
$333 USD în 10 zile
5,0 (4 recenzii)
3,0
3,0
Avatarul utilizatorului
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 în 10 zile
5,0 (1 recenzie)
2,1
2,1
Avatarul utilizatorului
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 using an Excel Macro, for example? It is fine but not secure also merging is not that simple and it only supports 65565 records per sheet Or is it better to put this into a database and access it from there? It is better and very precise solution also secure and very fastly comparable and already merged. In this case, it would still be necessary to upload this data into a database. regarding database there are many ways one to export excel to the DB or add directly to the DB through your forms. Waiting for your reply, thanks and regards, Kashif Saeed
$750 USD în 3 zile
0,0 (0 recenzii)
0,0
0,0
Avatarul utilizatorului
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 în 4 zile
0,0 (0 recenzii)
0,0
0,0
Avatarul utilizatorului
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 în 10 zile
0,0 (0 recenzii)
0,0
0,0
Avatarul utilizatorului
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 according to your instructions. I am an expert in the following Excel, Excel Macros, Excel VBA, Script Install, PHP, C Programming, C++ Programming, Software Architecture, Software Development, Software Testing and etc. Regards, George
$600 USD în 3 zile
0,0 (0 recenzii)
0,0
0,0
Avatarul utilizatorului
I'm good at macros
$555 USD în 10 zile
0,0 (0 recenzii)
0,0
0,0
Avatarul utilizatorului
Hi, easy, direct and interesting job ! For the job: - when You can send me the FTP login I will send You a sample of the automated combiner from FTP to CSV file combined. - Then You can decide options like how to store Login/Pass or where the data will be saved (even on the internet), etc. For the questions: - For security and efficiency reasons the FTP measurement file has to be downloaded directly and processed during download by an Executable program. - I suggest to remove the redundant headers during communication: it can be automatic and the algorithm implementation result will be durable in time and versions: Excel macro needs to be updated when Microsoft wants it. - To obtain a Database from a combined CSV will be easy and is a good practice, when You will manage Your data in a statistical or analytical manner. What we do now in this way will be easily extended for future needs. Cheers Gianni
$250 USD în 0 zi
0,0 (0 recenzii)
0,0
0,0

Despre client

Steagul UNITED STATES
Vancouver, United States
5,0
1
Metoda de plată a fost confirmată
Membru din iun. 11, 2018

Verificarea clientului

Mulțumim! Ți-am trimis prin e-mail linkul pe care trebuie să-l accesezi pentru a revendica creditul gratuit.
A apărut o eroare la trimiterea e-mailului. Încearcă din nou.
Utilizatori înregistrați Totalul proiectelor postate
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Se încarcă previzualizarea
S-a oferit permisiunea de depistare a locației.
Ți-a expirat sesiunea pentru conectare sau te-ai deconectat. Conectează-te din nou.