topic Re: Converting QVD files to CSV in QlikView

Converting QVD files to CSV

Rajesh_K — Sat, 16 Nov 2024 19:35:50 GMT

Hi,

I have a requirement to convert QVD files into spreadsheet format for our data feed downstream.

Requirement is, the qvd file is residing in a server location which is getting updated daily. We need to convert it into csv and put in our shared drive path.

I am able to open Qlikview 12 Personal edition application from my machine and run the 'STORE' command to convert the file into CSV. But we need to automate this script to run daily to fetch the file from the remote server and deploy it in our shared drive. Is there a way to schedule this script ? Please help. TIA.

Regards,

Rajesh

Re: Converting QVD files to CSV

jaibau1993 — Mon, 25 Nov 2019 07:58:50 GMT

Hi!

Create a .bat file and write the something similar to the following command

"C:\Program Files\QlikView\Qv.exe" /r "[Your qvw path]\[your file name].qvw"

This opens, reloads and closes the specified qlikview file. Then, you only have to create a scheduled task on "windows task scheduler" so the batch file is executed daily. This task must be configured by the user that owns that Personal Edition QV file (it is the only user that can open it with PE).

Regards,

Jaime.

Re: Converting QVD files to CSV

Rajesh_K — Mon, 25 Nov 2019 23:45:37 GMT

Thanks Jaime for your reply. I have created the .bat file. But i am facing the issue of "this qlikview document was created by another qlikview personal edition user" and forced to abort the opening. I am creating and saving the .qvw file in my desktop and opening again using Qlik View and it throws this error. I searched for solutions but it doesn't help. Could you please help on this. Not able to understand why it says as the document was created by another qlikview user.

Edition is : Qlikview for Windows Version 12.10.20600.0 SR8

It doesn't have any license keys currently.

TIA

Regards,

Rajesh

Re: Converting QVD files to CSV

srishsum2017 — Tue, 26 Nov 2019 03:38:03 GMT

After generating the csv file try below mentioned command-

EXECUTE cmd.exe /C copy "[Your generated csv path]\xyz.csv" "[Path where you want to move csv]\";

Re: Converting QVD files to CSV

Rajesh_K — Tue, 26 Nov 2019 04:31:06 GMT

Thanks Sumit. But did you come across with this .qvw file opening error i have mentioned above. The error pops up even when i try to open using Qlikview application or call the file through BAT file to open in Qlikview. TIA

Regards,

Rajesh

Re: Converting QVD files to CSV

srishsum2017 — Tue, 26 Nov 2019 05:41:56 GMT

Hi Rajesh,

Please go through the below mentioned url, i hope you will get your answer-

https://support.qlik.com/articles/000003188

Re: Converting QVD files to CSV

Brett_Bleess — Mon, 09 Dec 2019 16:28:27 GMT

Rajesh, do you have QVServer Reload Engine or Publisher? If so, you should be able to get one of the developers to setup the app for you to do things and then setup a task to run daily to create that... That will alleviate the personal edition issue you are encountering, but I was not sure what you have as far as product etc... If you got things sorted, please consider leaving details on what you ended up doing, and after you post it, you can use the Accept as Solution button on it to mark it as the solution too. If you have further questions, shout back.

Regards,
Brett