XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> + What Pipeline standard do you ... (4)
-> + How can i increase sylus memor... (2)
-> - Tutorial & Tech support needed (1)
-> + Generate HTML Documentation fr... (3)
-> + Use of saxonsa outside stylus ... (2)
-> + Schema to DTD (6)
-> + Trial version requires interne... (4)
-> - APACHE FOP text box (1)
-> + Cannot create SQL Server datas... (11)
-> + StylusValidator Crashes (2)
-> + XML diff with optimize Change ... (2)
-> + how do I get the .xsl page to ... (3)
-> + Can't Use WYSIWYG from the Fil... (6)
-> + EDI Help (2)
-> + XInclude support (3)
-> + Editor options and customized ... (3)
-> + Licensed version connectes to ... (6)
-> + handling abstract types in the... (5)
-> + XML not validating against its... (4)
-> + SS gets into state where the "... (6)
-> + Download Link from Order email... (2)
-> + Stylus Studio doesn't run (2)
-> + Indent XML Tags uses pretty sh... (2)
-> + Some questions on supported pl... (3)
-> + Apache FOP Border (2)
-> + line numbers, line-wrap.. (11)
-> + Not Able to Load Siebel Web Se... (3)
-> + XSLT node or nodeset as scenar... (4)
-> - tree view parsing error: Expec... (1)
-> + reactivating the license key f... (2)
-> + XSL FO region-body border (2)
-> + WhiteSpace facet default (2)
-> - Web Service Call (1)
-> + DB to XML convertion (6)
-> + Converting: How to handle data... (2)
-> + Toss Character Exception (2)
-> + EDI conversion COM segment (5)
-> - SS passing invalid CALS table ... (1)
-> + Carrier Related EDI SAP questi... (2)
-> + How to generate 1 output XML f... (2)
-> + Urgent Eval: How2 w/ Possibly ... (4)
-> + Preview Problems (7)
-> + Mapping to EDIFACT ORDERS UNT0... (8)
-> + Deploying Conversion XML to ED... (2)
-> + Use EDI Adapter within Sap BC (3)
-> + Uninstall->instal entepr. 2007 (2)
-> - xml data to sql 2000 table (1)
-> - Convert from Oracle DB to XML ... (1)
-> + NTFShardlink broken (5)
-> + Can't get catalog to work (3)
-> + Only One of each EDI segment g... (3)
-> + convert (2)
-> + convert (4)
-> + EDIFACT to XSD problem (3)
-> + quark xpress tags (2)
-> + Duplicating nodes allows to cr... (2)
-> + Duplicated, unused nodes are r... (3)
-> + Converting to XML from a varie... (5)
-> + xsd:import's with escaped char... (8)
-> + Viewing the FO Sample Applicat... (3)
-> + Stylus Studio - Window tiling (3)
-> + Question about XML->Java Objec... (2)
-> + SVG web-based editor (2)
-> + conversion process for the pdf... (2)
-> + GUI Mapper does not create pro... (4)
-> + JavaScript working inside prev... (4)
-> + Stylus Studio Crashes when I a... (4)
-> + SVG ImageReader for FOP (2)
-> + Web Service Call Using HTTPS (8)
-> + Meditech database (2)
-> + How to connect to Informix (5)
-> + long filenames in Berkeley XML... (3)
-> + Opening multiple documents = m... (3)
-> + MySQL Connectivity (2)
-> + using .xsd to create forms (3)
-> + Convert-to-XML Engine could no... (2)
-> + editor questions (2)
-> + Cannot connect to SQL server (7)
-> + Convert Cobol file to XML (2)
-> + XML Diff problem (4)
-> + running XSLT - time + memory m... (7)
-> + New wsdl creation (4)
-> + DB to XML Parameters (2)
-> + Help (html in xml) need to out... (8)
-> + Stylesheet questions (2)
-> + Verion 1.0 XPATH for testing "... (5)
-> + Berkely XML DB file system (2)
-> + WYSIWYG in 2007 demo (2)
-> + EDIFACT code list problem (3)
-> + XQuery over a Berkeley XML DB ... (3)
-> + Href and display linked ref. (2)
-> + How my applications can gener... (11)
-> + CLASSPATH (2)
-> + Fixed order of attributes (2)
-> + merging XML files (13)
-> - The Struzzo.exe hung with no G... (1)
-> + Problem Registering Old Versio... (4)
-> + CHART.XML + CHART.XSL to CHART... (17)
-> + Aplication not loading (6)
-> + Can Stylus Studio be used to s... (2)
-- Previous [1801-1820] [1821-1840] [1841-1860] Next
+ Website Feedback (249)
+ XSLT Help and Discussion (7625)
+ XQuery Help and Discussion (2017)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
Jon SharpSubject: "SDQ format" processing
Author: Jon Sharp
Date: 10 Aug 2006 10:37 AM
I've recently received an EDI file from a vendor that I need to convert into an XML document. I've been doing this for some time using Stylus Studio. However, this time the file format is slightly different. I've been told it is in "SDQ format". It is supposed to be a standard X12 EDI document, but Stylus Studio's EDI file converter can't understand it as an EDI file. When I inquired to the precise nature of this format, I was told the following:

--
An SDQ po is just a type of X12 formatted EDI. The basic layout is that the line item detail is first based on a "line item basis or by product" like normal po's. On an SDQ po you have another level of looping inside the "line item basis or by product" which is the SDQ segment. In the SDQ segment it lists qty per store and store numbers. In the P0102 field there is the total qty. In the SDQ03 it lists a store number, in the SDQ04 it lists the qty for the store in the SDQ03. The SDQ05 and 06 follow the same pattern which is repeated up to the SDQ22. Please let me know if you need further details on this setup.
--

I was wondering if perhaps someone else has seen this type of file before and knows how I might go about working with it using Stylus Studio.

Thank you for any help you can provide!

--
Jon

Postnext
Tony LavinioSubject: No Topic
Author: Tony Lavinio
Date: 10 Aug 2006 11:47 AM
Could you post a sample of this document to our support email
forum at stylus-field-report@progress.com ?

We'd like to see exactly how it differs so that we can give you
proper guidance.

Put "SDQ format" in the subject line, please.

Postnext
Tony LavinioSubject: No Topic
Author: Tony Lavinio
Date: 14 Aug 2006 02:28 PM
I've read over the SDQ file, and it is nothing more than a standard X12 850 Purchase order with some of the segments removed.

Specifically, the start of the file should include the prologue of ISA and GS segments, and the end of the file should have the epilogue of GE and IEA segments.

Also, before each BEG segment there should be an ST segment, and after each CTT segment there should be an SE segment.

Without some of those missing segments, no general-purpose adapter will be able to handle the file, and here's why:

The ISA segment tells what the element and segment separator characters will be. X12 doesn't supply default values, so that segment is needed for those.

The GS segment tells us which version of the transaction sets the message will include. Otherwise, we won't know how to decode the values, or even which validation rules to apply.

The SE segment tells us that the data is in the 850 Purchase Order transaction set. We can't just infer this from the presence of SDQ segments alone, since in addition to the 850, the 163, 180, 210, 212, 214, 223, 810, 830, 840, 843, 846, 852, 855, 856, 860, 862, 865, and 940 transaction sets also use SDQ segments.

Also, I could not find a reference to "SDQ Format" in any of the X12 documentation we have, nor could I find references in the members-only portions of the site. It's possible that it exists somewhere and is poorly indexed, but I could not find it.

In short, I think your vendor has created for you a file that includes some, but not all, of the X12 standard.

What are your options?

1. Have your vendor add the missing pieces so that they emit X12 EDI that is according to the published X12 standards, without omitting mandatory segments.

-or-

2. Use Convert-to-XML and build your own map. Since only a few segment types are used in this message, you'd only have to develop a few pattern matches.

Let us know if we can help further.

Postnext
Jon SharpSubject: Thanks
Author: Jon Sharp
Date: 16 Aug 2006 04:59 PM
Thanks for your assessment. That's mostly what I expected, though I wasn't sure exactly how to deal with it. I think I may have to create a custom map as the vendor doesn't appear to think there's anything "wrong" with it.

Thanks again!
Jon

Postnext
Lara EdomSubject: SDQ
Author: Lara Edom
Date: 23 Mar 2007 10:12 AM
Jon, what was your outcome on this map? How did you handle a SDQ loop that in X12 document exists on detail level but has to create a customer's ship-to header records with re-composed product’ information for each ship-to under it? We received an EDI 850 from a new partner with SDQ segments in it and we don’t have any experience with this map… Any information would be greatly appreciated.

Posttop
Tony LavinioSubject: SDQ
Author: Tony Lavinio
Date: 30 Mar 2007 09:51 AM
Another option would be to create a small program that adds
the missing pieces before and after the SDQ file to make a
completed file, and then have the result of that passed into
the converter.

   
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! 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

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
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.