EDI (Electronic Data Interchange)


What is required to implement an EDI system? For ex. my app can export any standard EDI xml file, or i need to know the data format from customer app. Is a standard format or not?

best regards
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

KimputerIT ManagerCommented:
As with ALL forms of communications, you need to agree upon a set of rules.
BOTH sides need to know these rules to properly create and interpret the EDI files.

ONE side: create files (incl auditing content), transfer files, backup files
OTHER SIDE: receive/retrieve file, interpret file (incl auditing content), backup files.
(and in some cases, vice versa)

There's no real standard format, as you can change anything you want, as long as both sides agree upon it (some companies don't use XML, simply using this character (') as the delimiter.
Even this could be a valid EDI file:


Just as long as both sides know what it means.

If you set up a new EDI system, you can design it yourself. If you are using existing rules (integrate a company that's already working with the EDI files), it's better you adjust to the existing rules and build your solution around it. In some cases, it's better to have a rule set from a long existing EDI system, as all the familiar errors, are already filtered out (for example, you can't have two lines starting with "AB+1+1'" as that would mean that xx conflicts with yy etc etc).
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
EDI is a HUGE subject, and can be very, very difficult to implement, depending on your needs and skill level.

There are EDI standards in several "flavors", like X12, EDIFACT, etc. You must determine if you're going to use one of those, and if so, which one. Even the the "standards" can change, and they'll be different for different industries (Medical, Manufacturing, etc), so as Kimputer said you must be sure that both sides agree on the format. From there, it's just a matter of transferring files containing the information needed.

There are many commercial and open source programs that can create and handle EDI for you. In many cases, it's simpler and better to use one of those programs instead of trying to create your own.
rflorencioAuthor Commented:

can you sugest anu EDI Open Source Software.

Best regards
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
BOTS is the one I'm thinking of, but I'm sure there are others:


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Languages and Standards

From novice to tech pro — start learning today.