Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
battistiandco
Contributor II
Contributor II

Issue importing a txt file

I am trying to import a txt file with ; separator with 100000 rows.

Only part of the file is imported.

I have try to import it in MsAccess and all rows are imported.

Can you help me ?

1 Solution

Accepted Solutions
flipside
Specialist II
Specialist II

Hi,

Have you tried setting Quoting to none instead of msq?

Your load script will end something like ...

     (txt, codepage is 1252, embedded labels, delimiter is ';', no quotes);

instead of ...

     (txt, codepage is 1252, embedded labels, delimiter is ';', msq);

flipside

View solution in original post

7 Replies
rbecher
MVP
MVP

Hi,

if no error occurs in QlikView I presume there are binary data in a record or an empty row in the file.

Can you post your load command and some sample records..

- Ralf

Vizlib Head of R&D
battistiandco
Contributor II
Contributor II
Author

No error occurs, but the rowsestracted  are only some and not adiacent

This is the load comand

Directory;

LOAD [ID Garanzia],

     [Codice Garanzia],

     N.Prenotazione,

     Fidelity,

     [Punto vendita],

     [Data vendita],

     [Tipo Garanzia],

     Articolo,

     Marca,

     Seriale,

     [Valore Articolo],

     [Valore Garanzia],

     [ID Cliente],

     Nome,

     Cognome,

     Indirizzo,

     [Citta'],

     Provincia,

     CAP,

     [Data inizio Garanzia],

     [Data Fine Garanzia],

     Aperta,

     L1,

     D_L1,

     L2,

     D_L2,

     L3,

     D_L3,

     L4,

     D_L4,

     L5,

     D_L5,

     L6,

     D_L6,

     L7,

     D_L7,

     L8,

     D_L8

FROM

[1_Garanzie.txt]

(txt, utf8, embedded labels, delimiter is ';', msq);

Some rows

ID Garanzia;Codice Garanzia;N.Prenotazione;Fidelity;Punto vendita;Data vendita;Tipo Garanzia;Articolo;Marca;Seriale;Valore Articolo;Valore Garanzia;ID Cliente;Nome;Cognome;Indirizzo;Citta';Provincia;CAP;Data inizio Garanzia;Data Fine Garanzia;Aperta;L1;D_L1;L2;D_L2;L3;D_L3;L4;D_L4;L5;D_L5;L6;D_L6;L7;D_L7;L8;D_L8

1;AAA6RILBIANCO10;0163080025447;0400103685478;CASTENEDOLO;04/11/2008;;WHIAWOD4112;WHIRLPOOL;859230538000;359,00;109,00;0;ROBERTO;MARCELLI;VIA BASALICA 10;CALVISANO;BS;25012;06/11/2008;11/11/2014;Aperta;64357;BIANCO;64358;LAVAGGIO;64359;LAVATRICI FRONTALI 60X60;64399;FINO 5 KG.;64400;DA 650 A 800 G;;;;;;

2;AAA3RILPCDESK149;0163080025473;0400110276935;CASTENEDOLO;04/11/2008;;ACEASM5641;ACER;92E2RFPIBP8300DC312701;849,00;149,00;0;ALESSANDRO;TADINI;VIA GERONI 7;MONTICHIARI;BS;25018;04/11/2008;07/11/2011;Aperta;64375;I.T;64376;COMPUTER;64476;DESKTOP/TOWER;64477;STANDALONE;64496;INTEL;64638;DUALCORE***;;;;

3;AAA3RILPCLAP169;0163080025490;0400113159709;CASTENEDOLO;04/11/2008;;TOSA3001IK;TOSHIBA;88292795Q;899,00;169,00;0;ENRICO;SABINO;VIA EUROPA 57;S.ZENO NAVIGLIO;BS;25010;05/11/2008;08/11/2011;Aperta;64375;I.T;64376;COMPUTER;64377;LAPTOP;64378;NOTEBOOK;64379;INTEL;64415;DUALCORE***;;;;

4;AAA6RILBIANCO16;0163080025525;0400113156609;CASTENEDOLO;05/11/2008;;GOLWD12320RD;LG;610KWTA00297;999,00;169,00;0;DANIELA;STRADA.;DEL BOSCONE 2F;CASTENEDOLO;BS;25014;06/11/2008;11/11/2014;Aperta;64357;BIANCO;64358;LAVAGGIO;64531;LAVASCIUGA;64532;OLTRE 1000 GIRI;;;;;;;;

5;AAA3RILPCLAP169;0163080025528;0400110275297;CASTENEDOLO;05/11/2008;;ACEA5930G844G25MN;ACER;LXAQ40X132826153842000;872,03;169,00;0;FABIO;LOIZZI;VIA GIUSEPPE PIROVANO 15;MONTICHIARI;BS;25018;05/11/2008;08/11/2011;Aperta;64375;I.T;64376;COMPUTER;64377;LAPTOP;64378;NOTEBOOK;64379;INTEL;64415;DUALCORE***;;;;

6;AAA4RILTVPLA149;0163080025550;0400113159044;CASTENEDOLO;05/11/2008;;SAMPS50A416;SAMSUNG;Z5EB3SSQ803660;999,00;149,00;0;GABRIEL;SCARPIELLO;VIA DON LUIGI STURZO 8;MONTIRONE;BS;25010;05/11/2008;08/11/2012;Aperta;64362;CONSUMER ELECTRONIC;64363;VIDEO;64364;PLASMA;64437;50;64438;HDTV;;;;;;

7;AAA5RILTVLCD099;0163080025563;0400113155534;CASTENEDOLO;05/11/2008;;GOL32LG5700;LG;809WRPD2R488;678,00;99,00;0;VITTORIO;RONGA;VIA 25 APRILE 18;BRESCIA;BS;25121;05/11/2008;09/11/2013;Aperta;64362;CONSUMER ELECTRONIC;64363;VIDEO;64390;LCD;64391;32;64392;FULL HD;;;;;;

8;AAA5RILTVLCD099;0163080025578;0400103835132;CASTENEDOLO;05/11/2008;;SAMLE32A436;SAMSUNG;AL8C3SCQA01336;532,53;99,00;0;DONATO ANTONIO;DI CHELE;VIA F. BARACCA 5;GHEDI;BS;25014;05/11/2008;09/11/2013;Aperta;64362;CONSUMER ELECTRONIC;64363;VIDEO;64390;LCD;64391;32;64395;HD;;;;;;

9;AAA5RILTVLCD099;0163080025682;0400105287250;CASTENEDOLO;07/11/2008;;PHI32PFL7433D;PHILIPS;HJ3HO843430580;699,00;99,00;0;MARCO;PISONI;VIA VERDI 21;BOTTICINO;BS;25080;07/11/2008;11/11/2013;Aperta;64362;CONSUMER ELECTRONIC;64363;VIDEO;64390;LCD;64391;32;64395;HD;;;;;;

10;AAA5RILTVLCD129;0163080025691;0400106866805;CASTENEDOLO;07/11/2008;;GOL42LT75;LG;709WRJC48068;899,00;129,00;0;BRUNA;BESCHI;VIA DELLA RESISTENZA 7;CASTENEDOLO;BS;25014;07/11/2008;11/11/2013;Aperta;64362;CONSUMER ELECTRONIC;64363;VIDEO;64390;LCD;64508;42;64607;HD;;;;;;

battistiandco
Contributor II
Contributor II
Author

Hi Ralf, I have understood the issue. In the file there are some rows with

the " character. I attach an example.

It's a bug o QlikView ?

How I can do to skip this problem ?

Thanks Rainer

2012/2/7 Ralf Becher <qliktech@sgaur.hosted.jivesoftware.com>

**

QlikCommunity <http://community.qlik.com/index.jspa> Re: Issue

importing a txt file created by Ralf Becher<http://community.qlik.com/people/rbecher>in

Connectivity and Data Sources - View the full discussion<http://community.qlik.com/message/189269#189269>

flipside
Specialist II
Specialist II

Hi,

Have you tried setting Quoting to none instead of msq?

Your load script will end something like ...

     (txt, codepage is 1252, embedded labels, delimiter is ';', no quotes);

instead of ...

     (txt, codepage is 1252, embedded labels, delimiter is ';', msq);

flipside

battistiandco
Contributor II
Contributor II
Author

Hi flipside

The right command was

(txt, codepage is 1252, embedded labels, delimiter is ';', no quotes, no

eof);

Thanks you very much for your help.

Rainer from Italy

2012/2/7 flipside <qliktech@sgaur.hosted.jivesoftware.com>

**

QlikCommunity <http://community.qlik.com/index.jspa> Re: Issue

importing a txt file created by flipside<http://community.qlik.com/people/flipside>in

Connectivity and Data Sources - View the full discussion<http://community.qlik.com/message/189295#189295>

giuval45
Partner
Partner

Hi Flipside,

many thanks and very helpful... "no quotes" worked perfectly...;-)

Best regards,

Giulio

pablo_nieto
Contributor II
Contributor II

Thanks a lot, it fixed my problem.