TASK: EDI To Flat File

OS: WindowsOS

Platform: webMethods 4.6/SAP BC

To convert an edi document to flat file we have to follow the below procedure. Firstly, 

Create a Dictionary: 

To create a Dictionary we have to use SEFParse Java Service (WmEDI-wm.b2b.edi: SEFParse). This service is used for generating Flat File dictionaries and schemas.

In SEFParser Service assign the following values in Service In under Pipeline Tab.

Ø SEFFileName:webMethods6IntegrationServerpackagesWmEDIpubSEFSX124010.sef (Here we parsing 4010 version EDI so we have to give 4010.sef).

Ø EDIDocName: Since we are parsing a 210 EDI we have to give the name as“210”.

Ø Version: Its an optional filed here we can give version as “4010”.

Ø TargetSchema: Give the path of Schema where you want to create it  (Example: EDI_Parse: T210).

Ø TargetPackage: Give the package name (Ex: Default).

Ø TargetDictionary: Create an empty dictionary and give its path in this filed (Example: EDI_Parse: D210).

Now run the Parser service and refresh the server then automatically schema will be generated and dictionary will be filled with fields. 

 Create a Document Type:

Ø  Select Schema in the Navigation Panel (Ex: T210)

Ø  Now Click on Flat File Structure tab and click on document symbol then a document type will be created (EDI_Parse: T210DT).

Parsing Service:

Ø  Now create a service (example ParseEDI) for parsing an EDI file. 

First take the envelope process for validating the EDI file (WmEDIsamples-sampleServices: X12Values).

Ø  Now click on “envelope process” service and double click on “edidata” under pipeline tab and assign the edi 210 file.

Ø  Assign the path of the schema in “EDIffSchema” field (Ex: EDI_ParseT210).

Ø  Take the Reference Document Type of EDI in pipeline out (Ex: T210DT).

Ø  Now map EDIValues to the Reference Document Type.

Ø  Insert a map step and map the required fields from EDI Reference Doc to another Flat File Document type (Ex: FlatSchemaDT).

Ø  While mapping from multiple document to single document we have to convert multiple document to a single document by using a loop step and then map the fields.

Ø  While mapping to a multiple document use “appendToDocumentList” service. 

Using appendToDocumentList Service:

Ø  Copy all fields from multiple documents.

Ø  Take a single document and append all fields under that document.

Ø  Now map the required fields to single document and assign null values to remaining fields.

Ø  Now use appendToDocumentList Service as shown above.

Ø  Take multiple document list in “Pipeline In” under “Pipeline” tab (Ex: SingleDocList).

Ø  Now map Single document to “fromItem” and multiple document to “toList”(Ex:SingleDoc to fromItem and SingleDocLIst to toList).

Ø  Now map toList in “Service Out” to SingleDocList in PipeLine Out.

Ø  Now map this SingleDocList to main Multiple document list.

Ø  Now insert convertToString Service (WmFlatFile-pub.flatFile: convertToString) and map Flat file Document type to ffValues.

Ø  Give Flat file Schema by double clicking ffSchema Ex: EDI_Parse: FlatSchema).

Ø  We will get Flat File String as output.