How to transfer an app with its bookmarks from an environment to another

Sonja_Bauernfeind · Aug 24, 2023 7:00:44 AM

When exporting and importing an application from one environment (ex: DEV) to another (ex : PROD), only the Public bookmarks are exported.

Scenario:

A is an Administrator user
B is a consumer user
In a published application, B has personal bookmarks created
If user A exports the application in QMC, then B's bookmarks will not be exported

The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.

Modification to the Qlik Sense Repository database are done at your own risk. Prior to making changes, backup the database in case of a rollback being necessary. Qlik Support will require the system to be restored to the previous state, should an issue occur after modifications were done.

Option 1:

Find and re-import the App's binary file (an App .qvf file without the file extension ".qvf" in its name) stored in the Qlik Sense share. This file will contain all the bookmarks including the Community and Personal bookmarks. However, there will not be any indication of ownership for them and the administrator that re-imported the App will be the new owner of all bookmarks. Once the app is re-published all bookmarks will become Public Bookmarks, so there should be discretion in determining which ones should be published.
For information on finding the binary files see How to find App ID of application in QlikSense Server

Note: The file needs to be renamed to include the .qvf extension prior to importing.

Option 2:

Install pgadmin 4 and connect it to the QSR database (See Installing and Configuring PGAdmin 4 to access the PostgreSQL database used by Qlik Sense or NPrinti...)
In the DEV QMC, open the App view and on the top right column selector, add the ID column; now you have the ID of your app (see How to find App ID of application in QlikSense Server)
In Pgadmin, once you're connected to the QSR database, open the Tool > QueryTool

Run this command (adapt it)

SELECT * FROM public."AppObjects" 
where "App_ID"='9abc7e1b-b797-4752-8e83-f6b3c987b1f2' 
AND "ObjectType"='bookmark';

You can see the column Owner_ID with ID of the owner

Return to the Qlik Sense Management Console > Users
With the column selector, add the ID column; and find the ID of the owner of the app. It should match with the ID located in pgadmin.

We now change the owner of an appObject bookmark in Pgadmin:

UPDATE public."AppObjects" 
set "Owner_ID"='<your new ID>' 
where "App_ID"='9abc7e1b-b797-4752-8e83-f6b3c987b1f2' 
AND "ObjectType"='bookmark';

This changes the owner of all bookmarks in this app to a specific user.

Export from TEST; import into PROD
Verify that you have all the bookmarks
In PROD install pgadmin and do the same kind of modification.

How to transfer an app with its bookmarks from an environment to another