You cannot append to a file when using AsciiOutput and TextOutput, right? Wrong!

Post Reply
User avatar
gtonkin
MVP
Posts: 1216
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: Latest and greatest
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

You cannot append to a file when using AsciiOutput and TextOutput, right? Wrong!

Post by gtonkin »

Cross-posting this topic here in case someone needs it.

TL:DR
Inserting the below function will allow you to append to a file when using AsciiOutput or TextOutput. Works across Prolog, Metadata, Data and Epliog as well as other TI processes:

Code: Select all

AsciiOutputOpen(<filename>,0|FILE_OPEN_APPEND|FILE_OPEN_SHARED);
Argument of 0 truncates.
Can be used in PAW, just ignore the error where PAW does not recognize the function.

Full article is here.

@Admins - could we leave this here for a while then move to Tips & Tricks once it has had some exposure please.
MarenC
Regular Participant
Posts: 371
Joined: Sat Jun 08, 2019 9:55 am
OLAP Product: Planning Analytics
Version: Planning Analytics 2.0
Excel Version: Excel 2016

Re: You cannot append to a file when using AsciiOutput and TextOutput, right? Wrong!

Post by MarenC »

Hi,

you are sleeping with someone at IBM or you randomly put words into TI's and hope for the best? :D

Either way, keep up the great work!

Maren
User avatar
gtonkin
MVP
Posts: 1216
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: Latest and greatest
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Re: You cannot append to a file when using AsciiOutput and TextOutput, right? Wrong!

Post by gtonkin »

Let's go with the random words option...
ardi
Community Contributor
Posts: 159
Joined: Tue Apr 02, 2013 1:41 pm
OLAP Product: tm1, cognos bi
Version: from TM1 9.4 to PA 2.0.9.6
Excel Version: 2010
Location: Toronto, ON

Re: You cannot append to a file when using AsciiOutput and TextOutput, right? Wrong!

Post by ardi »

Thanks for sharing George!

I wonder how many other golden TI Functions like this are there :)
Ardian Alikaj
Post Reply