Page 1 of 1
TI Process to pull data from an ftp site
Posted: Thu Nov 04, 2010 3:31 pm
by Joni
On a daily basis we upload figures from an ftp site into TM1. To achieve this, I login to the ftp site, download the relevant file into a location accessible by the TM1 server, and then run a process to pull the data from this file into TM1. Is it possible to create a process that can go directly to the ftp site and just pull in the latest file?
Re: TI Process to pull data from an ftp site
Posted: Thu Nov 04, 2010 3:36 pm
by tomok
Joni wrote:On a daily basis we upload figures from an ftp site into TM1. To achieve this, I login to the ftp site, download the relevant file into a location accessible by the TM1 server, and then run a process to pull the data from this file into TM1. Is it possible to create a process that can go directly to the ftp site and just pull in the latest file?
Not directly but if you can encapsulate your FTP tasks into a batch file or executable program (with VB.net or similar) you can call that from a TI process using the ExecuteCommand function. There are numerous posts in the forum about using this function, just do a search for it.