How to validate Xml in that specific way

My problem is that i dont know how to properly write a xsd that allows me to validate xml in such way : i need to have few necessary nodes (in any order) and to allow any other nodes to be in root so for example i need to validate such xml, with 2 ...
more »

2017-02-05 22:02 (1) Answers

XSLT-2.0: grouping by node content

We need to do a grouping table rows on the content of the first column, and then perform a certain amount of processing for each row in the group. The contents of the first column - numbers. It would be approached for-each-group, if the columns do no...
more »

2017-02-05 18:02 (3) Answers

cdata-section-elements not working

I am trying to set a password in an xml file generated via XSLT (using Saxon-HE v9.7.0.14), by setting a global parameter. The password can contain any characters so it needs to be put in a CDATA section. I am trying to achieve this by setting the ...
more »

2017-02-03 07:02 (3) Answers

awk double quote field separator

I can't seem to figure out my last piece to achieve my desired output. I have a file with many entries like the following: <Stats> <RecNum>45435</RecNum> <Date>2016/12/31</Date> <DayofWeek>6</Dayof...
more »

2017-01-29 01:01 (3) Answers

How to print percentile using xsl

I am trying to generate 99 percentile in the HTML report using jmeter-results-detail-report_21.xsl file. I am able to print the 90 percentile using the below code: </xsl:template> <xsl:template name="percentiles"> <xsl:param na...
more »

2017-01-24 04:01 (1) Answers

remove root tag from xml using xslt

I have an xml file like this <root> <level1>data</level1> <level1>data</level1> . . . <level1>data</level1> <level1>data</level1> </root> I want to remove the root tag using xslt. can any...
more »

2017-01-21 12:01 (1) Answers

Pandas read_xml() method test strategies

Interestingly, pandas I/O tools does not maintain a read_xml() method and the counterpart to_xml(). However, read_json proves tree-like structures can be implemented for dataframe import and read_html for markup formats. Now, if the pandas team does...
more »

2017-01-21 07:01 (0) Answers

XSLT Transformation from XML PCDATA to XML

I need to do transformation from PCDATA in XML into another XML. Can any one help me on this? I need to map the line of business, site-location and policy number from the request to the corresponding field in response. Input XML containing PCDATA w...
more »

2017-01-18 09:01 (1) Answers

XSLT - concatenating values to existing one

I have the following XML: I would like id to be the concatenation of subname + subname2. Example: For the first one id would be: ThinkVision, the second one: LenovoMind Is this achievable via xsl:for-each ? I tried using the following xslt: ...
more »

2017-01-16 19:01 (1) Answers

Why XSL transformation to linear xml fails

For unknow reason SEPA payment file cannot converted to linear xml. I tried xml file and stylesheet below using http://http://www.utilities-online.info/xsltransformation result xml ei empty. Selector <xsl:template match="TxAmt/*"> must fin...
more »

2017-01-15 18:01 (1) Answers

XML Transformation with XSLT

I'm new to XSLT. I am getting duplicate WaitingPeriodStatus nodes for the persons as shown in the below current output example. I need to get the WaitingPeriodStatus of each person as in expected output. INPUT XML: <ns0:Root xmlns:ns0="http://...
more »

2017-01-09 23:01 (1) Answers

Import XML Children as Columns in Excel

I have several large XML files that I need to convert to Excel spreadsheets. Some of the data is nested and when I import to Excel it is creating extra rows for each child value. I would like to create a column to handle the children so I only have...
more »

2017-01-03 19:01 (2) Answers

XSLT Conditional Count

new to this site. Hoping someone can help me figure out why my code is not working. I used some other posts on the subject from this site to get this close, but can't see my error. XSLT: <!-- Keyset based on the Subject (Part Numb...
more »

2016-12-22 20:12 (2) Answers

Save xslt form in mysql using zend 1.12

I want to save xml document in mysql database as below: $_docId= $this->getRequest()->getParam('docId', 0); $_slmData = '<SLM_form_v2 id="slmform"><group_1_1><section1_1/><name1_1>sdfds</name1_1> enter code here&...
more »

2016-12-12 14:12 (1) Answers

Adding data from one XML file to another - PHP

Any help would be appreciated on this. Im looking to take a value from one XML file and input it into another XML using PHP preferably. I will accept any other methods of transformation if they work. XML 1 <field-list> <field Id="spMF_1_16...
more »

2016-12-09 10:12 (1) Answers

Notepad++ XML compare in order with xsl

I need to compare two XML files but they aren't always in the same order. This is the format I have: <?xml version="1.0" encoding="UTF-8"?> <?xml-stylesheet type="text/xsl" href="Untitled.xsl"?> <Abc> <Blub> ...
more »

2016-12-04 20:12 (0) Answers