Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Read QVD file whith PHP

is posible read qvd file, with php?

Tags (2)
11 Replies
gandalfgray
Valued Contributor

SV:Read QVD file whith PHP

Short answer:

No.

Not applicable

SV:Read QVD file whith PHP

Smiley Sad $#%/#$&

vgutkovsky
Honored Contributor II

SV:Read QVD file whith PHP

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

Re. :Re: SV:Read QVD file whith PHP

Sir VLAD, you said PROBABLY.

Does this mean that you have not tried it yet?

Thanks

vgutkovsky
Honored Contributor II

Re. :Re: SV:Read QVD file whith PHP

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

Not applicable

Re. :Re: SV:Read QVD file whith PHP

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
Valued Contributor

SV:Re: Re. :Re: SV:Read QVD file whith 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');

Not applicable

Read QVD file whith PHP

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
Contributor

Re: Read QVD file whith PHP

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

Community Browser