topic Re: Export Qlikview Notes (Annotations) to Excel in QlikView

Export Qlikview Notes (Annotations) to Excel

EladKushmaro — Thu, 18 May 2023 12:11:00 GMT

Hi,

Is it possible to export all QV notes (annotations) to Excel for documentation purposes?

Thanks, Elad.

Re: Export Qlikview Notes (Annotations) to Excel

rwunderlich — Thu, 18 May 2023 16:31:07 GMT

In the past I have loaded the Annotations from the server using Qlik script and the QvsAdminDataProvider.dll connector. You should find QvsAdminDataProvider.dll in the "Database" dropdown in the script editor.

Attached is a script I created several years ago to load Annotations and other server objects. I don't currently have a QV Server environment to test with, so I can't validate if it still works.

Good luck!

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

Re: Export Qlikview Notes (Annotations) to Excel

EladKushmaro — Tue, 23 May 2023 12:44:00 GMT

Thank you for your generosity!

My interest is in exporting the content of the annotation (the text that the user wrote), Is it possible?

Thanks, Elad.

Re: Export Qlikview Notes (Annotations) to Excel

rwunderlich — Fri, 26 May 2023 00:20:22 GMT

Yes, that is included in script I posted.

-Rob

Re: Export Qlikview Notes (Annotations) to Excel

rwunderlich — Mon, 29 May 2023 23:56:20 GMT

A correction to my earlier post. It's the "QvServerObjectConnector" that loads the annotations, not the QvsAdminDataProvider.dll connector. I think QvServerObjectConnector was part of QV Power tools. According to this matrix the connector is not available for QV12 https://community.qlik.com/t5/QlikView-Documents/Power-Tools-for-QlikView-One-stop-shop/ta-p/1493451

-Rob

Re: Export Qlikview Notes (Annotations) to Excel

EladKushmaro — Sun, 11 Jun 2023 12:27:06 GMT

Thank you Rob! now I understand why it didn't work for me.

I will try to see if something changed with the availability of the connector.

Elad.