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

[Emmanuelle__Bustos]

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?

[Levi_Turner]

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.

[Anonymous]

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]

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

[Emmanuelle__Bustos]

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?

[Anonymous · Accepted solution]

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]

Let me try this out and keep posting.

[simondachstr]

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]

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

[Emmanuelle__Bustos]

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!!!