Find Jobs
Hire Freelancers

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

$30-70 USD

Færdiggjort
Slået op næsten 11 år siden

$30-70 USD

Betales ved levering
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
Projekt-ID: 4713218

Om projektet

3 forslag
Projekt på afstand
Aktiv 11 år siden

Leder du efter muligheder for at tjene penge?

Fordele ved budafgivning på Freelancer

Fastsæt dit budget og din tidsramme
Bliv betalt for dit arbejde
Oprids dit forslag
Det er gratis at skrive sig op og byde på jobs
Tildel til:
Brug Avatar.
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 på 3 dage
5,0 (23 anmeldelser)
4,1
4,1
3 freelancere byder i gennemsnit $84 USD på dette job
Brug Avatar.
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 på 3 dage
5,0 (38 anmeldelser)
5,2
5,2

Om klienten

Flag for UNITED STATES
Fullerton, United States
5,0
4
Betalingsmetode verificeret
Medlem siden jan. 8, 2011

Klientverificering

Tak! Vi har sendt dig en e-mail med et link, så du kan modtage din kredit.
Noget gik galt, da vi forsøgte at sende din mail. Prøv venligst igen.
Registrerede brugere Oprettede jobs i alt
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Indlæser forhåndsvisning
Geolokalisering er tilladt.
Din session er udløbet, og du er blevet logget ud. Log venligst ind igen.