XML / XSL

10-Jul-02 0:55

Hi,

I'm currently using the XML DOM from VC++ in order to load / manipulate / save XML files. I like to format my XML files nicely with tabular indents and so on, in order to form a readble document. However, the parts of the document modified from within VC are just written in "one-huge-line"-style. No nice linebreaks and tab indents... How do I do that ? The IXMLDOMNodePtr->xml property hasn't got a put method, so I can't manually append a linebreak directly. Any ideas folks ?

Thanks a lot in advance ;o)

Best regards

/Jan

Anonymous10-Jul-02 4:17

Anonymous

10-Jul-02 4:17

This has already been answered just a few lines down
click here to read it Cool | :cool:

Jan R Hansen10-Jul-02 5:42

10-Jul-02 5:42

yeah - well.. sort of. Thats "my" thread as well - as you've probably seen.

However, I can't find anything in the helping link about how to format the XML file - not the data output. Or I'm just missing something important here ;o)

Anyway, could you be a bit more specific about how I fix it ? the problem is that

<sometag>
<child1>
<subitem1>hello</subitem1>
<subitem2>world</subitem2>
</child1>
<child2>
<subitem1>hello</subitem1>
<subitem2>xml</subitem2>
</child2>
</sometag>

after updating child 2 data is turned into

<sometag>
<child1>
<subitem1>hello</subitem1>
<subitem2>world</subitem2>
</child1>
<child2><subitem1>hello</subitem1><subitem2>xml</subitem2></child2>
</sometag>

- which is pretty annoying. And I just can't find any way of telling the XML document object/nodes how to physically dump the data.

Maybe that was more clear - or maybe I've just misunderstood the entire concept. Who knows ?

/Jan

Christopher Lord10-Jul-02 11:13

10-Jul-02 11:13

There is a 'whitespace' element in the DOM, I've never used it since it costs performance to use.
see http://www.xml.com/pub/a/2001/12/05/whitespace.html

Jan R Hansen10-Jul-02 21:24

10-Jul-02 21:24

Allright, I may be completely off track here - but the link you refer to deals with the problems of showing the data from the XML file using a stylesheet, and getting line breaks in the resulting "view".

What I want, is linebreaks in my XML file. When I generate this data structure :
<parent>
<child>
<data1>bla</data1>
<data2>bla</data2>
</child>
</parent>

from VC++, the _file_ looks like this :

<parent><child><data1>bla</data1><data2>bla</data2></child></parent>

- which, of course, is correct - but not what I want.

What do you think ? completely off track and unable to understand the link you gave me ;o) ?

Thanks anyway.

/Jan

Philip Fitzsimons11-Jul-02 11:56

Philip Fitzsimons

11-Jul-02 11:56

there is property of xmlwriter than creates/preserves space.
personally I allways turn it off.

Christopher Lord11-Jul-02 16:11

11-Jul-02 16:11

whoops, yea, posted wrong link! My bad.

You definately are looking for the whitespace setting. I cant find the link I was going to give you now, though.

Passing Strings encoded BASE64 in XML

Ranjan Banerji15-Jul-02 11:08

Ranjan Banerji

15-Jul-02 11:08

The problem you are facing is true if you read the xml in a text editor. But any xml editor should automatically reorganize the display of your data in the "neat" way. I am assuming this is your objective. Unless you wish to read it in a simple text editor and yet have it formatted. In which case.... hmmmm... too much effort, when there are so manty xml editors and tools available. Including IE which will display your XML in the "neat" way.

8-Jul-02 5:02

I want to use XML to transport some data across HTTP protocol. When text in some element contains US ASCI characters then all is OK. But when some language- specific characters appear i get error.

I want to encode contents of some elements (these that contain these unfortunate characters) to BASE.64.

when I do the following, I get error.

_variant_t var_val=GetSomeText_WithStrangeChars()
..check errorcodes...
pNewNodeOut->put_dataType(L"bin.base64");
..check errorcodes... //ok it works so far
pNewNodeOut->put_nodeTypedValue(var_val); //HERE CRASH
//It is here where HRESULT is E_FAIL

The first question is: What to do to avoid error, and
to sucessfully put value of _variant_t (containing BSTR)
into element whose type is set to bin.base64 ?

The last question is:
Shall I be able to automatically get the value of the
element without explicit converting it from BASE.64 ?
I mean : Shall MSXML parser do the conversion automatically for me when I will call nodeTypedValue property ?

Thanks
Michal Januszczyk

Re: Passing Strings encoded BASE64 in XML

Anonymous9-Jul-02 16:44

Anonymous

9-Jul-02 16:44

Passing binary or base64 information around may be easiest if you use SOAP - here is information on building a SOAP tool in VC: C++ SOAP client for MS SOAP Toolkit 1.0

For more basic non-VC Sleepy | :zzz: introductory base64 information try this XML and Binary Data article and MXSML based class module to perform Base64 encoding and decoding and Class object for Base64 conversion with .NET

Reading an XML file to a Dataset and then from Dataset to SQLServer

Alexandru Savescu4-Jul-02 22:53

Alexandru Savescu

4-Jul-02 22:53

I am doing the folowing operations:

1. Export some tables (that have unique IDs and foreign keys) to an XML file using a DataSet object in .NET. This works file.

2. I want to be able to import that XML file into another SQLServer server that has the same database architecture, but of course, different data.

3. When reading the XML file into a Dataset and then updating the database, some key violations or duplicate records may occur because I exported some unique IDs from one databse server and am trying to import them into another server. Thus, when importing a master table, I must read the XML file and give the corresponding records new IDs accordingly. Since my master table will have several slave tables with foreign keys involved I would have to udpate the slave tables also to maintain the integrity.

I could do all that manually by having lots of structures and maps and hash tables. Is there a change .NET Dataset would take care of everything automatically for me?

Thanks.

Best regards,
Alexandru Savescu

Getting started with XML

Jeremy Pullicino1-Jul-02 21:42

Jeremy Pullicino

1-Jul-02 21:42

Hello guys,

I am about to self-teach myself some XML stuff. Till now, what I have seen in the MSDN mixed me up a little bit.

It seems that to do anything interesting with MS Explorer and XML, you will have to use a lot scripting.

I am not very interested in scripting (even though I know how to script in vbscript and jscript).

Is scripting always necessary to use when using XML in IE? Or could a good combination of XML and HTML do the trick?

Jeremy.

"Hey man, Taliban, Tali me Banana."

Christopher Lord1-Jul-02 22:03

1-Jul-02 22:03

no
Xml has its own transform language, XSL, which can be used to do very interesting things. It can transform XML in one format to another format (for example <player name="tom"/> to <player>tom</player>)

You can also use this to output HTML, raw text, CSS, ASP scripts, source code, and more. For example, I have an XSL file i built which transforms Winamp 3 playlists to M3U playlists very quickly. I have another which presents the playlist as an HTML page for viewing.

If another media player used XML for playlists but had a totally different node structure, I could port my playlist from Winamp to that program by simply writing a quick XSL doc.

Or if i wanted to write a program in C++ with all my music files as constant strings (for performance Wink | ;)

), I could write an XSL doc to quickly transform it into a compilable .CPP file.

There is a lot more, but thats a good start loc.

Christopher Duncan10-Jul-02 5:44

Christopher Duncan

10-Jul-02 5:44

Christopher,

I'm looking to do a conversion from Windows Media playlists (.asx, etc.), which is in an xml format, to Winamp .pls for use in the Turtle Beach AudioTron file player I just bought (extremely cool gizmo, by the way).

I haven't done anything with xml/xsl yet, but your description of the xsl transform language sounds perfect. Could you point me to some documentation on this feature? I'm not looking to really learn xml in full just yet, I merely have a single problem I need to solve as simply & quickly as I can make it.

Thanks!

Chistopher Duncan
Author - The Career Programmer: Guerilla Tactics for an Imperfect World (Apress)

Christopher Lord10-Jul-02 9:42

10-Jul-02 9:42

XSL is mainly for changing XML dialects (XHTML included).

In order to transform to non-xml files, like M3U or TXT, you have to either craft your transform very carefully (many formats will not work because they may use tags which conflict) or use something like FOP (http://xml.apache.org/fop/index.html)

You'll also have to watch out for whitespace, since most plain-text formats are very picky. Many xsl engines let you use absolute whitespace.

Christopher Duncan10-Jul-02 12:28

Christopher Duncan

10-Jul-02 12:28

Thanks, Christopher.

Looks like the quick & dirty way is just a fast MFC dialog based app and a little string processing. Appreciate the link!

Chistopher Duncan
Author - The Career Programmer: Guerilla Tactics for an Imperfect World (Apress)

MS le Roux1-Jul-02 22:07

MS le Roux

1-Jul-02 22:07

Scripting is necessary if you want to use the DOM to process XML. If you don't want to do that, you can use XSLT.

XSLT is pretty cool, but it is quite challenging to master. You can take a look at 2 XSLT articles I wrote (while I was still using the name MarSCoZa).

Erik Westermann3-Jul-02 1:59

Erik Westermann

3-Jul-02 1:59

One option is to use th DSO (Data Source Object) and a tiny bit of scripting (2-3 lines) to bind a control like a lisst box to an XML data source. Other than that, you can combine your XML with XSL to get IE to render an HTML-like document.

Erik Westermann
Author, Learn XML In A Weekend (Summer 2002)

9-Jul-02 16:28

Definitely do some reading at TopXML Rose | [Rose]

Updating an XML file from VC6.0

Richard Jones10-Jul-02 4:29

Richard Jones

10-Jul-02 4:29

Check out an article about CMarkupArchive by Jonathan de Halleux.
I use it in my apps.

Jan R Hansen26-Jun-02 3:11