Find Jobs
Hire Freelancers

Script to modify an excel file

$30-250 USD

Terminado
Publicado hace casi 7 años

$30-250 USD

Pagado a la entrega
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.
ID del proyecto: 13977232

Información sobre el proyecto

31 propuestas
Proyecto remoto
Activo hace 7 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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 en 2 días
4,9 (173 comentarios)
6,2
6,2
31 freelancers están ofertando un promedio de $144 USD por este trabajo
Avatar del usuario
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 en 3 días
4,9 (1325 comentarios)
9,6
9,6
Avatar del usuario
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 en 1 día
5,0 (778 comentarios)
8,1
8,1
Avatar del usuario
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 en 3 días
5,0 (399 comentarios)
8,1
8,1
Avatar del usuario
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 en 4 días
5,0 (74 comentarios)
7,2
7,2
Avatar del usuario
we have expertise in Excel-VBA, Data processing. Client satisfaction is our main motto for long term relationship.
$80 USD en 2 días
5,0 (49 comentarios)
6,7
6,7
Avatar del usuario
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 en 4 días
5,0 (55 comentarios)
6,9
6,9
Avatar del usuario
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 en 3 días
5,0 (69 comentarios)
6,9
6,9
Avatar del usuario
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 en 0 día
4,8 (105 comentarios)
6,8
6,8
Avatar del usuario
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 en 3 días
5,0 (25 comentarios)
5,5
5,5
Avatar del usuario
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 en 2 días
5,0 (19 comentarios)
5,6
5,6
Avatar del usuario
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 en 3 días
4,9 (11 comentarios)
4,7
4,7
Avatar del usuario
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 en 3 días
4,4 (23 comentarios)
4,9
4,9
Avatar del usuario
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 en 10 días
4,7 (7 comentarios)
3,8
3,8
Avatar del usuario
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 en 2 días
3,5 (4 comentarios)
2,9
2,9
Avatar del usuario
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 en 25 días
4,0 (2 comentarios)
2,1
2,1
Avatar del usuario
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 en 2 días
5,0 (1 comentario)
1,2
1,2
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
What needs to be in the added columns? I am confident I can get this done in 2 days.
$122 USD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 2 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
Lawrenceville, United States
4,9
18
Forma de pago verificada
Miembro desde dic 8, 2007

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.