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

Post Reply
User avatar
gtonkin
MVP
Posts: 1212
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: 359
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: 1212
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...
Post Reply