Move files using ExecuteCommand

Post Reply
bassmad
Posts: 2
Joined: Mon Jun 02, 2014 3:08 pm
OLAP Product: TM1
Version: 10.1
Excel Version: 2007

Move files using ExecuteCommand

Post by bassmad »

Hi guys,

Very simple question. I am trying to archive a file when I am done loading it. I have done this in the past with the ExecuteCommand function few years back and I just cant remember the syntax for the command. I have Googled it and also searched the forum but cant find it.

Could any sympathetic soul help me out please?
Alan Kirk
Site Admin
Posts: 6667
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: Move files using ExecuteCommand

Post by Alan Kirk »

bassmad wrote:Hi guys,

Very simple question. I am trying to archive a file when I am done loading it. I have done this in the past with the ExecuteCommand function few years back and I just cant remember the syntax for the command. I have Googled it and also searched the forum but cant find it.

Could any sympathetic soul help me out please?
You don't do it directly from the ExecuteCommand function. Instead you use the ExecuteCommand function to run (typically, in this case) a DOS batch file, which does the move.

A primer for creating batch files, including passing parameters to them so that you can specify which file(s) you want to archive, will be found here.
"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.
bassmad
Posts: 2
Joined: Mon Jun 02, 2014 3:08 pm
OLAP Product: TM1
Version: 10.1
Excel Version: 2007

Re: Move files using ExecuteCommand

Post by bassmad »

I remember doing this good few years ago. Type in the cmd which included creating folders and moving files. This did not include any batch files. This was probably version 9.0. Has this all changed now? I am now on version 10.1.1

Thanks for your reply
Alan Kirk
Site Admin
Posts: 6667
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: Move files using ExecuteCommand

Post by Alan Kirk »

bassmad wrote:I remember doing this good few years ago. Type in the cmd which included creating folders and moving files. This did not include any batch files. This was probably version 9.0. Has this all changed now? I am now on version 10.1.1
It doesn't have anything to do with the TM1 version. However since ExecuteCommand is essentially executing something that is, well, executable, you could directly call anything that is an external command line application such as, for instance, Robocopy. If you weren't using batch files before (which I'd prefer to stick with since they provide the option for some error handling, however rudimentary) you may well have been using that.
"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.
Post Reply