Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
gordon_ash
Contributor III
Contributor III

Change Spaces for all QVD files

Hi folks,

I have to move all the QVDs from Spaces to the Shared space - I have seen various articles on REST calls, powershell scripts to make API calls - I implemented in Postman a simple to get a list of spaces and although it kind of works it couldn't get all of the spaces we have. I have checked the spaces one by one for permissions and the account I use has all of the permissions available so I don't believe that is the issue - is there a bug in the API or more probably am I calling it incorrectly?

In postman I use the bearer token, newly created in case that is the issue, then the URl is 

https://XXXXX.qlikcloud.com/api/v1/spaces/

The resulting JSON  only pulls 10 spaces but I have 30 - is there something else I need to do to get the full list?

Thanks

 

Labels (2)
1 Solution

Accepted Solutions
Kayleigh_Milewski
Contributor III
Contributor III

Here's a simple script to move qvds one at a time. You could modify it to loop through all tables in a space.

 

//Change variable to name of data file you are moving
LET vTable = 'QVDName';

[$(vTable)]:
//Change file path to OLD location you are retrieving the data file from
LOAD
*
FROM [lib://OldSpaceName:DataFiles/$(vTable).qvd]
(qvd);

//Change file path to NEW location you are storing the data file
STORE [$(vTable)] INTO [lib://NewSpaceName:DataFiles/$(vTable).qvd];

You will have to delete the qvds from the old space. 

View solution in original post

4 Replies
saif_khan
Contributor
Contributor

I have faced the same issue while getting app list in PowerShell using Qlik-cli. The solution I found was to append --limit [number] at the end of the command. I put a large number so it doesn't miss any app. 

For example, you can write a following command to get list of apps:

qlik app ls --limit 20

fmarvnnt
Partner - Creator III
Partner - Creator III

Why don't you Load QVD then Store on a different space?  https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegularS... .

Maybe I'm too simply,

 

😉

FMa

 

Kayleigh_Milewski
Contributor III
Contributor III

Here's a simple script to move qvds one at a time. You could modify it to loop through all tables in a space.

 

//Change variable to name of data file you are moving
LET vTable = 'QVDName';

[$(vTable)]:
//Change file path to OLD location you are retrieving the data file from
LOAD
*
FROM [lib://OldSpaceName:DataFiles/$(vTable).qvd]
(qvd);

//Change file path to NEW location you are storing the data file
STORE [$(vTable)] INTO [lib://NewSpaceName:DataFiles/$(vTable).qvd];

You will have to delete the qvds from the old space. 

gordon_ash
Contributor III
Contributor III
Author

This is great to know , I never thought to append an explicit limit, I will give this a go when I get the chance.

Thanks Very much for sharing.