Questions relating to - TM1 Application folder

Post Reply
Ashleigh W
Posts: 61
Joined: Mon Oct 24, 2016 1:21 pm
OLAP Product: TM1
Version: TM1 Perspectives 10
Excel Version: Excel 2016

Questions relating to - TM1 Application folder

Post by Ashleigh W » Fri Aug 31, 2018 7:06 am

Hello TM1 Experts out there!!!

I have many files I need to (1) download from Application folder to local folder and archive and (2) upload multiple new files mostly excel to the folder. Is there a way to automate (upload/download) this in TI or any other way, please advise.

Currently the manual way is to do it one by one.

regards :)

Wim Gielis
MVP
Posts: 1826
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0
Excel Version: 2016
Location: Brussels, Belgium
Contact:

Re: Questions relating to - TM1 Application folder

Post by Wim Gielis » Fri Aug 31, 2018 7:51 am

Hello,

Those files are stored in the }Externals folder of the TM1 Data directory.
So look into that folder to download your files.

Do the new files replace the existing files with same file names ?
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 105 TM1 articles and a lot of custom code
Newest blog article: Looping over input files

Ashleigh W
Posts: 61
Joined: Mon Oct 24, 2016 1:21 pm
OLAP Product: TM1
Version: TM1 Perspectives 10
Excel Version: Excel 2016

Re: Questions relating to - TM1 Application folder

Post by Ashleigh W » Fri Aug 31, 2018 7:58 am

Hi Wim, thanks for quick support. I do not have admin rights to perform this task. Is there a way to process this copy/replace suggestion via TI Process?

regards
Ashleigh

Wim Gielis
MVP
Posts: 1826
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0
Excel Version: 2016
Location: Brussels, Belgium
Contact:

Re: Questions relating to - TM1 Application folder

Post by Wim Gielis » Fri Aug 31, 2018 8:26 am

That should be feasible by using ExecuteCommand in a TI process, using MS DOS commands for example.
But that seems like a lot of overkill for a one-off task. I suggest that you involve IT or someone else with the ability to access/copy those files.
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 105 TM1 articles and a lot of custom code
Newest blog article: Looping over input files

Ashleigh W
Posts: 61
Joined: Mon Oct 24, 2016 1:21 pm
OLAP Product: TM1
Version: TM1 Perspectives 10
Excel Version: Excel 2016

Re: Questions relating to - TM1 Application folder

Post by Ashleigh W » Fri Aug 31, 2018 9:09 am

That helps, thank you!

Post Reply