edi to csv not displaying correctly

54 views
Skip to first unread message

Srini Vaddi

unread,
Aug 16, 2022, 2:36:11 AM8/16/22
to Bots Open Source EDI Translator
Hi,

I am using the following grammar

from bots.botsconfig import *

syntax = {
        'field_sep': ',',
    'quote_char':    '"',
        'charset':  "iso-8859-1",
        'Merged':False,
       # 'noBOTSID': True,
        }

structure=    [
{ID:'HEA',MIN:1,MAX:10000,
    QUERIES:{
        'frompartner':  {'BOTSID':'HEA','EANZENDER':None},
        'topartner':    {'BOTSID':'HEA','EANONTVANGER':None},
        'reference':    {'BOTSID':'HEA','BERICHTNUMMER':None},
        'testindicator':{'BOTSID':'HEA','TEST':None}},
    LEVEL:[
        {ID:'HAL',MIN:0,MAX:10},
        {ID:'LIN',MIN:0,MAX:10000,
            LEVEL:[
                {ID:'LAL',MIN:0,MAX:10},
                ]},
        {ID:'TOT',MIN:0,MAX:1},
        ]},
]

nextmessage = ({'BOTSID':'HEA'},)

   
recorddefs = {
    'HEA':[             #invoice header
            ['BOTSID','C',3,'A'],
            ['SOORT', 'C', 20, 'AN'],        
            ['EANZENDER', 'C', 13, 'AN'],       #ILN sender  
            ['EANONTVANGER', 'C', 13, 'AN'],         #ILN receiver
            ['TEST', 'C', 1, 'AN'],         #test indicator (0 or 1)
            ['FACTUURNUMMER', 'C', 17, 'AN'],         #invoice number
            ['FACTUURDATUM', 'C', 8, 'AN'],          #invoice date
etc...

My CSV file to read the data
HEA,"INVOICE96AUNEAN008","8712345678910","8712345678820","0",

but the output values for SOORT and EANZENDER not displaying correctly
Capturenew.JPG
the highlighted should be 8712345678910
Please help to fix this error.
thank you all in advance.

Regards
Srini

Eppye Bots

unread,
Aug 16, 2022, 2:42:24 AM8/16/22
to 'Chuck Turco' via Bots Open Source EDI Translator
looks like input file is read as fixed length records?
this is a plugin on bots sourceforge website?
so what has changed in configuration?

kind regards, Henk-Jan Ebbers


--
You received this message because you are subscribed to the Google Groups "Bots Open Source EDI Translator" group.
To unsubscribe from this group and stop receiving emails from it, send an email to botsmail+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/botsmail/1188df09-5f9e-4883-939f-00b11850486cn%40googlegroups.com.
Reply all
Reply to author
Forward
0 new messages