[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 15:08:51 -0400
RE: Re:  "FLAT" XML to Hierarchical XML
So you still have no way of determining if an order from "John Smith" from a particular address is from the same person as an order from "J. Smith" at the same address. If you are willing to accept that, you can use the technique described on Jenni Tennison's web site that has been recommended to you.
Charles Knell
cknell@xxxxxxxxxx - email

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

My current method will be to check based on primary key fields (last, first, address, city) .

My hope was to put in a filler value until I get real values from my DB. List first "unique" customer with an ID of 1, then also use a CustomerID in the orders part of the XML during the transformation that matches (1). For the OrderID I can use the Order_Number I am getting from my partner, and then when I send it to my DB my OrderID numbers will be used instead.

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

cknell@xxxxxxxxxx wrote:

" ... I have no way of knowing if the customer already exists in my DB until I attempt to add them."

O.K., once you have the file, how will you discover if a customer is already in the database?

Current Thread


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.
First Name
Last Name
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.