topic export qvd from API in QlikView

export qvd from API

Mon, 26 Oct 2009 14:25:52 GMT

in a sub (API) I write this code to export data from a object .
The data is a qvd extension.:

set vi = ActiveDocument.GetSheetObject("CH01")
vi.Export "AA.qvd" , ";"

now if i check this qvd I found a new column (unaspected) .
The column contains a xml forma like this:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
...
But this column is not request. Pleas I need to export data from Api in qvd format.
Is it correct tu use this code:
set vi = ActiveDocument.GetSheetObject("CH01")
vi.Export "AA.qvd" , ";"

Many thanks
Slash

export qvd from API

Anonymous — Mon, 26 Oct 2009 14:49:53 GMT

Hi Slash,

I'm not quite sure I understand what you mean. The data in QVD files is stored in XML format.

If you only want a flat file with the data from the object you could try exporting to a text file or csv perhaps?

export qvd from API

Mon, 26 Oct 2009 16:07:19 GMT

Hi,
I need to store from API. I suppose is not possible and I try to export
in q AA.qvd

this file contains the column of the object (see exapmles i posted) and Qv
add one column in a XML format. This is a problem
In this example I export 1 row (column a and column b).
the esport in API build a xml and repetions of fields something like this:

------------------------------------------------------------------------------
column a | column b | <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
------------------------------------------------------------------------------
100 | 100 |descriptiongelwellkkl250†›01/01/2009<QvdTableHeader><QvBuildNo>6206</-10-26 ...

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

100 | 100 |</Fields>
------------------------------------------------------------------------------
.......

export qvd from API

mongolu — Mon, 26 Oct 2009 16:09:17 GMT

try ExportEx instead.

set obj = ActiveDocument.GetSheetObject("CH01")
obj.ExportEx "C:\test.qvd", 4

4 = qvd fileformat

export qvd from API

Mon, 26 Oct 2009 18:08:04 GMT

Export will only work for csv's, txt-files etc....these exports will usually be encoded by Ansi or UTF-8.

You should have a look the ExportEx function in the API guide.

set obj = ActiveDocument.GetSheetObject("CH01")
obj.ExportEx "C:\test.qvd", 4

Export format
0 = HTML
1 = Text delimited
2 = bitmap image
3 = XML
4 = QVD
5 = BIFF (Excel)

/Martin