Find Jobs
Hire Freelancers

FTP data processing question

$250-750 USD

완료함
게시됨 거의 6년 전

$250-750 USD

제출할때 지불됩니다
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: 17150638

프로젝트 정보

21 제안서
원격근무 프로젝트
활동 중 6년 전

돈을 좀 벌 생각이십니까?

프리랜서 입찰의 이점

예산 및 기간 설정
작업 결과에 대한 급여 수급
제안의 개요를 자세히 쓰세요
무료로 프로젝트에 신청하고 입찰할 수 있습니다
프로젝트를 수여된 사용자:
사용자 아바타
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 3일에
5.0 (4 건의 리뷰)
5.5
5.5
21 이 프로젝트에 프리랜서들의 평균 입찰은 $470 USD입니다.
사용자 아바타
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 7일에
4.7 (20 건의 리뷰)
5.7
5.7
사용자 아바타
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 10일에
4.9 (16 건의 리뷰)
5.0
5.0
사용자 아바타
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 10일에
5.0 (2 건의 리뷰)
3.5
3.5
사용자 아바타
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 10일에
5.0 (4 건의 리뷰)
3.0
3.0
사용자 아바타
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 10일에
5.0 (1 건의 리뷰)
2.1
2.1
사용자 아바타
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 3일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
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 4일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
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 10일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
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 3일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
I'm good at macros
$555 USD 10일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
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 0일에
0.0 (0 건의 리뷰)
0.0
0.0

고객에 대한 정보

국기 (UNITED STATES)
Vancouver, United States
5.0
1
결제 수단 확인
6월 11, 2018부터 회원입니다

고객 확인

감사합니다! 무료 크레딧을 신청할 수 있는 링크를 이메일로 보내드렸습니다.
이메일을 보내는 동안 문제가 발생했습니다. 다시 시도해 주세요.
등록 사용자 전체 등록 건수(일자리)
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
미리 보기 화면을 준비 중...
위치 정보 관련 접근권이 허용되었습니다.
고객님의 로그인 세션이 만료되어, 자동으로 로그아웃 처리가 되었습니다. 다시 로그인하여 주십시오.