Export Text Files using Table Conversion

[Maria Garcia]

I´m in EnterpriseOne 8.11 Windows and Oracle Database.
I´ve trouble using Table conversion with text file, the log file show me this error:
this TCEngine Level 0 \b9\common\TCEngine\tcdtacnv.c : TCE009018 - Missing delimiter after column Column 1 in format TextLine1
TCEngine Level 0 \b9\common\TCEngine\tcdtacnv.c : TCE009186 - Value  of column Column 1 in format TextLine1 exceeds length in column definition.

And my text file contains this data:
"SIS0002","SISTEMA02","0","ZS","000000000002134SZ00001","EP4004Z",1,"A","1",,
"SIS0002","SISTEMA02","0","ZS","000000000002247SZ00001","EP4004Z",1,"A","1",,
"SIS0002","SISTEMA02","0","ZS","000000000002542SZ00001","EP4004Z",1,"A","1",,
"SIS0002","SISTEMA02","0","ZS","000000000002820SZ00001","EP4004Z",1,"A","1",,
"SIS0002","SISTEMA02","0","ZS","000000000002829SZ00001","EP4004Z",1,"A","1",,
"SIS0002","SISTEMA02","0","ZS","000000000050046SZ00001","EP4004Z",1,"A","1",,
"SIS0002","SISTEMA02","0","ZS","000000000058649SZ00001","EP4004Z",1,"A","1",,
The specifications are:
Format Type delimited... Column delimiters ","... textual qualifers Double quotations..

So, I don´t understand whats going on !!!.

Thanks in advance

Maria Garcia
Project Leader

 

[SSAJAROFF]

Hi Maria,

Your problem seems to be the extra comma after "1". I'm pretty sure it's a null field which is confusing JDE.
By the way, your mail should be posted to OneWorld forums, no to World ones...

Regards, Sebastian Sajaroff

 

[Sebastian Sajaroff]

Hi Maria,

The problem is surely caused by the last double comma.
I'm quite sure it comes from a null field, you should
check that you don't have null values (which confuse
JDE) and then try again.
Good luck,

Sebastian Ignacio Sajaroff

 

[Maria Garcia]

Hi guys !!!
I did your suggest without result ...I deleted the last 2 commas. The text files looks like this
"SIS0002","SISTEMA02","0","ZS","000000000002134SZ00001","EP4004Z",1,"A","1"
"SIS0002","SISTEMA02","0","ZS","000000000002247SZ00001","EP4004Z",1,"A","1"
"SIS0002","SISTEMA02","0","ZS","000000000002542SZ00001","EP4004Z",1,"A","1"
"SIS0002","SISTEMA02","0","ZS","000000000002820SZ00001","EP4004Z",1,"A","1"
"SIS0002","SISTEMA02","0","ZS","000000000002829SZ00001","EP4004Z",1,"A","1"
"SIS0002","SISTEMA02","0","ZS","000000000050046SZ00001","EP4004Z",1,"A","1"
"SIS0002","SISTEMA02","0","ZS","000000000058649SZ00001","EP4004Z",1,"A","1"

AND I´m trying to import into the F0041Z1 table (ZFCTID,ZFUSER,ZFTRNM,ZFTRNY,ZFTRNK,ZFPID,ZFSERK,ZFAPVC,ZFTSC)


Thanks a lot again...

 

[Dave Kahn...]

From the error message it appears the system is not recognising the
comma as the field delimiter. Where are you based? Some regions use a
comma as decimal point and a different character, eg semi-colon, as
the field delimiter. If this is the case the best solution is probably
to produce your text file so that it uses the correct field and string
delimiters.

It may be possible to use the existing text file by adjusting the
appropriate parameters but I can't help you with that as you say you
are using EnterpriseOne 8.11 with Windows and Oracle. This is the JDE
World forum. If you were using the iSeries, the best commercial
computing platform known to man, we'd be able to help you further.