Subject:XML Mappin Author:Ray Valle Date:26 Aug 2009 11:45 PM Originally Posted: 26 Aug 2009 07:47 PM
I have an xml file that I need to have elements mapped to a code list. The code list is supplied as a separate XML file. The results will be inserted into a MySql database.
I am trying to determine the best method for doing this. I am using Stylus studio Enterprise edition. Can someone guide me in the direction I should go in getting this accomplished? I have attached the xml file as well as the ONIX for Books Code List.
The format is as follows:
The top-level tag is <ONIXCodeTable>.
The document contains a sequence of composite elements<CodeList>, each of which contains the data elements <CodeListNumber>, <CodeListDescription>and <IssueNumber>, and a sequence of composite elements <Code>.
Each composite element <Code>contains the data elements <CodeNumber>, <CodeValue>, <CodeDescription>, <CodeNotes> and <IssueNumber>.
Here is a sample:
<?xml version="1.0" encoding="utf-8"?>
<CodeListDescription>Notification or update type code</CodeListDescription>
<CodeNotes>Use for a complete record issued earlier than approximately six months before publication.</CodeNotes>
For instance, in the sample below the composit <ProductIdentifier> has a child element <ProductIDType> with value 2. This value correlates to IBSN and is found in code list 5. as such:
<CodeListDescription>Product identifier type code</CodeListDescription>
<CodeNotes>International Standard Book Number, pre-2007, unhyphenated (10 characters)</CodeNotes>
Then there is a another iteration of the same element with value 03. This value correlates to IBSN13 and so on. How would the lookup table need to be formatted to handle the translation?