Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Distribution task removes script from QVW

Hi

We have two different QV physical servers:

1. Publisher - for loading models and distribution

2. QVS - for user documents - (via Open in Server and Access Point)

We are using distribution tasks to copy our QVW files from the Publisher server to the QVS server.

However, we noticed that if we open a QVW which was distributed - it's script will be totally removed and the 'Load' option in the document properties security tab will be disabled.

Is there any way to avoid this?

thanks

Yaniv

1 Solution

Accepted Solutions
peter_turner
Partner - Specialist
Partner - Specialist

Hello Yaniv,

This is a feature of Publisher as the distribution task will be making the QVW available to your user group, and in most cases you wouldn't really want them looking at your script.

I cannot check for sure, but you might be able to just perform a reload task?, and get the publisher server to save the QVW into another folder with a new name instead of performing a 'distribution' on it.

Of cause this wouldn't allow you to use the loop and reduce features of publisher, but may get to the result your after.

View solution in original post

9 Replies
peter_turner
Partner - Specialist
Partner - Specialist

Hello Yaniv,

This is a feature of Publisher as the distribution task will be making the QVW available to your user group, and in most cases you wouldn't really want them looking at your script.

I cannot check for sure, but you might be able to just perform a reload task?, and get the publisher server to save the QVW into another folder with a new name instead of performing a 'distribution' on it.

Of cause this wouldn't allow you to use the loop and reduce features of publisher, but may get to the result your after.

Bill_Britt
Former Employee
Former Employee

HI,

There is no way to make it save the script, even if you distribute to a folder. You could do a reload of the document and then write a .bat file to move it from the source document folder to the new location. Also, all of this can be done within publisher by creating a supporting task.

Bill

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
greg-anderson
Luminary Alumni
Luminary Alumni

This is something we're seeing also, as new users of Qlikview.  We actually lost a couple of pretty complex scripts before we figured out what was happening.

Problem is, we cannot reload the data (or load new data) onto a QVW that's been put in the access point.  This should be an automated function.  I'm looking into Publisher now for answers.

Anonymous
Not applicable
Author

Greg

I am using Publisher successfully without losing scripts, in a nutshell here is what I do:

  • Develop QVW in Dev folder
  • Copy it to the Apps.Source folder, which is defined in the QMS as a Source Folder
  • Publisher Task reloads from Apps.Source and distributes into the Apps.User folder which is defined as a Mounted Folder

So Dev & Apps.Source have script.

And Apps.User does not, which is what we want.

Would that work for you ?

If not then which bit trips you up ?

Best Regards,     Bill

Not applicable
Author

Hi,

If you set the source and distribution folder set to be the same destination will you get this behavior as the distributed copy (that never has a script) of the document will overwrite the source.

Starting from v11.20 SR4 you will get a warning if you set up a task where the source and distribution folder are the same to prevent tasks to run and overwrite the source document.

greg-anderson
Luminary Alumni
Luminary Alumni

No, we definitely have the source and user folders set to different destinations.  It's not overwriting the original folder, although we did have some admins who were overwriting source files with 'updated' versions (front end changes) based on QVWs from the user folder, thus no script.  I've taken care of that.

My problem is that one of our distributed documents is losing data and returning empty charts and other errors from the Access point.  I'm going to post that as a separate question.

Thanks.

evan_kurowski
Specialist
Specialist

Hello Bill,


I am interested in confirming the premise the script is always removed from distribution copies (copies as the end product of a reload task).

We have tasks set up in which the Source folder is also mounted published folder.


In the task, the 'Distribute:Distribute to Folder' path is left blank

When the task reloads, the .QVW log shows a valid reload, but the script is still present, and is the only known copy of the .QVW.

When we adjust the task to direct the distribution copy to a location not re-pointing to itself, a second distribution copy is created and the script is removed.


When we explicity re-point the distribution copy back to itself, we get the warning message, and the reload removes the script.

So it is in cases where the 'Distribute:Distribute to Folder' path is left blank, that the task is performing a Reload, skipping the creation of a distribtion copy.  Then the reloaded source copy is all that remains in the AccessPoint. (because the Source Copy folder has been mounted to Access Point)

Is this possible?

Peter_Cammaert
Partner - Champion III
Partner - Champion III

Yes, but about every other setting belonging to the distriubtion will not be made. If you don't distribute, you will not get access permissions set to anything else than what the file already had, you will not be able to grant creation of server objects to some users, you will not be able to set client preferences,... In short you will not set any meta data that controls properties and access rights of your published document.

Making Source and User folders point to the same location is strongly discouraged. But disabling distribution simply switches off various nice automation techniques in Publisher.

For some analogies, see here: Distribute to Folder vs Distribute to Server

Best,

Peter

evan_kurowski
Specialist
Specialist

Hello Peter,

Thanks for the response, this is exactly the kind of details I was hoping to confirm, such as what features and attributes are unavailable when not using distribution documents.  Thanks very much!