how to use external files into dasboads

[krishna789]

how use external files into dasboards ( connection string, usernmae and password etc )

[Anil_Babu_Samineni]

May be Binary Load / You could create one txt file for String and remaining. Then call txt file by help of Must_Include(Path/Filename.txt)

[Anonymous]

What type of external files are you having issues loading?

[vijetas42]

you can use include command like, $(include=\\path of the folder\file_name.extension)

[avinashelite]

Your trying load the data from QVS ? or txt

check this

Importing text files containing scripts?

[krishna789]

hello ,avinash i am loading data through  from sql and i want to hide path so, i am saving path in qvs . while accessing qvs files again path is showing can i hide the path.

[avinashelite]

In the load script its showing up ? Yes it will including the path in QVS won't hide path from logs or load script

only option for this is to use the hidden script option

Go to Edit Script> File > Create Hidden script >

add the SQL connection part which you don't want to show

NOTE: If you forget the Hidden script password then you cannot be recover . So make a note of the password

Hope this helps you

[krishna789]

hi thanks  i got it ..

[krishna789]

actually my doubt is while connecting to my sql i will get

OLEDB CONNECT32 TO [Provider=SQLOLEDB.1;Persist Security Info=True;User ID=krg;Initial Catalog=Pro;Data Source=SAT;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=SATI;Use Encryption for Data=False;Tag with column collation when possible=False] (XPassword is BHCOeZFOMbD); here we can see user id,which system it belong to everthing we can see..so want to load data but it shoukld hide...so before that save your 'OLEDB in notpad and through qlikview by <insert>include statement>browser will select the text file  then you can see that OLEDB FILES IN NOTEPAD is load in this formate  ' $(Include=kri.txt);' here we can see no details of server ,we can access  this file.

but thanks for your try...

[avinashelite]

Got your question ..I think once your connected to that source ...you could remove the RIGHT hand side info I guess

just keep

OLEDB CONNECT32 TO connection_name

this will work