topic Document Name in the script (version 8.2) in QlikView

Document Name in the script (version 8.2)

patricio — Fri, 11 Sep 2009 02:00:53 GMT

I need to obtain the document name in the script.

I am using version 8.20.5415.2 in my computer and version 8.20.5402.2 in the Server.

I have an application that uses the DocumentName() function to obtain the name of the document and it worked fine in my computer.

When I published the application on the server the script didn't recognize the DocumentName() function when loading the application. So I need to find another way to obtain the name.

I read everything I found on the blog.

- The system variable QVWorkPath is not good because it is loaded only at the end of the script. (First load can give a wrong document name)

- Writing a function that returns the document name by using Function GETNAME() GETNAME = ActiveDocument.Name End Function hangs when running from the script. I am not an expert in Macros, I pick these lines from the forum.

- If I use ActiveDocument.GetProperties.FileName I obtain no value.

The last 2 are giving the path name if is use msgbox(ActiveDocument.Name) or msgbox(ActiveDocument.GetProperties.FileName) when testing the macro.

Someone can share any idea on how to obtain this name?

Thank you

Document Name in the script (version 8.2)

Fri, 11 Sep 2009 03:21:18 GMT

I'm not sure if you need this in a script or macro, but I'm almost sure you need this in a script.

if that's the case FileName() should do the trick.

Document Name in the script (version 8.2)

patricio — Fri, 11 Sep 2009 19:22:07 GMT

Hi dragonauta. FileName() does not give me the document name. In the qv help I found for filename() the following definition that is not what I am looking for "Returns a string containing the name of the table file currently being read, without path but including the extension".

What I need is the document name and not a table or file that is used in the document. Thank you anyway.

Document Name in the script (version 8.2)

Fri, 11 Sep 2009 19:37:51 GMT

Hi,

I had a similar issue.

The only possibility I found is to call a macro and the filename (if you need it all the time you could call the macro with the OnOpen trigger.

dim strFilePath Dim strFileName strFilePath = ActiveDocument.GetProperties.FileName strFileName = (InStrRev(strFilePath,"\",len(strFilePath))) strFileName = Mid(strFilePath, InStrRev(strFilePath,"\") + 1)

Please have a look at the attached example.

Best regards

Stefan

Document Name in the script (version 8.2)

Fri, 11 Sep 2009 20:37:37 GMT

Is anybody out there having a better solution / a solution without using macros?

Best regards

Stefan

Document Name in the script (version 8.2)

patricio — Fri, 11 Sep 2009 20:52:52 GMT

Thank you Stefan,

Are you able to obtain that value from your qlikview script. If yes, could you please send me some tips on how to call that macro from the script?

Document Name in the script (version 8.2)

Fri, 11 Sep 2009 21:06:10 GMT

Hmm,

oh, I've overseen that you need it from loadscript.

Have a look at the attached example; this does not work; I think that's because the "Application" object in macro is not initialized while load-script.

Sorry for not having better news ...

Best regards

Steafn

Document Name in the script (version 8.2)

Fri, 11 Sep 2009 21:07:07 GMT

sorry, forget to mention:

Have a look into the load-script of my updated example ...

Best regards

Stefan

AW:Document Name in the script (version 8.2)

rbecher — Fri, 11 Sep 2009 22:23:32 GMT

Patricio,

have you tried DocumentName()? This is my example:

LET vDocName = DocumentName();

DocInfo:
LOAD 'Document Name' as Property
, '$(vDocName)' as Value
autogenerate(1);

This works on QV9, try this on QV8.2.

- Ralf

AW:Document Name in the script (version 8.2)

patricio — Fri, 11 Sep 2009 22:33:50 GMT

Thank you Ralph,

Yes I have tried it. This is the origin of my problem. DocumentName() worked on my computer but it didn't work when I published on the server. I am looking for something different so I can publish on the server with the same functionality. Please see first post for details.

AW:Re: AW:Document Name in the script (version 8.2)

rbecher — Fri, 11 Sep 2009 22:41:19 GMT

I have no idea, you should ask QT support. Maybe this is a bug.

Document Name in the script (version 8.2)

MichaelRobertshaw — Mon, 14 Sep 2009 00:30:58 GMT

As QV v9.00 has been available for some time, and v8.50 is now very mature (SR5) I wonder what impediments you have to upgrading from v8.20 to at least v8.50sr5 where we know that DocumentName() is available and works.

Regards,
MichaelR