List:MaxDB« Previous MessageNext Message »
From:Oliver Vecernik Date:November 21 2000 8:44am
Subject:Re: AW: File import question
View as plain text  
"Schildberg, Steffen" wrote:
> 
> Hi Oliver,
> The described behavior is a bug and will be fixed in one of the next
> versions of the
> Replication Manager.
> 
> To get 'empty' strings loaded you need to apply a workaround: you have to
> include at
> least one space sign between the separators for every 'empty' string. That
> means your
> datafile would look like this
> 
> "0160-050P000";"AT01";"5744.28"; ; ; ; ; ;"417.44";;
> "0160-050P001";"AT01";"5744.28"; ; ; ; ; ;"417.44";;

It is even necessary at the end of line if the last field is empty. I
had to change all my files with %s/;$/; /g in vi. Thus the data file has
following format (underlines indicating spaces):

"0160-050P000";"AT01";"5744.28";_;_;_;_;_;"417.44";_;_
"0160-050P001";"AT01";"5744.28";_;_;_;_;_;"417.44";_;_

Oliver
-- 
VECERNIK Datenerfassungssysteme
AT-2560 Hernstein, Hofkogelgasse 17
Tel.: +43 2633 47530, Fax: DW 50
http://members.aon.at/vecernik

Thread
File import questionOliver Vecernik18 Oct
AW: File import questionSteffen Schildberg19 Oct
  • Re: AW: File import questionOliver Vecernik21 Nov