ImportCumulusFile

[ninendal]

Hi,

Using the latest ImportCumulusFile to insert dayfile.txt in mysql. This file has multiple rows but only one row is visible in the database. The other thing is that the date field is filled with 0.

0000-00-00,"1.0","8 2","9 19:","69.0","01 23","0.0","0 6","8.00","6 6","4.00","10 1","2.00","9 19:","3.00","1.00","0.0","8.0","1 20:","8.0","4 0","0.0","0 00:",NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,"N",NULL

The first row of the dayfile.txt;

05-04-15;16,1;0;18:35;4,8;23:54;9,9;19:01;1026,69;19:01;1028,01;23:56;0,0;00:00;0,0;6,8;9,6;6,4;19:01;59;19:01;85;23:41;0,10;1,2;9,9;19:01;7,3;19:06;3,1;23:54;0,0;00:00;4,8;23:54;3,1;20:06;1,8;23:20;14;2,4;0,0;135;19:07;0,0;00:00

Any suggestions?

Paul

[mcrossley]

Paul

Did you set the control variables correctly?

Code: Select all

$field_delimiter = ',';
$date_delimiter = '/';
$date_format = 'DMY'; //or MDY or YMD
$decimal_separator = '.';

[ninendal]

Paul

Did you set the control variables correctly?

Code: Select all

$field_delimiter = ',';
$date_delimiter = '/';
$date_format = 'DMY'; //or MDY or YMD
$decimal_separator = '.';

Of course not Now it is & working. Thx again.