Xslt Puns

Hi All,

So, I have an XML like below -

	<Shipments>
	<Shipment CarrierServiceCode="Ground" DeliveryMethod="SHP" ExpectedShipmentDate="2021-10-18T16:43:48+00:00"   StatusDate="2021-10-18T16:43:57+00:00">
		<Extn ExtnSLAExpectedShipDate="2021-10-19T16:43:48+00:00"/>
		<ShipmentLines TotalNumberOfRecords="5">
			<ShipmentLine >
				<Extn>
					<ExtnLocationInfoList>
						<ExtnLocationInfo FloorLocation="15NDAR" FloorLocationDesc="Needle Arts"/>
					</ExtnLocationInfoList>
				</Extn>
			</ShipmentLine>
			<ShipmentLine >
				<Extn>
					<ExtnLocationInfoList>
						<ExtnLocationInfo FloorLocation="10SWCN" FloorLocationDesc="Sewing Construction"/>
					</ExtnLocationInfoList>
				</Extn>
			</ShipmentLine>
			<ShipmentLine >
				<Extn>
					<ExtnLocationInfoList>
						<ExtnLocationInfo FloorLocation="15NDAR" FloorLocationDesc="Needle Arts"/>
					</ExtnLocationInfoList>
				</Extn>
			</ShipmentLine>
			<ShipmentLine >
				<Extn>
					<ExtnLocationInfoList>
						<ExtnLocationInfo FloorLocation="15NDAR" FloorLocationDesc="Needle Arts"/>
					</ExtnLocationInfoList>
				</Extn>
			</ShipmentLine>
		</ShipmentLines>
	</Shipment>
	</Shipments>

I need to sort all the ExtnLocationInfo elements inside ShipmentLine tag in ascending order of attribute value FloorLocation.

So Output should be like below

<Shipments>
	<Shipment CarrierServiceCode="Ground" DeliveryMethod="SHP" ExpectedShipmentDate="2021-10-18T16:43:48+00:00" StatusDate="2021-10-18T16:43:57+00:00">
		<Extn ExtnSLAExpectedShipDate="2021-10-19T16:43:48+00:00"/>
		<ShipmentLines TotalNumberOfRecords="5">
			<ShipmentLine>
				<Extn>
					<ExtnLocationInfoList>
						<ExtnLocationInfo FloorLocation="10SWCN" FloorLocationDesc="Sewing Construction"/>
					</ExtnLocationInfoList>
				</Extn>
			</ShipmentLine>
			<ShipmentLine>
				<Extn>
					<ExtnLocationInfoList>
						<ExtnLocationInfo FloorLocation="15NDAR" FloorLocationDesc="Needle Arts"/>
					</ExtnLocationInfoList>
				</

Hello! I've been working in technical writing for about six months now, so I'm still very much a newbie. Because I have some (limited) experience in coding, my company has given me a lot of work and projects involving XSLT transformations. So far everything has been going smoothly, and I've actually really liked the work. I feel like I've been on a crash course in XML, DITA and XSLT, so needless to say I've really learned a lot.

A couple of questions have popped into my head recently, and I thought this might be the appropriate place to ask them.

1. I've been reading on the Internets that XSLT is on the way out, and HTML + CSS paged media would be the way to do things in the future. Do you think this is the case? Have you switched from dabbling with XSLT to CSS yourself, or seen such a transformation in the industry overall? In short, is XSLT still relevant?

2. Is JSON commonly used in technical writing? If so, in what capacity? And what programs, techniques and such should I learn about it? Pretty much all the projects I've worked with have involved XML and DITA, so I'm just wondering what other formats, if any, are used?

3. Where do you see technical writing going in the future, technology-wise? What kind of technologies should an aspiring tech writer learn?

My mom’s company let go all of the older software engineers who were working from home last July. My mom had worked there for over 20 years. Their reasoning was that they wanted people to work in-person at their new office headquarters across the country. But probably the real reason was to replace the higher income people with new grads who will work at a lower salary.

She’s been applying for as many jobs as possible this whole time, even low salary jobs that aren’t programming related. She’s also been taking online training courses in C# I think and maybe some others. She hasn’t been able to find a new programming job or even a secretary type position somewhere.

Does anyone have advice for a programmer experienced in XSLT, PL1, or JCL? They only gave her 4 months severance and things are getting kind of hard. My mom would prefer another work from home position but is willing to work somewhere within a 4 hour drive from Indianapolis, Indiana. Thank you for any help you can give :)

Edit: thank you guys so much! I expected to get a few replies at most and I’m shocked at how kind and helpful this sub is. I told my mom about a lot of your comments and it made her happy. I told her I saw a few comments saying that she must be pretty smart to know XSLT so well, which made her feel good.

My mom’s still in touch with her former coworkers who were also laid off - they have a video call every couple weeks or so. As far as I know, no one else has found a job yet either, however I don’t know how hard the others are looking. My mom always says those meetings are so depressing because her old coworkers just complain a bunch.

She’s on LinkedIn and it’s updated. She gets calls and messages from recruiters all the time honestly, but the jobs they suggest for her are usually looking for different languages. So if she gets an interview, it doesn’t usually go very well.

I’m not offended by comments saying she should’ve kept her skills more current. I agree. And I appreciate other comments reminding people that she’s from a different generation where people could count on working for one company for their whole career. I graduated from engineering school a few years ago and we had a required seminar class where industry people would come speak and basically tell us how important it is to continue educating yourself throughout your career. I’m sure my mom didn’t have that benefit. And, yes she did have to take stacks of code cards down to the single big basement comput

Hello, I hope I've come to the right place. I'm at a loss as to how to handle my problem. I have an XML feed that contains HTML tags, now the feed of course has the tags escaped and this feed works until I try to apply XSLT 3 to it. All the HTML tags (characters) are escaped and now being displayed as literal values instead of the browser rendering/parsing the HTML tags. I need to some how convert or transform the characters so they can be parsed.

I've been searching for a solution for days but I either am not understanding it or I'm just not finding the solution. Any help would be greatly appreciated.

Content example

<p>

<a href="https://www.gsmarena.com/samsung_galaxy_s6_(usa)-7164.php">>Samsung Galaxy S6</a>

<p>

Result I'm looking for but with the HTML element tags parsed.

<p>  
<a href="https://www.gsmarena.com/samsung_galaxy_s6_(usa)-7164.php">Samsung Galaxy S6</a>
</p>

Example of Rendered Output

Hi.

I have an interesting problem, just curious to know if anyone has some recommendations about how to do this.

I have some XML configuration data for an old version of some software. There's also an accompanying stylesheet used to produce the config info.

Unfortunately, the software vendor only supports using the XML configuration on the same version of the software, so it can't be used to move configuration data during an upgrade.

I'd like to develop a way to do exactly that - export the XML config, use the stylesheet for the upgraded version to produce a new config file that can be used on the newer version of the software. I know there will need to be some minor changes (to accommodate new features and make minor config changes) so the recommended solution needs to be able to accommodate that as well.

Thanks in advance for your help.

I've cross-posted this in the s/Excel sub already but I think that you guys here may have come across this more so than the guys over there. It's not specific to powershell but there may be a powershell solution I am unaware of. If its out of scope then I apologize and feel free to delete.

Having adjusted expectations, I think the title captures it sufficiently. It may be worth emphasizing again that I am not talking about a simple XML export but the XSLT stylesheet ... a stylesheet that could then be used to create more Excel Worksheets with different datasets.

A little background: I am dealing with web applications. Each worksheet represents an application environment [dev, test, qa, prod, dr, etc]. In each worksheet you'll have a listing of servers. Servers that represent different layers of the application [web, app and database layers]. For each server you will have ip address, OS, disk, CPU, RAM info. Right now I have to enter this information manually into Excel and then make it all pretty. However, I have a powershell script that gathers all this information. So I am trying to bridge the gap.

So I would like to have the powershell script export the data into XML format (fairly easy) and then using the XSLT Stylesheet (what I'm asking for help with), transform it into Excel format (fairly easy).

The alternative would be to programmatically use powershell to make calls directly to Excel and then process all the desired formatting that way. This would be clunky and awkward. I've done this with VBScript and VBA before and its less desirable. I would prefer the manual process over this.

A google search revealed a lot of sites talking about going the other way. XML->XLSX but I didn't see anything for what I need.

Is what I'm asking for even possible? Help?

My coworkers are advocating that a new system we are designing use JSON rather than XML. I can see the positive points and why it would be convenient since most of the browser side widgets we use consume JSON. But I am bothered by the lack of tools for JSON such as XPath the XSLT. With these XML can queried and transformed and thereby easily be converted to JSON when necessary.

So is there an equivalent for XPath/XSLT/XML for JSON?

Hello!
Can anyone recommend any good tutorial to learn xslt?

G'day Everyone,

I know XSLT is not exactly the sexiest technology on the block at the moment, but every contract I've worked there is always some Xalan XSLT system sitting on some server somewhere, chugging away quietly, handling some mission critical integration tasks.

That is until something goes wrong and you're hit with the job of fixing this critical system that everyone has come to rely while you field calls from all over the state asking when it will be back up...and you realise it's a completely black box....message in, *magic, message out.

XSLT/Xalan systems are soooooooo hard to debug, and you're usually under the pump while you're doing it. On top of that, often you can't reproduce the error in a dev environment...you set the system up in eclipse, fire some messages through, everything works fine...put it back in prod and boom, crash again.

Anyway, over the years I've written a bunch of helpful little utilities (like a bridge between XSLT and SLF4j) that help me out in these situations...I'm a stay at home dad to a toddler these days so I thought I'd open source them and see if anyone else gets any use out of them.

https://github.com/AdamNormanJenkins/SXE/

Cheers

Jenko

We have a team in our project who are responsible to convert 100000+ XML files to PDF via an XSLT. Currently they are running the task on 4 desktops but are looking for a quicker turnaround.
This made me think to use some service in AWS to do this but I have no idea what AWS service we could deploy. I was thinking Lambda could be a candidate but not sure about the allowed running time per call (some XML's are quite large, resulting in over 20MB PDF files) and the cost of calling Lambda for so many files might not be cost effective.

 
Edit: we asked our TAM also for some input. Once we have some conclusion from them or perhaps via the inputs from the great people here we will paste the route and method we have chosen to go with.

If anyone here has some idea or suggestions then that would be great!

(SOLVED) thanks to u/BonScoppinger

Hello guys, I'm hoping you can help me with this XML to XML transformation activity using XSLT.

I want to compute for the "total fee" based from the tuition fee of a student's program multiplied to his/her units. However it seems that the only first tag of <tuition>'s values is being computed or used which is "1000".

XML text<enrollment>

<students>

<student program="IT">

<name>Mercado, Clarion AJ C.</name>

<yearLevel>1</yearLevel>

<studNum>2019101308</studNum>

<units>16</units>

<previousTerm>2</previousTerm>

<courses>

<course>GED105</course>

<course>IT126</course>

<course>CS127</course>

</courses>

</student>

<student program="CS">

<name>Quilantang, Kyrie I.</name>

<yearLevel>2</yearLevel>

<studNum>2018105368</studNum>

<units>15</units>

<previousTerm>2</previousTerm>

<courses>

<course>GED107</course>

<course>IT127-8L</course>

<course>CS128</course>

<course>CS126</course>

</courses>

</student>

</students>

<terms>

<oldterm>

<term1>1</term1>

<term2>2</term2>

<term3>3</term3>

<term4>4</term4>

</oldterm>

<newterm>

<term1>1st Term</term1>

<term2>2nd Term</term2>

<term3>3rd Term</term3>

<term4>4th Term</term4>

</newterm>

</terms>

<fees>

<fee>

<id>IT</id>

<tuition>1000</tuition>

<misc>8500</misc>

</fee>

<fee>

<id>CS</id>

<tuition>2000</tuition>

<misc>9000</misc>

</fee>

</fees>

</enrollment>

Hello,

I am trying to map some old XML to HTML for easier viewing. From online examples, I understand the basics, however, I was hoping to get assistance with the finer details related to my case.

Example XML:

<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href="books06.xsl"?>
<books>
   <book number="1">
           <title>OpenGL Programming Guide Fourth Edition</title>
           <location>107</location>
           <publisher>Addison-Wesley</publisher>
           <year>2004</year>
           <chapter chapternum="1">
                   <pages>4</pages>
                   <words>221</words>
           </chapter>
           <chapter chapternum="2">
                   <pages>32</pages>
                   <words>25701</words>
           </chapter>
   </book>
   <book number="2">
           <title>An Introduction to NURBS: With Historical Perspective</title>
           <location>120</location>
           <publisher>Academic Press</publisher>
           <year>2001</year>
           <chapter chapternum="1">
                   <pages>24</pages>
                   <words>20001</words>
           </chapter>
           <chapter chapternum="2">
                   <pages>54</pages>
                   <words>223401</words>
           </chapter>
           <chapter chapternum="3">
                   <pages>5</pages>
                   <words>401</words>
           </chapter>
   </book>
</books>

I was attempting to output multiple tables in HTML using the attribute number as the table title and then having the table columns be the xml tags; however, with multiple "chapters" the tables could become unruly. So I gave that method up.

Now I am attempting to create a summary block that has a title "Book Number 1" with two columns for the standard data e.g.

------------------------------------------
            BOOK NUMBER 1
    title: xxxx       location: xxxxx
publisher: xxxx           year: xxxxxx
-------------------------------------------
Chater 1: 
            pages: x

I'm calling an endpoint, and getting a XML response. I want to run that XML response through XSLT, How can I do that ?

I have only the basic understanding of XSLT. I discovered it day before yesterday and since then studying on it. Any help on this highly appreciated.

Example xml:

<class> 
   <student rollno = "393"> 
      <firstname>Alex</firstname> 
      <lastname>Benjimin</lastname> 
      <nickname>AlexG</nickname> 
      <marks>30</marks>
      <age>18</age> 
   </student> 
   <student rollno = "493"> 
      <firstname>Mathew</firstname> 
      <lastname>Helm</lastname> 
      <nickname>Makkie</nickname> 
      <marks>50</marks>
      <international>true</international>
   </student>
   </student> 
   <student rollno = "493"> 
      <firstname>Mathew</firstname> 
      <lastname>Helm</lastname> 
      <nickname>Makkie</nickname> 
      <marks>95</marks>
      <international>true</international>
   </student>

..........
</class>

I want to use condition in XSLT for if (marks > 60 && international==true), if only these conditions are satisfied I want to pass/save the XML elements.

Output:

   </student> 
   <student rollno = "493"> 
      <firstname>Mathew</firstname> 
      <lastname>Helm</lastname> 
      <nickname>Makkie</nickname> 
      <marks>95</marks>
      <international>true</international>
   </student>

.......

Is this doable using XSLT ?

P.S. Some attributes are present for only specific students only (ie age).

As the title asks...is there a way to WYSIWYG edit and XSLT and have a real time preview of the result?

I originally posted this on r/cscareerquestions. I got a lot of great advice and info, including the idea to post my question here and on r/experienceddevs as well. Thank you in advance for any help you can give :)

My mom’s company let go all of the older software engineers who were working from home last July. My mom had worked there for over 20 years. Their reasoning was that they wanted people to work in-person at their new office headquarters across the country. But probably the real reason was to replace the higher income people with new grads who will work at a lower salary.

She’s been applying for as many jobs as possible this whole time, even low salary jobs that aren’t programming related. She’s also been taking online training courses in C# I think and maybe some others. She hasn’t been able to find a new programming job or even a secretary type position somewhere. She’s on LinkedIn and it’s updated. She gets calls and messages from recruiters all the time honestly, but the jobs they suggest for her are usually looking for different languages. So if she gets an interview, it doesn’t usually go very well.

Does anyone have advice for a programmer experienced in XSLT, PL1, or JCL? They only gave her 4 months severance and things are getting kind of hard. She’s on unemployment right now, but it’s nowhere near enough for her bills. My siblings and I are helping out as much as we can, but it’s still not sustainable. Plus she’s kind of a workaholic and is going crazy lol. My mom would prefer another work from home position but is willing to work somewhere within a 4 hour drive from Indianapolis, Indiana.

My mom’s still in touch with her former coworkers who were also laid off - they have a video call every couple weeks or so. As far as I know, no one else has found a job yet either, however I don’t know how hard the others are looking. My mom always says those meetings are so depressing because her old coworkers just complain a bunch.

On my original post, I got a lot of comments saying she should’ve kept her skills more current. I agree and it doesn’t offend me. I also appreciated other comments reminding people that she’s from a different generation where people could count on working for one company for their whole career. I graduated from engineering school a few years ago and

Hello. New. First post.

I think the title captures it sufficiently. It may be worth emphasizing again that I am not talking about a simple XML export but the XSLT stylesheet ... a stylesheet that could then be used to create more Excel Worksheets with different datasets.

A little background: I am dealing with web applications. Each worksheet represents an application environment [dev, test, qa, prod, dr, etc]. In each worksheet you'll have a listing of servers. Servers that represent different layers of the application [web, app and database layers]. For each server you will have ip address, OS, disk, CPU, RAM info. Right now I have to enter this information manually into Excel and then make it all pretty. However, I have a powershell script that gathers all this information. So I am trying to bridge the gap.

So I would like to have the powershell script export the data into XML format (fairly easy) and then using the XSLT Stylesheet (what I'm asking for help with), transform it into Excel format (fairly easy).

The alternative would be to programmatically use powershell to make calls directly to Excel and then process all the desired formatting that way. This would be clunky and awkward. I've done this with VBScript and VBA before and its less desirable. I would prefer the manual process over this.

A google search revealed a lot of sites talking about going the other way. XML->XLSX but I didn't see anything for what I need.

Is what I'm asking for even possible? Help?

I originally posted this on r/cscareerquestions. I got a lot of great advice and info, including the idea to post my question here and on r/mainframe as well. Thank you in advance for any help you can give :)

My mom’s company let go all of the older software engineers who were working from home last July. My mom had worked there for over 20 years. Their reasoning was that they wanted people to work in-person at their new office headquarters across the country. But probably the real reason was to replace the higher income people with new grads who will work at a lower salary.

She’s been applying for as many jobs as possible this whole time, even low salary jobs that aren’t programming related. She’s also been taking online training courses in C# I think and maybe some others. She hasn’t been able to find a new programming job or even a secretary type position somewhere. She’s on LinkedIn and it’s updated. She gets calls and messages from recruiters all the time honestly, but the jobs they suggest for her are usually looking for different languages. So if she gets an interview, it doesn’t usually go very well.

Does anyone have advice for a programmer experienced in XSLT, PL1, or JCL? They only gave her 4 months severance and things are getting kind of hard. She’s on unemployment right now, but it’s nowhere near enough for her bills. My siblings and I are helping out as much as we can, but it’s still not sustainable. Plus she’s kind of a workaholic and is going crazy lol. My mom would prefer another work from home position but is willing to work somewhere within a 4 hour drive from Indianapolis, Indiana.

My mom’s still in touch with her former coworkers who were also laid off - they have a video call every couple weeks or so. As far as I know, no one else has found a job yet either, however I don’t know how hard the others are looking. My mom always says those meetings are so depressing because her old coworkers just complain a bunch.

On my original post, I got a lot of comments saying she should’ve kept her skills more current. I agree and it doesn’t offend me. I also appreciated other comments reminding people that she’s from a different generation where people could count on working for one company for their whole career. I graduated from engineering school a few years ago and we ha