Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Read QVD file whith PHP

is posible read qvd file, with php?

12 Replies
gandalfgray
Specialist II
Specialist II

Short answer:

No.

Not applicable
Author

😞 $#%/#$&

vgutkovsky
Master II
Master II

It's true that this is not possible with QVDs, but take a look at the new QVX format available in v10, you should be able to read it with outside applications (and probably with PHP).

Regards,

Not applicable
Author

Sir VLAD, you said PROBABLY.

Does this mean that you have not tried it yet?

Thanks

vgutkovsky
Master II
Master II

That's correct, I haven't tried it myself yet 🙂

Not applicable
Author

Ok, Ok.

this VBScript solved this problem

---------------------------------------------------------------------------------------------------------------------------

rem ** ActualFolder **
Set ActualFolder = CreateObject("Scripting.FileSystemObject")

rem ** Create Object **
set Qv = CreateObject("QlikTech.QlikView")
set ActiveDocument = Qv.CreateDoc

ActiveDocument.ClearAll false
set Doc = ActiveDocument.Getproperties

rem ** Create Export Script **
Doc.Script = Doc.Script & "Export: REPLACE LOAD * FROM xxxxxx.qvd (qvd); STORE ExportINTO xxxxxx.tab (txt, delimiter is '\t'); DROP TABLE Export;"
ActiveDocument.SetProperties Doc

rem ** Save As **
ActiveDocument.SaveAs ActualFolder.GetParentFolderName(wscript.ScriptFullName) & "\export.qvw"

rem ** Run Script **
ActiveDocument.Reload
ActiveDocument.CloseDoc
Qv.Quit

rem ** Delete QVW **
ActualFolder.deletefile ActualFolder.GetParentFolderName(wscript.ScriptFullName) & "\export.qvw"

---------------------------------------------------------------------------------------------------------------------------

Netx, import xxxxxx.tab file on PHP.

Surprise

gandalfgray
Specialist II
Specialist II

You could also do it in the load script, I would have done it that way.

Export:

LOAD * FROM xxxxxx.qvd (qvd);

STORE Export

INTO xxxxxx.tab (txt, delimiter is '\t');

Not applicable
Author

It is possible to read QVX files from Python. PHP should be about the same

http://community.qlik.com/media/p/149203.aspx

-Alex

www.snowflakejoins.com

etl_tools
Creator
Creator

Why do you want to read it with PHP?

Even if you find the sultion it will use a lot of memory and eventually it will fail

Much better option would be to conver qvd's into something else

BTW You can now use Advanced ETL Processor (AETL) to load QVD files into the database

http://www.etl-tools.com/articles/datawarehousing/loading-qvd-files-into-the-database.html

AETL works wih 27 datasources and 22 data targers.

Mike