# Get path to script (bat files) from value in Sys Settings cube # for the test the name is set to variable, it can be collected # to add ” in the string you need a variable # set to not get ” in the text file you write to disk You need to create two dimensions to handle the adjustable settings in a settings cube.Ĭreate the dimension Sys.EnvironmentVariables with the elements Mottagare, MailSender, MailSubject, ScriptPath.Ĭreate a Sys.Settings cube from above two dimensions, in this cube can you enter name of the sender and other useful information like path to the files, that can change when you move the TM1 application to a new server.įor example at ScriptPath you should enter D:\TM1 data\Scripts\ in that cube.Īnd at Mottagare you should enter the name of the recipient of the message in a SMTP mail format like Please fill in the other values accordingly. You can create a message.txt file before if you want, but to add the filename of the file that is read by TM1, we have added the creation of the message file to the TI process, so you can adjust the variable to get the filename from some other TM1 process. Should be simple, with only the mail name one each a startblat.cmd file to start the blat function, it should contain this text:Ĭall “D:\tm1 data\script\blat.exe” message.txt -tf recipient.txt -subject “Mapping file loaded” -p PeoĪbove two is optional, you can also create the startblat command in the TI process and add the recipient to the code. “SMTP is stored under the profile key Peo, you can use any name for the profile, but it have to be the same name used in the other scripts.Ĭreate a recipient.txt file that contains the names of the receiver of the alert mail.
TNEF2MIME.DLL MAILESSENTIALS WINDOWS
This create the values inside Microsoft Windows registry at key Run the installblat.cmd to get the values stored in Microsoft Windows. The roger-mailname should be replaced with your Sender address, that should be known to the SMTP mail server. SMTP name should be replaced with the name of your SMTP server. REMark where bbbb is replace with the username and ccccc is replace with the passwordįor a account that are allowed to send SMTP mail on the mail server.
TNEF2MIME.DLL MAILESSENTIALS INSTALL
Recommended is to use the BLAT install function to store the user and password to access the SMTP in the Windows registry, there it will be encrypted.Ĭreate a cmd file named installblat.cmd with this content:Ĭall “D:\tm1 data\script\blat.exe” -install 3 25 Peo bbbbbbb cccccccc If possible add the folder where BLAT.EXE are to the Windows Path variable. d:\tm1 data\scriptsĬopy all the BLAT files to the empty folder. Think you are in a TM1 project, and you want the TM1 Super user to get a mail when the csv file with data has been loaded into the DB2 database.Įnsure that you have a mail server that accepts SMTP mail from the TM1 server.Ĭreate a empty folder on the TM1 server, e.g. How do I send a mail to the user that a TM1 Turbo Integrator (TI) process have finished?