The EDI 810 to Excel sample flow has pre-configured connectors for translating the following transaction sets from X12 specifications: 

**810 Invoice**

Various connectors provide the core elements of the flow:

**X12 Connector**: Translates transaction sets between EDI and XML.
**XML Map Connector**: Transforms data from one XML format to another, providing easy backend compatibility.
**Excel Connector**: Allows you to insert or retrieve the data in these documents to or from an Excel spreadsheet. 

These connectors are configured to automatically move files from one connector to the next until the incoming EDI 810 files are transformed and inserted into Excel. You can modify the automation settings for each connector in its Automation tab, or you can manually process each step in the workflow using the Send button in the connector's Input tab.

If you would like to use this sample flow in your workspace, please follow these instructions:

**Importing Workspace**
 
1. Create Workspace

First, navigate to the **Flows** tab and click on the cogwheel icon in the top right corner. Choose the **Create Workspace** option to create a new Workspace for this sample flow.

2. Import Workspace

Then, from the same cogwheel dropdown, click **Import Workspace**. In the resulting dialog, choose the downloaded sample flow *EDI810toExcel.arcflow* to import the relevant connectors and settings. You can choose to import the flow into any Workspace you like, but we recommend using separate Workspaces for distinct workflows.

Once you have successfully imported the sample flow, you can begin configuring the connectors to best suit your specific use case.

**X12 Connector**

1. Review Interchange Settings for Incoming Documents

Navigate to the **Settings** tab of the X12_810 Connector. Review the Interchange Settings and ensure that the following segments contain the correct information:

ISA05 - Sender ID Qualifier
ISA06 - Sender Identifier
ISA07 - Receiver ID Qualifier
ISA08 - Receiver Identifier

2. Review the Functional Group Settings for Incoming Documents

Ensure the following segments contain the correct information:

GS02 - Sender Identifier
GS03 - Receiver Identifier

Since incoming documents are received by the vendor from a partner, the value AMAZONDS is preconfigured as the Sender Identifier, and VENDOR as the Receiver Identifier.

***Once you configure the X12 Connector, the sample flow is ready for use!***

For a better understanding of which connectors process the EDI 810 as it flows from start to finish, please continue reading.

**EDI 810 Invoice**

When the EDI 810 Invoice is receieved, it will be translated into XML in the X12_810 connector, then sent to the XMLMap_810 Connector for XML transformation, and finally passed onto the Excel_810 Connector, which outputs an Excel invoice. You can navigate to the **Output** tab of the Excel_810 Connector to find the invoice file.

Are You Up & Running?

Congratulations for successfully configuring the EDI 810 to Excel sample flow! If you are confronted by any issues or have any further questions, please do not hesitate to contact us.

Contact ArcESB Support (support@arcesb.com)