topic Re: Relative path syntax required to move file between environments in QlikView

Relative path syntax required to move file between environments

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

My folder structure is as follows: as in dev , Uat and prod

-> Root - Root folder

1 --> SourceDocuments - Dashboard names are listed a to z under thhis SourceDocuments folder as given below

1.1. ---> Dashboard Folder - Contains 4 sub folders as shown below for hosting the dashboard and its associated files

1.1.1 ---->Application - contains Qvws of dashboard hosted here

1.1.2 ---->Config - contains configuration files ( e.x database connectivity files )

1.1.3 ---->DataSources - Contains Source files loaded into the dashboard example excel , csv etc

1.1.4 ---->QVDs - Contains the QVd files both created and consumed by the dashboard are hosted here.

Q1) What I Require :- Require the relative path syntax for all DataSources files such as Excel, csv etc .That I can use in the application qvw. require relative path to connect to QVDs as well. I require the syntax for relative path so that when I move the actual qvw along with its associated data sources to another environment I should not have any issue connecting them again.

Basically - what is the Syntax for relative path to connect to excel csv and qvd based on above structure so that it will work on any env.

Re: Relative path syntax required to move file between environments

karthikoffi27se — Sat, 11 Nov 2017 08:10:46 GMT

Hi Trail,

There is no constant relative path for the documents. The path have to be created newly when we move any of the source documents. So we have to create a new relative path once the source is moved.

Many Thanks

Karthik

Re: Relative path syntax required to move file between environments

swuehl — Sat, 11 Nov 2017 13:03:36 GMT

Have a look at

Path (computing) - Wikipedia‌

For example an application in subfolder 1.1.1 may address a QVD in folder 1.1.4 like

LOAD Field

FROM [..\1.1.4\QVDFileName.qvd] (qvd);

i.e. go one level up in folder hierarchy, then enter subfolder 1.1.4, then open QVDFileName.qvd

Re: Relative path syntax required to move file between environments

Anonymous — Mon, 13 Nov 2017 03:17:56 GMT

Hi Stefan, will the path you mentioned work when I move my files to different environments. Please let me know. Regards

Re: Relative path syntax required to move file between environments

swuehl — Mon, 13 Nov 2017 09:02:45 GMT

It should work if you have understood the information provided above and adapted your paths accordingly.

Why not just try it?