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

XSLT: Positioning of newly added attribute

i am copying a xml document and add a attribute to certain nodes (see: xslt how to add attributes to copy-of) Thing is, my nodes already have some existing attributes, f.e.: <element id="123" dbfield="table"> When i add a new attribute, it...
more »

2016-11-21 13:11 (2) Answers

XSLT Contains function

I want to do three things, show the amount of cars that are older and younger than 1999, show the average price range between the cars (the year). And also extract the amount of cars which contain the text automatic in adtext parameter of the XML. Th...
more »

2016-11-20 11:11 (1) Answers

How to convert Xpath syntax to XSL/XSLT syntax?

I understand how XPath syntax works, and can write Xpath commands to extract certain information from a XML file. I would like to convert my XPath commands to XSLT scripts so that someone else can just run the script over the XML file to get the same...
more »

2016-11-18 16:11 (2) Answers

XPath 3.0 XML parsing functions in XSLT

I have a sequence of strings that I need to parse as XML using XSLT. For example: &lt;span&gt;Foo&lt;/span&gt; &amp; &lt;span&gt;bar&lt;/span&gt; have been tagged. When I try to parse this using fn:parse-xml-frag...
more »

2016-11-14 19:11 (1) Answers

Remove http(s):// in XSLT 1.0

I'm working on a CMS function where a user could add Meta Data to images. The Option source is used to create a backlink to the original ressource/main page. This case works finde to determine, a Link should displayed or just the resource. But I ha...
more »

2016-11-04 09:11 (1) Answers

XSLT - removing empty nodes

I am using the below xslt to remove namespaces. How can it be enhanced to remove empty tags as well? <?xml version="1.0" encoding="utf-8"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:o...
more »

2016-10-31 21:10 (1) Answers

Importing a XML file in MS Access

Good morning world! Have a nice day! I'm searching to create a XSLT file (or Ms Access transformation file) to import this XML, can anyone help me? I don't know stylesheet very well, I tried to create one but it doesn't show me the QUOTATION NUMBER ...
more »

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

Node name as parameter

Hi my xml looks like this <Component name="super.useful.component"> <StringValue name="component.title.1"> <Value>some value</Value> </StringValue> <StringValue name="component.title....
more »

2016-10-25 22:10 (2) Answers