EDI X12-Read
View some of the Frequently Asked Questions to our support staff. Included are some tips and tricks making this forum ideal for users getting started with GoAnywhere MFT. Note: Users can reply to existing topics but only our support staff can add new topics to this forum.
1 post
Page 1 of 1
- Site Admin
- Posts: 43
- Joined: Wed Jun 21, 2017 8:12 am
Question:
Can I read an EDI X12 documents into GoAnywhere?
Answer:
Follow the instructions below to write the contents of an EDI X12 file to an Excel file using the Read EDI X12 Data Mapper.
EDI X12 Transaction Set – Select an EDI X12 Transaction Set from the list of those installed. See the
Can I read an EDI X12 documents into GoAnywhere?
Answer:
Follow the instructions below to write the contents of an EDI X12 file to an Excel file using the Read EDI X12 Data Mapper.
- From within the Project Designer page, expand the Data Translation folder in the Component
Library, and then drag the Read EDI X12 task to the Project Outline.
- On the Read EDI X12 task, specify values for the following attributes:
EDI X12 Transaction Set – Select an EDI X12 Transaction Set from the list of those installed. See the
- Click Launch Data Mapping Wizard on the Read EDI X12 task main panel to open the EDI X12 Data Mapper.
- When you first launch the EDI X12 Data Mapper, you will see an Input EDI X12 Transaction Set and a RowSet container. The EDI X12 Transaction Set container contains all available data elements, segments, and envelopes for the chosen Transaction Set.
- Each Transaction Set element can be read to a RowSet variable column. To create a column, select the Transaction Set element then drag and drop it into the RowSet variable container. Double-click on a RowSet container name to give the output RowSet variable a name.
- Multiple RowSet variables can be created to isolate segments of data. To add a new RowSet, right-click an open space within the Mapper and select Add RowSet. Follow the above drag and drop procedure to populate the new RowSet.
- Click Apply to leave the Mapper and return to the Project Designer.
- One possible use of the output RowSets would be to write the data to an output file. The following image is an example of a RowSet variable containing package data being written to an Excel file using the Write Excel task.
Philip Horn
Senior Support Analyst
e. [email protected]
p. 1-800-949-4696
w. GoAnywhere.com | HelpSystems.com
Senior Support Analyst
e. [email protected]
p. 1-800-949-4696
w. GoAnywhere.com | HelpSystems.com
1 post
Page 1 of 1