Extracting Journals in a loadable format?

[Beeswing77]

Hi,

We're on 7.4.  Is there a way to extract a posted journal from one application so that I can easily load it to another application.  This would be super useful for investigating issues. 

At present, we can easily find imported data files, and load these into our test app. But I can't see any way to extract journals in the same way.  The only options seem to be extracting a .csv file,  which has the information but is not formatted in a way that can be loaded again.

[aformenti]

Hi @Beeswing77 ,

There is a new One Place solution that would allow you to move data between apps easily. Including journals data:

 https://solutionexchange.onestream.com/Dashboard/home/browse/browse

[Beeswing77]

Oh, that sounds great.  The link just takes me to the Solution Exchange home page though.  Do you know what the Solution is called please, so I can search for it?

[FredLucas]

It's called "Cube Data Manager (CDM)".

You might want to have a look at this post in case you have the same question while setting it up:

https://community.onestreamsoftware.com/t5/Workflow-and-Data-Integration/Setting-up-Cube-Data-Manage...

[FredLucas]

If you are interested in extracting and re up-loading the journals keeping the ability to drill to the journal files etc. you could also look into using the following functions:

'Export Journals:
Dim sValue As String = BRApi.Journals.Data.ExportJournalsToCsv(si, serverFilePath, wfProfileName, wfScenarioName, wfTimeMemberFilter, journalStatus)

'Import Journals:
objList = BRApi.Journals.Data.ImportAndProcessJournals(si, journalFilePath, save, submit, approve, post, unpostAndOverwrite, throwOnError)