Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlikview subversion data reload issue.

Hi,

Today I tried to move my dashboard over SVN, I have installed Silk SVN and Tortoise Diff and given following parameters:

/base:%base /mine:%mine /theirs:%theirs /merged:%merged

So when I added my dashboard.qvw to SVN then qlikview created all the chart and other necessory XML's in folder dashboard-prj and moved it to SVN. Which I verified by going to that reporsitory online.

Now when using another system user when I tried to check out that dashboard from subversion then qlikview created respective qvw and XML files at mentioned location. When I opened dashboard.qvw then it seems it haven't loaded data. So I placed data file in the folder and tried to reload data but then following error occurred.

Error.png

When I compared both the load scripts then original document and this checked out document was having same load script. Later I found that after checking out from svn values for all the variables set to empty, which is causing this error. As can be seen below.

Variables.png

Can anybody advise a solution for this?

5 Replies
hopkinsc
Partner - Specialist III
Partner - Specialist III

there is a problem with SVN and variables. When SVN removes all data, it also removes variable values.

We got around this by storing all of our variables in an excel file and loaded in the excel file in the script.

That way the variables are recreated on every reload.

We also found the same issue with field triggers. SVN removes all fields which also means that any triggers and number format set on the field itself are also lost.

We have not found a solution to losing field triggers. obviously number formats can be set in the script.

Hope that helps.

Not applicable
Author

Hi ,

Thanks for the reply , I already have moved variables to load script which resolved this issue , In my case field triggers are working fine, now I have one problem remaining , I have a dashboard where 2 sheets run in 2 different states and a field in all 3 states have single select behaviour when this dashboard is retrieved from SVN then this single select functionality goes away, Whereas any single select filter of "inherited" state remains fine. It seems to me a issue with handling of states over SVN. Can you suggest some solution or workaround for this?

Gysbert Wassenaar I really appreciate your knowlege base of qlikview... can you suggest a solution?

Not applicable
Author

Is there a specific reason that Qlikview "forgets" them?

If not: is there a bug-report for it?

We're starting/testing to use SVN and have many reports, so quite some work to get triggers / variables external to the document...


Hope to get your response

Not applicable
Author

Well what I got is when committing to SVN , Qlikview only commits document design with each item's properties in separate xml file and couple of global xml files. So what it does not transfer is the data and as variable often store meta data so it does not transfer its values. So as a solution I have moved variables from variable overview to load script and whenever I do fresh check out, I perform a reload so that variable can retain their values. Hope this helps.

Not applicable
Author

If you have problems running version control and QlikView you can maybe find help in QVScriptor that handle .prj files a smarter way alongside with .qvw and automatically.

have a look here

QVScriptor SmartCompare