topic Re: QVW with Macros to publish excel report to Share point in QlikView

QVW with Macros to publish excel report to Share point

nandhuvji — Mon, 26 Jan 2026 18:19:17 GMT

Hello Everyone,

Task in QMC is keep on running w/o result.

Task will execute batch file, the batch file will run QVW which has Macros to publish report to Sharepoint.

Recently i have done changes to macros in QVW to update new sharepoint email. When tested it is working fine in DEV. The same QVW is not working in UAT and PROD.

Note - Still the DEV version is working fine.

Can you please help to fix this issue?

Thanks

Anand

Re: QVW with Macros to publish excel report to Share point

petter — Fri, 01 Nov 2019 22:05:17 GMT

It might very well be that the user account in UAT and PROD is not the same and thus does not have the same access rights for SharePoint. You should capture the output of your batch file and also check with your administrators about which user account the UAT and PROD is using and whether this has the same access to SharePoint.

Re: QVW with Macros to publish excel report to Share point

nandhuvji — Fri, 01 Nov 2019 22:10:28 GMT

There are Separate FID's for each environment. All the FID'S have same access to Mail server.

I think there should not be any issues with access.

Thanks

Anand

Re: QVW with Macros to publish excel report to Share point

nandhuvji — Mon, 04 Nov 2019 14:04:57 GMT

Can anyone please let me know what could be the issue here?

Re: QVW with Macros to publish excel report to Share point

nandhuvji — Wed, 06 Nov 2019 21:58:49 GMT

Batch script when executed manually (double click .bat file) on server is working fine. But when i execute the same batch file from QMC using external program , task is initiated and stuck/hung. In the log file i see the last step as executing the .bat file.

The issue is only if i execute the task from QMC. Will there be any macros restrictions when running as a service?

I am stuck with this issue since last week. Can any one please throw some light on this issue.?

Thanks

Anand

Re: QVW with Macros to publish excel report to Share point

marcus_sommer — Thu, 07 Nov 2019 14:10:06 GMT

It looked that there is any user-access and/or security-rights not correct set. Maybe you get a hint to the cause if you enables an output of the batch into a txt-file, like: https://www.windowscentral.com/how-save-command-output-file-using-command-prompt-or-powershell .

- Marcus

Re: QVW with Macros to publish excel report to Share point

nandhuvji — Thu, 07 Nov 2019 15:13:51 GMT

Batch file is not executing after i enable output to txt file. Throws message "Failed to open document". Below are the before and after commands. Please let me know if i am missing anything here.

Before:

command in batch file w/o out put - "C:\program files\qlikview\qv.exe" /vExportData=Yes "Export Daily by Country.qvw"

After:

Updated command to enable output - "C:\program files\qlikview\qv.exe" /vExportData=Yes "Export Daily by Country.qvw" > "c:\Develop\output.txt"

"C:\program files\qlikview\qv.exe" /vExportData=Yes "Export Daily by Country.qvw" > c:\Develop\output.txt

Re: QVW with Macros to publish excel report to Share point

marcus_sommer — Thu, 07 Nov 2019 16:40:19 GMT

I'm not really an expert in regard to track the execution of a batch-file - I just did it once or twice and know that's possible. Therefore I suggest you search for your type of batch in google to further examples - there might be various differences in the syntax (number and kind of spaces, quotes, number and kind of >, ...) if it's a cmd or a bat or another type and also how the commands are specified.

Another thing which I observed is that there is no path specified for the qvw - batches are sometime tricky in such things.

- Marcus

Re: QVW with Macros to publish excel report to Share point

Brett_Bleess — Thu, 07 Nov 2019 21:07:39 GMT

Just want to try to move this one forward, we found one part of the problem was the Desktop client was running as Personal Edition, so that was the main issue of the app not opening and that is now resolved.

The current issue is in the macro side of things, pretty sure things are launching, but I am not an expert in how to kick a message out of the VB code when things are running as a service, which is what is needed at this point to see where exactly things are getting hung up in the macro code.

The task does not end currently due to the 'Quit' statement in the macro code never being reached, that is what kills the QV.exe process and in turn ends the task properly in Publisher. If anyone has any ideas on how to throw out something like a msgbox message when things are running as a service, that would be most helpful at this point.

Regards,
Brett

Re: QVW with Macros to publish excel report to Share point

nandhuvji — Thu, 07 Nov 2019 21:20:07 GMT

service account running the task is having administrator access. Is there any local security policy need to be applied to service account?

Re: QVW with Macros to publish excel report to Share point

Brett_Bleess — Thu, 07 Nov 2019 21:25:50 GMT

Anand, the service account is a domain user account, correct? Just wanted to be sure it was not a local account on the server, pretty sure it is a domain account, but just wanted to be certain for everyone.

Regards,
Brett

Re: QVW with Macros to publish excel report to Share point

nandhuvji — Thu, 07 Nov 2019 21:40:21 GMT

Yes, it is domain user account

Re: QVW with Macros to publish excel report to Share point

nandhuvji — Thu, 07 Nov 2019 21:43:02 GMT

Additional details FYR:

QVW with macro working fine when executed thru batch file (External Program) from QMC (both in DEV and PROD).

In the Macros, we had share point email as 'XX'. Due to Share point migrated to latest version, we have updated share point email in the macros as 'YY'. This is the only update we have done in macros as part of the new share point migration.

After update in DEV, everything is working fine like reports are published to new Share point. But the same code when deployed in PROD, task in QMC is keep on running w/o result.

We have roll backed changes in PROD (by replacing email from YY to XX). Now reports are published to Old Share point when executed from QMC. I don't see any issue with Macros as the existing code with email XX is working fine. we need to make the reports to be published to New SP YY.

Note - DEV and PROD has the same code, same batch file, same tasks but it is working in DEV but not in PROD.

Thanks

Anand

Re: QVW with Macros to publish excel report to Share point

marcus_sommer — Fri, 08 Nov 2019 08:50:14 GMT

If it's worked with the old XX as target and not with the new YY it meant that the issue isn't related to the macro-stuff else to any security/rights topic and there might be just one entry in the group policies missing. In our company nearly everything is blocked per default and will be only permitted per white-listing - means each new IP, port, user, ... must be separate permitted.

- Marcus