Automatically publishing a package

[jedi2005]

Hi all,

please help me with this problem:

How can i automatically publish a package in frameworkmanager eg. publishing the package every day at 4:00am without creating it manually.
It is possible by starting a Windows-Script? And if yes, how?
(I have to this because i want to externalize data of a SAP BW Cube into .csv-files)

Thanks for your answers

[prikala]

I think BmtScriptPlayer.exe might be the right tool for this (FM user guide contains title "Running Scripts That Publish Packages May Result in Broken Reports" in troubleshooting section).

Unfortunately publishing package is not recorded in FM Transaction Log so you must write the "action log" yourself and syntax for log files is not documented in FM documentation (maybe in sdk?).

[cognosjon]

Just a general query regarding this, why do you need to republish every day, do you add new categories everyday?
We have externalised queries that are used for transformer and they have probably only been republished twice in the last four months.

[jedi2005]

Thank you for your help, prikala.
You're right with bmtscriptplayer.
You can log the publishing by changing the value of the loglevel of publishing to "2" in the file CR1behaviors.xml.
With this script it's possible to start publishing with a .bat-File using bmtscriptplayer.