creating the QVD using macro

[#1]

Hi all,

In my QVW file having an TableBox object, now i am creating QVD for this Tablebox object.

I am using below macro code, but when i am using the Created QVD in another QVW file then it is not file type as QVD instead of that it is displaying Delimited.

Why it is happening ?

sub ExportTablebox

set obj = ActiveDocument.GetSheetObject("TB13")

obj.export "C:\Users\admin\Desktop\SaveQuery\test1.qvd",","

msgbox("Exported Table")

end sub

Thanks in advance

Regards

Venkat

[danielrozental]

Try ExportEx

set obj = ActiveDocument.GetSheetObject("CH01")

obj.ExportEx "C:\test.qvd", 4      

[#3]

You can create a qvd with a macro but it will not be optimized (its really a comma delimited file). You will have to bring the file back in through the script and then save it through the script as a QVD, this will optimize it and a "real" QVD.

Stephen

[#4]

Hi sjcharles,

Thanks for your reply,

Actually i didn't got your point regarding QVD, pls can give me a little more clear explanation.

So that might be very useful to me.

Thanks in Advance

Regards

Venkat

[#5]

Hi sjcharles,

From the macro code itself can i make it a real QVD.

Instead of creating like comma delimited and then getting that qvd into script. After that making a real QVD is not a better process in my task.

How can i make it a Real QVD from Macro in the first attempt itself.

I hope so you understand my requirement.

Thanks in advance.

Regards

Venkat.

[kaushiknsolanki]

Hi,

    Let me Explain the whole process.

    The Export and ExportEx both are used to export the data.

    Now the difference is that Export command is used to export the data into delimited file, where as ExportEx is used to export data into HTML, Delimited, Image, QVD, Biff (i.e Excel).

    But now problem is that You can not use the ExportEx function for tablebox, it is used only for pivot and straight table. and Export Command can be used with all three of them i.e pivot, Table and Straight table.

    So Satish, in your case you are using Tablebox, thats why you are using Export and as i said it is used to export in delimited file, thus you can see it as comma seperated file. Meaning it is not in QVD format even though its has QVD as extension.

    Now if you want in a proper QVD file format you need to take this Delimited file into another QVW and then use the store command in script to generate  QVD out of it.

    I hope it is clear to you now.

Regards,

Kaushik Solanki 

[#7]

Hi Kaushik,

Your post explains a clear process regarding QVD. And it helps me a lot.

Can i ask you one more question regarding same concept...

What is the main difference between ExportEx and ServerSideExportEx ?

Thanks in Advance.

Regards

Venkat

[kaushiknsolanki]

Hi,

    I dont know the difference as i have never used ServerSideExportEx.

    I would suggest you to use it and see the changes.

    In general i think it should be used for exporting from browser.

Regards,

Kaushik Solanki

[kaushiknsolanki]

Hi,

   Actually you can use the ServerSideExportEx in your case as this command is valid for Tablebox.

  Try and let us know.

Regards,

Kaushik Solanki

[gainkarthi]

When i use option 4 or anything (1 to 5), i get that letter(4 or anything) in csv output. I dont want it and need to have space as delimiter. please help.

Thanks,

Karthi