Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Emmanuelle-Bustos
Valued Contributor

Export an App with other users sheets on it. Qlik Sense

Is it possible to export an App or duplicate it having any of the user's previously created sheets on it so we can republish it after some changes but maintaining all those users Sheets?

Tags (3)
1 Solution

Accepted Solutions
vishal_ezops
Contributor

Re: Export an App with other users sheets on it. Qlik Sense

Here you go :

  • Open the folder: "C:\Program Files\Qlik\Sense\Repository\PostgreSQL\9.3\bin" and run PgAdmin III.exe tool.
  • Add Connection to the Server
    • Host - localhost, port- 4432 (default), DB - postgres, username - postgres
  • Now you can find AppObjects table (Table you want to update) by Double-click of Server, then QSR  Schemas  Tables  AppObjects.
  • Click on Execute arbitrary SQL Query where you can check data of AppObjects Table and then can update the value of Approved column to true for the required sheets of the App accordingly.
  • Run the query.

Hope this will help

9 Replies
Employee
Employee

Re: Export an App with other users sheets on it. Qlik Sense

The duplicate function will achieve this, though be sure to test.

Unfortunately there is no way to move from the server version (user created sheets only accessible to the user (unpublished) or in the community but not in the original sheets outside of the server then back again. Once you go outside of the server by say copying the binary from C:\ProgramData\Qlik\Sense\Apps to Desktop, all sheets (user created or otherwise) will be combined with the original sheets and the value-add of sheets displayed to a single individual will go away.

vishal_ezops
Contributor

Re: Export an App with other users sheets on it. Qlik Sense

You can duplicate the app. But export doesn't pick the sheets which are not approved. What you can do is, update the database and mark those objects to approved, export the objects and update them back to not approved.

You can use the below query :

Update "AppObjects" set "Approved" = true where "App_ID"=your-app-id

Thanks

-Vishal

Emmanuelle-Bustos
Valued Contributor

Re: Export an App with other users sheets on it. Qlik Sense

I've already tried duplicate and export but the users sheets (Not Approved) are not exported.

Emmanuelle-Bustos
Valued Contributor

Re: Export an App with other users sheets on it. Qlik Sense

I imagined something like that when I saw the Status Field (Not Approved) for the users sheets, but this means modify the Postgre database right? I'm not very skilled with that, may you be a little more specific doing this changes?

vishal_ezops
Contributor

Re: Export an App with other users sheets on it. Qlik Sense

Here you go :

  • Open the folder: "C:\Program Files\Qlik\Sense\Repository\PostgreSQL\9.3\bin" and run PgAdmin III.exe tool.
  • Add Connection to the Server
    • Host - localhost, port- 4432 (default), DB - postgres, username - postgres
  • Now you can find AppObjects table (Table you want to update) by Double-click of Server, then QSR  Schemas  Tables  AppObjects.
  • Click on Execute arbitrary SQL Query where you can check data of AppObjects Table and then can update the value of Approved column to true for the required sheets of the App accordingly.
  • Run the query.

Hope this will help

Emmanuelle-Bustos
Valued Contributor

Re: Export an App with other users sheets on it. Qlik Sense

Let me try this out and keep posting.

simondachstr
Valued Contributor III

Re: Export an App with other users sheets on it. Qlik Sense

Modifying the Postgre database will not necessary work for a multi-node environment where sync'ing of apps between nodes is required.

A different way to achieve what you are trying to do is to copy the physical file of the app from the server directory and re-import it.

Emmanuelle-Bustos
Valued Contributor

Re: Export an App with other users sheets on it. Qlik Sense

Hi, that was the first option but it doesn't work.

Emmanuelle-Bustos
Valued Contributor

Re: Export an App with other users sheets on it. Qlik Sense

Hi, I already tried and It Works! But it is necessary to run 2 querys to work one for Approved and one for Published:

If I only run:

Update "AppObjects" set "Approved" = true where "App_ID"=your-app-id

the export doesn't work.

So I had to run:

Update "AppObjects" set "Approved" = true where "ID"='b12dfc5b-2994-4155-8a95-e9be74a0e72c' and "ModifiedByUserName"='username';

Update "AppObjects" set "Published" = true where "ID"='b12dfc5b-2994-4155-8a95-e9be74a0e72c' and "ModifiedByUserName"=username';

and so the sheet is Published on the hub for all users just as a part of the original App, and when I export the app the user's sheet is carried along all app sheets.

*Note: I changed the query field "App_ID" to "ID" because using "App_ID" can affect more than one sheet so better use "ID" corresponding to the particular sheet.

Thank you so much for your help!!!