Xcelerator loading XLSM files to application folder

[robert.karunaratne]

Hi,

I am tring to upload a macro enabled workbook to an application folder in Xcelerator, however it is addig an xlsx extension to the file making it unreadable in the process.

Does anyone know if there a setting in the .cfg that I need to be enabling.

Thanks,

Robert

[robert.karunaratne]

I have done some further digging and a file Book4.xlsm which is uploaded to the application folder becomes in the }Externals\ Book4.xlsm.xlsx_20100917045222.xlsx

renaming the file has no affect as the .blob can't find the new file.

[LoadzaGrunt]

This definitely looks like a bug, not a feature...

You can do us all a favour and raise a ticket with IBM

[jrizk]

1. First you need to stop the Tm1 service (save your data first)
2. Create a blob file using text editor and place it under the appropriate applications folder (if any),

eg under }Applications\MyReports (or just }Applications if there are no sub folders)

- save the following as a file called say Book4.xlsm.blob

FILE_FORMAT=100
ENTRYNAME=Book4.xlsm
ENTRYTYPE=blob
ENTRYREFERENCE=TM1:///blob/public/.\}Externals\Book4.xlsm

3. Copy your file Book4.xlsm to }Externals - note Book4.xlsm has to be the same name as line 4 of the blob file.
4. Start the Tm1 service.

PS you don't need to upload the file via the Tm1 menus in Excel at any point. To update or modify the file going forward just open it directly from the }Externals folder and save.

[robert.karunaratne]

Hi,

Thanks a lot for the help.

whilst the solution works, it's not great from a customer perspective so I will raise it with IBM as well as.

Cheers,

Robert

[mnasra]

I see that the last message was in October 2010 and we are in May 2011- Do we have a 'normal' solution for this problem.
I see the 'workaround', but I do not understand how to implement it.
Also, I have more than one xlsm to put in the applications.

[tomok]

I see that the last message was in October 2010 and we are in May 2011- Do we have a 'normal' solution for this problem.
I see the 'workaround', but I do not understand how to implement it.
Also, I have more than one xlsm to put in the applications.

It is my understanding that TM1 still only supports the adding of XLSX files to the application folder (for Excel 2007 and above). The only way to get it to work is going to be to do the workaround suggested by jrizk.

[Andy Key]

Which part of the workaround are you having trouble with?

[mnasra]

2. Create a blob file using text editor and place it under the appropriate applications folder (if any),

What is a blob?

eg under }Applications\MyReports (or just }Applications if there are no sub folders)

- save the following as a file called say Book4.xlsm.blob

FILE_FORMAT=100
ENTRYNAME=Book4.xlsm
ENTRYTYPE=blob
ENTRYREFERENCE=TM1:///blob/public/.\}Externals\Book4.xlsm

Do I write exactly those 4 lines and I save the file as Book4.xlsm.blob

3. Copy your file Book4.xlsm to }Externals - note Book4.xlsm has to be the same name as line 4 of the blob file.

Do I have a book4.xlsm somewhere in my environment?


Where do I put the name of my own xlsm file? (and if I have 2?)

Sorry, on top of my english is not my first language, I am not a technical person.

Thanks

[Andy Key]

2. Create a blob file using text editor and place it under the appropriate applications folder (if any),

What is a blob?
A blob file is just a plain text file with the extension .blob rather than .txt. You can create it with Notepad.

eg under }Applications\MyReports (or just }Applications if there are no sub folders)

- save the following as a file called say Book4.xlsm.blob

FILE_FORMAT=100
ENTRYNAME=Book4.xlsm
ENTRYTYPE=blob
ENTRYREFERENCE=TM1:///blob/public/.\}Externals\Book4.xlsm

Do I write exactly those 4 lines and I save the file as Book4.xlsm.blob
Change every reference to Book4.xlsm to the name of the workbook that you want to add to your applications folders. Save the file as whatever you now have after ENTRYNAME= but with the .blob extension after .xlsm.

3. Copy your file Book4.xlsm to }Externals - note Book4.xlsm has to be the same name as line 4 of the blob file.

Do I have a book4.xlsm somewhere in my environment?
No, this is the workbook that you want to add.


Where do I put the name of my own xlsm file? (and if I have 2?)
The answer to the first question should be clear from the answers above. If you have more than one file to add, repeat the process.


Sorry, on top of my english is not my first language, I am not a technical person.

Thanks

[JayM]

Hi,

I am having the same issue with xslx or xlsm files under Application folder. What is this }Application\ folder where this .blob file needs to be saved?

Thanks

[mnasra]

THe }Application folder is under your SERVER name \datafiles\ }Application

I hope this helps
micheline

[Martin Ryan]

Anyone heard back from IBM on this issue? I've just encountered it two years and a few versions of TM1 later.

I'll work around by saving as .xls but I'd rather be able to save it in native Excel 2010 format as that's what's being used by all the users.

Martin

[rmackenzie]

You can attach .xlsm's as shortcuts, as opposed to actually 'uploading' them thereby creating a copy in }Externals. Not sure if that's going to work for you Martin?

[Martin Ryan]

Yeah, could probably make that work, thanks for the idea Robin.