SSDN - URGENT URGENT URGENT ! (EDIFACT 921 -EDI files to Excel XML or CSV)

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

Ace Brown

Subject: URGENT URGENT URGENT ! (EDIFACT 921 -EDI files to Excel XML or CSV)
Author: Ace Brown
Date: 06 Dec 2011 12:48 PM
Originally Posted: 06 Dec 2011 12:45 PM

I have EDIFACT 921 DELFOR (delivery forecasts). I need 5 of them to be converted into XML and I want to display the Quantities, Delivery Dates, Etc. in non-technical terms. Please advise. I am new to using Stylus Studio. Here is a screenshot of one example within Stylus Studio 2011 XML Enterprise Suite.

This is VERY URGENT as I need to display a historical for a major vehicle manufacturer before tomorrow Wednesday (12-7-11).

The screenshot shows multiple EDI files that I just opened within Stylus Studio. I can interpret the data pretty well by looking at the code, but I need to extract it and only display the pertinent segments on an excel spreadsheet...

Ace Brown

Subject: URGENT URGENT URGENT ! (EDIFACT 921 -EDI files to Excel XML or CSV)
Author: Ace Brown
Date: 06 Dec 2011 02:24 PM

So far I have just copy and pasted the data (green and blue text) out onto a Word Doc, removed a bunch of the unnecessary info, and then copy and pasted it into an excel file.

This is the only way that I have come up with thus far to get my data onto an excel spreadsheet. It will still require a lot of manual adjustment to move certain data into new columns with proper header above.

Ivan Pedruzzi

Subject: URGENT URGENT URGENT ! (EDIFACT 921 -EDI files to Excel XML or CSV)
Author: Ivan Pedruzzi
Date: 06 Dec 2011 03:53 PM

Ace,

We just contacted you offline with our offer to help.

Please have a look at the video tutorial at
http://www.stylusstudio.com/videos/EDItoXMLPart1/editoxmlPart1.html

Hope this helps
Ivan Pedruzzi
Stylus Studio Team

Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!

Go to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.