topic Re: Path of Lib in Connectivity & Data Prep

Path of Lib

TimB — Thu, 23 Dec 2021 15:15:54 GMT

Hello community,

is it possible to locate the path of a libary? I need the libraries combined with system paths.

My goal is to read the system paths from a logfile in which libraries are used.

Re: Path of Lib

Gysbert_Wassenaar — Mon, 20 May 2019 08:45:08 GMT

Can you tell me what you mean with the path of a library? Is that the path of a folder connection definition? Or are you talking about file paths to code libraries like javascript files or dll files?

You can find the paths of folder connections if you edit the connections. You can also find them in the Data connections section of the QMC in the Connection string property of a data connection.

Re: Path of Lib

TimB — Mon, 20 May 2019 11:04:02 GMT

For example:

creat the lib „testconnection“ to the path c:\
load Data with the lib

Data:

LOAD *

FROM [lib://Testconnection/Data.txt] (txt, codepage is 28591, no labels, delimiter is ',', msq);

Now I need a way to transform the "lib://Testconnection" into c:\ without having to look into library manually.

For only this short example it is not an expense but if there are many libraries it is too much effort to look manual. I'm searching for a way to transform all existing libaries into the path of the system (c:\...).

Re: Path of Lib

Gysbert_Wassenaar — Mon, 20 May 2019 11:34:58 GMT

You can query the repository database. The DataConnections table is stored in the public schema in the QSR database in the Postgresql instance your Qlik Sense installation uses.

SELECT D."Name", D."Connectionstring" FROM public."DataConnections" D
WHERE D."Type" = 'folder'