"Bill Nguyen" <billn_nospam_please@jaco.com> wrote in message
news:elv4d89oHHA.4112@TK2MSFTNGP04.phx.gbl...
>I am having problem opening the XAL file in the browser because the xmlns
>URL and xsi URL are invalid.
> If I would like to ignore those, what's the way to get the data into an
> SQLserver table?

"Bill Wade" <bwade@profdata.com> wrote in message
news:%236OSIpSpHHA.1216@TK2MSFTNGP03.phx.gbl...
> Contact PCATS at http://www.pcats.org to acquire a copy of the schema.
> Then group the schema files in the directory with your XML file to allow
> the browser to open and validate the XML.
>
> If you want to process the file in code without access to the XSD files,
> use an XMLReader with an XMLReaderSettings object that has the
> XMLReaderSettings.ValidationType set to ValidationType.None.
>
> For example, the code below employs an XSL file to transform the XML
> into the desired format (output to a file thru a StreamWriter). Given
> that you're processing a bill of lading document, you may want to load
> the XML into an XMLDocument object and peel out the pieces you need.
>
> using (FileStream fs = File.Open(uploadFilename, FileMode.Create,
> FileAccess.ReadWrite, FileShare.None))
> {
> FileInfo SourceFile = new FileInfo(XmlFilePath);
> // Establish the settings for the XmlReader
> XmlReaderSettings ReaderSettings = new XmlReaderSettings();
> ReaderSettings.CloseInput = true;
> ReaderSettings.ConformanceLevel = ConformanceLevel.Document;
> ReaderSettings.ProhibitDtd = false;
> // Disable validation
> ReaderSettings.ValidationType = ValidationType.None;
> // Create the reader
> XmlReader Reader = XmlReader.Create(SourceFile.FullName,
> ReaderSettings);
> XPathDocument XPathDoc = new XPathDocument(Reader);
> XPathNavigator XPathNav = XPathDoc.CreateNavigator();
> // Create some XsltSettings and load the stylesheet
> XsltSettings XSLTSettings = new XsltSettings(false, true);
> XslCompiledTransform XSLT = new XslCompiledTransform();
> XSLT.Load(StyleSheet);
> // Do the XSLT transform.
> XSLT.Transform(XPathDoc, XSLTArgs, fs);
> Reader.Close();
> fs.Close();
> }
>
>
> *** Sent via Developersdex http://www.developersdex.com ***

"Bill Wade" <bwade@profdata.com> wrote in message
news:%236OSIpSpHHA.1216@TK2MSFTNGP03.phx.gbl...
> Contact PCATS at http://www.pcats.org to acquire a copy of the schema.
> Then group the schema files in the directory with your XML file to allow
> the browser to open and validate the XML.
>
> If you want to process the file in code without access to the XSD files,
> use an XMLReader with an XMLReaderSettings object that has the
> XMLReaderSettings.ValidationType set to ValidationType.None.
>
> For example, the code below employs an XSL file to transform the XML
> into the desired format (output to a file thru a StreamWriter). Given
> that you're processing a bill of lading document, you may want to load
> the XML into an XMLDocument object and peel out the pieces you need.
>
> using (FileStream fs = File.Open(uploadFilename, FileMode.Create,
> FileAccess.ReadWrite, FileShare.None))
> {
> FileInfo SourceFile = new FileInfo(XmlFilePath);
> // Establish the settings for the XmlReader
> XmlReaderSettings ReaderSettings = new XmlReaderSettings();
> ReaderSettings.CloseInput = true;
> ReaderSettings.ConformanceLevel = ConformanceLevel.Document;
> ReaderSettings.ProhibitDtd = false;
> // Disable validation
> ReaderSettings.ValidationType = ValidationType.None;
> // Create the reader
> XmlReader Reader = XmlReader.Create(SourceFile.FullName,
> ReaderSettings);
> XPathDocument XPathDoc = new XPathDocument(Reader);
> XPathNavigator XPathNav = XPathDoc.CreateNavigator();
> // Create some XsltSettings and load the stylesheet
> XsltSettings XSLTSettings = new XsltSettings(false, true);
> XslCompiledTransform XSLT = new XslCompiledTransform();
> XSLT.Load(StyleSheet);
> // Do the XSLT transform.
> XSLT.Transform(XPathDoc, XSLTArgs, fs);
> Reader.Close();
> fs.Close();
> }
>
>
> *** Sent via Developersdex http://www.developersdex.com ***

> I am having problem opening the XAL file in the browser because the xmlns
> URL and xsi URL are invalid.
> If I would like to ignore those, what's the way to get the data into an
> SQLserver table?
>
> Thanks
> Bill
>
>
>
> <?xml version="1.0"?>
> <pcats:NAXML-FuelsDoc
> xmlns="http://www.naxml.org/Retail-EDI/Vocabulary/2003-10-16"
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> xsi:schemaLocation="http://www.naxml.org/Retail-EDI/Vocabulary/2003-10-16
> NAXML-FuelPrice15.xsd" version="1.5">
> <pcats:TransmissionHeader>
> <pcats:TransmissionId>200705311139</pcats:TransmissionId>
> <pcats:TransmissionDate>2007-05-31</pcats:TransmissionDate>
> <pcats:TransmissionTime>11:39:17-06:00</pcats:TransmissionTime>
> <pcats:TransmissionStatus>original</pcats:TransmissionStatus>
> <pcats:TransmissionSender>Musket Corporation</pcats:TransmissionSender>
> <pcats:TransmissionAgency>DTN Integrated
> Services/dtnDataConnect</pcats:TransmissionAgency>
> </pcats:TransmissionHeader>
> <pcats:FuelPriceInfo>
> <pcats:Terminal>
> <pcats:Name identType="PlantNumber" ident="1132">
> <pcats:NamePrefix>Stck ST Service</pcats:NamePrefix>
> </pcats:Name>
> <pcats:City>Stockton</pcats:City>
> <pcats:State>CA</pcats:State>
> <pcats:FuelProduct><pcats:EffectiveDate>2007-05-30</pcats:EffectiveDate>
> <pcats:EffectiveTime>12:01:00</pcats:EffectiveTime>
> <pcats:FuelProductId identType="Ultra Low Sulfur CARB
> #2">0402</pcats:FuelProductId>
> <pcats:Price>2.210000</pcats:Price>
> <pcats:NetChange>.000000</pcats:NetChange>
> </pcats:FuelProduct>
> </pcats:Terminal>
> </pcats:FuelPriceInfo>
> </pcats:NAXML-FuelsDoc>
>