Relative path syntax required to move file between environments

[Anonymous]

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.

[karthikoffi27se]

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 

[swuehl]

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

[Anonymous]

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

[swuehl]

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

Why not just try it?