Page 1 of 1

EDI X12-Write

Posted: Thu Aug 29, 2019 5:06 pm
by Support_Philip
Question:

Can I use GoAnywhere to write an EDI X12 document?

Answer:

Follow the instructions below to write the contents of a CSV file to an EDI X12 file using the Write EDI X12 data mapper.
  1. From within the Project Designer page, expand the Data Translation folder in the Component Library and drag the Read CSV task to the Project Outline.
  2. On the Read CSV task, specify values for the following attributes:
    Input File – The file path and name of the CSV file to read. In this example, the
    input file will contain purchase order header data.
    Output RowSet Variable – The name of the variable which will contain the data read
    from the input file.
    WriteEDIX12task.png
  3. For this example, a second Read CSV task is added to read in packaging data.
    WriteEDIX12task2.png
  4. Expand the Data Translation folder in the Component Library and drag the Write EDI X12 task to the Project Outline.
  5. On the Write EDI X12 task, specify values for the following attributes:
    1. Output File – The path and file name of the EDI X12 file to write.
    2. Sender ID – The code published by the sender of the data.
    3. Receiver ID – The code published by the receiver of the data.
    4. Control Number – The value used to uniquely identify the message.
    5. EDI X12 Transaction Set - Select an EDI X12 Transaction Set from the list of those installed. Transaction sets can be downloaded from the Add-on marketplace.
    WriteTask.png
    WriteTask.png (26.52 KiB) Viewed 15468 times
  6. Click Launch Data Mapping Wizard.
  7. The EDI X12 Transaction Set container (on the right side of the page) contains all available data elements, segments, and envelopes of the chosen Transaction Set.
  8. Each Transaction Set element can be linked to an input RowSet variable column. When the Project executes, the Transaction Set element will be populated with data from the link RowSet column. Add a column by clicking on the next to the Input RowSet title and selecting Add Column.
  9. Double-click on a column to rename it. Continue adding and naming columns until the RowSet contains the columns needed for the transaction set. Column names do not need to be identical to those contained in the RowSet because the column index is used.
    WriteEDIX12datamapperExample.png
  10. Repeat this process for the second input RowSet variable.
  11. To link an input RowSet column to a Transaction Set element, click on the column name in the RowSet container, then drag and drop it to the Transaction Set element. An arrow will appear to indicate the column and element are linked.
    WriteEDIX12ExampleDattaMapper.png
  12. The following image illustrates the Project Outline for the Write EDI X12 task example using the data mapper.
ExampleWriteEDIprojectOutline.png
ExampleWriteEDIprojectOutline.png (17.28 KiB) Viewed 15468 times