<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Problem with the export when i run the qvw from a batch file in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/Problem-with-the-export-when-i-run-the-qvw-from-a-batch-file/m-p/767018#M669096</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hello.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I have created a qvw that exports a jpg file with a vbscript module when i reload the qvw by trigger on postReload.&lt;/P&gt;&lt;P&gt;This is the script&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Sub ExportFiles&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;set corp = ActiveDocument.GetSheetObject("CH10")&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;corp.ExportBitmapToFile "C:\TEST\Sales.jpg"&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;End sub &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;When i reload it manually it works and the file exports.&lt;/P&gt;&lt;P&gt;When i run a batch file that reloads the qvw does not work.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;The batch file contains the commands below.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;@ECHO OFF&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;"C:\Program Files\QlikView\Qv.exe"&amp;nbsp; /r C:\TEST\SALES.qvw&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I have to mention that when i export the file in xls with the command in vbscript below the batch file works and the file exports.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;corp.ExportBiff&amp;nbsp; "C:\TEST\Sales.xls"&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Has anyone an idea what is happening and does not work the batch file when i try to export a jpg file ?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thank you in advance.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Tue, 04 Nov 2014 20:32:31 GMT</pubDate>
    <dc:creator>geogou1973</dc:creator>
    <dc:date>2014-11-04T20:32:31Z</dc:date>
    <item>
      <title>Problem with the export when i run the qvw from a batch file</title>
      <link>https://community.qlik.com/t5/QlikView/Problem-with-the-export-when-i-run-the-qvw-from-a-batch-file/m-p/767018#M669096</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hello.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I have created a qvw that exports a jpg file with a vbscript module when i reload the qvw by trigger on postReload.&lt;/P&gt;&lt;P&gt;This is the script&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Sub ExportFiles&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;set corp = ActiveDocument.GetSheetObject("CH10")&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;corp.ExportBitmapToFile "C:\TEST\Sales.jpg"&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;End sub &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;When i reload it manually it works and the file exports.&lt;/P&gt;&lt;P&gt;When i run a batch file that reloads the qvw does not work.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;The batch file contains the commands below.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;@ECHO OFF&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;"C:\Program Files\QlikView\Qv.exe"&amp;nbsp; /r C:\TEST\SALES.qvw&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I have to mention that when i export the file in xls with the command in vbscript below the batch file works and the file exports.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;corp.ExportBiff&amp;nbsp; "C:\TEST\Sales.xls"&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Has anyone an idea what is happening and does not work the batch file when i try to export a jpg file ?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thank you in advance.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 04 Nov 2014 20:32:31 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Problem-with-the-export-when-i-run-the-qvw-from-a-batch-file/m-p/767018#M669096</guid>
      <dc:creator>geogou1973</dc:creator>
      <dc:date>2014-11-04T20:32:31Z</dc:date>
    </item>
  </channel>
</rss>

