[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

RE: Re: "FLAT" XML to Hierarchical XML

Subject: RE: Re: "FLAT" XML to Hierarchical XML
From: cknell@xxxxxxxxxx
Date: Fri, 24 Sep 2004 13:13:07 -0400
flat xml
XSL is good, but it isn't magic.

You can use it to create a unique id string for an element, but you have to tell it the basis for identifying elements. For example, in your sample document you have a Ship_To_First_Name element and a Ship_To_Last_Name element.

Suppose you have two customers named "John Smith". You couldn't use a combination of first name and last name to uniquely identify individual customers. "Well," you might say, "then I'll combine first name, last name, Ship_To_Address_1, Ship_To_Address_2, Ship_To_City, Ship_To_State, and Ship_To_Zip to use as the basis for a unique identifier."

That will work to differentiate the two John Smiths, but suppose one of the John Smiths enters a subsequent order and calls himself "John L. Smith", or "J. Smith". How will you be able to tell XSL that these are the same person?

You'll have to go back to your database adminstrator and ask if there is a column in the customer table with a name like "customer_id" that uniquely identifies a customer.
--
Charles Knell
cknell@xxxxxxxxxx - email



-----Original Message-----
From:     Brandon Schenz <brandons@xxxxxxxxxxxxxxxxx>
Sent:     Fri, 24 Sep 2004 12:37:10 -0400
To:       xsl-list@xxxxxxxxxxxxxxxxxxxxxx
Subject:  Re:  "FLAT" XML to Hierarchical XML

That will be another problem that I hoped would be able to be fixed by the XSL.

*Brandon Schenz*
Midwest Sports Supply
Phone: 513-956-4900
Fax: 513-956-4910
E-mail: brandons@xxxxxxxxxxxxxxxxx


cknell@xxxxxxxxxx wrote:


I don't see a customer id element or attribute in the sample source XML you provided. How will you uniquely identify each customer?

Current Thread

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
Email
First Name
Last Name
Company
Subscribe in XML format
RSS 2.0
Atom 0.3
Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.