Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

Creator
Creator

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

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

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?

Creator
Creator

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

Let me try this out and keep posting.

Luminary
Luminary

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.

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

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