Is it possible to distribute a QVW as a binary?

[Anonymous]

We have a user which want's to reload QVW's with an extra XLS by himself.

Since we don't want our users to reload and change scripts by themselves we are looking for a way of distributing the original QVW with only the binary data.

Is it possible to distribute an exisiting QVW (containing load scripts)as a QVW with only binary data?

Or is the only way to create a new QVW (which we don't want) and load the original QVW as binary data ...

thx in advance!

Anita

[kaushiknsolanki]

Hi,

   There is a way.

   Save the same Qvw file with some other name.

   Go to Script, Delete All Script. and type.

   Binary ;   //Give the path of the Original Document which have Script.

   Reload the Document.

   Now you will see that the document have same thing as the original file.

   Now even if user tried to reload he will not be able to do so, cause he will not have the file specified in the path.

Regards,

Kaushik Solanki

[Anonymous]

This is exactly what we don't want ... this is extra maintenance.

We are looking for a way we can do this with the original report ...

[Miguel_Angel_Baeyens]

Hi,

You can create a section access and put all the script within the hidden script. They will be able to access the documents and see the tables (and that makes sense) but if you tweak the security preferences, no users will be able to edit script or print or anything you have not allowed them to.

Is not binary, since everything is there (script, data, objects) but users cannot get to it.

Is that what you are looking for?

MIguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

[kaushiknsolanki]

HI,

    I agree with Miguel.

    There is another way.

    You can copy all your scripts in a txt file.

    and then include this txt file in your qvw file.

    You can add this txt file with the help of Include Statement in scipt.

    It looks like this.

     $(Include=d:\text.txt)

Regards,

Kaushik Solanki

[Anonymous]

This is a lot of extra work ... only thing we want is to distribute our original QVW to a special user directory.

In this directory the user is allowed to add extra XLS to the QVW ... but is not allowed to edit the script.

This special user directory is disconnected from the original data (QVD's) ...

Is there a way the user is able to add the XLS and reload only the XLS into the QVW, without trying to reload the whole data area ...

[kaushiknsolanki]

Hi,

   You can use Partial Repload for that purpose.

Regards,

Kaushik Solanki 

[Anonymous]

The situation is that the user works locally and wants a local Excel file added (only for personal use!) temporary.

This person can not reload the data from the server and is also no allowed to do so ...

Partial reload is in this case not something of use I guesse? The report itself should reload totally on the server (Full Reload) ... this report should be distributed to our special user. This user wants to have the possibility to add Excels locally ...

rgrds,

Anita

[Miguel_Angel_Baeyens]

Hello Anita,

If you know beforehand the structure of the columns and data the excel will have, you can prepare the script with a simple conditional so if the file is in the directory, the script loads it renaming the fields to fit into the data model and so. But this means the user will always use the same XLS structure for his files.

I don't see any other good option rather than let the user create an empty document with the excel files, and then incorporate the script to the main document. But you cannot (at least I don't see how) let the user "edit the script" (to add his excel files) but not "edit the script" (modifying the already existing code), rather than putting all your existing code in the hidden part, so the user is unable to modify it, but he do is able to add new code (loading new files) to the existing model.

The hidden script will load with no need of section access or any other settings in the server.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica