MS Access Code to execute process

恭喜发财1

Hey All,

I would like to insert a piece of vb code into MS Access to execute a Tm1 process.
If anybody knows the syntax for this. It would be much appreciated.

Regards,

gaohua5201

Since no client uses access I had to google if bat-scripts may be executed via access:  (apparently yes)

If you can indeed call bat-scripts (and this is applicable in your case), have a look at runti.exe
(especialy the 5th post, which contains the documentation) runti.exe is available since 9.5.2 HF1 but should work fine for older versions if you can get your hands on the exe.

copy this to a bat file to create the pwd and key file (I usually get confused which is which so I made the script. yes, I'm that lazy)
Code: @echo off
set base_path=%~dp0
set tm1crypt="Crogram Files (x86)CognosTM1bintm1crypt.exe"
set /P user=Username:
set /P pswd=Password:
set tm1crypt_arguments=-pwd %pswd% -keyfile "%basepath%tm1crypt_%user%_pwdkey.txt" -outfile "%basepath%tm1crypt_%user%_pwd.txt" -validate

%tm1crypt% %tm1crypt_arguments%

pause
(at least the .bat will attempt to create the files at the folder it resides in. if you put it at c:, run it as administrator. obvious? I got bothered with this twice this week. it's still Monday over here. Weeks do start with Monday.)

then use
Code: @echo off

rem set tm1adminhost=
set tm1server=cubica_test1
set tm1user=api
set pwd_path=C:UserslukasmDocumentsTM1_TABScubica_test1
set tm1runti="Crogram Files (x86)CognosTM1bintm1runti.exe"


set pwd="%pwd_path%tm1crypt_%tm1user%_pwd.txt"
set pwdkey="%pwd_path%tm1crypt_%tm1user%_pwdkey.txt"
set tm1runti_params=-process SYS_SecurityRefresh -adminhost %tm1adminhost% -server %tm1server% -user %tm1user% -passwordfile %pwd% -passwordkeyfile %pwdkey%
@echo on
%tm1runti% %tm1runti_params%

This script runs the process "SYS_SecurityRefresh" as user "api" with password information found at pwd_path
If your process has arguments, see the mentioned documentation - it should be easy to add.

chenwu521

Lukas Meyer wrote:runti.exe is available since 9.5.2 HF1 but should work fine for older versions if you can get your hands on the exe.

I'm pretty sure that is not true although I have not tested it. New TM1 features are almost always never backward-compatible.

Esuom

Tomok,

I'm guessing that RunTi accesses the API in a similar way to the batch files created on this site before it existed. It may work but I think it's not designed to so you may be right. Instead of using RunTi use the batch files from this site (available in helpful code) that are free and are know to work on multiple version,

Jim.

孤云清云

Hey All,

Thanks for the replies.

We are running TM1 v9.5.2 HF2 at the moment. (Upgrading to 10 in the next couple of months).

So I guess the RunTi.exe will work?

I will test and give feedback.

Thanks!!!

sysease

Hey All,

Thanks everything worked perfectly.

Regards,