|
Hi Again
I managed to get it working...both the conversion to XML and back to it's original file.
Thanks for the help...much appreciated!
|
|
|
|
|
I am writing a program that will be processing XML files. There are roughly 5 schemas involved. I should tell you now that I'm not using C# but a language called ABAP (SAP), although I think that's largely irrelevant.
The pseudocode for how this works is as follows:
OPEN FILE file AS TEXT.<br />
<br />
WHILE NOT EOF<br />
<br />
APPEND LINE OF file INTO xml_string.<br />
<br />
END.<br />
<br />
CALL TRANSFORMATION my_transformation USING xml_string INTO my_table.
Originally, there was just one schema and one transformation (a transformation is a small program in SAP that is used to take the XML string and turn it into something called an "internal table" - think of it as a DataTable for you C# developers).
Now that we've got different schemas, however, I need a way to know which one to call based upon the type of file. I've thought of two ways but if someone else has a better idea I'd love to know!
1) Use something in the filename to indicate the type of schema
2) Use an attribute in the root element to indicate the file type:
<envelope ftype='terminations'>
...
</envelope>
Unfortunately, with this approach I'd have to parse the first line of the file manually in my program as ABAP doesn't natively handle XML files very easily so it would be less work to do that. So, I'm leaning that way but I wanted a second opinion.
Thanks in advance.
|
|
|
|
|
Ummm - there are various ways of inidicating the schema in use - usually use of different namespaces, on eper schema. The namespace declaration attribute is generally on the root node of the document.
Alternatively, there is a specific namespace and set of attributes[^] that can be used to show what schema is in use.
Java, Basic, who cares - it's all a bunch of tree-hugging hippy cr*p
CodeProject MVP for 2010 - who'd'a thunk it!
|
|
|
|
|
Hi,
Apologies if this in the wrong place but its the first time I've posted.
I've got a problem using the .net XMLSerializer object. My experience of this is limited and I haven't worked with XML much. I'm trying to something like the following:
<Record xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<Property1>blah</Property1>
<oai_dc:dc xmlns:oai_dc=http:
<dc:Property2>asdsd</dc:Property2>
<dc:Property3>asdasasdda</dc:Property3>
</oai_dc:dc>
</Record>
however the best I can get at the moment is
<Record xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:oai_dc="http://www.openarchives.org/OAI/2.0/oai_dc/" xmlns:dc="http://purl.org/dc/elements/1.1/">
<Property1>blah</Property1>
<oai_dc:dc>
<dc:Property2>asdsd</dc:Property2>
<dc:Property3>asdasasdda</dc:Property3>
</oai_dc:dc>
</Record>
The namespaces are being declared in the root element, not on the dc element as I would like.
I'm attaching the XMLSerializerNamespaces as follows:
Dim XMLNamespaces As New XmlSerializerNamespaces()
XMLNamespaces.Add("oai_dc", "http://www.openarchives.org/OAI/2.0/oai_dc/")
XMLNamespaces.Add("dc", "http://purl.org/dc/elements/1.1/")
XMLNamespaces.Add("xsi", "http://www.w3.org/2001/XMLSchema-instance")
XMLSerializer.Serialize(XMLWriter, inputObject, XMLNamespaces)
and the objects I'm using are shown below:
<XmlRoot("Record")> _
Public Class Record
<XmlElement("Property1")> _
Public Property1 As String
<XmlElement("dc", Namespace:="http://www.openarchives.org/OAI/2.0/oai_dc/")> _
Public DCMetadata As DublinCore
Public Sub New()
DCMetadata = New DublinCore()
End Sub
End Class
<XmlRoot("dc", Namespace:="http://www.openarchives.org/OAI/2.0/oai_dc/")> _
Public Class DublinCore
<XmlElement("Property2", Namespace:="http://purl.org/dc/elements/1.1/")> _
Public Property2 As String
<XmlElement("Property3", Namespace:="http://purl.org/dc/elements/1.1/")> _
Public Property3 As String
Public Sub New()
End Sub
End Class
Is there any way to force the XMLSerializer to output the namespace declarations against an element further down the line?
Thanks for any input,
Andy
modified on Wednesday, January 27, 2010 9:17 AM
|
|
|
|
|
Hi,
this might not the answer you expected, but what is wrong with the namespaces declared within the root element? Both xml are correct, and express the same.
Regards
Sebastian
|
|
|
|
|
Thanks for that, my limited knowledge of XML is the problem here. I have found a way to render the XML as I had intended though. This might be useful to someone else at some point...
Declare an XmlSerializerNamespaces object within the class to be serialized.
<XmlNamespaceDeclarations()> _
Public xmlns As XmlSerializerNamespaces
Then add the namespaces to this collection instead of attaching it to the serializer directly. This has the desired effect of declaring the namespace where it is used.
xmlns = New XmlSerializerNamespaces()
xmlns.Add("oai_dc", "http://www.openarchives.org/OAI/2.0/oai_dc/")
xmlns.Add("dc", "http://purl.org/dc/elements/1.1/")
xmlns.Add("xsi", "http://www.w3.org/2001/XMLSchema-instance")
Andrew
|
|
|
|
|
Hello All,
It's about 4:25 EST and I got in around 7:30am EST. I have scoured the Web for a SIMPLE tutorial or example to send and receive(process) SOAP messages in C#. At this moment, I have not found any full descriptive examples/tutorials to satisfy my goal.
My goal is simple and not in need of anything fancy. I have a web service that requires a SOAP message to be passed to it and I require a response. The closet I have come is to recreate an app that get's the time off of EBay's server which was a paramount step. But when I try the same for my WebService, I receive an error "Malformed SOAP request, SOAP-ENV:Envelope element not found in root". My sniffer, did show that SOAP-ENV was not included in the message, indicating to me that I have to find a way to edit the message.
So, I am now forced to you, my last hope to assist me with accessing my goal. What I am looking for is a tutorial or code example (mostly complete) that would show me how to create a soap message (manually would be better in this case) send it and read the response. Simple (to you) but a monster to me.
Any and I mean any help will be greatly appreciated.
|
|
|
|
|
Hi,
how did you created the client? Could you post the code? I guess the problem is the namespace. SOAP-ENV is the prefix for the soap namespace in your message. Does the message contain a "xmlns:SOAP-ENV=..." in the first element (which should have the local name 'envelope'). Or better, post the request message from your sniffer.
Regards
Sebastian
|
|
|
|
|
Thanks Sebastian for the time:
Below is a snippet of the code that creates and calls the service (simply).
Below the code is the sniffer section that shows that there is no SOAP-ENV namespace. So I guess my guestion is, how can I create a user specified SOAP message.
O
int rprocess;
int rErrors;
int sampAdded;
int sampMod;
int sampDeleted;
int aliAdded;
int aliModified;
int aliDeleted;
int[] recSent = {'1'};
string[] reqNum = {"C0772014121"};
string[] sampType = {"BLOOD"};
string[] sampID = {"07720141210"};
DateTime[] inputDate = {Convert.ToDateTime("2009-10-15")};
DateTime[] inputTime = {Convert.ToDateTime("17:12")};
int[] aliID = {100050};
WebReference.Freezerworks service = new WebReference.Freezerworks();
service.Url = @"http://172.32.2.102:8081/Freezerworks/Update/";
try
{
service.TestUpdate("ffowler",
"garrett1",
"TestUpdate",
1,
"Time Change",
reqNum,
sampType,
sampID,
inputDate,
inputTime,
aliID,
out rprocess,
out rErrors,
out sampAdded,
out sampMod,
out sampDeleted,
out aliAdded,
out aliModified,
out aliDeleted);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message.ToString());
Console.ReadLine();
}
***************************************************************************************************
SNIFFER OUTPUT
<?xml version="1.0" encoding="UTF-8"?>
<env:Header xmlns:env="http://schemas.xmlsoap.org/soap/envelope/"></env:Header>
<soap:Body soap:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<tns:TestUpdate xmlns:tns="http://www.dwdev.com/Webservices/Freezerworks/">
<UserName xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xsd:string">ffowler</UserName>
<Password xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xsd:string">garrett1</Password>
<UpdateServiceName xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xsd:string">TestUpdate</UpdateServiceName>
<RecordsSubmitted xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xsd:int">1</RecordsSubmitted>
<AuditTrailOverallReason xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xsd:string">Time Change</AuditTrailOverallReason>
<SampleID href="#id1"/>
<AliquotType href="#id2"/>
<AccessionID href="#id3"/>
<CollectionDate href="#id4"/>
<CollectionTime href="#id5"/>
<UniqueAliquotID href="#id6"/>
</tns:TestUpdate>
<soapenc:Array id="id1" soapenc:arrayType="xsd:string[1]" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/">
<Item>C0772014121</Item>
</soapenc:Array>
<soapenc:Array id="id2" soapenc:arrayType="xsd:string[1]" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/">
<Item>BLOOD</Item>
</soapenc:Array>
<soapenc:Array id="id3" soapenc:arrayType="xsd:string[1]" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/">
<Item>07720141210</Item>
</soapenc:Array>
<soapenc:Array id="id4" soapenc:arrayType="xsd:dateTime[1]" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/">
<Item>2009-10-15T00:00:00</Item>
</soapenc:Array>
<soapenc:Array id="id5" soapenc:arrayType="xsd:dateTime[1]" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/">
<Item>2010-01-26T17:12:00</Item>
</soapenc:Array>
<soapenc:Array id="id6" soapenc:arrayType="xsd:int[1]" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/">
<Item>100050</Item>
</soapenc:Array>
</soap:Body>
|
|
|
|
|
I am quite new to XSLT and I want to add unique index to elements types to transform something like this:
<item1>
<item2>
<item3></item3>
<item3></item3>
</item2>
<item2>
<item3></item3>
<item3></item3>
</item2>
</item1>
<item1>
</item1>
into:
<item1 id="1">
<item2 id="1">
<item3 id="1"></item3>
<item3 id="2"></item3>
</item2>
<item2 id="2">
<item3 id="3"></item3>
<item3 id="4"></item3>
</item2>
</item1>
<item1 id="2">
</item1>
I tried using position() but it counts based on context and not globally on document.
Thanx. 
|
|
|
|
|
I have got the answer from daniweb (thanks fpmurphy) :
1. <?xml version="1.0"?>
2. <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" >
3. <xsl:output method="xml" indent="yes"/>
4.
5. <xsl:template match="/">
6. <xsl:apply-templates/>
7. </xsl:template>
8.
9. <xsl:template match="*">
10. <xsl:variable name="name" select="name()" />
11. <xsl:element name="{name()}">
12. <xsl:attribute name="id">
13. <xsl:value-of select="count(preceding::*[name()=$name]) + 1" />
14. </xsl:attribute>
15. <xsl:apply-templates />
16. </xsl:element>
17. </xsl:template>
18.
19. </xsl:stylesheet>
|
|
|
|
|
Hello Guys
I am new to XML. I have started reading XML few days back.
I have a question. Consider a table calling "Catalog" and has following
column names "book" , "author", "title", "genre", "price", "publish_date"
"description".
XML representation of Catalog Table
<catalog>
<book id="bk101">
<author>Gambardella, Matthew</author>
<title>XML Developer's Guide</title>
<genre>Computer</genre>
<price>44.95</price>
<publish_date>2000-10-01</publish_date>
<description>An in-depth look at creating applications
with XML.</description>
</book>
<book id="bk102">
<author>Ralls, Kim</author>
<title>Midnight Rain</title>
<genre>Fantasy</genre>
<price>5.95</price>
<publish_date>2000-12-16</publish_date>
<description>A former architect battles corporate zombies,
an evil sorceress, and her own childhood to become queen
of the world.</description>
</book>
<catalog>
Compressed format of catalog table
<?xml version="1.0"?>
<Table = "catalog" enum{ book = 1, author = 2, title = 3, genre = 4, price = 5, publish_date = 6, description = 7}> </Table>
<catalog>
<1 id="bk101">
<2>Gambardella, Matthew</2>
<3>XML Developer's Guide</3>
<4>Computer</4>
<5>44.96</5>
<6>2000-10-01</6>
<7>An in-depth look at creating applications
with XML.</7>
</1>
<1 id="bk102">
<2>Ralls, Kim</2>
<3>Midnight Rain</3>
<4>Fantasy</4>
<5>6.96</5>
<6>2000-12-16</6>
<7>A former architect battles corporate zombies,
an evil sorceress, and her own childhood to become queen
of the world.</7>
</1>
<catalog>
So compressed format requires 20% less memory. I know that XML is user readable also. But while transferring huge XML data over the network, compressed format could improve the performance. And at the end (destination) we can decompress the compressed XML data.
So my question is Why cant we use compressed XML???
I have no idea about this. Please let me correct if i am wrong.
Thanks
Bipin Dalbhide
|
|
|
|
|
As I recall there is no need to change the XML structure, you can just zip (rar or whatever) the original file, send it and unzip it after (compressing algorithms are optimized for that)! For example I think that is what "new" Microsoft Word docx is all about.
|
|
|
|
|
we can zip compressed file.
|
|
|
|
|
I need a program in PHP which can extract the hidden biders from ebay.I will have to insert the item number and the program must show me all bidders of the auction and their emails.
Also the same program must extract the registered contact information for any specified bidder specially the email address
I will pay for this
If someone can help please contact me at totos_back@yahoo.com
Thanks
|
|
|
|
|
totolcm wrote: I need a program in PHP
And why you post in XML / XSL?
|
|
|
|
|
Because he's an a**hole who has posted everywhere, looking for some (probably) illegal code.
Bob
Ashfield Consultants Ltd
Proud to be a Code Project MVP
|
|
|
|
|
Maybe he is hoping for a prize.
I count 12 cross posts.
"GOLD award - for the most cross-posts on a single subject"
modified on Thursday, January 14, 2010 1:03 PM
|
|
|
|
|
Greeting!
As declared in w3.org there is predefined derived type in XSD schemas - the ENTITY. This type is used for attributes, which means are unparsed entities from DTD. Using of the ENTITY as attribute type in schema is not problem (no errors for the schema self-validation) but:
1. XML file didn't pass the schema validation - the XML file didn't find unparsed entities declared in the schema DTD (that's right - it is the schema DTD only) and from other hand the XML file DTD eliminates schema using (that's right too - the DTD is closed model). How to use the ENTITY type?
2. In XSD schemas there is predefined base type - NOTATION. The NOTATION takes values from the schema set of <notation> elements. In other words this replaces using of DTD NOTATION as attribute type. May be it is for the ENTITY type too?
|
|
|
|
|
You can't declare entities in XML Schemas. You can declare them in XML documents that are instances of the schema.
Java, Basic, who cares - it's all a bunch of tree-hugging hippy cr*p
MVP for 2010 - who'd'a thunk it!
|
|
|
|
|
No, IMHO it is impossible to declare entities in XML document if the document has schema because entities are declared in DTD and using of the DTD excludes using of the schema (DTD is closed model).
|
|
|
|
|
Sorry - it is possible - I've tried it successfully with Microsoft's XML parser.
See this page[^] of the XML schema recommendation which gives the example I used.
Java, Basic, who cares - it's all a bunch of tree-hugging hippy cr*p
MVP for 2010 - who'd'a thunk it!
|
|
|
|
|
Sorry sir, can You show how You succeed? I can't validate this example. I have used Microsoft XML paser (DOM). There is error - Element "purchaseOrder" is used but not defined in DTD and schema. But there is the validation when I am commenting DTD in the XML file (and deleting symbol "&" for conversion entity to string literal). My JScript code fragment follows. Tell me please, where I have mistaken?
var xmldoc = WScript.CreateObject("MsXml2.DomDocument.5.0");
xmldoc.preserveWhiteSpace = false;
xmldoc.async = false;
xmldoc.validateOnParse = false;
xmldoc.load("a.xml");
printResult(xmldoc.parseError);
var schema = WScript.CreateObject("Msxml2.XMLSchemaCache.5.0");
schema.add("http://www.example.com/PO1", "a.xsd");
xmldoc.schemas = schema;
printResult(xmldoc.validate());
|
|
|
|
|
I used the .NET XML parser.
Here's my little C# program:
using System;
using System.Xml;
using System.Xml.Schema;
namespace a
{
class Program
{
static public void vvv(Object sender, ValidationEventArgs e)
{
Console.WriteLine(e.Message);
throw new XmlSchemaValidationException();
}
static void Main(string[] args)
{
try
{
XmlDocument xmldoc = new XmlDocument();
xmldoc.PreserveWhitespace = false;
xmldoc.Load("Changes.xml");
Console.WriteLine(xmldoc.DocumentElement.Name);
Console.WriteLine("The document has {0} entities", xmldoc.DocumentType.Entities.Count);
XmlSchemaSet schema = new XmlSchemaSet();
schema.Add("", "change-history.xsd");
xmldoc.Schemas = schema;
xmldoc.Validate(vvv);
Console.WriteLine("Document validated!");
}
catch (XmlSchemaValidationException)
{
Console.WriteLine("Document didn't validate!");
}
}
}
}
Here's my schema (called change-history.xsd)
<?xml version="1.0" encoding="UTF-8"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="unqualified" attributeFormDefault="unqualified">
<xs:element name="change-history">
<xs:annotation>
<xs:documentation>Comment describing your root element</xs:documentation>
</xs:annotation>
<xs:complexType>
<xs:sequence>
<xs:element name="items">
<xs:complexType>
<xs:sequence maxOccurs="unbounded">
<xs:element name="item">
<xs:complexType>
<xs:sequence maxOccurs="unbounded">
<xs:element name="version">
<xs:complexType>
<xs:sequence maxOccurs="unbounded">
<xs:element name="change">
<xs:complexType>
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="reason" type="xs:string" use="optional"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name="number" type="xs:string" use="required"/>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name="name" type="xs:string" use="required"/>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name="product" type="xs:string" use="required"/>
</xs:complexType>
</xs:element>
</xs:schema>
And here's my sample XML file
<?xml version="1.0" encoding="utf-8" ?>
<!DOCTYPE change-history [
<!ENTITY eacute "é">
]>
<change-history product="Sample" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="change-history.xsd">
<items>
<item name="Sample.exe">
<version number="2.21.0">
<change reason="issue 11">Added license to executable.</change>
<change>éFixed bug in executable.</change>
</version>
</item>
</items>
</change-history>
Java, Basic, who cares - it's all a bunch of tree-hugging hippy cr*p
MVP for 2010 - who'd'a thunk it!
|
|
|
|
|
Trez bien! Thank You very much! Your code is working without errors, validation is passed. But Your code converted to JScript is working with the same errors. Hence there are errors in the Ms COM implementation of Xml parser.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
