How are you moving file from QV server to the SharePoint document library? Just a copy command over network path? Or you are calling SP webservices to store excel file?
You know you can always assign an email address to a document library and email excel file an an attachment. It will then extract the file from email and store it in the document library. You can also configure to use subject line to create a sub-directory and then store file in there. It's SP standard feature. Thought you would find it interesting!
I am using a macro from within QlikView to complete the export (OnPostReload event). I use Publisher to call a batch file that completes the reload with QlikView Developer since Publisher will not run the OnPostReload macro.
The export command works if I run the extract from within QlikView Developer, but will not work when I have Publisher run the reload. Thoughts?
P.S. - I'll give the email to SharePoint idea a try and see if that will work. Thanks!
Well, Publisher and Macros together cannot be trusted - as it is clearly documented in the documentation as well.
Why don't you call this batch file from QV script using "execute" command? Give it a try. Something like this: EXECUTE batchfile.bat;
You can always put all the copy commands, what you have in batch file, in your QV script itself by using EXECUTE CMD.EXE..... But there is a security restrictions copying files over UNC path. Please make sure to make adjustments in the server registry to work with UNC paths from command prompts. Here is the link for this adjustment details: http://support.microsoft.com/kb/156276
Hope this helps.