• Post category:HCM Extract
  • Post comments:3 Comments
  • Post last modified:July 1, 2020
  • Reading time:3 mins read
You are currently viewing How to convert HCM Extract Export XML to Readable format?
How to convert HCM Extract Export XML to Readable format?
- How to convert HCM Extract Export XML to Readable format?
Total Visits: 32

In this article we will look into another interesting feature of HCM Extracts which will allow us to read through the HCM Extract in a User Friendly html format.

This tool was created by John Rhodes from Oracle Product Development team and I took his approval before posting this on my website.

John developed an XSL Transformation .xsl file which needs to be applied on the HCM Extract export XML file to get the html output which when opened shows the details of the extract in a user friendly tabular format.

I made some minor tweaks to the John’s XSL script to make it more user friendly by changing some parameters and spacing.

Without much delay, let’s have a look at the tool and how we should use this tool.

Let’s take a sample Extract export XML file and see how it looks.

We will consider an existing extract for this purpose and let’s see how we export the XML file for an extract.

Navigate to My Client Groups > Extract Definitions and search for the extract.
Click on the Export button to export the extract to XML.

image 1 1024x410 - How to convert HCM Extract Export XML to Readable format?

HCM Extract Export XML will look like below:

image 1024x476 - How to convert HCM Extract Export XML to Readable format?
SM_Demo_V1 Extract Export XML

It is hard to read through this XML file to check all attributes and the flags associated with the attributes , advanced filters, fast formulas and dbi name.

Now, we will use the XSL Transformation tool to transform the Exported XML file to an html file.

We will use the free XSL Transformation tool online https://www.freeformatter.com/xsl-transformer.html

image 2 1024x530 - How to convert HCM Extract Export XML to Readable format?
XSL Transformation online

Now, let’s input the Exported XML and XSL file (John’s XSL file attached at the end of the article) and click Transform. You can either copy paste the XML and XSL or browse for the files and transform it.

image 3 - How to convert HCM Extract Export XML to Readable format?
Click on Transform XML in New Window
image 5 - How to convert HCM Extract Export XML to Readable format?
Transformed Output

It will open up a new window with the transformed output file.
Copy paste it onto Notepad++ and save it as Extract_Name.html (SM_Demo_V1.html)

Now, Let’s open the html file and check how it displays the output.

image 6 1024x437 - How to convert HCM Extract Export XML to Readable format?
Extract presented in tabular format html view
image 7 1024x551 - How to convert HCM Extract Export XML to Readable format?
Extract child data groups and records presented in tabular format

Overall this is a cool way of reading through the extract without importing the extract to an instance.

Tip: We can use this html view to compare changes to an extract between different instances. As it extracts attribute and flag level information, this can be used to compare and migrate changes.

Download Links for Files:

HCM Extract ExportedSM_Demo_V1.xml
Transformation XSL FileXML Transformation.xsl
Transformed readable ExtractSM_Demo_V1.html

  • after saving the transformed output, in Which application I need to open that HTML so that i can see that in the readable format?

  • In visible box by plugintheme