export user bookmarks and reports

[krisdaels]

in an existing on premise qlik sense server with eternal license (serialnumber/key) the license was replaced by a signed license (long story - human error).

to return to the original eternal license, the only solution is a complete reinstallation of the system.

We manage to export the apps and import them in the newly installed system, but the user generated content is not available (bookmarks, reports).

Is there a way to export these user items and import them again in the new server?

if necessary, we can query the database tables directly.

[anderseriksson]

I imagine you could export those from the old repository database and import into the new server.
But GUIDs for applications will have changed since you did export/import of those instead of merging the repository to the new server.
Merging the repository would have included the licensing thus I understand why you did that.
You did not have a backup of the old server prior to the license change that you could use and then update the existing apps from the other server?

[krisdaels]

at this moment, the old server is still running. We did a test export/import to our own test/development server, so nothing final has happened yet. We plan to do the reinstallation next week. 

Any suggestions on exporting/importing the user data would be welcome!

[anderseriksson]

Never done it thus can't make much suggestions.
Should be possible to find it in the repository but as I said the key connecting it with applications are GUIDs and as you have exported/imported to move the apps to the new server their GUIDs have changed.
Minimum you would need to change the application GUID when importing on the new server.
And doing things directly in the repository database of course is unsupported by Qlik!

[Anil_Babu_Samineni]

@krisdaels  In my opinion As soon as the AppID is changed from one server to another (Though you have physical Cluster root folder backup). The boomarks still be there in from Server 1. 

So, please tell us how did you restore the site?

[krisdaels]

we did not yet restore the the site.

We created in a separate network a domain with the same netbios name as the customers network, and installed a fresh installation of our development/test server on a new server.

We created a few domain users with the same usernames as in the original network, and gave them a license on the new server.

We then exported the apps from the customers server and imported them into the new server. The apps were fine, but the user generated content (bookmarks ...) were not available.

we found an article on how to retrieve the apps with the user content included.

How to backup / migrate / move / re-import communi... - Qlik Community - 1717908

The only problem then is that all user content is then linked to the admin user importing the app, and not to the user that created the content. This would probably allow us to restore the user  content (including cleaning up unnecessary items)