[XSL-LIST Mailing List Archive Home]
[Reply To This Message]
Re: "FLAT" XML to Hierarchical XML
Subject: Re: "FLAT" XML to Hierarchical XML|
From: Brandon Schenz <brandons@xxxxxxxxxxxxxxxxx>
Date: Fri, 24 Sep 2004 13:48:18 -0400
The problem is that the Source file is being created by an outside
partner. They do not pass their ID for the customer, and I have no way
of knowing if the customer already exists in my DB until I attempt to
Midwest Sports Supply
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
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
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.
PURCHASE STYLUS STUDIO ONLINE TODAY!
Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!
Download The World's Best XML IDE!
Accelerate XML development with our award-winning XML IDE - Download a free trial today!
Subscribe in XML format