topic Re: QlikSense Problem with Folderconnection in App Development

QlikSense Problem with Folderconnection

jomamma1 — Sat, 16 Nov 2024 21:52:28 GMT

Hi - I'm having the darndest time with a folder connection.

I've connected the folder.

I'm trying to STORE the contents of a table into the *qvd file.

Everyone has write permissions to the folder behind the \\FolderConnection data connection.

Attached is a screen shot.

Connection Definition and Failure

Re: QlikSense Problem with Folderconnection

chriscammers — Fri, 16 Nov 2018 19:37:57 GMT

If you cannot rename it you do need to include the part in parenthesis after the name.

Usually the only way to remove that suffix it to remove it in the QMC

Re: QlikSense Problem with Folderconnection

dplr-rn — Fri, 16 Nov 2018 19:38:15 GMT

can you share the relevant part of the script?

Re: QlikSense Problem with Folderconnection

jomamma1 — Fri, 16 Nov 2018 19:40:58 GMT

this is all the script is doing ...

LIB CONNECT TO 'OneReporting_DB (uswin_v374914)';
ItamDeviceView:
SQL select top 10 * from itam_reporting.reporting.vw_itamdevice;
Store ItamDeviceView into 'lib://FolderConnection/ItamDeviceView.qvd'

Re: QlikSense Problem with Folderconnection

dplr-rn — Fri, 16 Nov 2018 19:43:13 GMT

Are you missing a ';'
in the picture on your original post i see a unquality below it

Re: QlikSense Problem with Folderconnection

chriscammers — Fri, 16 Nov 2018 19:44:56 GMT

Try this...

Store ItamDeviceView into [lib://FolderConnection(uswin_v374914)/ItamDeviceView.qvd](qvd)

There may be a space before the parenthesis but I'm not sure

Re: QlikSense Problem with Folderconnection

jomamma1 — Fri, 16 Nov 2018 19:45:08 GMT

Same error with the semi-colon ...

Re: QlikSense Problem with Folderconnection

dplr-rn — Fri, 16 Nov 2018 19:46:48 GMT

is this folder on your machine or network?

Re: QlikSense Problem with Folderconnection

jomamma1 — Fri, 16 Nov 2018 19:48:19 GMT

*FileConnector | Data load editor - Qlik Sense

The following error occurred:

Connection not found: FolderConnection(uswin_v374914)

The error occurred here:

Store ItamDeviceView into [lib://FolderConnection(uswin_v374914)/ItamDeviceView.qvd](qvd)

Data has not been loaded. Please correct the error and try loading again.

Re: QlikSense Problem with Folderconnection

jomamma1 — Fri, 16 Nov 2018 19:48:58 GMT

Local machine .. d: drive if that matters

Re: QlikSense Problem with Folderconnection

jomamma1 — Fri, 16 Nov 2018 19:53:14 GMT

Tried again pointing to c:\temp and getting the same error

Re: QlikSense Problem with Folderconnection

dplr-rn — Fri, 16 Nov 2018 19:53:24 GMT

Not sure why uswin_v374914 is coming next to the connection name.

i assume you tried deleting the folder and adding again with same name.

Re: QlikSense Problem with Folderconnection

jomamma1 — Fri, 16 Nov 2018 19:58:07 GMT

(uswin_v374914) - for some reason it's appending my userid.

Re: QlikSense Problem with Folderconnection

jomamma1 — Fri, 16 Nov 2018 20:43:24 GMT

Found it!

I had to go into the QMC

Take off the uswin_v374914 that was being appended to the FolderConnection name.

I'm not sure HOW it got appended there (other than uswin_v374914) is my user id - but what a nuisance.

Thanks for the help out there.

Re: QlikSense Problem with Folderconnection

chriscammers — Fri, 16 Nov 2018 20:47:52 GMT

Yep, that is what I was trying to say.

For whatever reason, if you create/edit a connection in the load editor it will appent your userid to the name of the connection. You are right it is super annoying. I usually go into the qmc right away and change the name before I use it.