|
Title: ASCII data query with SQL database professional Post by: QuentinPCO on March 26, 2018, 03:44:15 PM 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 Title: Re: ASCII data query with SQL database professional Post by: Arthur Grasin on March 26, 2018, 03:56:21 PM Hello,
Is it a trial or full version? The trial version has a limit of 100 records, Title: Re: ASCII data query with SQL database professional Post by: QuentinPCO on March 26, 2018, 05:01:15 PM 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 Title: Re: ASCII data query with SQL database professional Post by: Arthur Grasin on March 27, 2018, 07:04:05 AM What our logger do you use?
Title: Re: ASCII data query with SQL database professional Post by: QuentinPCO on March 27, 2018, 10:34:15 AM 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 Title: Re: ASCII data query with SQL database professional Post by: Arthur Grasin on March 27, 2018, 10:55:35 AM What interface (data source) type did you add?
Title: Re: ASCII data query with SQL database professional Post by: QuentinPCO on March 27, 2018, 10:56:38 AM File interface (filesrc.dll)
Ok then I managed to find the problem. Problem solved. Title: Re: ASCII data query with SQL database professional Post by: Arthur Grasin on March 27, 2018, 11:27:02 AM How did you solve this problem?
Title: Re: ASCII data query with SQL database professional Post by: QuentinPCO on March 27, 2018, 11:28:44 AM I modify the value of Block size
Title: Re: ASCII data query with SQL database professional Post by: Arthur Grasin on March 27, 2018, 12:01:43 PM I would recommend to enable the "Align size to signature" option and specify the line feed character code of your CSV file.
Title: Re: ASCII data query with SQL database professional Post by: QuentinPCO on March 27, 2018, 12:09:42 PM OK, i enable "Align size to signature" but it keeps the digital parameter entered in: Block size (bit)
Title: Re: ASCII data query with SQL database professional Post by: Arthur Grasin on March 27, 2018, 12:21:52 PM This is maximum block size. But the program will send an aligned data block to the parser.
Title: Re: ASCII data query with SQL database professional Post by: QuentinPCO on March 27, 2018, 12:24:59 PM I do not believe because I come to the inial situation, I have data that does not register in database .. ;)
Title: Re: ASCII data query with SQL database professional Post by: Arthur Grasin on March 27, 2018, 12:59:44 PM Set the block size to bigger value then your CSV line size.
Title: Re: ASCII data query with SQL database professional Post by: QuentinPCO on March 27, 2018, 02:11:23 PM If I set the block size to bigger value, I have data that does not register in database
|