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...
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.