Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Emmanuelle__Bustos
Partner - Specialist
Partner - Specialist

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?

1 Solution

Accepted Solutions
Anonymous
Not applicable

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

View solution in original post

11 Replies
Levi_Turner
Employee
Employee

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
Not applicable

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
Partner - Specialist
Partner - Specialist
Author

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

Emmanuelle__Bustos
Partner - Specialist
Partner - Specialist
Author

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
Not applicable

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
Partner - Specialist
Partner - Specialist
Author

Let me try this out and keep posting.

simondachstr
Luminary Alumni
Luminary Alumni

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
Partner - Specialist
Partner - Specialist
Author

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

Emmanuelle__Bustos
Partner - Specialist
Partner - Specialist
Author

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