Last week I came across an interesting requirement to move an app from one server to another, including community sheets.
Is it really possible? I was hoping that it is so I looked for a solution.
Yes, you can do it. It’s straightforward, copy app binary, rename it and change the file extension to .qvf and import it in another environment.
Great! will it keep the sheet published status, approved status and owner info as is?
I have a bad news for you.
No, all the community sheets will become base sheets and the person migrating the app will become the owner of all the app objects, sheets, bookmarks, and stories.
I have tried searching through Qlik community and Qlik knowledge base, and have not found an easy solution for this problem. The best answer I found is to change the published and approved status and object ownership manually. For the smaller app, it is ok to apply changes manually, but for bigger apps with more sheets and objects, it’s complicated.
Enter my effort to come up with a solution to address this major issue that I am sure all of you are facing at work.
I spent a weekend and created node CLI app to migrate the Qlik Sense app from one environment to another including community sheets and its published, approved and ownership metadata.
Let’s see it in action.
Considering the fact that it is a tall order to migrate a Qlik Sense application with community sheets with original ownership from one environment to another, and that there is no solution available to address this business conundrum, I hope you will find it helpful.
Please feel free to download and share your feedback so that we can make it better in future releases.