New to XML need help

[sherzaad]

Hi,

I'm new here and new to xml

Basically have this xml code at the moment:

Code: Select all

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

    <userealtime>False</userealtime>

    <event category="Interaction" time="05/06/17 15:39:59.162"> Run.Pressed=False</event>

    <event category="Interaction" time="05/06/17 15:40:00.060"> File.SaveAs.IO=C:\My Documents\Waveforms\20170605-0002.psdata</event>

</document>

the above code saves file 20170605-0002.psdata to the specified file location.

what I would like to be able to do is instead of having a static filepath string as above, I would like to add the systemtime (current PC time) to the filename.

Can anyone please help me with writing that bit of code? Thanks

[Radu]

Hi,

And how is that XML document generated? Is it manually modified? Maybe you can create the XML document on the spot before using it.

Regards,
Radu

[sherzaad]

Hello Radu,

thank you for your reply.

the XML file was auto-generated by the application (picoscope). Similar to excel you can record macros in picoscope but instead of VBA, it saves the steps executed as xml.

I would like to now modify the script generated to basically add a timestamp each time a file is saved so as not to overwrite existing files as it would do with the xml code i have provided.

[Radu]

Hi,

Using Oxygen (or an open source XSLT processor) you can apply an XSLT stylesheet like this:

Code: Select all

<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"

    xmlns:xs="http://www.w3.org/2001/XMLSchema"

    exclude-result-prefixes="xs"

    version="2.0">

    <xsl:template match="node() | @*">

        <xsl:copy>

            <xsl:apply-templates select="node() | @*"/>

        </xsl:copy>

    </xsl:template>

    

    <xsl:template match="event[contains(text(), 'File.SaveAs.IO=')]">

        <!-- Copy its attributes -->

        <xsl:message><xsl:value-of select="current-time()"/></xsl:message>

        <event>

            <xsl:copy-of select="@*"/>

            <!-- And modify the save output value -->

            <xsl:value-of select="substring-before(text(), '.psdata')"/>

            <xsl:text>-</xsl:text>

            <xsl:value-of select="format-time(current-time(), '[H][m][s]')"/>

            <xsl:text>.psdata</xsl:text>

        </event>

    </xsl:template>

</xsl:stylesheet>

over your XML document to add the current time of day to the output file name pattern.

Regards,
Radu

[sherzaad]

Hello Radu,

Thank you for the script. That helps a lot.