There is a fully functional PHP Script which uploads data into our customer database.
The current format is in CSV and is as follows:
1103||1103450155||3||12||2002||3||11||2003||Paul||Babbit||Kids-R-Kids Inc.||123 SW 456 Street||apt 2||Miami||FL||32123||305-222-5555||555-444-6666||Economy||Inactive||test1||test1||test2||test2||test3||test3||these are the notes for this customer||Extra 01||Extra 02||Extra 03||Extra 04||Extra 05||Extra 06||Extra 07||Extra 08||Extra 09||Extra 10||Extra 11||Extra 12||Extra 13||Extra 14||Extra 15||Extra 16||Extra 17||Extra 18||Extra 19||Extra 20
Obviously, this is confusing for us to enter data, then to upload.
We would like to enter the data in an excel sheet, which would have the specific titles, such as FIRST NAME, LAST NAME, etc. in COLUMN 1.
We would like the DATA to be in COLUMN 2, ie JOHN DOE.
Current PHP code is attached.
8 freelancers are bidding on average $47 for this job
Dear sir, I have experience in working with .xls files in PHP. In my previous project fields could be recognized from titles of Excel sheet in user preference or by admin predefined values.