Tm1 Web File upload

Post Reply
nameSpace
Posts: 3
Joined: Wed Apr 18, 2018 2:38 pm
OLAP Product: TM1
Version: 11.1
Excel Version: 1803

Tm1 Web File upload

Post by nameSpace »

Planning Analytics version 2.0.6

Good Day

We are currently looking for a solution to allow users to upload files through tm1web directly through their web browsers and then save the file somewhere on the web server. What would be the best approach to achieve this? Is there code that is readily available to integrate into tm1web or will we need to develop this functionality in house?

If developing the upload functionality ourselves is our only option, what would be the best/easiest technologies to use for development for WebSphere liberty server that runs tm1web? As far as I know Websphere liberty does not support PHP to retrieve the files, would using something like Jax-rs be a variable alternative?

Any help will be greatly appreciated

Kind Regards
Matthew
tomok
MVP
Posts: 2836
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Tm1 Web File upload

Post by tomok »

TM1Web does not have any file upload capabilities in it. To "add" it would involve hacking the TM1Web code, something I would definitely not recommend because every time you deployed a new release of TM1Web you would have to redo your hack. Instead of delving into the technical specifics, what is the business purpose and why does it have to be through the TM1Web site? You could do this quite easily with Sharepoint or even just a plain old Apache web server and PHP. I've done a good bit of web programming in my day and the file upload routine in PHP is really easy to program.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
User avatar
paulsimon
MVP
Posts: 808
Joined: Sat Sep 03, 2011 11:10 pm
OLAP Product: TM1
Version: PA 2.0.5
Excel Version: 2016
Contact:

Re: Tm1 Web File upload

Post by paulsimon »

Hi

The file upload facility you will need to do yourself. A bit of googling should provide an answer. JavaScript is an option. C# with ASP.Net is another option. We use a hyperlink function on our TM1 Web Sheets to launch this and to pass params to the upload facility. The upload actually goes to an IIS Server. We then use an Action button to trigger a TI to process the uploaded file.

If you wanted to do something more integrated you could use the JavaScript TM1 Web API but that is quite a lot of work.

Regards

Paul Simon
Post Reply