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.
Writing data in txt files using TextOutput function
-
- 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
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.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?
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.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.