Read nodes from an XML file

[teognost]

I have an XML file like:
<?xml version="1.0"?>
<log>
<logentry
revision="28617">
<author>John Doe</author>
<date>2007-08-21T13:51:44.617641Z</date>
<paths>
<path
action="M">/sources/trunk/Controls/Grids/MyGrid.cs</path>
<path
action="A">/sources/trunk/3rdPartyLibs/Infragistics/Infragistics2.Win.UltraWinGrid.ExcelExport.v7.1.xm l</path>
<path
action="M">/sources/trunk/MyProj/Pro.csproj</path>
</paths>
<msg>Issue: Fixed some error...</msg>
</logentry>
<logentry
revision="28618">
<author>me</author>
<date>2007-08-21T14:11:50.500926Z</date>
<paths>
<path
action="M">/sources/trunk/Exchange/Server/Triggers/TriggerProvider.cs</path>
<path
action="M">/sources/trunk/Exchange/Server/OrderControllers/OrderControler.cs</path>
<path
action="M">/sources/trunk/Exchange/Server/Sessions/Wrapper.cs</path>
</paths>
<msg>Issue: Removed Trigger</msg>
</log>


I need to read all the paths <path> and to put them in a text file line by line.
Any idea how I can do this in VBP?
I looked at the sample XML.bld but there is a different parsing ,for attributes,I did not succed to pars it the way I need...
Thanks for any help

[kinook]

Using an XSL transform would be one way (see attached sample).

[teognost]

Thanks a lot,it works perfectly!
I just noticed sometimes the paths are not unique as the same file was modified in multiple revisions.Is it possible to change the XSL file in order to produce unique paths (every path should appear only once)?(I do not have any experience with XSL)
Or I should parse separately the output text fle in order to create another text file with unique paths?

[kinook]

In the 'Create XSL file' step, replace

<xsl:for-each select="//path">

with

<xsl:for-each select="//path[[not(.=preceding::path)]]">

[teognost]

Tried that but the step fails:
8/24/2007 11:19:59 AM: Building project step 'Generate text file(containing paths)'...
Loading XML input document...
Loading XSLT stylesheet...
Initializing XSLT processor...
Expression expected.

//path[-->[<--not(.=preceding::path)]]
8/24/2007 11:19:59 AM: Step 'Generate text file(containing paths)' failed
8/24/2007 11:19:59 AM: Build ended.

XSL file looks now like this:
<?xml version="1.0"?>

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="text"/>

<xsl:template match="/">
<xsl:for-each select="//path[[not(.=preceding::path)]]">
<xsl:value-of select="."/><xsl:text>&#xD;&#xA;</xsl:text>
</xsl:for-each>
</xsl:template>

</xsl:stylesheet>

[kinook]

Please ZIP and send or post:
1) The info from Help | About | Install Info
2) The version(s) of MSXML installed (listed in Add/Remove Programs)

[teognost]

1)
Visual Build Professional 6.3
Registered to: xxxxxxxxxx (1-computer license)
Windows Version: 5.1.2600.2.0
Install path: D:\Program Files\VisBuildPro6
SftTree_IX86_U_50.dll version 5.05
unins000.exe version 51.46.0.0
VisBuildCmd.exe version 6.3.0.0
VisBuildPro.exe version 6.3.0.0
VisBuildBld.dll version 6.3.0.0
VisBuildBurn.dll version 6.3.0.0
VisBuildCore.dll version 6.3.0.0
VisBuildDotNET.dll version 6.3.0.0
VisBuildExt.dll version 6.3.0.0
VisBuildLog.dll version 6.3.0.0
VisBuildMisc.dll version 6.3.0.1
VisBuildMS.dll version 6.3.0.0
VisBuildMS2.dll version 6.3.0.0
VisBuildNet.dll version 6.3.0.0
VisBuildSvr.dll version 6.3.0.0
VisBuildSvr.Interop.dll version 1.0.0.0
VisBuildVCS.dll version 6.3.0.0

2)It appears MSXML 4.0 SP2 and also MSXML 6.0 parser

[kinook]

If you're putting the expression in the XSLT file itself (rather than the Create XSL File step as suggested), use single brackets instead of double:

<xsl:for-each select="//path[not(.=preceding::path)]">

[teognost]

Thanks,with single brackets works ok:
<xsl:for-each select="//path[not(.=preceding::path)]">

[teognost]

Well,another issue appeared :-(
I need to read line by line the text file produced by transformation.
I use a set macro step in order set a macro CURRENT_LINE to value
[vbld_TempMacroObj("FILE").ReadLine()]
However -the macro remains empty.
I tried even to set a macro FILE_CONTENT to value:
[vbld_GetFileContents("%CHANGED_FILES_TXT%")] but the resulting value is always :
ÿþ/
I do not understand what is the issue...

[teognost]

Ok,I finally got it,text file is encoded in Unicode so it should be read like this:
[vbld_EscapeString(vbld_FSO.OpenTextFile("%CHANGED_FILES_TXT%", , , True).ReadAll)]

[kinook]

You originally indicated you wanted to put the values into a text file. To instead iterate over the matches within VBP, just use that XPath expression in an MSXML query (see attached sample).

[teognost]

I see,thanks a lot for sample!

[teognost]

In the last sample (transform3.bld)-how can I write in log-step "Do stuff with node value"- >for every path the related revision (written in <logentry
revision="xxxxx">)?
Basically one logentry has one revision and multiple paths.

[kinook]

Attached.

[teognost]

Thank you very much!

[teognost]

Another thing appeared-in the last sample transform4.bld,one extra requirement appeared->how can I query only path nodes containing string :
sources/trunk/Exchange ?
(still they should be shown only once )

[kinook]

Attached.

[teognost]

Thanks.Is there any documentation somewhere about this kind of syntax you use for reading XML nodes?
I would like to avoid to bother you in case some other changes would be needed...

[kinook]

http://www.google.com/search?q=xpath%20reference

[teognost]

Hi
I have another issue now,I studied the link u provided and I thought I implemented the XML step correctly but it seems I made a mistake.
I have an XML file contaiing a list of SVN changes.
I need to create a list with all the files changed for a specific string appearing in <msg> -but taken only once (same file should not appear twice)
For example –I need to get a list with all the files changed for F0026703 –therefore I will search all the path nodes having a msg that contains F0026703 and taake them only once:

vbld_TempMacros().Add "NODELIST", msxml.selectNodes("//path[[not(.=preceding::path) and ../../msg[[contains(., '%CURRENT_HB_NUMBER%')]] ]]")

where CURRENT_HB_NUMBER is set to F0026703

This works fine but I have a problem when string to search is F0026704-as it does read only one path :
/branches/ecl/10.X/char/sh/dwh_feed_mappingBBB.sh
And does not read paths /branches/ecl/10.X/char/sh/dwh_acc_settl.sh, /branches/ecl/10.X/char/sh/dwh_trades.sh ,etc –although they appear only in previous logentry for F0026703 –so they should be read as well.
Any idea how to correct the XPath above in order to achieve what I need?

I attached a sample VBP project

XML file looks like this:
<?xml version="1.0"?>
<log>
<logentry
revision="24772">
<author>johnk</author>
<date>2009-11-24T13:20:48.707927Z</date>
<paths>
<path
kind=""
action="M">/branches/ecl/10.X/char/c/ec_feed_liffe_v4.c</path>
<path
kind=""
copyfrom-path="/trunk/char/c/ec_feed_liffe_v5.c"
copyfrom-rev="24755"
action="A">/branches/ecl/10.X/char/c/ec_feed_liffe_v5.c</path>
<path
kind=""
action="M">/branches/ecl/10.X/char/c/ec_feed.c</path>
<path
kind=""
action="M">/branches/ecl/10.X/char/c/ec_feed.h</path>
</paths>
<msg>F0026325: Patch 3331 Merged from trunk, file list:
ec_feed.c 8.36 -&gt; 8.37 F0031033: Changes made to support.
</msg>
</logentry>
<logentry
revision="24835">
<author>maks</author>
<date>2009-11-25T15:07:42.016178Z</date>
<paths>
<path
kind=""
action="M">/branches/ecl/10.X/char/sh/dwh_acc_settl.sh</path>
<path
kind=""
action="M">/branches/ecl/10.X/char/sh/dwh_trades.sh</path>
<path
kind=""
action="M">/branches/ecl/10.X/char/sh/dwh_acc_equity.sh</path>
<path
kind=""
action="M">/branches/ecl/10.X/char/sh/dwh_contact_master.sh</path>
<path
kind=""
action="M">/branches/ecl/10.X/char/sh/dwh_account_master.sh</path>
<path
kind=""
action="M">/branches/ecl/10.X/char/sh/dwh_exe_ass.sh</path>
<path
kind=""
action="M">/branches/ecl/10.X/char/sh/dwh_accounting_transx.sh</path>
<path
kind=""
action="M">/branches/ecl/10.X/char/sh/dwh_nett_posn.sh</path>
<path
kind=""
action="M">/branches/ecl/10.X/char/sh/dwh_exe_brok.sh</path>
<path
kind=""
action="M">/branches/ecl/10.X/char/sh/dwh_feed_mapping.sh</path>
<path
kind=""
action="M">/branches/ecl/10.X/char/sh/dwh_feed_mappingAAA.sh</path>
</paths>
<msg>F0026703: Patch 3256 Merged from trunk, file list:
dwh_acc_equity.sh 9.4 -&gt; 9.5 F0026703 Change BATCH_DIR
</msg>
</logentry>
<logentry
revision="24836">
<author>maks</author>
<date>2009-11-25T16:07:42.016178Z</date>
<paths>
<path
kind=""
action="M">/branches/ecl/10.X/char/sh/dwh_acc_settl.sh</path>
<path
kind=""
action="M">/branches/ecl/10.X/char/sh/dwh_trades.sh</path>
<path
kind=""
action="M">/branches/ecl/10.X/char/sh/dwh_acc_equity.sh</path>
<path
kind=""
action="M">/branches/ecl/10.X/char/sh/dwh_contact_master.sh</path>
<path
kind=""
action="M">/branches/ecl/10.X/char/sh/dwh_account_master.sh</path>
<path
kind=""
action="M">/branches/ecl/10.X/char/sh/dwh_exe_ass.sh</path>
<path
kind=""
action="M">/branches/ecl/10.X/char/sh/dwh_accounting_transx.sh</path>
<path
kind=""
action="M">/branches/ecl/10.X/char/sh/dwh_nett_posn.sh</path>
<path
kind=""
action="M">/branches/ecl/10.X/char/sh/dwh_exe_brok.sh</path>
<path
kind=""
action="M">/branches/ecl/10.X/char/sh/dwh_feed_mapping.sh</path>
<path
kind=""
action="M">/branches/ecl/10.X/char/sh/dwh_feed_mappingBBB.sh</path>
</paths>
<msg>F0026703,F0026704: Patch 3256 Merged from trunk, file list:
dwh_acc_settl.sh 9.4 -&gt; 9.5 F0026703 Change BATCH_DIR to COMPANY
</msg>
</logentry>
<logentry
revision="24972">
<author>johnk</author>
<date>2009-11-24T19:20:48.707927Z</date>
<paths>
<path
kind=""
copyfrom-path="/trunk/char/c/ec_feed_liffe_v5.c"
copyfrom-rev="24755"
action="A">/branches/ecl/10.X/char/c/ec_feed_liffe_v5.c</path>
<path
kind=""
action="M">/branches/ecl/10.X/char/c/ec_feed.h</path>
</paths>
<msg>F0026325: Patch 1111 Merged from trunk, file list:
ec_feed.h 8.36 -&gt; 8.37 F0026325: Changes made to support.
</msg>
</logentry>
</log>

[teognost]

Finally I solved it,instead of :
vbld_TempMacros().Add "NODELIST", msxml.selectNodes("//path[[not(.=preceding::path) and ../../msg[[contains(., '%CURRENT_HB_NUMBER%')]] ]]")
I use now:
vbld_TempMacros().Add "NODELIST", msxml.selectNodes("//path[[not(.=preceding::path[[../../msg[[contains(., '%CURRENT_HB_NUMBER%')]] ]]) and ../../msg[[contains(., '%CURRENT_HB_NUMBER%')]] ]]")