Cloud

OneStream File Association Quick Tip

Istock 948997140 (1)

As with most programs, the OneStream platform utilizes file extensions that typically will not be associated with a program on your computer.  This Quick Tip will provide the steps on how to associate the import log of a file represented by extension “XFL” and the export of a transformation rule represented by extension “TRX” with Notepad.  Note, OneStream Software provides an alternate approach for these extensions which is KB0010896 accessible from the OneStream service portal.

To begin the process, log into OneStream and select a Workflow Profile that has an import profile type.  This blog will utilize the reference application, GolfStream, to demonstrate.

Blog 2021 10 26 20 05 00 Clipboard

After a file has been imported, select the “View Last Log File…” icon Blog 2021 10 26 19 47 40 Clipboard to open the log file.

Blog 2021 10 26 19 43 38 Clipboard

If the log file extension of XFL is not associated with a program, the next image or a similar image will display.  Select “More apps” to associate Notepad with the XFL extension.

Blog 2021 10 26 19 32 54 Clipboard

Scroll down the list of programs, select “Notepad – 1” and then select “OK – 2“.  Leave if checked or check “Always use this app to open .xfl files” which will make the association permanent in the Windows Registry.

Blog 2021 10 26 19 34 24 Clipboard

With the XFL extension associated, the log file will display in Notepad.

Blog 2021 10 26 19 35 15 Clipboard

Next, the file extension “TRX” will be associated with Notepad.  To begin the process, select “Application” -> “Data Collection” -> “Transformation Rules

Blog 2021 10 26 20 20 17 Clipboard

Select a transformation rule for a Rule Group and Dimension.  Any transformation is applicable.

Blog 2021 10 26 20 23 31 Clipboard

With the transformation rule selected, click the “Export selected group to a TRX file” icon Blog 2021 10 26 20 28 28 Clipboard.

Blog 2021 10 26 20 31 25 Blog 2021 10 26 19 39 06 Clipboard

Assuming the transformation rule file extension of TRX is not associated with a program, the next image or a similar image will display.  Select “Notepad -1 ” and then “OK – 2” to associate Notepad with the TRX extension.

Blog 2021 10 26 19 39 36 Clipboard

Blog 2021 10 26 19 40 01 Clipboard

With the TRX extension associated, the transformation rule file will display in Notepad.

Blog 2021 10 26 19 40 34 Clipboard

I hope this blog was helpful and thank you for your time in reading.  Should you have any questions, feel free to either post a comment or email me at terry.ledet@perficient.com.

About the Author

Terry is a Senior Solutions Architect at Perficient and a OneStream Certified Professional (OCP) - Lead Architect R1. He is a frequent speaker at Splash and passionate about making clients successful. When not blogging about OneStream, Terry is a husband, parent, and baseball enthusiast.

More from this Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Subscribe to the Weekly Blog Digest:

Sign Up
Categories