TI Process to pull data from an ftp site
-
- Posts: 5
- Joined: Mon Oct 11, 2010 7:11 pm
- OLAP Product: TM1
- Version: 9.1 9.4 9.5
- Excel Version: Excel 2003
TI Process to pull data from an ftp site
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?
-
- MVP
- Posts: 2832
- 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: TI Process to pull data from an ftp site
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.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?