2. PHPRunner General questions
  3. [SOLVED]  csv import - custom delimiter
This topic is locked
[SOLVED]

 csv import - custom delimiter

 		12/15/2011 3:31:04 AM
PHPRunner General questions
C
 chanpeter88 author

i want to import a csv file. the delimiter is not comma but "#". does it allow me to change delimiter to "#"?
C
 		cgphp 12/15/2011

You have to change the delimiter for the fgetcsv function in the import.php file (Program Files\PHPRunner6.0\source\import.php)
C
 		chanpeter88 author 12/21/2011

i have changed to "#" but for data is ok, for header, i still have to use comma, otherwise,
Import didn't succeed, couldn't find followind fields: tel#mobile#email#fax
[does not work]

tel#mobile#email#fax

1#2#3#4

2#3#4#5
[ok]

tel,mobile,email,fax

1#2#3#4

2#3#4#5
pls advise
Sergey Kornilov admin 12/22/2011

You also need to modify getImportCVSFields() function in include/import_functions.php file replace comma with # character.