Excel file in Applications folder

[vamp]

Is there are any way to show excel blob (TM1BlobCreate), which saved in "}Applications", in Applications folder of Architect? Which of tm1api functions need to be used?
Thanks for reply!

[Ricky Marwan]

Check TM1FolderEntries

[vamp]

using TM1FolderEntries() function - I can get only contents of any folder of }Applications, but I didn't need this.

Code: Select all

var serverFolder = TM1ObjectPropertyGet(Pool, Server, TM1ServerFolder());
var count = TM1ObjectListCountGet(Pool, User, serverFolder, TM1FolderEntries());

// listing of files and directory contents below

I need to put blob, which would be visible in Architect

[Ricky Marwan]

clear now, need to put blob
the first thing you need to get TM1EntryReference followed by URLHandle of entry reference
open the blob, use filestream to read block of bytes and use Blob put to store bytes
finally blob close

[vamp]

You almost right, but:

I create blob using TM1BlobCreate(), I can read & write any data, but I can't see created blob/file using Achitect application.

[vamp]

What about TM1FolderEntryAdd function? Anyone used it?

[vamp]

I've just debugged tm1a.exe application and found that TM1FolderEntryAdd called after add File/add Reference-menu item click: http://d.pr/i/ewIJ
Does anyone know TM1FolderEntryAdd signature?

[Mike Cowie]

Hi Vamp:

I don't think the TM1 Application components of the TM1 API are officially documented which, when that happens, usually means that:

• They haven't gotten around to documenting them officially yet
• They think there's a chance they'll change the implementation/functions and don't want to publish them right now

If you think you need them for the purposes of what you're trying to do then I would reach out to IBM, make a case for why you need them and tell them you understand that what they give you is subject to change. Someone else may have a copy of the declarations for these functions, but it might be good to get it from the source.

Hopefully they will officially document these soon given application folders have been around for ages!

Regards,
Mike

[Marcus Scherer]

an approach through the backdoor would be the following: you already determined/created
- the xls file in }Externals folder
- the blob with parameter entry ENTRYNAME/ENTRYTYPE/ENTRYREFERENCE
- the path to it in the }Applications folder
you could insert a new element (folder\blob name) in the }ApplicationEntries dimension and hierarchy with the API.

The drawback is that it requires a server restart to make the xls file accessible in Architect.

[vamp]

now I've successfully created copy of folder-object using TM1ObjectDuplicate (I think that I can duplicate any file entry) , after - register it using TM1ObjectRegister and folder appears in Architect