How to add an user in Power Tools qv-user-manager

[g_westaway]

In the new QV Power Tools, qv-user-manager, I can list CAL & DMS users nicely, I can also see these options exist:

  -a, --add=CAL|DMS          Add users or assign CALs [CAL|DMS]
  -r, --remove=CAL|DMS       Remove specified users or inactive CALs [CAL|DMS]

Can someone please indicate the syntax with example for these, i.e. how to specify the value to be added / assigned?

[g_westaway]

Hi, any clues from Power Tools experts would be most appreciated. Nothing I have tried seems to work. As the API has changed significantly since 8.5, we are struggling to migrate our DMS update tool in time for a release.

[g_westaway]

My colleague Gaurav found this:

Make a text file with a list of users to add or delete, one on each line, e.g. user.txt:
j_bloggs
x_men

In the command prompt or bat file run something like this:

D:\QlikView\Support Tools\Tools\qv-user-manager\qv-user-manager.exe --add dms --document DMS_test.qvw < user.txt

Substitute the path, document name and text file as appropriate.

It picks up the file referenced and returns the number processed (it allows for existing entries, so no duplicates / errors).

There may be another way to run this but this approach works for us.

[haggroth]

Hi Giles,

I've experimented with DMS and CAL assignment using qv-user-manager in QV10, and it works pretty well. In my example i load users from a file, and assign a cals and dms by executing qv-user-manager directly from the script.

In the example below, the usernames are piped to qv-user-manager instead of being read from a txt file. Adding CALs is similar (just use "--add cal" instead).

EXECUTE cmd.exe /C (ECHO domain\user1 && ECHO domain\user2 && ECHO domain\user3) | "C:\DMSPop\qv-user-manager" --add dms --document "docname.qvw"

[peter_turner]

Hello,

I have a quick question on the powertool:

How can i import cal data back into the QV Server?

When you run the example command "qv-user-manager.exe --list cal > cals.csv" you get a csv file listing the named CALs and Doc CALs, which is great.

I'd like to import that file back into the server (i.e disaster recovery), is there a quicker way to import this data again?

[haggroth]

Hi Peter,

if you check the readme file of qv-user-manager, you will see lots of helpful examples. See "Examples for populating DMS users". The syntax is the same for populating CALs, you just need to replace "--add dms" with "--add cal".

If you have several documents with doc CALs, you probably need to run the "--add cal" command separately for each document.