Re: XSLT passing a variable to starts-with - XML / XSL Discussion Boards

Re: saving a file to the internet.

Richard MacCutchan31-May-17 23:32

Richard MacCutchan

31-May-17 23:32

Link does not go anywhere. You need to explain your problem in proper detail.

Re: saving a file to the internet.

felixjrz19851-Jun-17 1:43

felixjrz1985

1-Jun-17 1:43

iam sorry i did not explain very well.
it is not the actual link...
i mean i want to store my update.xml file somewhere on the remote location and access its link as something link www.website.com/update.xml and not as www.googledrive.com/id?=xskdhfIsksdhf

it is because i want to compare the two files update.xml in the local drives, and the www.website.com/update.xml from from remote location.

Thank you for your response.

Re: saving a file to the internet.

Richard MacCutchan1-Jun-17 2:03

Richard MacCutchan

1-Jun-17 2:03

Sorry I still do not understand what your problem is, or what this has to do with XML/XSL.

Re: saving a file to the internet.

Gerry Schmitz1-Jun-17 4:20

Gerry Schmitz

1-Jun-17 4:20

Do you have access to a domain / web site called "www.website.com"?

If you did, you would typically put "update.xml" in you website's "root directory"; or you would use some form of "redirection" to resolve the supplied address (e.g. MVC routing).

Is that clear?

"(I) am amazed to see myself here rather than there ... now rather than then".
― Blaise Pascal

Re: saving a file to the internet.

Terry Perez11-Sep-17 4:41

Terry Perez

11-Sep-17 4:41

Just make a google spreadsheet, that's all.

XSLT passing a variable to starts-with

bjmallon13-Feb-17 15:03

bjmallon

13-Feb-17 15:03

I've got an XML file full of user details including 'FirstName', 'Surname' and 'StreetAddress'.

Currently my XSL file has a template (SurnameAlphabetGrouping) that groups users by the first character of the Surname element's value. I've only provided the process for 'A' to save space. All 26 letters are processed.

XML

<xsl:template name="SurnameAlphabetGrouping">
    <xsl:variable name="AMatch" select="/Users/User[starts-with(Surname, 'A')]"/>
    <xsl:variable name="ACount" select="count($AMatch)"/>
    <xsl:if test="$ACount > 0">
      <h2>
        <a href="javascript:void(0)" class="dsphead" onclick="dsp(this)">
          + A (<xsl:value-of select="$ACount"/>)
        </a>
      </h2>
      <div class="dspcont">
        <table border="1" cellpadding="1" cellspacing="1">
          <tr>
            <xsl:call-template name="HeadingRow"/>
          </tr>

          <xsl:for-each select="/Users/User[starts-with(Surname, 'A')]">
            <xsl:sort select="Surname"/>
            <xsl:call-template name="UserRow"/>
          </xsl:for-each>
        </table>
      </div>
    </xsl:if>
  </xsl:template>

That's all well and good. But now that I've got it working that way, I really want to make it smarter (i.e. cut down the code), so I'm trying to build a template that can take the required character as a parameter.

I've got a variable (Letters) that carries tokens for the 26 letters of the alphabet:

XML

<xsl:variable name="Letters">
    <xsl:call-template name="tokenise">
      <xsl:with-param name="string" select ="'A B C D E F G H I J K L M N O P Q R S T U V W X Y Z'"/>
      <xsl:with-param name="delimeters" select="' '"/>
    </xsl:call-template>
  </xsl:variable>

I'm then attempting to process each token, passing it to the template as a parameter:

XML

<xsl:for-each select="msxsl:node-set($Letters)/token">
  <xsl:variable name="currToken" select ="./node()[1]"/>
  <xsl:call-template name="ListSurnameStartsWith">
    <xsl:with-param name="character" select="$currToken"/>
  </xsl:call-template>
</xsl:for-each>

This is the template as it stands at the moment:

XML

<xsl:template name="ListSurnameStartsWith">
    <xsl:param name="character" select="''"/>
    <xsl:variable name="charMatch" select="/Users/User[starts-with(Surname, $character)]"/>    
    <xsl:variable name="charCount" select="count($charMatch)"/>
    
      <xsl:if test="$charCount > 0">
      <h2>
        <a href="javascript:void(0)" class="dsphead" onclick="dsp(this)">
          + <xsl:value-of select="$character"/> (<xsl:value-of select="$charCount"/>)
        </a>
      </h2>
      <div class="dspcont">
        <table border="1" cellpadding="1" cellspacing="1">
          <tr>
            <xsl:call-template name="HeadingRow"/>
          </tr>

          <xsl:for-each select="/Users/User[starts-with(Surname, $character)]">
            <xsl:sort select="Surname"/>
            <xsl:call-template name="UserRow"/>
          </xsl:for-each>
        </table>
      </div>
    </xsl:if>
  </xsl:template>

'currToken' is getting the value I want. It's landing in the 'ListSurnameStartsWith' template just fine, but 'charMatch' just comes back blank all the time, meaning I can't get a meaningful count to test whether the output needs to be generated. The later '

Re: XSLT passing a variable to starts-with

Richard Deeming14-Feb-17 3:32

Richard Deeming

14-Feb-17 3:32

Are you absolutely certain that the character parameter is getting the correct string value?

I've just tried the following simplified example, and it works as expected:

XML

<?xml version="1.0"?>
<bookstore>
    <book>
         <title>The Weather Pattern</title>
         <author>Weather Man</author>
         <price>100.00</price>
    </book>
    <book>
         <title>Weaving Patterns</title>
         <author>Weaver</author>
         <price>150.00</price>
    </book>
    <book>
         <title>Speech Pattern</title>
         <author>Speaker</author>
         <price>15.00</price>
    </book>
    <book>
         <title>Writing Style</title>
         <author>Writer</author>
         <price>1500.00</price>
    </book>
</bookstore>

XML

<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
    <xsl:template match="/">
        <root>
            <xsl:apply-templates select="/bookstore">
                <xsl:with-param name="character" select="'W'" />
            </xsl:apply-templates>
        </root>
    </xsl:template>
    
    <xsl:template match="bookstore">
        <xsl:param name="character" select="''" />
        <xsl:variable name="charMatch" select="book[starts-with(title, $character)]"/>    
        <xsl:variable name="charCount" select="count($charMatch)"/>
        
        <result>
            <char><xsl:value-of select="$character" /></char>
            <count><xsl:value-of select="$charCount" /></count>
            <books>
                <xsl:for-each select="$charMatch">
                    <xsl:copy-of select="." />
                </xsl:for-each>
            </books>
        </result>
    </xsl:template>
</xsl:stylesheet>

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: XSLT passing a variable to starts-with

bjmallon16-Feb-17 19:45

bjmallon

16-Feb-17 19:45

Richard,

Thanks for your reply.

Yes, if I pass 'A' to the template, I get the correct answer. So that's a good thing.

Now, given a tokenised string stored in a variable (Letters):

XML

<xsl:variable name="Letters">
    <xsl:call-template name="tokenise">
        <xsl:with-param name="string" select ="'A B C D E F G H I J K L M N O P Q R S T U V W X Y Z'"/>
        <xsl:with-param name="delimeters" select="' '"/>
    </xsl:call-template>
</xsl:variable>

And trying to process each token through the template:

XML

<xsl:for-each select="msxsl:node-set($Letters)/token">
  <xsl:variable name="currToken">
    <xsl:value-of select="./node()[1]"/>
  </xsl:variable>
  <xsl:call-template name="ListSurnameStartsWith">
    <xsl:with-param name="character" select="$currToken"/>
  </xsl:call-template>
</xsl:for-each>

What should I be using inside the 'select' attribute to ensure that i get 'A' and not some other value.

Some options I've tried, debugging in Visual Studio 2013, are:

XML

<xsl:variable name="currToken">
  <xsl:value-of select="."/>
</xsl:variable>

This gives me:

$currToken	{Dimension:[1]}
    [1]	/
        node()[1]	A

'select="./node()"' gives me the same answer.
'select="./node()[1]"' gives me the same answer.

I haven't had any help from Google, as I can't seem to ask the right question, or nobody's doing this.

What do I need to put into the select to actually get the character A.

Re: XSLT passing a variable to starts-with

Richard Deeming17-Feb-17 2:48

Richard Deeming

17-Feb-17 2:48

Have you tried:

./text()[1]

If that doesn't work, can you post your "tokenise" template?

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: XSLT passing a variable to starts-with

bjmallon20-Feb-17 23:55

bjmallon

20-Feb-17 23:55

Richard,

Sorry I haven't replied earlier. I went on leave the day you responded and have been... occupied since.

I tried your suggestion, without success, although it has given me something to pursue.

As requested, the tokenisation templates I gleaned from other forum sources a fair while ago are below. It worked well for what I was doing then, but it may not be the best for what I'm attempting now.

Any advice would be appreciated.

XML

<!-- Tokenisation templates -->
  <xsl:template name="tokenise">
    <xsl:param name="string" select="''" />
    <xsl:param name="delimiters" select="' 	'" />
    <xsl:choose>
      <!-- Nothing to do if empty string -->
      <xsl:when test="not($string)" />

      <!-- No delimiters signals character level tokenization. -->
      <xsl:when test="not($delimiters)">
        <xsl:call-template name="_tokenise-characters">
          <xsl:with-param name="string" select="$string" />
        </xsl:call-template>
      </xsl:when>
      <xsl:otherwise>
        <xsl:call-template name="_tokenise-delimiters">
          <xsl:with-param name="string" select="$string" />
          <xsl:with-param name="delimiters" select="$delimiters" />
        </xsl:call-template>
      </xsl:otherwise>
    </xsl:choose>
  </xsl:template>

  <xsl:template name="_tokenise-characters">
    <xsl:param name="string" />
    <xsl:if test="$string">
      <token>
        <xsl:value-of select="substring($string, 1, 1)" />
      </token>
      <xsl:call-template name="_tokenise-characters">
        <xsl:with-param name="string" select="substring($string, 2)" />
      </xsl:call-template>
    </xsl:if>
  </xsl:template>

  <xsl:template name="_tokenise-delimiters">
    <xsl:param name="string" />
    <xsl:param name="delimiters" />
    <xsl:param name="last-delimit"/>
    <!-- Extract a delimiter -->
    <xsl:variable name="delimiter" select="substring($delimiters, 1, 1)" />
    <xsl:choose>
      <!-- If the delimiter is empty we have a token -->
      <xsl:when test="not($delimiter)">
        <token>
          <xsl:value-of select="$string"/>
        </token>
      </xsl:when>
      <!-- If the string contains at least one delimiter we must split it -->
      <xsl:when test="contains($string, $delimiter)">
        <!-- If it starts with the delimiter we don't need to handle the -->
        <!-- before part -->
        <xsl:if test="not(starts-with($string, $delimiter))">
          <!-- Handle the part that comes befor the current delimiter -->
          <!-- with the next delimiter. If ther is no next the first test -->
          <!-- in this template will detect the token -->
          <xsl:call-template name="_tokenise-delimiters">
            <xsl:with-param name="string"
                            select="substring-before($string, $delimiter)" />
            <xsl:with-param name="delimiters"
                            select="substring($delimiters, 2)" />
          </xsl:call-template>
        </xsl:if>
        <!-- Handle the part that comes after the delimiter using the -->
        <!-- current delimiter -->
        <xsl:call-template name="_tokenise-delimiters">
          <xsl:with-param name="string"
                          select="substring-after($string, $delimiter)" />
          <xsl:with-param name="delimiters" select="$delimiters" />
        </xsl:call-template>
      </xsl:when>
      <xsl:otherwise>
        <!-- No occurances of current delimiter so move on to next -->
        <xsl:call-template name="_tokenise-delimiters">
          <xsl:with-param name="string"
                          select="$string" />
          <xsl:with-param name="delimiters"
                          select="substring($delimiters, 2)" />
        </xsl:call-template>
      </xsl:otherwise>
    </xsl:choose>
  </xsl:template>

</xsl:stylesheet>

Re: XSLT passing a variable to starts-with

Richard Deeming21-Feb-17 2:42

Richard Deeming

21-Feb-17 2:42

OK, I think I've found the problem.

Within the <xsl:for-each select="msxsl:node-set($Letters)/token">, the default context is the node-set returned from your "tokenise" template. When you try to resolve /Users, it's looking in that node set, rather than the source document.

You need to capture the nodes from the source document that you want to process, and pass those to the template:

XML

<xsl:variable name="users" select="/Users" />

<xsl:for-each select="msxsl:node-set($Letters)/token">
    <xsl:variable name="currToken" select ="./node()[1]"/>
    <xsl:call-template name="ListSurnameStartsWith">
	    <xsl:with-param name="users" select="$users"/>
        <xsl:with-param name="character" select="$currToken"/>
    </xsl:call-template>
</xsl:for-each>

Update the template to:

XML

<xsl:template name="ListSurnameStartsWith">
    <xsl:param name="users" />
    <xsl:param name="character" select="''"/>
    
    <xsl:variable name="charMatch" select="$users/User[starts-with(Surname, $character)]"/>    
    <xsl:variable name="charCount" select="count($charMatch)"/>
    
    <xsl:if test="$charCount > 0">
        <h2>
            <a href="javascript:void(0)" class="dsphead" onclick="dsp(this)">
                <span class="dspchar">+</span> <xsl:value-of select="$character"/> (<xsl:value-of select="$charCount"/>)
            </a>
        </h2>
        <div class="dspcont">
            <table border="1" cellpadding="1" cellspacing="1">
                <tr>
                    <xsl:call-template name="HeadingRow"/>
                </tr>
                
                <xsl:for-each select="$charMatch">
                    <xsl:sort select="Surname"/>
                    <xsl:call-template name="UserRow"/>
                </xsl:for-each>
            </table>
        </div>
    </xsl:if>
</xsl:template>

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: XSLT passing a variable to starts-with

bjmallon21-Feb-17 11:24

bjmallon

21-Feb-17 11:24

Richard,

Thank you. That extra piece of understanding did the trick.

Regards
Brendan

How to generate XML file with serialisation in vb.net

Member 1280320219-Oct-16 9:06

Member 12803202

19-Oct-16 9:06

Hi there,

I have a one big prob.

I want to generate xml file with a specific format Like this syntax!:

<declarationrelevededuction xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<identifiantfiscal>1088081
<annee>2016
<periode>8
<regime>1
<relevedeductions>
<rd>
<ord>1
<num>FF160400146
<des>PRESTATION
<mht>2400.00
<tva>480.00
<ttc>2880.00
<reff>
<if>52803595
<nom>LEADER SOFT
<ice>001540114000046

<tx>20.00
<mp>
<id>2

<dpai>2016-08-01
<dfac>2016-01-30

<rd>
<ord>2
<num>FF160400147
<des>PRESTATION
<mht>1500.00
<tva>300.00
<ttc>1800.00
<reff>
<if>52803595
<nom>LEADER SOFT
<ice>001540114000046

<tx>20.00
<mp>

So, I've created form with button to generate the xml files and I created this code for That:

Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
Dim xmlsetting As New XmlWriterSettings
'xmlsetting.ConformanceLevel = ConformanceLevel.Document
'xmlsetting.OmitXmlDeclaration = True
Dim writxml As XmlWriter = XmlWriter.Create("mytest.xml", xmlsetting)
Try
With writxml
.WriteStartDocument()
.WriteStartElement("DeclarationReleveDeduction")
.WriteStartElement("identifiantFiscal")
.WriteString("111111")
.WriteEndElement()
.WriteStartElement("annee")
.WriteString("2016")
.WriteEndElement()
.WriteStartElement("periode")
.WriteString("8")
.WriteEndElement()
.WriteStartElement("regime")
.WriteString("1")
.WriteEndElement()
.WriteStartElement("Relvededution")
For i As Integer = 1 To 10
.WriteStartElement("Id")
.WriteString(i)
.WriteStartElement("Nom")
.WriteString("Nom " & i)
.WriteEndElement()
.WriteStartElement("prenom")
.WriteString("Prenom " & i)
.WriteEndElement()
.WriteStartElement("Adresse")
.WriteString("Adresse " & i)
.WriteEndElement()
.WriteEndElement()
Next

.WriteEndElement()
.WriteEndElement()
.WriteEndDocument()
.Close()
End With
MsgBox("fichier a été généré avec succès", vbInformation)
Catch ex As Exception
MsgBox(ex.Message)
End Try
End Sub
when I generated the xml file I have got like this format:

<declarationrelevededuction><identifiantfiscal>111111<annee>2016<periode>8<regime>1<relvededution><id>1<nom>Nom 1<prenom>Prenom 1<adresse>Adresse 1<id>2<nom>Nom 2<prenom>Prenom 2<adresse>Adresse 2<id>3<nom>Nom 3<prenom>Prenom 3<adresse>Adresse 3<id>4<nom>Nom 4<prenom>Prenom 4<adresse>Adresse 4<id>5<nom>Nom 5<prenom>Prenom 5<adresse>Adresse 5<id>6<nom>Nom 6<prenom>Prenom 6<adresse>Adresse 6<id>7<nom>Nom 7<prenom>Prenom 7<adresse>Adresse 7<id>8<nom>Nom 8<prenom>Prenom 8<adresse>Adresse 8<id>9<nom>Nom 9<prenom>Prenom 9<adresse>Adresse 9<id>10<nom>Nom 10<prenom>Prenom 10<adresse>Adresse 10

Please help me I need to do that in this days of current month Cry | Cry | :((

Confused | Confused | :confused:

[REPOST] How to generate XML file with serialisation in vb.net

Richard Deeming19-Oct-16 10:28

Richard Deeming

19-Oct-16 10:28

You have already posted this in the VB forum:
How to generate XML file with serialisation in vb.net - Visual Basic Discussion Boards[^]

Posting the same question in different places on the site duplicates work and annoys people.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Transform the date format from yyyy/mm/dd to mm/dd/yyyy

Member 1278840611-Oct-16 16:21

Member 12788406

11-Oct-16 16:21

XML

<xsl:attribute name="name">Insured1BirthDate</xsl:attribute>
						<xsl:if test="function-available('ExFunctions:FormatDate')">
							<xsl:value-of select="ExFunctions:FormatDate(X-pathh,'mm/dd/yyyy')"/>
						</xsl:if>

Re: Transform the date format from yyyy/mm/dd to mm/dd/yyyy

Richard Deeming12-Oct-16 4:26

Richard Deeming

12-Oct-16 4:26

You forgot to ask a question.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Read xml string

trungysp198610-Oct-16 15:48

trungysp1986

10-Oct-16 15:48

Help me read value in note <Code>, <Message>, <Time>

string result = "<?xml version=\"1.0\" encoding=\"utf-8\" ?> 
<string xmlns=\"http://tempuri.org/\">
<AAA> 
<Code>5</Code> 
<Message>Send MT Error!.</Message>
<Time></Time>
</AAA>
</string>"
XmlReader xReader = XmlReader.Create(new StringReader(result));
while (xReader.Read())
{
??????????????
}

Thanks so much!

^_^_^

modified 26-Aug-17 0:24am.

Re: Read xml string

Richard MacCutchan10-Oct-16 22:54

Richard MacCutchan

10-Oct-16 22:54

How to: Parse XML with XmlReader[^].

Re: Read xml string

Swinkaran11-Oct-16 17:09

Swinkaran

11-Oct-16 17:09

Something like this will also do,
https://www.dotnetperls.com/xmlreader[^]

XML

Member 1273144310-Sep-16 4:41

Member 12731443

10-Sep-16 4:41

I am getting this message when I try to validate my xml document: 13:2 The markup in the document following the root element must be well-formed. Every time when I try to fix line 13, I get the same error message.

XML

<?xml version="1.0"?>
<registration_form>
            <name>Digestive and Endoscopy Medical Office MD</name>
            <register>patient information</register>
            <patient>Arijit Singh</patient>
            <status>Single</status>
            <birthdate>10/20/1987</birthdate>
            <age>27</age>
            <address>6216 GreatWater Dr, Windermer, FL 34786</address>
            <home>(407)-987-2525</home>
            <cell>(407)-288-9331</cell>
</registration_form>
<patient employment>
            <employer <information>Orlando Home Team</employer>
            <occupation>Real Estate Agent</occupation>
            <address>1300 e Michigan St, Orlando, FL 32812</address>
            <employer>(407)-885-3539</employer>
    <patient employment>
<Insurance_Information>
            <subscriber>Arijit Singh</subscriber>
            <subscriber's S.S.>789-53-3407</subscriber's S.S.>
            <group>DC2630</group>
            <co-payment>$50</co-payment>
</Insurance_Information>
<In Case of Emergency>
            <name>Zina Kaur</name>
            <relationship>fiancee</relationship>
            <authorization>Arijit Singh</authorization>
</In Case of Emergency>

Re: XML

OriginalGriff10-Sep-16 4:44

OriginalGriff

10-Sep-16 4:44

See wikipedia: XML - Wikipedia, the free encyclopedia[^]

Quote:
Tag names cannot contain any of the characters !"#$%&'()*+,/;<=>?@[\]^`{|}~, nor a space character, and cannot begin with "-", ".", or a numeric digit.

<patient employment>

Contains a space.

Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...

Re: XML

Member 1273144310-Sep-16 4:48

Member 12731443

10-Sep-16 4:48

I tried to write the code just like that <patient employment=""> and this <patient_employment> and <patientemployment> and I still get an error message. Confused | :confused:

Re: XML

Member 1273144310-Sep-16 4:52

Member 12731443

10-Sep-16 4:52

I tried that but it did not work and I tried <patient_employment> and I tried <patientemployment> and I still got an error.

Re: XML

OriginalGriff10-Sep-16 5:06

OriginalGriff

10-Sep-16 5:06

And did you take a good look at the line below that as well?

Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...

Re: XML

Member 1273144310-Sep-16 5:18

Member 12731443

10-Sep-16 5:18

Yes I did. But I still did not find any solutions to the error.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.