XML / XSL

Dustin Metzgar14-Aug-06 8:57

Dustin Metzgar

14-Aug-06 8:57

Well, you've got a few problems to deal with here. First of all is this line:

lehya wrote:
XmlTextWriter writer = new XmlTextWriter(xmlFile, Encoding.UTF8);

This is a shortcut to remove some of the tedium of opening a file. But, its assumption is that you want to erase the old file if one is there, not append to it.

The second problem is that you're dealing with an XML file. You can't just append to the end of the file. You have to add your new elements as a part of the existing document.

Appending to the end of an XML document is not easy. You have some options though. Open the XML in an XmlDocument object and just append your child nodes in there where appropriate, then save the file. If the XML file is big, this will take up lots of memory and be slow. Another option is to open up the existing file with an XmlReader and open up a temporary file with an XmlWriter. Read the existing XML until you get to the end of the document and while you're doing it, write those elements out to the writer. Before writing the EndDocument, write in your new elements. Then delete the old file and rename the temp file to the correct filename.

Logifusion[^]
If not entertaining, write your Congressman.

lehya14-Aug-06 10:31

lehya

14-Aug-06 10:31

Thanks buddy...Sounds like it works..But reading everything and writing into a temporary file...saving it as a new file..oh this sounds too hard..but i will try

Re: New to XML [modified]

Dustin Metzgar14-Aug-06 11:00

Dustin Metzgar

14-Aug-06 11:00

You could also write to a MemoryStream so long as the XML is not too big. The MemoryStream will have a smaller memory footprint than the XmlDocument object.

Logifusion[^]
If not entertaining, write your Congressman.

manowj18-Aug-06 22:38

manowj

18-Aug-06 22:38

Hi lehya,

First check whether the xml file exists, If not create xml [ u have done this], if exists load xml file, get the root node element and append every node you add as as child node [plz don`t use processing instructions while appending to xml] and save the xml.

<ex: <Contact_info> => Root Element
<contacts>
<name>test</name>
<age>35</age>
<sex>M</sex>
</contacts>
<contacts>
<name>test</name>
<age>35</age>
<sex>M</sex>
</contacts>
</Contact_info>

-- modified at 4:38 Saturday 19th August, 2006

Regards,
Manowj

MS Access 2003 and Exporting in a XML Format

Dustin Metzgar22-Aug-06 11:13

Dustin Metzgar

22-Aug-06 11:13

You're probably already past this, but I've seen this question enough times that I thought I might write an article on it. Link[^]

Logifusion[^]
If not entertaining, write your Congressman.

sweep12314-Aug-06 3:53

sweep123

14-Aug-06 3:53

I have a series of tables in MS Access 2003 and would like to export a subset of the data out in an XML format.

I have come accross the Application.ExportXML facility in MS Access 2003, but is this applicable if I need to export 2 fields from Table A, 3 from Table B and 1 from Table C.

My question is, should I write a VBA module to export the data I require or are they an example on how to use Application.ExportXML in the way required.

I cant find much documentation on this facility.

Sorry if this is the wrong forum.

Many thanks

Re: MS Access 2003 and Exporting in a XML Format

Stephen McGuire14-Aug-06 15:18

Stephen McGuire

14-Aug-06 15:18

Create a query containing your required fields then use Application.ExportXML with the query as your DataSource.

Application.ExportXML _
ObjectType:=acExportQuery, _
DataSource:="YourQuery", _
DataTarget:="Path\YourFile.xml"

The above shows the required properties. For a list of additional (optional) properties, see the Access 2003 help file for the ExportXML method.

Steve

Access violation exception while trying to create a XML Element

adidas.levy12-Aug-06 22:52

adidas.levy

12-Aug-06 22:52

Hey guys!

I'm kind of new to XML using VC++ 6.0.
I know XML DOM and XML MiniDOM from python...

and I use MSXML4.0.

anyway, I try to create an element, or a node,
and as I run my little application it carshed due to "Access violation"
the exception occures in the functions
raw_createElement(...) and raw_createNode(...)

it happens all the time, and frankly I really don't know what the heck is wrong in there....

here is a fragment of my source:

#define PHONEBOOK_NODE _T("Node")
hr= m_pDomDocument.CreateInstance("Msxml2.DOMDocument.4.0");
sprintf(node, "%ld", m_NodeID);
l_XMLNode = m_pDomDocument->createNode(l_vtType, _T(node), _T(""));
l_XMLElement = m_pDomDocument->createElement(PHONEBOOK_NODE);

where:
m_pDomDocument is IXMLDOMDocument2Ptr
l_XMLNode is IXMLDOMNodePtr
l_XMLElement is IXMLDOMElementPtr

I'll be very glad (and so my boss) if someone will be kind to
share his or her opinion about that...

thanx,
Adidas

Re: Access violation exception while trying to create a XML Element

led mike15-Aug-06 6:03

Re: Access violation exception while trying to create a XML Element

15-Aug-06 6:03

adidas.levy wrote:
I'm kind of new to XML using VC++ 6.0.
I know XML DOM and XML MiniDOM from python...

Are you saying you are new to C++ development? If so you are "starting" off with a much to complex project.

An "Access Violation" is not a XML/XSL problem it is a C++ problem so this question belongs in the Visual C++/MFC forum.

led mike

adidas.levy15-Aug-06 19:52

adidas.levy

15-Aug-06 19:52

Hey,

No, I'm not new to C++ programming, I'm programming C++ for over 3 years.
I am used to program under UNIX operating systems and not under Windows.
recently I started programming under Windows...

anyway, I solved the problem, I just had an additional call to "CoInitialize()" which caused the problem....

Need XML Help

Amit Kumar G12-Aug-06 9:53

Amit Kumar G

12-Aug-06 9:53

Hi All

First of all thanks for your valuable time. I am new to XML and i have very basic query.I need to generate my AsP.NET MENUS through XML and i build the XML file as below

<code><?xml version="1.0" encoding="utf-8"?>
<Menus xmlns="http://tempuri.org/XYZ.xsd">
<Menu Name="Electronics">
<ChildName>TV</ChildName>
<ChildUrl>//localhost/Tv.aspx</ChildUrl>
<ChildName>Mp3 Player</ChildName>
<ChildUrl>//localhost/MP3.aspx</ChildUrl>
</Menu>
<Menu Name="Furniture">
<ChildName>Tables</ChildName>
<ChildUrl>//localhost/tables.aspx</ChildUrl>
<ChildName>Chairs</ChildName>
<ChildUrl>//localhost/chair.aspx</ChildUrl>
<ChildName>Beds</ChildName>
<ChildUrl>//localhost/beds.aspx</ChildUrl>
so on.......
</Menu>
</Menus></code>
How i can read these XML nodes values???? I am confused and i tried dom, xmltextreader etc.......I am not sure which is the best way to use and how to use. I can load XML document but after that i am not able to read these nodes values....I am using ASP.Net, VB.Net version 1.x

Please provide some good sample source code. Thanks in advance for your help....One small request please help me ASAP.

Amit

Re: Need XML Help

Rizwan Bashir15-Aug-06 3:48

Rizwan Bashir

15-Aug-06 3:48

Define Dataset and read the XML in DataSet like
ds.readXML(FilePath)
and here you go.. you have the details do what ever you want.
there are many other ways to read the XML but this is the easiest among all.

Rizwan Bashir
ALM Soft[^]

Re: Need XML Help

Amit Kumar G15-Aug-06 14:16

Amit Kumar G

15-Aug-06 14:16

Thanks for your reply. And it really helps me to move one step. Now i am facing another problem. I am able to load my menus through xml, but it is taking some time to load. Moreover my other frmaes loaded before menus load..... Any thoughts???

Namespace in XMLDocument

VSush10-Aug-06 0:34

VSush

10-Aug-06 0:34

Hi,
I am sorry if this is a very basic question.
I am new to XMLs.
I am using .net XMLDocument class to operate with xml files.
I would like to know what is the significance of a namespace when parsing XMLs. what and why is a namespace used?

Thanks.

Re: Namespace in XMLDocument

led mike10-Aug-06 7:20

Re: Namespace in XMLDocument

10-Aug-06 7:20

VSush wrote:
what and why is a namespace used?

The base reason for "namespace" support in any code based language is to reduce name collisions.

so if you want an xml element named ECustom and so do I we can't use them both in a single document. However if we add a namespace then they become

VSush.ECustom
and
led-mike.ECustom

So now they are two different elements and both can be used in a single document without ambiguity.

led mike

George L. Jackson10-Aug-06 13:44

George L. Jackson

10-Aug-06 13:44

Adding to led mike's answer,

Preventing name collisions is the major reason for using namespaces. Nevertheless, the grouping of names for a specific purpose is a pleasant side-affect of this. Thus, for example, you can have elements that refer to schemas, html, xslt and xml in the same document.

George

How to use XML Inline data in HTML [modified]

Sarvan AL9-Aug-06 20:07

Sarvan AL

9-Aug-06 20:07

Hi ALL,

QUESTION: 1
___________

I have an XML file in which I've put an Image data inline, like the following.

<?xml version="1.0" encoding="utf-16"?>
<Data xmlns:dt="urn:schemas-microsoft-com:datatypes"
dt:dt="bin.base64">/9j/4AAQSkZJRgABAQAAAQABAAD/2wBDAAsHCAkIBwsJCQkMCwsNEBoREA8PECAXGBMaJiIo
KCYiJSQqMD0zKi05LiQlNUg1OT9BREVEKTNLUEpCTz1DREH/2wBDAQsMDBAOEB8RER9BLCUs
QUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUH/wAAR
CABiAGADASIAAhEBAxEB/8QWqPcDcEmhaNC2Sik+8Vzwo/8Ahr8hSpUESTvhp+BflXfD
QfcX5UqVaTIuRfwj5UuRM/ZX5UqVdOi5V/CPlSKKceyPlSpV06Lw0PVFPwpv+Hgz/Bj/APEU
qVdNjhGg6Io+FdVVByFHypUq2ZP/2Q==</Data>

I am able to show the image in the HTML file like this.

<HTML>
<BODY>
<img src="data:image/gif;base64,/9j/4AAQSkZJRgABAQAAAQABAAD/2wBDAAsHCAkIBwsJCQkMCwsNEBoREA8PECAXGBMaJiIo
KCYiJSQqMD0zKi05LiQlNUg1OT9BREVEKTNLUEpCTz1DREH/2wBDAQsMDBAOEB8RER9BLCUs
QUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUH/wAAR
CABiAGADASIAAhEBAxEB/8QWqPcDcEmhaNC2Sik+8Vzwo/8Ahr8hSpUESTvhp+BflXfD
QfcX5UqVaTIuRfwj5UuRM/ZX5UqVdOi5V/CPlSKKceyPlSpV06Lw0PVFPwpv+Hgz/Bj/APEU
qVdNjhGg6Io+FdVVByFHypUq2ZP/2Q=="/>
</BODY>
</HTML>

But, I'd like to bring the inline image data from XML to HTML. I am able to do this for normal text data, something like this:

<html>
<body>
   <xml id="cdcat" src="cd_catalog.xml"></xml>
   <table border="1" datasrc="#cdcat">
   <tr>
   <td><span datafld="ARTIST"></span></td>
   <td><span datafld="TITLE"></span></td>
   </tr>
   </table>
</body>
</html>

Since I'm a newbie to XML, kindly bear if you feel this a silly question.

QUESTION: 2 - Inline Video data
_________________________________

I've embedded a Windows Media Player and able to play a .WMV file, like this:

<html>
<body>
<embed width="320" height="290" src="video.wmv"
autostart="True" 
showcontrols="True" showstatusbar="False" 
showdisplay="False" autorewind="True">
</embed> 
</body>
</html>

How to make the Base64 encoded video data inline.

Kindly bear this lengthy question.
Thanks in advance,
Sarvan AL

led mike10-Aug-06 7:16

Re: How to use XML Inline data in HTML [modified]

10-Aug-06 7:16

Sarvan AL wrote:
I am able to show the image in the HTML file like this.

I loaded that HTML file in both IE and Firefox and the image does NOT display, so.... what are you talking about?

led mike

George L. Jackson10-Aug-06 14:00

George L. Jackson

10-Aug-06 14:00

It didn't work for me either using IE 6. The following information is interesting:

http://dean.edwards.name/weblog/2005/06/base64-ie/[^]

I believe IE 6 or less needs assistance to display base64! Other browsers don't have this problem.

-- modified at 20:07 Thursday 10th August, 2006

led mike11-Aug-06 6:01

11-Aug-06 6:01

Yeah his image data is not valid. The one in the dean.edwards blog entry is valid and works in Firefox.

George L. Jackson wrote:
I believe IE 6 or less needs assistance to display base64

What does "assistance" mean, an ActiveX control?

led mike

George L. Jackson11-Aug-06 8:35

George L. Jackson

11-Aug-06 8:35

In the dean.edwards blog, he is using a server-based script and javascript to "correct" the base64 data to display in IE6. He presents some different approaches to solve the problem.