Writing data in txt files using TextOutput function

Post Reply
jbcraigs
Posts: 24
Joined: Thu Nov 11, 2010 4:38 am
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2007

Writing data in txt files using TextOutput function

Post by jbcraigs »

We are trying to create logs in form of csv or text files which would log when a particular TI process ran along with some of the key variables.

I was planning to use Textoutput or ASCIIOutput functions but they overwrite the previous data present in the text file instead of just adding new rows.

Is there any other function which can be used to achieve this?

Thanks.
Alan Kirk
Site Admin
Posts: 6647
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: Writing data in txt files using TextOutput function

Post by Alan Kirk »

jbcraigs wrote:We are trying to create logs in form of csv or text files which would log when a particular TI process ran along with some of the key variables.

I was planning to use Textoutput or ASCIIOutput functions but they overwrite the previous data present in the text file instead of just adding new rows.

Is there any other function which can be used to achieve this?
Unfortunately not. Steve Vincent raised the idea as an enhancement, but I don't know whether he's submitted it and when/if it will ever be created by IBM. In the meantime all you can do is use ExecuteCommand to run a batch file which merges multiple files. See BIHints' post in this thread for further information.

Be aware that you won't be able to modify the source data file (if that's what you're planning to do; your post isn't clear on that) while the process still has a lock on it, but you could do it in a subsequent process in a chore.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
Post Reply