Pull files hourly from a gmail account, parse them out in CSV, combined them and insert / update database.
These files will come hourly. A total of three emails will be sent pretty much the same time. Your task is to have a process pull down these files, unzip them, parse them out as CSV, join then together (on same sets of keys), and insert of update existing mysql table.
All i can send you is teh details of the gmail account, i am hoping you will do the rest.
End product is you will have a remotely hosted mysql database populated with fresh data every hour. Again, you will need to figure out the keys in the file yourself to make sure when you join files together, you are joining on the right keys, plus, when you are finally doing an update or insert, you are doing it correct.
YOU MUST BE A SELF STARTER, I WONT HAVE TIME TO BABY SIT ANYONE ;O)
Décerné à :
10 freelance font une offre moyenne de $176 pour ce travail
Hi there, I am an expert in PHP I can parse and update the data to mysql table Please award the job and provide sample zip files,i will finish the job in 3 days Thank you, Yousuf
I have worked extensively with PHP, MySQL and Imap/POP. This is a fairly straightforward task and I can provide a completely automated script that you can run and forget.