Forum Discussion

grgatlin's avatar
grgatlin
New Contributor
11 months ago

Transformation Rules (trx) Export Multiple files

Hi - Is there a way to export multiple trx at once? And where it would indicate which Account Dimension Transformation Rule it came from?

  • Hi,

    the way I did in the past is using the following API:

    OneStream.[Shared].Wcf.TransformationRuleExtractor.ExtractTrx(dbConnFW, dbConnApp, TransformationTableName)

    This function returns the content of the TRX file as String so you would have to write to a TRX file.The function checks security access so only users to the transformation table can run the BR that uses it.

    It should work in V7, not sure in v8 as I have not tested.

    HTH

  • Hi there,

     

    You can also export the file, in app/load-export file. Select transformation rules, and then the rules you want to download. You'll get an XML file that you can read and update if necessary.

    Regards,

    Carlos

    • franciscoamores's avatar
      franciscoamores
      Contributor II

      Yup, that would be another way but it produces an XML instead of TRX

      You can also automate XML extract/load with API.

      Regards