but i try to export the results of bookmarks applied to the application. In fact i cycle through all bookmarks in the application and export the results to a csv to be processed further in another database.
Before exporting to csv i looped manually with vbscript macro through each row of the table and inserted via ODBC in the target database.
That worked in most cases but it was too slow (took around 2 hours per 1 million rows) and sometimes the odbc connection hang and qv simple didn't write anything in the database anymore. I get the error message on the Console Desktop : "Execution of Macro failed"
Would it be possible to extract data the other way round. From another application with qv-odbc driver to the qv application. Can i "apply Bookmarks" before i read from ODBC?
I understand... If you have to cycle through bookmarks, then your options are limited...
- I'm not sure if you can apply bookmarks before you read from ODBC... I haven't used QV-ODBC in a while, but I remember that earlier versions of it were not too robust.
- If the number of your bookmarks is limited and known upfront, try using Actions instead of Macros (if you are on ver. 9.00)
- Try to step back and find an alternative solution all together...
As an idea to consider, here is what you can try:
Write a macro that does the following:
1. Cycles through bookmarks. For each bookmark:
2. Save the document with an alternative name
3. Apply bookmark and Reduce data to possible values
4. initiate partial reload
5. In your load script, add a section conditioned by function IsPartialReload(), that stores the necessary tables into CSV files
6. Discard the temporary document and go back to the original
thanks for your great input.
i solved the problem slighlty modified using the following steps:
1. exported to excel instead of csv in the Macro. (This has no Export Memory Problems)
this however gives the next task, since QlikView writes only 65536 rows on one sheet and so puts multiple sheets in the excel output.
2. Put the number of Rows in the Excel Filename like "Filename_1234.xls"
3. Open the excel file with another QlikView File via a looped load that runs through all sheets.
4. store the generated table into csv file
process the csv file further and store into DB.