Uploading data with PAW/PAX

[20 Ton Squirrel]

I have a script that generates a CSV file on a quarterly basis. This file needs to be uploaded and digested by TM1... hopefully by the end-user, not me. I want to develop the system and leave the analysts to do their work.

I devised a TI process in PAW that uploaded the file to the server and digested it properly. This was exciting but there are two issues:

• I want to prompt the user for the file to upload (not a deal breaker if I just need to output the file to a static location/name)
• My company is only licensing PAW for developers... meaning, no analysts could use this process

Can PAX execute the same sort of procedure to upload data?

Everything I've searched out thus far says nope, but I'm a newb-nugget on TM1. Any ideas?

[Steve Rowe]

On the license side, you can point an action button at the TI process and the user can access this from within Excel or TM1 Web. No PAW license required for this.

You could put your TI process in a chore with some added code that checks for the existence of the file and then runs the load at the end of the load the TI can move the file to another location (and so the chore stops loading the file on the next pass). No need to involve the users at all then.

Cheers,

[20 Ton Squirrel]

Thanks for the response, Steve! It is good to know that a process CAN do this sort of thing from Excel.

I should've mentioned the other complication: the TM1 server is isolated from the company network. The folk in networking are stingy about security so only another developer and I have a login to access it. It's like flying to the moon to develop on this thing. :T

I was told I might be able to get a login just for transferring files up to the server. Seems like that would be the way to go:

1. The user executes a process that transfers the file from local to server (using special login credentials)
2. Have either:
   • A chore monitors the directory and consume file
   • The same process used to transfer proceeds to consume file

Seems like the latter option would be best.

I just gotta convince the dark & hungry network gawds to afford me a special login. Too bad all this working from home prevents strolling into the server room with bribery-flavored donuts. ;D