Find Jobs
Hire Freelancers

Script to modify an excel file

$30-250 USD

Completed
Posted almost 7 years ago

$30-250 USD

Paid on delivery
Hi, I'm looking for someone to create a script to be able to run automatically as a cron job. It could be a bash script (.sh), a .cgi script or a php script. Once script is created, I'll set it to run daily as a Cron Job. The main code is to: 1. Copy a Zip (.zip) file from a remote FTP server to local server location, 2. Uncompressed or unzip the file to extract the inside Excel file (.xlsx) 3. Add few columns to the existing excel file. 4. Once excel file is formatted with new columns, move the original Excel file to an ‘archive’ folder and rename it adding a timestamp at the end with naming format as [login to view URL] 5. If Excel data file contains more than 5,000 rows, then the final formatted file needs to be split in two or more. So, final formatted Excel file(s) needs to have no more than 5,000 rows for the server to be able to process the data in chunks. 6. Script needs to be able to run in a Cron Job ** See attached source Excel sample files and Project details.
Project ID: 13977232

About the project

31 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi. I just read it all and there are still tings you failed to address, so, even though you wrote that if we have questions not to bid, here they are: 1) You did not note what the 'partial' output files naming convention would be(this is expected, if what you say about the 11000 rows is true, on each and every run, so it's important not to overwrite outputs)? 2) There's no mention if the "quantity and tax" columns in the output will be "static" or calculated in any way? 3) There's no mention where any of the "suppliername,ImageAll,proImg1,proImg2,proImg3,proImg4,prodImages" columns data for the output will come from. Please elaborate further on these so the task ahead can be properly assessed. Regards, Dobri
$60 USD in 2 days
4.9 (173 reviews)
6.2
6.2
31 freelancers are bidding on average $144 USD for this job
User Avatar
Hi there I know how to download a ZIP file using FTP, uncompress and add new columns to the excel file. I had a look at the attachments. All clear for me. Looking forward to hear from you. Thanks Rinsad
$157 USD in 3 days
4.9 (1325 reviews)
9.6
9.6
User Avatar
I'm expert in data processing with huge experience working on projects like this that's why I'm sure you'll be impressed with my work. I can create Perl script which will work like in less than a day. You have pretty good project description so all I need to start is milestone payment from you. You'll release it only after you check everything on your side. Thanks. Roman
$100 USD in 1 day
5.0 (778 reviews)
8.1
8.1
User Avatar
Hi sir, This is kimi and I am scraping expert, I have did too many scraping projects, please check my profile page then you will know. https://www.freelancer.com/u/mantislin.html Can you tell me more details? then I will provide example data/script for you. Thanks, Kimi
$145 USD in 3 days
5.0 (399 reviews)
8.1
8.1
User Avatar
hello i have over 10 years of experience working on web development and i'm available to do the job. i will create a php script that can work as a cron job and do exactly what is described in the requirement. let's talk on private for more details thank you
$220 USD in 4 days
5.0 (74 reviews)
7.2
7.2
User Avatar
we have expertise in Excel-VBA, Data processing. Client satisfaction is our main motto for long term relationship.
$80 USD in 2 days
5.0 (49 reviews)
6.7
6.7
User Avatar
Hi! I would be glad to get this work done for you and I am very confident I can do it better than anybody else here. I understand you need a shell script to (a bash script) to download an Excel file from a remote FTP server and format it according to the given specification, move the original file to an archive folder renaming it adding a timestamp. I need all the technical expertise to get this job done to your full satisfaction. I have over 10 years of experience in writing linux/unix shell scripts and working with Excel sheets. Anyway before I can confirm my bid on this, I have a couple of questions that needs answers for. (1) Is it ok to write a separate python/perl script that the bash script would call for the excel formatting part? (or I could include everything in a python script so you can call it directly as a cron job). (2) Does the bash script have to upload the modified/formatted Excel file back to the FTP server it downloaded the file from? Thank you and I look forward to hearing from you and getting this work done for you.
$200 USD in 4 days
5.0 (55 reviews)
6.9
6.9
User Avatar
Hi, I can create a Per script to format the excel file for you. you can run through cronjob on your Linux machine
$155 USD in 3 days
5.0 (69 reviews)
6.9
6.9
User Avatar
Hi, I am expert in PHP and bash scripting. can write script in php or bash that can read file and process listed task. for bash script i have to install some tool for excel file reading. for php i can use library. script will be able to execute through cron.
$111 USD in 0 day
4.8 (105 reviews)
6.8
6.8
User Avatar
Note: I have already developed many software's and very much proficient to build an script to modify an excel file. Hi Dear, I am glad to offer you my services, I have more then 8 year of experience in development of websites and software's. I have great expertise in CGI, Perl, PHP, Shell Script, Software Architecture. I am available to discuss the project in detail and ready to get started. Kindly inbox me for further communication. I assure you that you will experience a WOW factor in our work. Many Thanks, Wasi Tentative bid
$250 USD in 3 days
5.0 (25 reviews)
5.5
5.5
User Avatar
Hello, I have read through your job description and reviewed the example excel files you provided for both the original and formatted files. I can create you a single PERL script that can be run via a CRON job to handle every step you have outlined from the FTP, Decompression, Excel formatting, and final output. I have created similar scripts many times before and have worked with all of the PERL modules needed to perform these operations. I have also done similar scripts using PHP but I find that PHP becomes a bit of a memory hog when processing large Excel files, so PERL is preferable to keep the server resource usage down. If you accept my bid I should be able to clarify a few detail questions I have for you and have it all finished within a few days at the most. Thanks. -Ben
$100 USD in 2 days
5.0 (19 reviews)
5.6
5.6
User Avatar
Hi , I'm 7 years experience in full stack developer , I'm interested in your project with immediate availability. Waiting for your reponce Thanks
$133 USD in 3 days
4.9 (11 reviews)
4.7
4.7
User Avatar
5 Reasons why you should hire me for your custom website and Application Development. 1. Available 24/7 upon your request 2. Delivery on-time with 100% satisfaction 3. Always think beyond boundaries and provide user friendly solution 4. Provide excellence with commitment 5. Most important, Free technical support for lifetime. Thank you
$155 USD in 3 days
4.4 (23 reviews)
4.9
4.9
User Avatar
Hi, I can do the whole thing in perl. Perl script can be schedule as cron job. If you are OK with it then please award the work to me and create the milestone. Release of milestone can be done once the whole work is tested and working successfully at your end. Thanks, Rajeev Kuamr
$200 USD in 10 days
4.7 (7 reviews)
3.8
3.8
User Avatar
I have been working as a software developer for more than two years on python scripting and having good experience in excel file handling using xlsxwriter and xlrd. I've done few projects on this
$110 USD in 2 days
3.5 (4 reviews)
2.9
2.9
User Avatar
I will use python script to finish this job. XLWT is one of the modules that might be useful for this task. Please share some more sample files so that I can verify my scripts.
$250 USD in 25 days
4.0 (2 reviews)
2.1
2.1
User Avatar
Hi Thanks for your time :) I have 4 year of experience in PHP. I have read your requirements regarding script and i am confident that i can that script within given timeline. I believe in best quality work. Please let me know if you have any other requirements. looking forward to work with you. waiting for reply. Thanks!
$35 USD in 2 days
5.0 (1 review)
1.2
1.2
User Avatar
I have hefty experience in PHP and working with Excel files. I will be able to give you a fully commented solution within 2-3 days.
$77 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
What needs to be in the added columns? I am confident I can get this done in 2 days.
$122 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi there, I would love to work with you on this project, also including in this package I will throw an extra bonus for free, I will include a free marketing video if it's needed in your niche that is. I look forward to talking with you
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I can do it in python for minimum cost just $49. if it is ok with you pls let me know. I will give support any changes you have in future. My bid is minimum but need top ratings and reviews. Regards,
$49 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Lawrenceville, United States
4.9
18
Payment method verified
Member since Dec 8, 2007

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.