[php] CSV importing problem !

[alaa_ecv_tc]

Hi ,
I'm trying to import a 7665 rows CSV File , Dilimiter is ";" ..
fields are many but one called "Work_Order_Number" must be unique in all rows ..
there could be importing many times for the updated file (old and new data is in ) so the code must not re-insert the same row , but replace it if it is not the same , without deleting data from database which not in the file ..
the file generated by a dummy program and there is nothing I can do for that .. the code must correct every thing .. like :
The file wrote in Windows-1256 and has arabic letters so must be converted to UTF-8 .. solved with iconv()
Integers has something after them .. looks space in excel but it is not space ! in output it looks � .. Not solved .
The code may take forever .. solved by avoiding time out ..

Is there an easier way to do that !?

Thanks ,

 

[alaa_ecv_tc]

Solved..
And I really need to sleep now
The weird char was "\t" (TAB) ! and in some areas was "\0" (NULL) ..
The code took about 2 minutes to insert/replace data .
The code may be posted later