Asciioutput to users local machine

Post Reply
MarenC
Regular Participant
Posts: 346
Joined: Sat Jun 08, 2019 9:55 am
OLAP Product: Planning Analytics
Version: Planning Analytics 2.0
Excel Version: Excel 2016

Asciioutput to users local machine

Post by MarenC »

Hi,

TM1 development is moving more and more to PAW, well in theory anyway!

One of the key tools when developing or sorting out issues is to asciioutput the results. As far as I know you can only output to a drive that the TM1 server has access to.

Given that PAW is a web based tool, and more than likely to be accessed from a users local machine, I think it would be useful to ascii to the local machine, rather than the TM1 server.

Anyone have any thoughts on this, or are their existing ways to make it possible?

Maren
User avatar
Steve Rowe
Site Admin
Posts: 2410
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: Asciioutput to users local machine

Post by Steve Rowe »

Yup...

#Get the logging directory (Delivered with a trailing slash)
sLogDirPath = GetProcessErrorFileDirectory;

#write the file
asciioutput(sLogDirPath | 'tm1myerror.log', etc....)

Any file that starts tm1 and ends .log will show up in the download logs dialogue on the PAW admin page of the TM1 DB.

Simple when you know how, but some experimentation was required!
Technical Director
www.infocat.co.uk
User avatar
gtonkin
MVP
Posts: 1192
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: Asciioutput to users local machine

Post by gtonkin »

I use two different approaches:
1 - Drill to the text file
2 - Email the resulting file based on the logged in user. ExecuteCommand in epilog to run the necessary ps script

Where files are big, FTP or RDP to the rich client are options for admins with relevant access.
MarenC
Regular Participant
Posts: 346
Joined: Sat Jun 08, 2019 9:55 am
OLAP Product: Planning Analytics
Version: Planning Analytics 2.0
Excel Version: Excel 2016

Re: Asciioutput to users local machine

Post by MarenC »

Hi,

thanks for the feedback, very interesting solutions that I will test at some point!

Still like logging onto the server and just opening from the directory, but good to see the available options and they do have other uses.

Maren
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Asciioutput to users local machine

Post by Wim Gielis »

If it’s an IBM cloud environment, the SFTP access with e.g. FileZilla is very easy.

Similar solutions can probably be set up for other systems.
Why not just READ access to the TM1 logging directory through a mapped network drive ?
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
User avatar
vovanenok
Posts: 88
Joined: Mon Jun 23, 2014 4:54 pm
OLAP Product: TM1
Version: 2.0.9
Excel Version: Office 365
Location: Toronto, Canada
Contact:

Re: Asciioutput to users local machine

Post by vovanenok »

For smaller logs, I would just use LogOutput()
Then you can search the logs using TM1 REST API (or check TeamOne in the commercial subforum: https://www.tm1forum.com/viewforum.php?f=20)

Another option is to write logs to a custom cube

I also like the drill to file solution proposed by George and mapped network drive proposed by Wim
----------
TeamOne Google Sheets add-on for IBM Planning Analytics
Let's connect on LinkedIn
Post Reply