cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
716
Views
0
Helpful
4
Replies

IPCC CRS Editor - XML file traversal

joannemarie
Level 1
Level 1

I?ve set up an xml file with the below format and I am trying to figure out how to

Traverse it so I can process each date. I?m not sure what the syntax is. I can get the first one with no

Problem. Any help is much appreciated.

<?xml version="1.0" encoding="utf-8" ?>

<!--

Holiday.xml

-->

<Holidays>

<Holiday>

<Name>New Year</Name>

<Date>01/01/2007</Date>

</Holiday>

<Holiday>

<Name>Memorial Day</Name>

<Date>05/31/2007</Date>

</Holiday>

<Holiday>

<Name>Fourth of July</Name>

<Date>07/04/2007</Date>

</Holiday>

<Holiday>

<Name>Labor Day</Name>

<Date>09/03/2007</Date>

</Holiday>

<Holiday>

<Name>Thanksgiving</Name>

<Date>11/22/2007</Date>

</Holiday>

<Holiday>

<Name>Thanksgiving Observance</Name>

<Date>11/23/2007</Date>

</Holiday>

<Holiday>

<Name>Christmas</Name>

<Date>12/31/2007</Date>

</Holiday>

</Holidays>

4 Replies 4

geoff
Level 10
Level 10

I think Cisco publish a version of this. Perhaps the easiest thing is to search Cisco.com for it.

All you have to do is change the XML names to xx, xx etc. Then use a set step with the expression editor to return a new string like:

{

// increment

holidayEntryNum++;

String s = new String();

s = "Holiday" + holidayEntryNum;

return s;

}

then look for

"/descendant::Holidays/child::" + Holiday

with your Get XML Document step. And of course, loop until dates match.

Regards,

Geoff

I have already redone it that way, and it works well. But, I would think there would be a way to interate through it when using instead of . I just do not know the syntax that Cisco expects and cannot find documentation on it.

Thanks for the response, I appreciate it.

Joanne

joluc_denmark
Level 1
Level 1

You should't use that script/xml-file as it is ineffiecient.

Instead create the current date in your script (such as '25-12-07'and add the letter-prefix A or some other letter..) and then parse this xml-file instead:

0

XMAS07.WAV

It is more efficient (if if doesn't find anything, its not a holiday) and gives you a few more options (as illustrated).

rgds

johnny

Thank, Johnny, good idea.

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: