Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
is posible read qvd file, with php?
Short answer:
No.
😞 $#%/#$&
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,
Sir VLAD, you said PROBABLY.
Does this mean that you have not tried it yet?
Thanks
That's correct, I haven't tried it myself yet 🙂
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.
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');
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
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