Shared File Conversion and Cleaning in Batch

[Chris_Rice]

Qlikview .SHARED files can be converted or cleaned using the Qlik Cleanup Tool.

Environment:

QlikView 

For background information on Shared file cleaning, see:

Cleaning and converting the shared files
Shared Files - Verification and Cleaning
How to convert between different QlikView shared file formats

To carry this out in batch processes:

1. Copy all shared files as well as the qvs.exe into one folder.
2. In Powershell, navigate to that folder.
3. To Clean and Convert the Tshared files:
   

   $FileList=$test=Get-ChildItem “C:\Users\cre\Documents\Temp” | Where-Object {$_.Extension -eq ".Tshared"}
   ForEach ($i in $FileList.Name)
   {
   $i
   .\QVS.exe -x $i -p -f orig -l ./
   }​

4. To just clean the shared files, run the following command:
   

   $FileList=$test=Get-ChildItem “C:\Users\cre\Documents\Temp” | Where-Object {$_.Extension -eq ".shared"}
   ForEach ($i in $FileList.Name)
   {
   $i
   .\QVS.exe -x $i -p -l ./
   }

5. To just clean the Tshared files, run the following command:
   

   $FileList=$test=Get-ChildItem “C:\Users\cre\Documents\Temp” | Where-Object {$_.Extension -eq ".Tshared"}
   ForEach ($i in $FileList.Name)
   {
   $i
   .\QVS.exe -x $i -p -l ./
   }​