ASCII data query with SQL database professional

[QuentinPCO]

Hello,

When saving a csv file to an SQL database, there is only part of the file that registers (about 1 in 60 lines)

Do you know why?

(1.000 row , 71 ko)

Thanks,
Quentin

[Arthur Grasin]

Hello,

Is it a trial or full version? The trial version has a limit of 100 records,

[QuentinPCO]

This is the full version but I load a file of 1000 lines at one time.

When I restart the same file, I have the same lines that registers but I can see all the lines in the display

[Arthur Grasin]

What our logger do you use?

[QuentinPCO]

I use :
- Data logger Suite 2.7.0.1209
- ASCII data query and parser with this conf (In attachment)
- Aggregation
- SQL Database Professional


Part of the file with hidden fields :
13/03/2018 00:00:11;***********;18618686;6372;3;18;236;96,3;95,6
13/03/2018 00:01:41;***********;18618686;6433;3;18;236;96,4;95,6
13/03/2018 00:03:11;***********;18618686;6497;3;18;236;96,4;95,6
13/03/2018 00:04:41;***********;18618686;6558;3;18;237;96,4;95,7
13/03/2018 00:06:11;***********;18618686;6618;3;18;237;96,5;95,7
13/03/2018 00:07:41;***********;18618686;6681;3;18;237;96,5;95,7
13/03/2018 00:09:11;***********;18618686;6741;3;18;237;96,5;95,6
13/03/2018 00:10:41;***********;18618686;6798;3;18;241;96,5;95,6
13/03/2018 00:12:12;***********;18618686;6860;3;18;242;96,5;95,6
13/03/2018 00:13:42;***********;18618686;6920;3;18;243;96,5;95,6
13/03/2018 00:15:12;***********;18618686;6979;3;19;243;96,6;95,6
13/03/2018 00:16:42;***********;18618686;7040;3;19;243;96,6;95,6
13/03/2018 00:18:12;***********;18618686;7102;3;19;244;96,6;95,6
13/03/2018 00:19:42;***********;18618686;7163;3;19;245;96,6;95,6
13/03/2018 00:21:12;***********;18618686;7221;3;19;245;96,6;95,6
13/03/2018 00:22:42;***********;18618686;7286;3;19;245;96,7;95,6
13/03/2018 00:24:12;***********;18618686;7345;3;19;246;96,7;95,6
13/03/2018 00:25:42;***********;18618686;7403;3;19;247;96,7;95,6
13/03/2018 00:27:12;***********;18618686;7466;3;19;249;96,7;95,6
13/03/2018 00:28:42;***********;18618686;7528;3;20;249;96,7;95,7
13/03/2018 00:30:12;***********;18618686;7588;3;20;249;96,7;95,6
13/03/2018 00:31:42;***********;18618686;7645;3;20;250;96,8;95,7
13/03/2018 00:33:12;***********;18618686;7710;3;20;250;96,8;95,7
13/03/2018 00:34:42;***********;18618686;7754;3;20;250;96,8;95,7
13/03/2018 00:36:12;***********;18618686;7776;3;20;251;96,8;95,7
13/03/2018 00:37:42;***********;18618686;7835;3;20;251;96,8;95,7
13/03/2018 00:39:12;***********;18618686;7895;3;20;252;96,8;95,7
13/03/2018 00:40:42;***********;18618686;7956;3;20;252;96,9;95,7
13/03/2018 00:42:12;***********;18618686;8019;3;20;252;96,9;95,7

[Arthur Grasin]

What interface (data source) type did you add?

[QuentinPCO]

File interface (filesrc.dll)

Ok then I managed to find the problem. Problem solved.

[Arthur Grasin]

How did you solve this problem?

[QuentinPCO]

I modify the value of Block size

[Arthur Grasin]

I would recommend to enable the "Align size to signature" option and specify the line feed character code of your CSV file.

[QuentinPCO]

OK, i enable "Align size to signature" but it keeps the digital parameter entered in: Block size (bit)

[Arthur Grasin]

This is maximum block size. But the program will send an aligned data block to the parser.

[QuentinPCO]

I do not believe because I come to the inial situation, I have data that does not register in database ..  

[Arthur Grasin]

Set the block size to bigger value then your CSV line size.

[QuentinPCO]

If I set the block size to bigger value, I have data that does not register in database