XSLT - Transformation of XML

[@jota_coelho]

Thank you for all your videos and for being so attentive, always coming back and helping ppl on the coments section. Your channel is pure gold. A big thank you from 🇧🇷. Wishing you all the best!

[@MikesTechCorner]

Thank you. Im happy to help ppl and messages like that gives energy :)

[@saransrinivas8551]

Very nice Mike. Got the concept in a very little time. Thanks,

[@MikesTechCorner]

Thank you for watching

[@danstoian7721]

Wow, believe it or not I actually had a whole "XML Technologies" course at university, they never told us a browser is capable of making XSLT transformations, we did it in some web app.... Thanks!

[@MikesTechCorner]

Im happy to hear so. Just use IntelliJ community edition and you will be happy. :-)

[@ranaphadiboys5516]

@@MikesTechCorner hi do you have a idea of Table of cases from multiple chapters. Send me a logic on [e-mail]

[@teachmehowtodoge1737]

This is great. Thanks for sharing. :)

[@MikesTechCorner]

My pleasure! Thank you for watching

[@alonsoquinones6979]

Another interesting topic (candidate for a youtube video) would be to go from one XSL to modularize XSL in terms of using or . This is very good when code grows and you want to split your solution in smaller chunks..

[@MikesTechCorner]

Great suggestion! Added to backlog

[@macton182]

Hello Mike. Thank you for the videos, very helpful! I have a tricky question: Instead of having this XML: Cactus Coconut Palms Grass you have this XML: 1 2 3 Every Plant in the XML is shown as a code (1, 2, 3) The Plant values of the code is stored in an external-file (plant.json or plant.xml) In external-file the plants are listed with the "Key" and "Value" (for example: Key "1" = Value "Cactus", ...) Is it possible to link in the xsl-File to the external-file (plant.json or plant.xml) and get the values from the content? It happens to work with a large amount of data so the idea was to keep the XSL lightweigt and store the "plant"-Data in a external-file. Other xsl-Files can then also use to the extern-file. thank you, tom

[@MikesTechCorner]

You need an XML file with the data with a transformation declaration in the top. Then the browser will take the transformation template and apply it to the XML and generate a new file from that.

[@MikesTechCorner]

It sounds like you want to code a small python or javascript program that does that. :) Npm can run your javascript.

[@macton182]

@@MikesTechCorner Thanks for your reply. I am a beginner in xml and xsl, but still looking for ways to simplify. When i am deeper into the topic, i try it with js. npm is running :)

[@MikesTechCorner]

@@macton182 Sounds good.

[@alonsoquinones6979]

Great video. Would be great to have a video that walks through XSLT automation, thus triggering the XSLT, say from terminal, so the transformation does not depend on a Java IDE.

[@MikesTechCorner]

Good idea. Added to backlog

[@salonygupta5096]

hi, lets suppose i have xmlns attribute in one of the parent tag : //child tags so, i am facing issue in getting the child tag value. how to resolve this?

[@MikesTechCorner]

I don't know

[@Ikbneinmudafcker]

thank you for the helpful content, I have the problem that my browser, after describing the type, doesn't convert the xls, its only show me my xml content, do you maybe know where is the issue?

[@MikesTechCorner]

I hope you find the solution. The transformation is very sensitive. First try with a very simple example and see if it works.

[@medtube1223]

thanks that is really helpful for me

[@MikesTechCorner]

Glad to hear that

[@amirulazmy1059]

Hi do you have any tutorial on generating bar chart using XSL ?

[@MikesTechCorner]

No :-) Sorry.

[@alanhorton2478]

I am receiving large data returns from an API (114 MB). I have tried ADO - failed abysmally. I tried reshaping the data using LiNQ for XML - not much better at performance! So, now I am interested in the performance of XSLT against Big Data API. I use NewtonSoft to deserialize the JSon into XML. I have a result document that looks like: about 30 data elements record repeats between 10,000 records to ~ 50,000 records. The DOM naturally goes to sleep chewing on these files. I have tried converting the JSon to XDocuments containing XElements and LiNQ doesn't perform all that well on these unformatted chunks of data. Would XSLT perform any better? Or, would this best be served to throw it up on AWS to a DocumentDB resource? Upsize it, index it and transform it with the Horsepower of AWS?

[@MikesTechCorner]

You should add support for paging in your api. So you can page 7 with a for instance a pagesize of 1000 records.

[@akhilraj-lb3xj]

Hi Mike I've a requirement that i have to convert a CSV file to a xml file with xslt. I have to us that xslt file to load as a transform file in my AX Aif File system adapter services. i have tried couple of code that i got from a blog, couldnt worked out well, all i have a ax table that need to be filled with values of a csv file from a shared parth on a network by aif concept in AX 2012.

[@MikesTechCorner]

That is an interesting problem. You can by default only convert xml as source with xslt. I would write a small java converter that uses OpenCSV to handle the .csv source file. Then I would convert it to XML with Jackson. I have made both videos on OpenCSV and Jackson XML which are available on my channel.

[@akhilraj-lb3xj]

@@MikesTechCorner thanks a lot Mike..I'll definitely refer those.. Thanks for considering my concern...

[@joewarwick430]

xsl:template match= is replace a for loop also.

[@MikesTechCorner]

Good point.Yes. I might make another XSLT video soon

[@joewarwick430]

@@MikesTechCorner yeah cool; with the apply-templates * in :)

[@sivakokkeragadda1869]

I Mike..it's really great explanation..Now i have to add a image in top left html report..please suggest any explanation..

[@MikesTechCorner]

Just add the html-tag for an image. Add

[@kaanbahadir1636]

I would really appreciate if you could do a video about creating an Output with : Xslt into Spreadsheet(Excel-Output). Unfortunatelly There are only videos about XSLT into HTML.

[@MikesTechCorner]

Added to backlog. Can't promise when I have time to do it.

[@PingpongPoof-c3r]

Thanks

[@MikesTechCorner]

Welcome