Page 1 of 1
import file from a specific network
Posted: Thu May 21, 2020 6:48 pm
by kalyan846
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
Re: import file from a specific network
Posted: Thu May 21, 2020 7:00 pm
by ascheevel
try replacing "\\data\s\" with "s:\"
Re: import file from a specific network
Posted: Fri May 22, 2020 8:38 am
by kalyan846
ascheevel wrote: ↑Thu May 21, 2020 7:00 pm
try replacing "\\data\s\" with "s:\"
No luck, its not working
Re: import file from a specific network
Posted: Fri May 22, 2020 9:36 am
by TJMurphy
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.
Re: import file from a specific network
Posted: Fri May 22, 2020 9:59 am
by kalyan846
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
Re: import file from a specific network
Posted: Fri May 22, 2020 10:16 am
by lotsaram
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.
Re: import file from a specific network
Posted: Fri May 22, 2020 11:19 am
by tomok
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