TM1 Forum

I looked through the API documentation and I think I found what you're looking for. Look up the TM1CubeCellSpreadStatusGet function. According to the documentation it will return an array where each index will have 1 of the following 3 values: TM1CubeCellSpreadStatusHeld() TM1CubeCellSpreadStatusHel...

Not 100% sure if this is what you're asking for, but take a look at the TM1ElementType() property. You should be able to check to see if the TM1_INDEX the API returns for the elements you're looking at matches what's returned by TM1TypeElementConsolidated() to tell if the cell you're looking at is a...

It looks like it changes the Security Access setting on the Process object loaded into memory on the server and then that change is only made permanent when a Save Data is run. This can be tested by changing the Security Access setting on a Process in Perspectives or Architect and then looking at th...

If you don't mind having to do some development in .NET you could write your own using the System.Net.Mail namespace.

I started on just such a project a few months ago but ran into a problem with either the variables or the parameters and it hasn't been enough of a priority for me to pursue it. (IBM support were less than useful with this too.) Thread derail here, but what issue did you run into? I've been working...

You can create a process through the API and register it (or update an existing one). However, it isn't trivial. First you create the empty process (TM1ProcessCreateEmpty), then there are about 30 or so properties for the process that you will have to set values for, then check the process (TM1Proce...

I'm not sure, to be honest. I switched over to using the regular TM1 API shortly after this because of all the shortcomings with the .NET API and never went back to check. I believe when I posted this I was using a version of 9.4.x so if you're on a version of 9.5.x and still having this issue I'm g...

Thanks, I'll fix that. I went into autopilot typing most of that out. :D Another thing that I discovered that you'll probably want to change is that for every external function declaration that returns a StringBuilder make it return an IntPtr instead. Returning a StringBuilder worked in my 32-bit co...

Jim, check your ACG email. If you do decide to go the .NET route I attached some sample code using the C API in C# using pinvoke.

You're right, I just tested it looks like the Users collection is only populated by connections you create in your session, so you can't use it to log out everyone.

Someone can correct me if I'm wrong, but I don't believe a disconnect all function exists in the C API. You'd have to get the array of handles that represents all the client connections to a particular server and then disconnect them one by one. On the other hand, if you're using the .NET API there ...

Can you post the relevant code? It's tough to tell what might be wrong otherwise.

I don't really know too much about Java API, but if it's similar to how the C API works for CAM authentication you have to create an array of TM1Vals and pass that to the login function. The correct order of elements for the array should be { [CAM Namespace], [Username], [Password] }. Are you doing ...

You're welcome. If you encounter any problems with it let me know; I've only really used the process and chore functions. I also have a translation of it for Python for the extremely curious.

I'd be surprised if anyone has already done that translation for C# though... but you never know, you might get lucky. Here you go: https://github.com/bagovino/TM1ProcessReplicate/blob/master/ProcessReplicate/TM1API.cs Everything is there except for the functions that deal with the TM1Object struct...

Are you sure all 3 instances are running on the same admin host? What are the values of strAdminServer and strServerCert?

I think there is, but being the curious and do-it-myself guy that I am I decided to see if I could figure it out how make my own.

It's a program that replicates processes from one instance to another without having to bounce the instance. I'd rather it not go around creating and deleting objects (any more than necessary) on the destination instance. The program itself works fine already, and looping over the chores and looking...

I know you guys said you're using VB.NET, but I'm getting close to having a complete classic TM1 API class in C# if you're interested. I'll post it up on the useful code forum when I'm done translating the function declarations in the header file if there's any interest and to save people from the e...

Thanks for the suggestion, but directly accessing the chore files on the disk is not applicable to what my application does. It actually doesn't have any access to the file system on the server running TM1.