Find Jobs
Hire Freelancers

small php script editing excel csv file under centos - repost 2

$30-70 USD

Terminado
Publicado hace casi 11 años

$30-70 USD

Pagado a la entrega
i have csv file downloaded from vendor every day in my centos server file path is /home/casemost/public_html/csv/[login to view URL] see attached file named [login to view URL] there are total 11 key columns such as (SKU, Catergory,Subcategory,LargeImage,Title,QtyAvailable,Description,netWeight,[login to view URL],UPC) you can safely ignore 'mapprice' column Your job is creating php script to edit this csv file , then i will run this script every day using server cron! script do following work 1. read attached file named csv and rename it as '[login to view URL]', be noted these two file names are constant,mean should be there under file path always! this '[login to view URL]' should be edited 2. if any key columns value is missing, then delete that row 3. merge column C & D value into C columm example, C2 value =Audio & Bluetooth, D2 value=Audio Adaptors, then make value "Audio & Bluetooth/Audio Adaptors" 3. if 'Make' Column cell value is empty, put 'casemost' 4. after making above job, copy it named as 'date'.csv for backup and compare purpose. after 7 days there should be [login to view URL], [login to view URL],[login to view URL],[login to view URL],[login to view URL],[login to view URL],[login to view URL] 5. do compare '[login to view URL]' and 'last [login to view URL]' find any 'SKU' gone! then make '[login to view URL]' containing only gone SKU rows from 'last [login to view URL]' example, today is July 10 Wed. compare '[login to view URL]' with [login to view URL] dated July.9 and find any sku not exist in '[login to view URL]' make '[login to view URL]' only containing missing sku row data. 6. do copy this '[login to view URL]' named as '[login to view URL]' for backup purpose , in csv folder [login to view URL], delete.Tue.csv............ 7. lastly delete backup files of 7 day old. example if today is Monday, delete '[login to view URL]' and '[login to view URL]' attached file encoding is UTF-8 encoded, and all file should be too from my small research, this work can be achieved using php script without much trouble. all csv file should have same header of '[login to view URL]' do test before deliver this script to me. 50 % initial milestone and 50% at the time of delivery. first half will be released delivery date,second half follow 7 days be sure to download attached file before bidding. i don't like canned bid like ' i can do it' without reading full post and seeing file richard*dot*park745
ID del proyecto: 4713218

Información sobre el proyecto

3 propuestas
Proyecto remoto
Activo hace 11 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
Dear sir, I have read careful about your requirement and have a look csv file you give. Please see discuss on pmb, thanks.
$64 USD en 3 días
5,0 (23 comentarios)
4,1
4,1
3 freelancers están ofertando un promedio de $84 USD por este trabajo
Avatar del usuario
I've readed entire description, also had a look at the file. I can get this done within three days, also I have a Centos server where I'll work and test this. I'm ready to start. Regards, Andy.
$111 USD en 3 días
5,0 (38 comentarios)
5,2
5,2

Sobre este cliente

Bandera de UNITED STATES
Fullerton, United States
5,0
4
Forma de pago verificada
Miembro desde ene 8, 2011

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.