Running TI from TM1 web issue.

sjgogo

We have created a TM1 application which will be accessed by more than 500 users.
Volume data should be uploaded by these 500 users which are at different remote locations. We are providing access to TM1 Web & not TM1 Perspective.
The problem is how they can upload data by themselves as if we select any TI Process in TM1 web then we dont have option to select file from our local machine.
That path has to be fixed for all. We do not have any common location for all users where they can upload their files & run the TI process.
Is there any way to achieve this. Please suggest
Thanks & Regards

aki秋

You made two comments there:

swati_phadtare wrote:That path has to be fixed for all

and

swati_phadtare wrote:We do not have any common location for all users where they can upload their files

They seem to contradict one another - I suggest you resolve that in your application design.

赏狗网

I suggest you resolve that in your application design.

Can you please suggest any idea for the same?
Thanks

fs111

I suggest you resolve that in your application design.
Can you please suggest any idea for the same?
Thanks

I think rmackenzie means you should create a common location for users to place their files in, in order to run the TI.

Alternatively, explore using a VBA macro to copy the file using a system account's credentials with access to the folder, and set the TI to run as a Chore on that particular folder.

itoto

You could also pass the full path and file name to the data file to the TI process as a parameter and update the data source of the TI process using the DataSourceNameForServer variable at run time. The only negative to this approach is that the process will bomb if the TM1 service does not have security access to the file that is passed.

sunnypure

Is there any way to upload files in TM1 from TM1 Web? We have 500 users which use Web & not perspective. How should they upload files in TM1?
Thanks & Regards

670648633

swati_phadtare wrote:Is there any way to upload files in TM1 from TM1 Web? We have 500 users which use Web & not perspective. How should they upload files in TM1?
Thanks & Regards

You've already been given a few pointers on how you could do this so asking more about a feature that doesn't exist isn't going to get you any further.  Out of the box you live with users specifying a UNC path and file name as a string and then clicking an action button to run a TI to load the file specified. (Note although this will certainly work validation of the file format and reporting of status of the load back to the end user is certainly going to be limited.)  If this isn't good a good enough solution then you could undertake a bit of custom development to add a button or menu to the standard TM1 Web toolbar to launch an external web application to ftp a nominated file, validate it, then use the api to load the data or launch a TI to do the load.  However, that's not a path I would recommend as the custom development will take time and money and make any future upgrade much more difficult.  What you could do is still have an external app do the ftp and validate the file format but just launch this via a hyperlink in a TM1 websheet.  That way you cut out the customization and have something that is almost as "integrated".   Or you simply have a 2 step process with some other interface of your choosing to handle the bulk file load requirement.

koko33777

lotsaram wrote: What you could do is still have an external app do the ftp and validate the file format but just launch this via a hyperlink in a TM1 websheet.  That way you cut out the customization and have something that is almost as "integrated".   Or you simply have a 2 step process with some other interface of your choosing to handle the bulk file load requirement.

lotsaram is right.  If you take a look at "Javascript File Browser" on google you will quickly find sample code that can be pasted into an html document that will allow an end user to browse for a file and then upload to a location you control.  We have tested this and works fine.

黄华民

lotsaram wrote: What you could do is still have an external app do the ftp and validate the file format but just launch this via a hyperlink in a TM1 websheet.

Good luck getting any IT department to OK that. You're effectively by-passing any Windows-based security when you do that. I don't know of a single IT department that's going to let you implement that. Why not just set up a share on the TM1 server, create an AD group that has READ and WRITE access to that share, and make the users a member of that group. Then they can just copy the file up with Windows Explorer.

jhh6yf

My guess would be that if you have 500 users, that doesn't mean 500 sites, so there is no need to store the files on their local machines. That would probably not be that secure, eg if someone loses their laptop. I would also guess that you don't have 500 individual files to upload. You mentioned high volume data. Presumably the low volume data, eg their plans are just being typed in?

I would guess that you probably only have a few sites. If so then assuming that there is a file server at each site, then set up an area where the large files must be placed, and map a network drive to each site's File Server on the TM1 Server.

If file access is not practical and validation etc is required, then the better approach would be to stage the data in your IT Depts preferred relational database, and then you only need one ODBC connection to that database from TM1.

I suggest that you have a word with your IT Dept to see what they would prefer. My guess would be that if you have high volumes of data, then it is either coming out of an IT system, or you have purchased it from outside? If the data files are extracts from IT Systems, then it might be easier to just go directly to that IT System.

Regards

Paul Simon