• Post Author:
  • Post published:May 21, 2020
  • Post Category:Others
  • Post Comments:0 Comments
  • Post last modified:May 21, 2020

 660 total views

In this article we will look into the tools that make life easier for Fusion consultants on daily work schedules.

Want to learn Fusion Technical tools? Checkout this article

1. Notepad++

https://notepad-plus-plus.org/downloads/

This is one of the most frequently used tool and most of you are also aware of it. This is basically a text editor with some syntax highlighting for SQL, XML etc.

What most of you don’t know is you can enhance the functionality of Notepad++ with the help of plugins available. List of official NPP Plugins are available here

The ones that I use are:
DSpellCheck > Spell checker to check typos.
Mime Tools > To convert text to Base64 encode and Decode without having to go online and convert.
XML Tools > To Convert the XML File into pretty readable format and find out the XPATH of the node that we are interested in.

Notepad++ Plugins Admin to install plugins
Notepad++ Plugins Admin

This is not an online tool. You will have to download and install it on your local machine to use it.

2. SOAPUI

https://www.soapui.org/

This is one of the widely used tools to test the SOAP/REST services. You can save the sample payloads as projects, so whenever you open the tool, you can reload the settings and use it directly. The UI is user friendly and it is easy to use. This is not an online tool and you will have to download and install it on your local machine.

SOAPUI tool for testing rest and soap web services in fusion hcm
SOAPUI tool

3. SQL Formatter

http://www.dpriver.com/pp/sqlformat.htm

We can convert the SQL written in random format into a neat and clean format with spacing for the select fields, from clause and where clause so that we can literally read through the SQL Query from top to bottom. There are multiple options that you can use too at the right hand side. This is an online only tool and no installation required.

Formatting SQL Query easily in fusion hcm using SQL formatter
Formatting SQL Query easily

4. Text Compare

https://text-compare.com/

This tool is used for comparing two files and it provides the differences beautifully. It will be useful to compare changes to the query or formula with respect to the backup copy. This is an online only tool and no installation required.

Text Compare Online tool to compare text. Useful for fusion hcm
Text Compare Online tool

5. Base64 Encode and Base64 Decode

Encodehttps://www.base64encode.org/
Decodehttps://www.base64decode.org/

These tools are mostly used when we use web services to get the output of BI Report and want to decode it or want to upload a file to UCM using web services. This is an online only tool and no installation required.

Base64 decode and encode online tool useful for uploading file to UCM and decoding bi report output fusion hcm
Base64 decode and encode online tool

6. Text Tools

https://miniwebtool.com/text-tools/

There are set of text tools available on this website which can be used as per our convenience.

Add Prefix and Suffix, Sort Alphabetically, Remove lines containing, remove duplicate lines to name a few.

Text tools online tool for fusion hcm
Text tools online tool

This is an online only tool and no installation required.

7. Text to HTML

https://www.textfixer.com/html/convert-text-html.php

This tool can be used to convert Text to HTML. In some data conversions, we have a requirement to load the data in html format so that the end user sees the formatted code. We can use this online tool to convert to html and then add the code to a text file and upload it using HDL.

Text to HTML in fusion hcm hdl tool
Text to HTML

This is an online only tool and no installation required.

8. XSLT transformation

https://www.freeformatter.com/xsl-transformer.html

In some cases when you use XSL templates for BI Reports or HCM Extracts, you need to test the XSL template. The only way to test this XSL template is to use the XSL Transformation websites. This is one of them. They have lot of other online tools too. You need to upload the input XML, XSL template and then it will generate the output XML for you. This is an online only tool and no installation required.

XSL Transformation online tool for xsl templates testing in Fusion HCM
XSL Transformation online

9. Code Beautify

https://codebeautify.org

This website has lot of text formatting tools, Base64 Decoder, Encoder, JSON Formatter, XML Viewer, XML Validator, XML to JSON,etc.

You can use these when you use SOAP/REST services and need tools to prepare payload in the right format. This is an online only tool and no installation required.

code beautify site to convert to multiple formats

10. Convert Case

https://convertcase.net/

This website has host of features on text tools. converting text to lowercase, uppercase, alternating case, title case, word count, character count and line count. This is an online only tool and no installation required.

Convert Case to convert text to alternate case in fusion hcm

Do you use any other free tools which you think would help others? Post them in the comments section.

Stay tuned to latest updates by joining our Telegram group, Facebook Page and LinkedIn Group

Sricharan

Sricharan is a Fusion HCM Solution Architect with over 13+ years of overall experience and 5+ years of Fusion experience. He is passionate about technical aspects of Fusion HCM and writes interesting articles on HCM Extracts, HCM Data Loader, Fast Formula, BI Publisher, Integrations and Automation etc.

Leave a Reply