topic Re. :Multiple authors in QlikView

Multiple authors

Thu, 11 Feb 2010 11:44:11 GMT

QV8.50

We are fortunate to have 2 developers and 6 professionals. We are all running one QVD. On occasion, we have had clashes of author, i.e. two or more people trying to change and save a single document.

Does anyone know of a way we can alert users, in the way Excel does for example, when someone else has a file open?

Re. :Multiple authors

fseregaza — Thu, 11 Feb 2010 12:35:50 GMT

Hi Russell,

I have an idea to resolve your problem. You should use (in your script) a DOS command to create a temporary file you will use as an "occupation flag". Then, you will only have to test if the file exists or not before making your modifications.

The script will be something like that:

SET TFile = QVTemp.txt; // Store there the name of your temporary file

// Set a variable indicating if the QVD exists or not
IF FileSize('$(TFile)') > 0 THEN
// What you do if already in use
ELSE
EXECUTE cmd /c echo 'In use' > QVTemp.txt;
// What you do if free
EXECUTE cmd /c del QVTemp.txt;
END IF

Does it answer your question ?

Best regards,

Franck SEREGAZA

Business & Decision

Re. :Multiple authors

Thu, 11 Feb 2010 12:43:43 GMT

Thanks Franck, I love the simplicity of your idea, and I am sure it will work.

Would you know how to record the active user's ID in the qvtemp.txt file? I was thinking this could then be displayed as an alert when opening the document.

Regards

Russell

Re. :Re: Re. :Multiple authors

fseregaza — Thu, 11 Feb 2010 13:49:23 GMT

Depending on what you want, you can use 2 QV functions:

QVUser(): return the login of the QV user (interesting only when you use a security for opening your application).
OSUser(): return the OS user which opened the application (you should use this one).

I hope it will fit you.

Best regards,

Franck SEREGAZA

Business & Decision