uploading a csv file into the TI process from an ftp site

[Gurumadheshwaran]

Hi,

My requirement is like this

I have to upload an csv file into the TI process from an ftp site

This ftp is located as a folder in the server of TM1

for eg,

if this is the ftp that i am using ftp://160.60.6.190, the files placed in here are stored in an path local to the server in the E drive

So when i browse in the TI Process, i could select my process as E:/ftp_Cognos/assumptions/assumptions.csv(ftp_Cognos is user name and pswd that we use to enter the ftp site)

As this folder is local to the server alone, it is running in the server alone and not in client machines

I also tried the path as ftp://160.60.6.190 (ip changed) , ip of the server , this is the site where the files are .

TM1 is throughin an error to use correct path conventions and recommending to use from an shared path(network neighbourhood) like //160.60.6.190/assumptions/assumptions.csv)

but it is required to use it from ftp site

so kindly help me to find a solution for this

[jim wood]

Why don't you just create a share for the folder and then you could you the unc path????

[tomok]

but it is required to use it from ftp site

There is no "FTP" solution because TM1 can not read from an FTP source. It has to either be 1) a text file, 2) an ODBC data source, or 3) an OLAP source. If the FTP site is actually on the same machine as TM1 and the path to the file you want is E:/ftp_Cognos/assumptions/assumptions.csv then you can put this path as the source in the TI process and it will work. The only caveat is that you will need to configure the TI process while running the TM1 client on that same machine because the "E" drive letter designation is not going to be valid on any other machine. The best answer is going to be to refer to the file by it's UNC path because that way it will be valid for configuration and running.

[Gurumadheshwaran]

Thanks for your reply about the issue