You will be writing a PHP script where everything should be in 1 single file to operate.
It will first pull this CSV file: [login to view URL]
This contains these fields: id, casedescription, dateraised, duedate
For each for returned, you will do the following:
1. Parse casedescription for an 8 digit number which could be formatted like this:
NNNNNNNN (example 12345678)
NNN-NNNNN (example 123-45678)
Either format you will turn into just NNNNNNNN and save as location id. All other data will be ignored, you are only looking for the 8 digit number which could be anywhere in the string.
2. Parse dateraised for a date and time. These should be split into separate fields
dateraiseddate - YYYY-MM-DD
dateraisedtime - HH-MM-SS in 24 hour time
3. Parse duedate for a date and time. These should be split into separate fields
duedatedate - YYYY-MM-DD
duedatetime - HH-MM-SS in 24 hour time
4. You will then use CURL to post each row back to this URL:
[login to view URL]:12:31&duedatedate=2015-12-16&duedatetime=13:47:12
5. You will repeat until each row of the CSV is complete.
Hi
I am expert web developer i can do your changes fast and in a professional way.
No payment until i finish your work.
I can start right now
Price and Time will depend to the changes
My-sk-pe: [login to view URL] , even if u didn't choose me for this project , maybe u can contact me in another work.
Thanks
$147 USD in 3 days
5.0 (274 reviews)
7.9
7.9
26 freelancers are bidding on average $134 USD for this job
Hello Good Day
I am an expert in PHP Curl. I also understand your requirement to parse the csv, format the data and post to a url. I can do this job. Looking forward to hear from you.
Thanks
Rinsad
Hello!
With 98% to 99% completion rate, 850+ successfully completed projects, and a 4.99 reputation (maximum possible, 5.0) (can be verified on my profile page https://www.freelancer.com/u/rajeshsonisl.html !!)... you can never go wrong choosing me :)
I am available to get started on your project right away. I look forward to your reply.
Thanks.
Kind Regards,
Rajesh Soni
Dear Sir,
Hope you are doing well, I have read your job description, I am willing to work with you. I have already done similar job and win 5 star rating with wonderful review.
- I ll complete all of your requirements
- I ll do more tweaks for you as well
Sir i ensure you that i am best suit for this post. Please open chat with me so we can discuss more in details
Looking forward to hear from you.
Best Regards,
Waheed Gondal
Hi
I would like to participate in developing your project.
I think I have experience in php projects.
I have already developed several websites running on servers.
You might have read this in my profile.
I read your project details and sure to parse csv file completely..
Anyhow, I would like to finish your project within a days as quickly as possible.
Please accept my bid. Of course, I will do my best.
Thanks in advance.
Dear sir, I will complete your project asap, LIFETIME error free guarantee and provide ONE YEAR support... I have right Skills required PHP, Software Architecture to execute your esteemed project.
I have experience in reading csv file through php and do string manipulations or finding string from string. and using curl to post data. Provide sample csv file to do this job. Also, please provide sercer detail, where this script to upload or should I give to you after completing script.
Plz come on chat now so we can discuss more....am waiting...
Dear Sir, I am really interested to work on this project, I can start the work now , and can provide the best services from my end. Please come on chat to discuss more about the project.
Regards,
Bhagwan
HI,
I have an extensive experience with scrapping data in any format, CSV also. I read your requirements and I can get this done in 4-5 hrs max.
Let me know if you are interested.
Thanks for the well documented scope. Pretty clear on what needs to be done which is a big help.
I can start immediately and should be able to wrap this up in a couple of days.
Will look forward to your response.
Regards,
Sam
Hi Mate! I work towards providing reliable, relevant and robust IT solutions at most competitive prices to my customers,It would be great to discuss this project further over personal chat. I ensure 100% customer satisfaction so lets start :)
Awaiting a positive response. Lets get started and really make it HAPPEN!!!
Thanks,
Regards,
RajRani