Translation of an EDI data file to text fixed columns date f

[Ali Salehian]

Hello,

My name is Ali Salehian, I have been working with CL for few years mainly dealing with HL7 data. We are recently in the process of converting some EDI (X12) applications from another system into CL. For example we are receiving EDI 810 (X12) transaction from outside vendors, we need to translate this data to a flat file (text fixed columns data)  to be sent to Lawson system. The output file will contain three types of information: Header data, Body data (repeating data) and then the trailer data as:

10_header

  10.1 header_field1        char (10)

  10.2 header_field2        char (15)

 

---

 

---

20_repeating detail  repeat  100 times

  20.1 item number    char (10_

  20.2 item_qty            number

  20.3 item price          number

 

---

 

---

30_trailer

  30.1 trailer_field1        char (10)

  30.2 trailer_field2        char (15)

 

---

 

---

Using  the Translator Configurator to translate X12 data (for example EDI 810) to a flat file, I could create a X12 variant for my input. What format should I use for my output file? I thought I could use FRL format. However I don’t see the capability within FRL to repeat a bunch of fields being grouping together.  Please any suggestion or ….

Thank you

Topic

[Jim Kosloskey]

Take a look at HRL.

email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.

[Ali Salehian]

Thank you, I will! I am sure you will hear from me again!

Ali

[Author]

Replies