SQL Server：EDI 到 XML 数据转换
我需要将 EDI 格式的数据转换为 XML。 有没有关于数据转换过程的分步教程和链接？ 如何从 EDI 转换为 XML，分步指南？
我非常感谢你的帮助。
谢谢
I need to do the data conversion from EDI format to XML.
is there any step by step tutorial, links about what are the processes on data conversion?
How to convert from EDI to XML, step by step guide?
I highly appreciate your help.
Thanks
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
这是一个非常复杂的问题。
首先，简短的回答是：使用商业产品（EDI 翻译器/映射器）。
对于更长的答案，有几种不同的 EDI 标准：
还有一个问题是 EDI 是二进制格式还是 XML 格式。由于您试图将其转换为 XML，因此我假设是前者。 （如果它已经是 XML 格式，则架构至少可用于 X12。）
解析二进制 EDI 是非-琐碎的。处理其他交换要求（例如功能确认），同时需要在办公桌上放一本三英寸厚的标准书来查找一个标准的一个版本的所有段和元素意味着更喜欢“购买”而不是“建造”。
EDI 翻译器/映射器并不便宜，而且有一个学习曲线。当您的贸易伙伴更改版本或标准、添加文档和片段和/或请求新文档作为回报时，成本就会收回。
我对当前的软件还不太了解；在“EDI 翻译器”上搜索其中一些。我相信 BizTalk 对此有一些支持以及。也许其他海报可以推荐一张。
That's a very complicated question.
First, the short answer: Use a commercial product (an EDI translator/mapper).
For a longer answer, there are several different EDI standards:
There's also the question of whether the EDI is in binary or XML format. Since you're trying to convert it to XML, I'll assume the former. (If it's already in XML format, schemas are available for X12 at least.)
Parsing binary EDI is non-trivial. Dealing with other interchange requirements (such as Functional Acknowledgments), combined with the necessity of having a three-inch-thick standards book on your desk to look up all the segments and elements for one version of one standard implies favoring "buy" over "build."
EDI translators/mappers are not cheap, and there's a learning curve. When your trading partner changes versions or standards, adds documents and segments, and/or requests new documents in return, the cost pays for itself.
I'm not up to date on the current crop of software; search on "EDI translator" for some of them. I believe BizTalk has some support for this as well. Perhaps other posters can recommend one.
正如 TrueWill 所说，这是一个复杂的问题。也许您可以提供有关您需要做什么的更多细节。如果您只需要几个文档进行一次性转换，您也许可以编写自己的转换器。如果你的需求不止于此，我不得不同意你会想买一些东西。你买什么取决于你的需要。
你是实时处理这些事情吗？有些产品具有可以向 Web 公开的运行时转换器（Mercator、StylusStuido、BizTalk、Webmethods？不太确定））。
如果您要处理来自多个来源的 EDI，则必须处理不同的行长度、编码、分隔符、标准版本、使用标准文档的方式、确认要求以及向您发送数据的人员可能会犯的错误制造他们声称自己没有制造的东西。
我发现的一些最好的教程是由 Stylus Stuido 完成的。它们是针对其产品的，但它们很好地解释了您可以在使用它们时应用到其他产品的内容。 http://www.stylusstudio.com/learn_xml.html。他们的论坛也很不错。
Like TrueWill said, it's a complicated question. Perhaps you can provide a little more detail about what you need to do. If you have a one-time conversion with just a few documents, you might be able to code your own converter. If you're in for more than that, I have to agree that you'll want to buy something. What you buy depends on your needs.
Are you processing these things real-time? There are some products that have runtime converters you can expose to the web (Mercator, StylusStuido, BizTalk, Webmethods? Not sure about that one)).
If you're dealing with EDI from multiple sources, you'll have to deal with different line lenghts, encodings, separators, versions of the standard, ways they use the standard document, acknowledgement requirements, and mistakes that the people sending you data will make that they claim they're not making.
Some of the best tutorials I've found are done by Stylus Stuido. They're specific to their product, but they do a good job of explaining things that you can apply to other products if you're using them. http://www.stylusstudio.com/learn_xml.html. Their forums are pretty good too.