EDIFACT D99B invoice to CSV

[Mark Dayton]

Hi, I've setup BOTS and i'm struggling to get edi2csv working.

It errors, im new to BOTS and EDI.

But what i'm trying to acheive is below.

1. Convert EDI 210 (210 Motor Carrier Freight Details and Invoice) to
CSV
2. Convert EDIFACT D99B invoice to CSV

Also would like it to work so we can convert CSV to EDIFACT/EDI 210

I hope this makes sense, again appologies for the newby questions.

Mark

[hjeb...@gmail.com]

hi Mark,

probably this error:
http://code.google.com/p/bots/wiki/Migrate210

henk-jan ebbers

[Mark Dayton]

Hi Henk-jan,

Right I have the edi2csv working now.

And also the errors now appear using google chrome instead of ie9.

I'm getting edifact.INVOICD99BUN", in structure: bots-collision
detected at record "[['UNH'], ['TAX']]". when trying to convert one of
my example files which i believe to be EDIFACT D99B INVOICE file,
although you did say was a DESADV?

Any ideas how I can solve this?

Thanks
Mark

[hjeb...@gmail.com]

you are right, it is an invoice.

the problem is in grammar; look at the trailer of the message, after the UNS segemnt.
Check the grammar/structure for INVOICD96a, you can see the problem is solved here by nesting some segments under the UNS segemnt.

this is a (good) workaround, problem will be solved in bots 2.9

kind regards,
henk-jan

[Mark Dayton]

Okay I have 96a

{ID: 'UNS', MIN: 1, MAX: 1},
{ID: 'CNT', MIN: 0, MAX: 10},
{ID: 'MOA', MIN: 1, MAX: 100, LEVEL: [
{ID: 'RFF', MIN: 0, MAX: 1, LEVEL: [
{ID: 'DTM', MIN: 0, MAX: 5},
]},
]},
{ID: 'TAX', MIN: 0, MAX: 10, LEVEL: [
{ID: 'MOA', MIN: 0, MAX: 2},
]},
{ID: 'ALC', MIN: 0, MAX: 15, LEVEL: [
{ID: 'ALI', MIN: 0, MAX: 1},
{ID: 'MOA', MIN: 0, MAX: 2},
]},
{ID: 'UNT', MIN: 1, MAX: 1},
]}
]

and 99b

{ID: 'UNS', MIN: 1, MAX: 1},
{ID: 'CNT', MIN: 0, MAX: 10},
{ID: 'MOA', MIN: 1, MAX: 100, LEVEL: [
{ID: 'RFF', MIN: 0, MAX: 1, LEVEL: [
{ID: 'DTM', MIN: 0, MAX: 5},
]},
]},
{ID: 'TAX', MIN: 0, MAX: 10, LEVEL: [
{ID: 'MOA', MIN: 0, MAX: 2},
]},
{ID: 'ALC', MIN: 0, MAX: 15, LEVEL: [
{ID: 'ALI', MIN: 0, MAX: 1},
{ID: 'MOA', MIN: 0, MAX: 2},
{ID: 'FTX', MIN: 0, MAX: 1},
]},
{ID: 'UNT', MIN: 1, MAX: 1},
]}
]

The only extra part I can see is the FTX line on 99b, they look
identical apart from this. Am I looking in the right place?

Should I be looking to move the TAX and MOA to within the UNS segment?

Thanks
Mark

[hjeb...@gmail.com]

{ID: 'UNS', MIN: 1, MAX: 1, LEVEL: [

{ID: 'CNT', MIN: 0, MAX: 10},
{ID: 'MOA', MIN: 1, MAX: 100, LEVEL: [
{ID: 'RFF', MIN: 0, MAX: 1, LEVEL: [
{ID: 'DTM', MIN: 0, MAX: 5},
]},
]},
{ID: 'TAX', MIN: 0, MAX: 10, LEVEL: [
{ID: 'MOA', MIN: 0, MAX: 2},
]},
{ID: 'ALC', MIN: 0, MAX: 15, LEVEL: [
{ID: 'ALI', MIN: 0, MAX: 1},
{ID: 'MOA', MIN: 0, MAX: 2},
]},
]},
{ID: 'UNT', MIN: 1, MAX: 1},
]}
]

[Mark Dayton]

Okay I see what you've done there with the LEVEL.

Thanks very much for you help.

I'm now getting Record "LIN" numeric field "1222" has non-numerical
content: "FT".

The message contains LIN+1++SLHRAI01267:AK++FT'

Is this an error in the message example?

Thanks
Mark

[hjeb...@gmail.com]

yes, this message is not correct.

henk-jan

[Mark Dayton]

I've edited the extra + out of it and it now errors with FTX not in
grammar

I've added it back into the example you gave me and I get "FTX" not in
grammar; looked in grammar until mandatory record: "[['UNH'],
['UNS']]".

I've also tried to move it above the UNS segment, can't seem to get it
to work? Any ideas

Thanks
Mark

[hjeb...@gmail.com]

the grammars bots uses are according to the official UN definitions.
so I guess they just added something they needed.

are you in the logistic sector?

henk-jan

[Mark Dayton]

Yeah we are, the example files came from Catterpillar.

[Mark Dayton]

These FTX records are free text, and i'm trying to incorporate these
into this grammar.

I've added it in here

{ID: 'MOA', MIN: 0, MAX: 99, LEVEL: [
{ID: 'FTX', MIN: 0, MAX: 99},
{ID: 'CUX', MIN: 0, MAX: 1},
]},

But now getting error Record "CUX" field "C504#1.6347" too big (max
3): "168.4".

This error relates to MOA+DTY:168.4' in the message.

Again sorry any ideas how I can fix this?

Mark

[hjeb...@gmail.com]

ask your edi partner what they are doing.
I am serious.
There might be some misunderstanding, mistake or other problem.
if not, asked them what theri message definition is and/or where they 'made it up' instead of using the standard.

henk-jan