Your CSV format requires that the CSV be all on one line, so you can split on " ". I wanted to use a xls column based format too. The enclosed file will allow the current format as well as.

Current Format CSV:
-33.7766,151.23954,130.4 -33.776468,151.23944,129.9 -33.776366,151.239305,129.9 -33.776234,151.239178,129.9 -33.776026,151.238976,129.9

New Allowable Format CSV:
-33.7766,151.23954,130.4
-33.776468,151.23944,129.9
-33.776366,151.239305,129.9
-33.776234,151.239178,129.9
-33.776026,151.238976,129.9

I added this to the Validate and Submit code:
$item['value'] = preg_replace("/\r/","", $item['value']);
$item['value'] = preg_replace("/\n/"," ", $item['value']);

CommentFileSizeAuthor
trackfield_csv.module.zip1.45 KBtomhung

Comments

raintonr’s picture

Status: Active » Fixed

Sorry. Yeah - I see the point. Have committed a fix into CVS that uses preg_split with breaks on any whitespace.

Anonymous’s picture

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.