Move sheets from one app to another by editing the AppObjects table

[RaulPardo]

Hi All!

Is it possible to "move" the sheets from one app to another app by editing the app_id field AppObjects table?

I have some apps that were corrupted (they cannot be exported or duplicated) due to an unexpected server restart.

I can get the load scripts from the log files, but I also need the sheets and visualizations. I can see the corrupted app's sheets on QMC and on the table. So my idea is to create new apps with the load script from the logs, and edit the sheets app field on the table to "move" the sheets from the corrupted app to the new app. Is that possible?

Thanks in advance.

[Anil_Babu_Samineni]

Did you contacted Qlik on this if you have partner. Because, they will have simplest solution (Just restart server corrupt the QVF - I won't think).

[RaulPardo]

Yes, we did. And there was no way for recovering the apps.

The server was not restarted in a "safe" way. The customer had a problem with the server and they pressed the power off button...

So, we'll need to re-create all apps one by one.

Is there any way to do what I suggested on the post?

[Anil_Babu_Samineni]

This sounds like a dangerours, Please help us how did you done restart/reboot for awareness as checklist 🙂

Seems like you don't have backup mechanism as well for your cluster if so, I don't have a way that how we can move all the sheets (I don't think that is possible).

@marcus_sommer have any enlight on this.

[marcus_sommer]

I haven't enough knowledge about the qvf file- and application-structure of Sense to say what's possible and then how to do it. But I have serious doubts that there is a simple way like copy and paste to recreate the sheets and objects within another application.

Thinkable is the attempt to read the xml meta-data per Qlik and/or to open the application with an editor to get access to the essential information about the sheets and objects. But extracting them in an importable or injectable way might be not impossible but would be probably extremely difficult (time consuming and requiring a lot of experiences).

I wouldn't try it else re-creating the applications from the scratch because it would be easier and faster and using it to implement a newer business-release by removing outdated parts and optimizing everything possible. Of course it need some efforts but by well-designed applications it shouldn't take too long.