Some more useful EDI sample programs
Below are example programs to demonstrate how one can use the Framework EDI component to process EDI files in several ways that can be useful in an EDI solution. You must have EDIdEv Framework ED installed on your machine to run the programs successfully.
Windows Service EDI Applications
Windows Service application examples that generates and acknowledges EDI files at intervals of 30 seconds.
Reading EDI files with MS Word
This example of a VB script macro using Framework EDI demonstrates how one can easily utilize MS Word to read and validate EDI files. (How it works)
Creating a macro in MS Word in 5 minutes that reads and validates an EDI file.
EDI Mapper in Excel
This is an example of an Excel macro program in Visual Basic to demonstrate how one can easily transform an MS Excel spreadsheet into an EDI mapper
for generating and translating small EDI files. (How it works)
Excel to EDI
More Excel macro programs to demonstrate how to generate and translate from and to an Excel spreadsheet.
- ExcelFlatEdi.zip - copy-&-paste a flat file onto a spreadsheet, massage it, then generate an EDI file
- ExcelEdiX12.zip - generate and translate an EDI X12 file in Excel
- ExcelEdiEdifact.zip - generate and translate an UN/EDIFACT file in Excel
EdiXml.zip This is an example program that converts an EDI file to XML. Click here to view source code.
cSharpEdiXml.zip This is a C# example program that shows how to converts an EDI file to XML as well as convert XML to EDI.
EDI X12 to EDI UN/EDIFACT
Below is a sample program that reads an EDI X12 850 file and maps it to an EDI UN/EDIFACT ORDERS file.
EDI X12 Splitter
Below is a sample program to demonstrate how one can separate the Functional Groups of an EDI file into their own separate EDI files so that the
files can be forwarded to their respective departments for processing.
Consolidate EDI files
Below is an example program that consolidates several EDI files into one.
Mask EDI files
Below is a program that masks the data in an EDI file, but maintains the file's overall structure.
Truncate EDI files
Having difficulty viewing a huge EDI file? Below is an example program using the Framework EDI that can truncate an EDI file by specifying the number
of segments you want while maintaining a valid EDI structure.
EDI Analyzer Tool
Below is a sample EDI tool that checks for errors in an EDI message
AnalyzerCSharp.zip (C# with Event handling)
EDI Viewer (eFileManager)
Below is a sample program that parses an EDI document down to its basic units and displays them in a hierarchy tree similar to our eFileManager.
EDI Files to Database
Below is a VS2010 C# example program that validates, acknowledges and translates different EDI files into an Access database.
Multiple Trading Partners
Below is a VB6 example program that demonstrates how to translate different types of EDI documents with different implementation guidelines from multiple trading partners.
Send EDI Files
Below is a sample program that automatically creates a 997 acknowledgment file when an EDI file gets loaded and sends the EDI file and 997 file by FTP to a server and by SMTP (email) to a mailbox.
EDI to Text
- TranView.zip - A sample program that translates an EDI X12 file into an HTM file.
- vbNetEdiToCsv - A sample programs that translates an EDI file into a CSV format text file.
- A source code that converts an EDI file to a Text file (with XML structure).
- (Also see example programs that translates EDI files to Excel, then from Excel you can export to text or other file formats.)
EDI X12 Reader
Below is a sample program, "EDIReader", that displays an EDI X12 file in a more readable layout without the EDI structure and codes, but only the
descriptions and values to make the EDI file more readable.
Click here to evaluate the Framework EDI
The example programs provided in this article are for illustration only and have no purpose other than to show software developers how to use the Framework EDI component in programming languages to process EDI files. If you have any questions, don't hesitate to contact us: