Page 1 of 1
Add Files to Application via process or vba
Posted: Thu Nov 27, 2008 8:30 pm
by pobrouwers
Hello Everybody,
Is it possible to create a folder and add a file into this folder in Application. This via process or via a script VBA.
Thx
Re: Add Files to Application via process or vba
Posted: Thu Nov 27, 2008 8:39 pm
by Paul Segal
Do you mean create a folder and add a file to it from Excel? Then the answer is yes - probably best to google some excel VBA sites for the code for this.
Regards
Paul
Re: Add Files to Application via process or vba
Posted: Thu Nov 27, 2008 8:49 pm
by pobrouwers
Hello Paul,
No in fact, add a file to Application in TM1 explorer
Re: Add Files to Application via process or vba
Posted: Thu Nov 27, 2008 10:00 pm
by pobrouwers
I've found.
It must to add element in the dimension }ApplicationEnties with this code and create folder and blob into }Applications folder.
Code: Select all
vDir = 'TEST 999';
vBlob = vDir | '\' | 'TEST.blob';
vDimensionName = '}ApplicationEntries';
vTopName = '}Applications';
DimensionElementInsert(vDimensionName,'',vDir,'C');
DimensionElementInsert(vDimensionName,'',vDir,'n');
DimensionElementComponentAdd(vDimensionName, vTopName, vDir, 1.000000);
DimensionElementComponentAdd(vDimensionName, vDir, vBlob, 1.000000);
That's works but the problem is that I must to restart the server to reload all objects.
How refresh the list object in application folder without stopping and starting the server TM1 ?
Thx
Re: Add Files to Application via process or vba
Posted: Fri Nov 28, 2008 9:03 am
by Steve Vincent
Does pressing F5 in the server explorer work? It does when i add a new cube and someone else wants to see it who was already logged in, but not sure if it would in this case...
Re: Add Files to Application via process or vba
Posted: Fri Nov 28, 2008 2:01 pm
by pobrouwers
I've tried F5 but it doesn't work...
Any ideas ?
Re: Add Files to Application via process or vba
Posted: Sat Nov 29, 2008 12:17 pm
by pobrouwers
Hello,
Who's an experience with tm1 api and more specialy TM1BlobCreate, TM1BlobPut,...
Do you have some examples ?
Thx
Re: Add Files to Application via process or vba
Posted: Mon Dec 01, 2008 9:25 am
by Steve Vincent
The API in that case is probably all you have left as an option. I've never delved that deep so i can't help on that front i'm afraid...