Kinook Software Forum

Kinook Software Forum (https://www.kinook.com/Forum/index.php)
-   [VBP] General Discussion (https://www.kinook.com/Forum/forumdisplay.php?f=2)
-   -   Read nodes from an XML file (https://www.kinook.com/Forum/showthread.php?t=2944)

teognost 08-30-2007 08:49 AM

Thank you very much!

teognost 09-04-2007 12:47 PM

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 09-04-2007 04:24 PM

1 Attachment(s)
Attached.

teognost 09-05-2007 08:55 AM

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 09-05-2007 09:18 AM

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

teognost 12-02-2009 09:43 AM

1 Attachment(s)
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 -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:


revision="24772">
johnk
2009-11-24T13:20:48.707927Z

kind=""
action="M">/branches/ecl/10.X/char/c/ec_feed_liffe_v4.c
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
kind=""
action="M">/branches/ecl/10.X/char/c/ec_feed.c
kind=""
action="M">/branches/ecl/10.X/char/c/ec_feed.h

F0026325: Patch 3331 Merged from trunk, file list:
ec_feed.c 8.36 -> 8.37 F0031033: Changes made to support.


revision="24835">
maks
2009-11-25T15:07:42.016178Z

kind=""
action="M">/branches/ecl/10.X/char/sh/dwh_acc_settl.sh
kind=""
action="M">/branches/ecl/10.X/char/sh/dwh_trades.sh
kind=""
action="M">/branches/ecl/10.X/char/sh/dwh_acc_equity.sh
kind=""
action="M">/branches/ecl/10.X/char/sh/dwh_contact_master.sh
kind=""
action="M">/branches/ecl/10.X/char/sh/dwh_account_master.sh
kind=""
action="M">/branches/ecl/10.X/char/sh/dwh_exe_ass.sh
kind=""
action="M">/branches/ecl/10.X/char/sh/dwh_accounting_transx.sh
kind=""
action="M">/branches/ecl/10.X/char/sh/dwh_nett_posn.sh
kind=""
action="M">/branches/ecl/10.X/char/sh/dwh_exe_brok.sh
kind=""
action="M">/branches/ecl/10.X/char/sh/dwh_feed_mapping.sh
kind=""
action="M">/branches/ecl/10.X/char/sh/dwh_feed_mappingAAA.sh

F0026703: Patch 3256 Merged from trunk, file list:
dwh_acc_equity.sh 9.4 -> 9.5 F0026703 Change BATCH_DIR


revision="24836">
maks
2009-11-25T16:07:42.016178Z

kind=""
action="M">/branches/ecl/10.X/char/sh/dwh_acc_settl.sh
kind=""
action="M">/branches/ecl/10.X/char/sh/dwh_trades.sh
kind=""
action="M">/branches/ecl/10.X/char/sh/dwh_acc_equity.sh
kind=""
action="M">/branches/ecl/10.X/char/sh/dwh_contact_master.sh
kind=""
action="M">/branches/ecl/10.X/char/sh/dwh_account_master.sh
kind=""
action="M">/branches/ecl/10.X/char/sh/dwh_exe_ass.sh
kind=""
action="M">/branches/ecl/10.X/char/sh/dwh_accounting_transx.sh
kind=""
action="M">/branches/ecl/10.X/char/sh/dwh_nett_posn.sh
kind=""
action="M">/branches/ecl/10.X/char/sh/dwh_exe_brok.sh
kind=""
action="M">/branches/ecl/10.X/char/sh/dwh_feed_mapping.sh
kind=""
action="M">/branches/ecl/10.X/char/sh/dwh_feed_mappingBBB.sh

F0026703,F0026704: Patch 3256 Merged from trunk, file list:
dwh_acc_settl.sh 9.4 -> 9.5 F0026703 Change BATCH_DIR to COMPANY


revision="24972">
johnk
2009-11-24T19:20:48.707927Z

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
kind=""
action="M">/branches/ecl/10.X/char/c/ec_feed.h

F0026325: Patch 1111 Merged from trunk, file list:
ec_feed.h 8.36 -> 8.37 F0026325: Changes made to support.



teognost 12-02-2009 11:28 AM

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%')]] ]]")


All times are GMT -5. The time now is 07:17 PM.


Copyright © 1999-2023 Kinook Software, Inc.