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?
Move files using ExecuteCommand
-
- 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
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.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?
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.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
- Posts: 2
- Joined: Mon Jun 02, 2014 3:08 pm
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2007
Re: Move files using ExecuteCommand
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
Thanks for your reply
-
- 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
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.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
"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.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.