import file from a specific network

Post Reply
kalyan846
Posts: 6
Joined: Fri Mar 06, 2020 4:48 pm
OLAP Product: Cognos TM1
Version: 10.2
Excel Version: office 365

import file from a specific network

Post by kalyan846 » Thu May 21, 2020 6:48 pm

Hi all,
i have a Ti process, in that we are taking data source as .Csv file
Recently we have moved into cloud and we have migrated everything into cloud and in here
the file in shared location which has user name and password
when i am trying to browse the file what i need to keep in
The processing is failing saying this, it is unable to pick the file from the source
I have even tried like
Data source name :- \\data\s\prod\Source files\Facilities \Facilities Allocation.US.csv
Data source name on server :- .\Facilities Allocation.US.csv

But no luck can you please help me out
Attachments
issue 2.PNG
data source names and path and error
issue 2.PNG (160.42 KiB) Viewed 135 times
issue 1.PNG
file where it is placed
issue 1.PNG (42.18 KiB) Viewed 135 times

ascheevel
Community Contributor
Posts: 146
Joined: Fri Feb 15, 2013 5:49 pm
OLAP Product: TM1
Version: PA 2.0.8
Excel Version: 2016
Location: Minneapolis, USA

Re: import file from a specific network

Post by ascheevel » Thu May 21, 2020 7:00 pm

try replacing "\\data\s\" with "s:\"

kalyan846
Posts: 6
Joined: Fri Mar 06, 2020 4:48 pm
OLAP Product: Cognos TM1
Version: 10.2
Excel Version: office 365

Re: import file from a specific network

Post by kalyan846 » Fri May 22, 2020 8:38 am

ascheevel wrote:
Thu May 21, 2020 7:00 pm
try replacing "\\data\s\" with "s:\"
No luck, its not working

TJMurphy
Posts: 71
Joined: Mon May 12, 2008 12:25 pm
OLAP Product: TM1
Version: PA 2.0.6 Local
Excel Version: Excel 2016

Re: import file from a specific network

Post by TJMurphy » Fri May 22, 2020 9:36 am

We've just been through this at our place.

So, for what it's worth, we ended up having to qualify the network names more completely.

For example, \\server\fileshare\folder needed to become \\server.some.domain.stuff\fileshare\folder

Not sure if it was unique to our setups but the reason explained to us was because the server was on a different domain we needed to give it a fully qualified name. Works fine now.

kalyan846
Posts: 6
Joined: Fri Mar 06, 2020 4:48 pm
OLAP Product: Cognos TM1
Version: 10.2
Excel Version: office 365

Re: import file from a specific network

Post by kalyan846 » Fri May 22, 2020 9:59 am

Yes, when i enter the server name, it pops up for windows securities like user name and password
i have those with me but how can i implement it
for example :- when i am taking that server name and entering into file explorer it pops up for windows securities
user name and password

can you please let me know where can i pass those user id and password

lotsaram
MVP
Posts: 3386
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: import file from a specific network

Post by lotsaram » Fri May 22, 2020 10:16 am

kalyan846 wrote:
Fri May 22, 2020 9:59 am
Yes, when i enter the server name, it pops up for windows securities like user name and password
i have those with me but how can i implement it
for example :- when i am taking that server name and entering into file explorer it pops up for windows securities
user name and password

can you please let me know where can i pass those user id and password
This seems just like the normal or classic case of making sure that the service account which runs the TM1 server instance
- is not the buiilt-in "local admin" account
- has network access
- specifically has read access to the folder containing the source file

The preview window is populated by DatasourceNameForClient which in turn depends on the access rights of the user openign the TI process editor. This is different from DatasourceNameForServer which is accessed at runtime by the service account.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.

tomok
MVP
Posts: 2724
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: import file from a specific network

Post by tomok » Fri May 22, 2020 11:19 am

kalyan846 wrote:
Thu May 21, 2020 6:48 pm
Hi all,
i have a Ti process, in that we are taking data source as .Csv file
Recently we have moved into cloud and we have migrated everything into cloud and in here
the file in shared location which has user name and password
when i am trying to browse the file what i need to keep in
The processing is failing saying this, it is unable to pick the file from the source
I have even tried like
Data source name :- \\data\s\prod\Source files\Facilities \Facilities Allocation.US.csv
Data source name on server :- .\Facilities Allocation.US.csv

But no luck can you please help me out
I assume you are talking about the IBM Cloud, correct? Based on your screen shot here are your settings:

Data Source Name:

Code: Select all

\\data\s\prod\SourceFiles\Facilities\Facilities Allocation US.csv
Data Source Name On Server:

Code: Select all

s:\prod\SourceFiles\Facilities\Facilities Allocation US.csv
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/

Post Reply