Export Qlikview Notes (Annotations) to Excel

[EladKushmaro]

Hi,

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

Thanks, Elad.

[rwunderlich · Accepted solution]

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

[EladKushmaro]

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.

[rwunderlich]

Yes, that is included in script I posted.

-Rob

[rwunderlich · Accepted solution]

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

[EladKushmaro]

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.