topic Re: Macro Not Working in Access point in QlikView

Macro Not Working in Access point

Fri, 04 Apr 2014 21:38:18 GMT

Hi,

I have created a sample dashboard for uploading files through qlikview application. When I try to upload the files from my qlikview desktop Macros are running fine and I am able to copy the file to the specified destination . After publishing, when I try to use the same functionality the macros are not executing on click of the buttons.

My code looks like this:

Created two buttons: 1) Choose File and 2) Upload File

On click of these buttons I am running the below macros:

Sub ChooseFile

Set objDialog = CreateObject("UserAccounts.CommonDialog")

If Not IsEmpty(objDialog) Then

objDialog.Filter = "QVW Files|*.*"

objDialog.InitialDir = "C:\"

intResult = objDialog.ShowOpen

If intResult = -1 Then

ActiveDocument.GetVariable("vFileName").SetContent objDialog.FileName, True

End If

End Sub

sub CopyFile

SourceFile = ActiveDocument.GetVariable("vFileName").GetContent.String

Set fso = CreateObject("Scripting.FileSystemObject")

fso.CopyFile SourceFile, "C:\Nagendra\Work\Right-Size\temp\", True

ActiveDocument.GetVariable("vFileName").SetContent "", True

End If

Set fso = Nothing

End sub

In server security settings both safe/unsafe macro option is enabled.

Any suggestions or help on this issue is highly appreciated

Thanks,

Nagendra

Re: Macro Not Working in Access point

whiteline — Sat, 05 Apr 2014 17:53:28 GMT

Hi.

Does the CopyFile work when the vFileName is set properly ?

Re: Macro Not Working in Access point

Sun, 06 Apr 2014 02:39:37 GMT

Hi I haven't test that seperately on the access point..but when I try it from my desktop version it is working fine.

Even if doesn't work I will connect to the destination ftp server and then place the file using put command.

Any workaround for the file browsing option.

Re: Macro Not Working in Access point

whiteline — Sun, 06 Apr 2014 07:21:15 GMT

I've asked about file copy to ensure that everything works fine and the problem is with dialog.

Re: Macro Not Working in Access point

Sun, 06 Apr 2014 07:28:34 GMT

I have tested it in my local machine it works fine. As of now the problem is with dialog box.

Re: Macro Not Working in Access point

Anonymous — Sun, 06 Apr 2014 12:20:15 GMT

What is the client? These macros can work only in IE Plugin.

Next, what do you see on Ctrl+Shift+M? It must be system access.

Re: Macro Not Working in Access point

vikasmahajan — Mon, 07 Apr 2014 06:47:00 GMT

Macros will not work in Access Point.

Vikas

Re: Macro Not Working in Access point

jerrysvensson — Mon, 07 Apr 2014 06:52:05 GMT

Are you using Plugin or WebView (Ajax)?

Re: Macro Not Working in Access point

Mon, 07 Apr 2014 16:44:27 GMT

Michaeal,

I tested the dashboard in both chrome and IE using plugin. In both the cases this doesn't work. Can you suggest some way to provide users for choosing file to upload.

And Module security is System Level.

Re: Macro Not Working in Access point

Mon, 07 Apr 2014 16:44:58 GMT

Jerry, I have tested using both the clients.

Re: Macro Not Working in Access point

Mon, 07 Apr 2014 16:46:12 GMT

Vikas,

In that case is there any work around so that the user can upload the documents from the dashboard.

Re: Macro Not Working in Access point

Anonymous — Mon, 07 Apr 2014 16:49:45 GMT

If you mean user download - yes. It is in QMC - User Documents, Availability. Same place where you define othe access methods (IE plugin, mobile, etc.)

Re: Macro Not Working in Access point

Mon, 07 Apr 2014 17:33:42 GMT

Michael,

I want to provide users a provision to upload files from the system where they run this dashboard.

Do you have any suggestions or pointers on this.