Hi. I have a CSV file with hundreds of rows and I need to extract and add some values from there. All I need is a simple php file which calls CSV (no mySql, just call it from the file).
I have attached a sample CSV file - bookings.csv.
If you look through the file, there are few important fields - Booking Agent and Guest Rent. I basically need to have rent added up for each Booking Agent category so output would be as follows:
Leisure - 890
Direct - 120
Private - 780
As I mentioned, I have hundreds of rows and I need to be able to just swap the CSV file in the folder and have the above data ready.
It's an easy job for somebody who knows PHP so my budget is fixed (£30) - please send me your details and if accepted all you need to do is write this script based on the sample CSV file so it works when i import something bigger. Also the 3 categories (Leisure, Direct and Private) are not all of them, I will be adding more but if you write something with the above then it should be easy for me to take it from there.
Before bidding please make sure that you can do it today and also that you actually CAN do it.