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
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.