topic Re: Document Analyzer V2 -- a major update in QlikView

Document Analyzer V2 -- a major update

rwunderlich — Mon, 09 Jun 2014 04:21:34 GMT

I've posted a major update "V2" to the Document Analyzer tool. It is available for download in the Tools section of QlikviewCookbook.com here Document Analyzer.

The primary function of Document Analyzer remains to identify unused fields that can be removed from your model. It has been expanded to assist in identifying slow charts.

There are a number of improvements over the 1.15 version, including bug fixes, a new UI, object calc times and improved analysis of variable and expression usage.

An important change is that only qvws that have been saved in QV10SR2 or later may be analyzed with this version. If you need to analyze an older document, save it first in QV10.

if a prj directory exists, it will be leveraged for the analysis. This can speed up the analysis run for documents with a lot of objects.

Use this thread if you have comments or questions. Enjoy.

-Rob

Re: Document Analyzer V2 -- a major update

whiteline — Mon, 09 Jun 2014 06:21:21 GMT

Hi.

I need Unicode names in the memory statistics, so in V1.15 I have changed the load codepage to utf8.

Could you help me with Unicode support in V2 ?

Re: Document Analyzer V2 -- a major update

rwunderlich — Mon, 09 Jun 2014 15:48:06 GMT

whiteline

Do you get a unicode mem file when you have unicode chars in your field names?

-Rob

Re: Re: Document Analyzer V2 -- a major update

whiteline — Mon, 09 Jun 2014 17:21:11 GMT

Yes. Have attached two samples.

Depending on the presence of unicode characters mem file is stored as ANSI or UTF-8.

Re: Document Analyzer V2 -- a major update

rwunderlich — Mon, 09 Jun 2014 17:46:33 GMT

Thanks for the samples. As you did, I've changed the script to utf8 and it seems to work equally well for unicode and codepage 1252. This change will be included in the next version. Go ahead and change your copy in the meantime.

Thanks,

Rob

Re: Document Analyzer V2 -- a major update

whiteline — Mon, 09 Jun 2014 18:19:12 GMT

Thanks Rob.

Ah. =)))

Now I see. I didn't see the tabs with scripts, except the last one, until I pressed << button.

So I decided that the app was completely rebuild.

Re: Document Analyzer V2 -- a major update

rwunderlich — Sat, 28 Jun 2014 21:44:19 GMT

I've posted an update V2.1 to Document Analyzer. This fixes an errors that will happen when a property such as Object Caption contains unprintable characters.

Re: Document Analyzer V2 -- a major update

m_woolf — Mon, 04 Aug 2014 18:36:26 GMT

Rob,

Am I correct in noting that the document analyzer doesn't detect hidden sheets?

I realize that I could do CTRL+SHIFT+S and save the document with no sheets hidden and then analyze it, but I was thinking about batch processing a bunch of documents to get info about objects and their show expressions.

Re: Document Analyzer V2 -- a major update

rwunderlich — Wed, 06 Aug 2014 15:11:11 GMT

It's true that DocAnalyzer does not detect hidden sheets. Unhiding the sheets prior to analysis is currently the only workaround.

-Rob

Re: Document Analyzer V2 -- a major update

Tue, 12 Aug 2014 10:19:43 GMT

Rob,

Thanks a lot for your Document, it is very good.

Mik.

Re: Document Analyzer V2 -- a major update

Anonymous — Wed, 29 Oct 2014 11:04:12 GMT

Hi,

I downloaded the document, I selected the qvw sheet to analyze it, but when I click on the "Open the QVW" button an error occours: "ActiveX component can't create the object: 'Scripting.FileSystemObject'"

Where am i wrong?

(I use the QV10 SR6 license).

Thks.

Re: Document Analyzer V2 -- a major update

rwunderlich — Wed, 29 Oct 2014 11:12:53 GMT

It sounds like you have not granted "Allow all macros" in the security dialog.

1. Open the module editor (Ctrl-m)

2. Set "Current Local Security" to "Allow System Access".

Further, it sounds like you may be using an older version or misunderstanding the usage? The "open qvw" button u should not throw the type of error you are describing.

1. Are you using Doc Analyzer V2.1? (Look at the change log sheet for version).

2. What happens when you press the "Extract Metadata" button? Does the extraction complete or throw an error?

-Rob

Re: Document Analyzer V2 -- a major update

Anonymous — Wed, 29 Oct 2014 13:04:59 GMT

Right, it was only a security access problem, as u suppose.

I'm using the right versione (2.1) and it works properly.

Thank you very much for the support and for the sheet 🙂

Re: Document Analyzer V2 -- a major update

rwunderlich — Mon, 17 Nov 2014 12:16:30 GMT

I've posted an update V2.2 to Document Analyzer. This version adds:

- Added Labels from Chart Expressions.

- Added Object Actions.

- Now extracting Chart Dimension conditional expressions. The [Expression Location] is "ChartDimensionDataDef.EnableCondition".

- Now extracting Chart Expression conditional expressions. The [Expression Location] is "Data.EnableCondition".

You can download it here:

Search Recipes | Qlikview Cookbook

-Rob

Re: Document Analyzer V2 -- a major update

Anonymous — Tue, 18 Nov 2014 10:30:28 GMT

Thank you very much and compliments for your job 🙂

Re: Document Analyzer V2 -- a major update

cedriclupo — Mon, 12 Jan 2015 09:36:55 GMT

Hello Rob and thank you for your app, it was useful

However, since few weeks I have a problem, I try to extract and it opens the macro window, when i close it, the document I was analyzing is opened.

The settings for macro is "allow system access" and always allowed.

It used to work until we upgraded to sr9, i'm not sure it's related.

Thanks a lot.

Cedric

Re: Document Analyzer V2 -- a major update

rwunderlich — Mon, 12 Jan 2015 18:43:25 GMT

Hi Cedric,

It sounds like something is failing in the module. Here is how you can identify for me exactly where it's failing.

1. Open the Module (Ctl-M)

2. Click "ProcessDocument" in the left-hand pane.

3. Click the Test button. The macro will run but stop on error and post an error message on top. Let me know what the error is and what line it stopped on.

-Rob

Re: Document Analyzer V2 -- a major update

Fri, 30 Jan 2015 22:53:33 GMT

Hey Rob, I tested it and it errors out on line 497 "log "writing ObjectInfo for " & obj.GetObjectId"

The error says Object required: 'obj'

Re: Document Analyzer V2 -- a major update

sujeetsingh — Sat, 31 Jan 2015 04:04:03 GMT

First of All thank you Rob you have designed an awesome thing which is a best tool for any Qlikview developer.

Re: Document Analyzer V2 -- a major update

rwunderlich — Sat, 31 Jan 2015 23:54:54 GMT

Hi Daron,

I'll need to know what kind of object it was processing when it failed. Can you look at the Document Analyzer log

C:\Users\yourname\AppData\Local\Temp\DocumentAnalyzer.log

and post the last 15 lines or so here?

-Rob