article QLIKVIEW AUTOMATION WITH PYTHON IS BACK! in Member Articles https://community.qlik.com/t5/Member-Articles/QLIKVIEW-AUTOMATION-WITH-PYTHON-IS-BACK/ta-p/1806332 <P>Over a year and half ago, I published instructions for creating a class to communicate with Qlikview api using the Python language. Here is the link for your convenience:&nbsp;<SPAN class="Y2IQFc"><A title="QLIKVIEW AUTOMATION WITH PYTHON" href="https://community.qlik.com/t5/Documents/QLIKVIEW-AUTOMATION-WITH-PYTHON/ta-p/1645028" target="_blank" rel="noopener">QLIKVIEW AUTOMATION WITH PYTHON</A></SPAN></P><P><SPAN class="Y2IQFc">Many of you have written and sent me messages requesting to make a new post containing the instructions to extract Qlikview pivot tables in excel and send them via email.</SPAN></P><P>So after more than a year and a pandemic in action, here is an example of extracting Qlikview tables and sending as an email attachment. All tested with Python 3.9</P><P><SPAN class="Y2IQFc">You can found the full files and code at &nbsp;<A href="https://github.com/MatteoMinischetti/PyQlikSender" target="_blank" rel="noopener">GITHUB</A>&nbsp;</SPAN></P><P><SPAN class="Y2IQFc">Here I post only the Python script.</SPAN></P><P>Basically, there is a configuration file of the email parameters and the path of the qlikview file. The qlikview script defines the table &nbsp;containing the people who must receive the emails with their addresses and the table fields to be filtered with the filter value to be used to reduce the data.</P><P>Hoping you like it, &nbsp;for question or issues write me on GitHub.</P><P><A href="http://www.linkedin.com/in/matteominischetti" target="_self">Matteo Minischetti</A></P><P>&nbsp;</P><P><SPAN>PyQlikSender.py</SPAN></P><P><SPAN>from </SPAN>win32com.client <SPAN>import </SPAN>Dispatch<SPAN class="Apple-converted-space">&nbsp; </SPAN><SPAN># pywin32 module<BR /></SPAN><SPAN>import </SPAN>smtplib<BR /><SPAN>from </SPAN>email.message <SPAN>import </SPAN>EmailMessage<BR /><SPAN>import </SPAN>os.path<BR /><SPAN>from </SPAN>datetime <SPAN>import </SPAN>datetime<BR /><SPAN>import </SPAN>configparser<BR /><SPAN>import </SPAN>logging<BR /><BR />current_path = os.getcwd()<BR />config = configparser.ConfigParser()<BR />config.read_file(<SPAN>open</SPAN>(<SPAN>r'PyQlikSenderConf.txt'</SPAN>))<BR />QLIKVIEW_DOCUMENT = config.get(<SPAN>'configuration'</SPAN><SPAN>,</SPAN><SPAN>'QLIKVIEW_DOCUMENT'</SPAN>)<BR />SMTP_ADDRESS = config.get(<SPAN>'configuration'</SPAN><SPAN>,</SPAN><SPAN>'SMTP_ADDRESS'</SPAN>)<BR />SMTP_PORT = config.get(<SPAN>'configuration'</SPAN><SPAN>,</SPAN><SPAN>'SMTP_PORT'</SPAN>)<BR />EMAIL_FROM = config.get(<SPAN>'configuration'</SPAN><SPAN>, </SPAN><SPAN>'EMAIL_FROM'</SPAN>)<BR />EMAIL_LOGIN = config.get(<SPAN>'configuration'</SPAN><SPAN>, </SPAN><SPAN>'EMAIL_LOGIN'</SPAN>)<BR />EMAIL_PASSWORD = config.get(<SPAN>'configuration'</SPAN><SPAN>, </SPAN><SPAN>'EMAIL_PASSWORD'</SPAN>)<BR />LOGFILE = config.get(<SPAN>'configuration'</SPAN><SPAN>, </SPAN><SPAN>'logfile'</SPAN>)<BR />QVRELOAD = config.get(<SPAN>'configuration'</SPAN><SPAN>, </SPAN><SPAN>'QVRELOAD'</SPAN>)<BR /><BR /><BR /><SPAN>class </SPAN>QlikView:<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; </SPAN><SPAN>def </SPAN><SPAN>__init__</SPAN>(<SPAN>self</SPAN><span class="lia-unicode-emoji" title=":disappointed_face:">😞</span><BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>self</SPAN>.app = Dispatch(<SPAN>'QlikTech.QlikView'</SPAN>)<BR /><BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; </SPAN><SPAN>def </SPAN><SPAN>opendoc</SPAN>(<SPAN>self</SPAN><SPAN>, </SPAN>docname<SPAN>, </SPAN>username<SPAN>, </SPAN>password):<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; &nbsp; &nbsp; </SPAN>doc = <SPAN>self</SPAN>.app.OpenDoc(docname<SPAN>, </SPAN>username<SPAN>, </SPAN>password)<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>return </SPAN>doc<BR /><BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; </SPAN><SPAN>def </SPAN><SPAN>reload</SPAN>(<SPAN>self</SPAN><SPAN>,</SPAN>doc):<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; &nbsp; &nbsp; </SPAN>doc.Reload()<BR /><BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; </SPAN><SPAN>def </SPAN><SPAN>clearall</SPAN>(<SPAN>self</SPAN><SPAN>,</SPAN>doc):<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; &nbsp; &nbsp; </SPAN>doc.ClearAll()<BR /><BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; </SPAN><SPAN>def </SPAN><SPAN>apply_field_filter</SPAN>(<SPAN>self</SPAN><SPAN>, </SPAN>doc<SPAN>, </SPAN>filter_field<SPAN>, </SPAN>filter_value):<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; &nbsp; &nbsp; </SPAN>doc.Fields(filter_field).Select(filter_value)<BR /><BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; </SPAN><SPAN>def </SPAN><SPAN>closedoc</SPAN>(<SPAN>self</SPAN><SPAN>, </SPAN>doc):<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; &nbsp; &nbsp; </SPAN>doc.CloseDoc()<BR /><BR /><BR /><BR /><SPAN>def </SPAN><SPAN>sendmail</SPAN>(email<SPAN>, </SPAN>subject<SPAN>,<SPAN class="Apple-converted-space">&nbsp; </SPAN></SPAN>name<SPAN>, </SPAN>surname<SPAN>, </SPAN>filename):<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; </SPAN>msg = EmailMessage()<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; </SPAN>msg[<SPAN>'Subject'</SPAN>] = subject<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; </SPAN>msg[<SPAN>'From'</SPAN>] = EMAIL_FROM<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; </SPAN>msg[<SPAN>'To'</SPAN>] = email<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; </SPAN>content = <SPAN>'Dear ' </SPAN>+ name + <SPAN>' ' </SPAN>+ surname + <SPAN>'<SPAN class="Apple-converted-space">&nbsp; </SPAN>your report is attached here'<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; </SPAN></SPAN>msg.set_content(content)<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; </SPAN><SPAN>try</SPAN>:<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>with </SPAN><SPAN>open</SPAN>(filename<SPAN>, </SPAN><SPAN>'rb'</SPAN>) <SPAN>as </SPAN>xls:<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN>msg.add_attachment(xls.read()<SPAN>, </SPAN><SPAN>maintype</SPAN>=<SPAN>'application'</SPAN><SPAN>, </SPAN><SPAN>subtype</SPAN>=<SPAN>'octet-stream'</SPAN><SPAN>, </SPAN><SPAN>filename</SPAN>=xls.name)<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; </SPAN><SPAN>except </SPAN><SPAN>Exception </SPAN><SPAN>as </SPAN>e:<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>print</SPAN>(<SPAN>'cannot open attachment to send, error :' </SPAN>+ <SPAN>str</SPAN>(e))<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; </SPAN><SPAN>try</SPAN>:<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>with </SPAN>smtplib.SMTP_SSL(SMTP_ADDRESS<SPAN>, </SPAN>SMTP_PORT) <SPAN>as </SPAN>smtp:<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN>smtp.login(EMAIL_LOGIN<SPAN>, </SPAN>EMAIL_PASSWORD)<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN>smtp.send_message(msg)<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; </SPAN><SPAN>except </SPAN><SPAN>Exception </SPAN><SPAN>as </SPAN>e:<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; &nbsp; &nbsp; </SPAN>logging.info(<SPAN>'cannot send email to : ' </SPAN>+ email + <SPAN>' , error :' </SPAN>+ <SPAN>str</SPAN>(e))<BR /><BR /><BR /><SPAN>def </SPAN><SPAN>manage_document</SPAN>(docname<SPAN>, </SPAN>current_path<SPAN>, </SPAN>tb_email):<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; </SPAN>username = <SPAN>None<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; </SPAN></SPAN>password = <SPAN>None<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; </SPAN></SPAN>q = QlikView()<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; </SPAN>version = q.app.QvVersion()<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; </SPAN><SPAN>print</SPAN>(version)<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; </SPAN>doc = q.opendoc(docname<SPAN>, </SPAN>username<SPAN>, </SPAN>password)<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; </SPAN><SPAN>if </SPAN>QVRELOAD == <SPAN>'Y'</SPAN>:<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; &nbsp; &nbsp; </SPAN>q.reload(docname)<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; </SPAN>email_table = doc.GetSheetObject(tb_email)<SPAN class="Apple-converted-space">&nbsp; </SPAN><SPAN># the object table containing email to send and filter to apply<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; </SPAN></SPAN>today_date = <SPAN>str</SPAN>(datetime.today().date()).replace(<SPAN>'-'</SPAN><SPAN>, </SPAN><SPAN>'_'</SPAN>)<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; </SPAN>rowiter = <SPAN>0<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; </SPAN></SPAN>rows = email_table.GetRowCount()<BR /><BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; </SPAN><SPAN>while </SPAN>rowiter &lt; rows:<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; &nbsp; &nbsp; </SPAN>title = email_table.GetCell(rowiter<SPAN>, </SPAN><SPAN>0</SPAN>).Text<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; &nbsp; &nbsp; </SPAN>name = email_table.GetCell(rowiter<SPAN>, </SPAN><SPAN>1</SPAN>).Text<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; &nbsp; &nbsp; </SPAN>surname = email_table.GetCell(rowiter<SPAN>, </SPAN><SPAN>2</SPAN>).Text<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; &nbsp; &nbsp; </SPAN>email = email_table.GetCell(rowiter<SPAN>, </SPAN><SPAN>3</SPAN>).Text<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; &nbsp; &nbsp; </SPAN>company = email_table.GetCell(rowiter<SPAN>, </SPAN><SPAN>4</SPAN>).Text<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; &nbsp; &nbsp; </SPAN>filter_field = email_table.GetCell(rowiter<SPAN>, </SPAN><SPAN>5</SPAN>).Text<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; &nbsp; &nbsp; </SPAN>filter_value = email_table.GetCell(rowiter<SPAN>, </SPAN><SPAN>6</SPAN>).Text<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; &nbsp; &nbsp; </SPAN>tb1 = email_table.GetCell(rowiter<SPAN>, </SPAN><SPAN>7</SPAN>).Text<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>print</SPAN>(title<SPAN>, </SPAN>name<SPAN>, </SPAN>surname<SPAN>, </SPAN>email<SPAN>, </SPAN>company)<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; &nbsp; &nbsp; </SPAN>rowiter = rowiter + <SPAN>1<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; &nbsp; &nbsp; </SPAN></SPAN>subject = <SPAN>"Qlikview report service for: " </SPAN>+ company<BR /><BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>if </SPAN>rowiter &gt; <SPAN>1</SPAN>:<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN>filename = tb1 + <SPAN>'_' </SPAN>+ name + <SPAN>'_' </SPAN>+ surname + <SPAN>'_' </SPAN>+ today_date + <SPAN>'.xls'<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN></SPAN>q.clearall(docname)<SPAN class="Apple-converted-space">&nbsp; </SPAN><SPAN># clear all filter<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN></SPAN>doc.Fields(filter_field).Select(filter_value)<SPAN class="Apple-converted-space">&nbsp; </SPAN><SPAN># apply filter<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN></SPAN><SPAN>try</SPAN>:<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN>chart = doc.GetSheetObject(tb1)<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>except </SPAN><SPAN>Exception </SPAN><SPAN>as </SPAN>e:<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN>logging.info(<SPAN>'error: ' </SPAN>+ <SPAN>str</SPAN>(e))<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN>chart_path = current_path + <SPAN>'/' </SPAN>+ filename<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN>chart.ExportBiff(chart_path)<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN>sendmail(email<SPAN>, </SPAN>subject<SPAN>, </SPAN>name<SPAN>, </SPAN>surname<SPAN>, </SPAN>filename)<BR /><BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; </SPAN>q.closedoc(doc)<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; </SPAN>q.app.Quit()<BR /><BR /><BR /><SPAN>if </SPAN>__name__ == <SPAN>'__main__'</SPAN>:<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; </SPAN>doc = current_path + <SPAN>'/' </SPAN>+ QLIKVIEW_DOCUMENT<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; </SPAN>logging.basicConfig(<SPAN>format</SPAN>=<SPAN>'%(asctime)s - %(message)s'</SPAN><SPAN>, </SPAN><SPAN>filename</SPAN>=LOGFILE<SPAN>, </SPAN><SPAN>encoding</SPAN>=<SPAN>'utf-8'</SPAN><SPAN>,<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN></SPAN><SPAN>level</SPAN>=logging.DEBUG)<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; </SPAN>tb_email = <SPAN>'email' <SPAN class="Apple-converted-space">&nbsp; </SPAN></SPAN><SPAN># qlikview table containing email address and info<BR /><SPAN class="Apple-converted-space">&nbsp; &nbsp; </SPAN></SPAN>manage_document(doc<SPAN>, </SPAN>current_path<SPAN>, </SPAN>tb_email)</P><P>&nbsp;</P> Wed, 21 Sep 2022 17:07:35 GMT matteo_mi 2022-09-21T17:07:35Z QLIKVIEW AUTOMATION WITH PYTHON IS BACK! https://community.qlik.com/t5/Member-Articles/QLIKVIEW-AUTOMATION-WITH-PYTHON-IS-BACK/ta-p/1806332 <P>QLIKVIEW AUTOMATION WITH PYTHON IS BACK!</P> Wed, 21 Sep 2022 17:07:35 GMT https://community.qlik.com/t5/Member-Articles/QLIKVIEW-AUTOMATION-WITH-PYTHON-IS-BACK/ta-p/1806332 matteo_mi 2022-09-21T17:07:35Z Re: QLIKVIEW AUTOMATION WITH PYTHON IS BACK! https://community.qlik.com/t5/Member-Articles/QLIKVIEW-AUTOMATION-WITH-PYTHON-IS-BACK/tac-p/1818991#M399 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/6437">@matteo_mi</a>&nbsp;, I have tried this code, however I am getting an error on Reload function, any idea why this error.</P><P>Traceback (most recent call last):<BR />File "D:\PyQlikSender-master\PyQlikSender.py", line 114, in &lt;module&gt;<BR />manage_document(doc, current_path, tb_email)<BR />File "D:\PyQlikSender-master\PyQlikSender.py", line 73, in manage_document<BR />q.reload(docname)<BR />File "D:\PyQlikSender-master\PyQlikSender.py", line 31, in reload<BR />doc.Reload()<BR />AttributeError: 'str' object has no attribute 'Reload'</P> Thu, 01 Jul 2021 02:39:34 GMT https://community.qlik.com/t5/Member-Articles/QLIKVIEW-AUTOMATION-WITH-PYTHON-IS-BACK/tac-p/1818991#M399 basav 2021-07-01T02:39:34Z Re: QLIKVIEW AUTOMATION WITH PYTHON IS BACK! https://community.qlik.com/t5/Member-Articles/QLIKVIEW-AUTOMATION-WITH-PYTHON-IS-BACK/tac-p/1819006#M400 <P>Hi Basavaraju_S &nbsp;you are right!</P><P>The problem is the variable passed to the reload, should be doc instead of docname</P><P><SPAN>q.reload(docname)&nbsp;should be changed in q.reload(doc)</SPAN></P><P><SPAN>let me know if this solve your&nbsp;problem.</SPAN></P><P>&nbsp;</P> Thu, 01 Jul 2021 06:55:47 GMT https://community.qlik.com/t5/Member-Articles/QLIKVIEW-AUTOMATION-WITH-PYTHON-IS-BACK/tac-p/1819006#M400 matteo_mi 2021-07-01T06:55:47Z Re: QLIKVIEW AUTOMATION WITH PYTHON IS BACK! https://community.qlik.com/t5/Member-Articles/QLIKVIEW-AUTOMATION-WITH-PYTHON-IS-BACK/tac-p/1819246#M401 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/6437">@matteo_mi</a>&nbsp;, Thanks for the reply.&nbsp;</P><P>I have changed the name to 'doc', application opened, reloaded, and filter was applied.&nbsp;</P><P>However getting the attribution error again, please find below.&nbsp;</P><P>Traceback (most recent call last):<BR />File "D:\PyQlikSender-master\PyQlikSender.py", line 114, in &lt;module&gt;<BR />manage_document(doc, current_path, tb_email)<BR />File "D:\PyQlikSender-master\PyQlikSender.py", line 102, in manage_document<BR />chart.ExportBiff("D:\PyQlikSender-master\exampletable1.xls")<BR />AttributeError: 'NoneType' object has no attribute 'ExportBiff'</P><P>&nbsp;</P><P>I have checked your previous article on the same, where Danosoft had mentioned to use&nbsp;</P><PRE><SPAN>ExportBitmapToFile or Exporthtml<BR /></SPAN></PRE><P>&nbsp;But even these are throwing the attribution error. Am I doing something wrong here?</P><P>&nbsp;</P><P>For the tables I have manually mentioned the object ID TB01 is 'email' and TB02 is 'tb1'&nbsp; &nbsp; &nbsp; perhaps I could be wrong here?</P> Fri, 02 Jul 2021 04:16:46 GMT https://community.qlik.com/t5/Member-Articles/QLIKVIEW-AUTOMATION-WITH-PYTHON-IS-BACK/tac-p/1819246#M401 basav 2021-07-02T04:16:46Z Re: QLIKVIEW AUTOMATION WITH PYTHON IS BACK! https://community.qlik.com/t5/Member-Articles/QLIKVIEW-AUTOMATION-WITH-PYTHON-IS-BACK/tac-p/1819249#M402 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/6437">@matteo_mi</a>&nbsp;, I figured it out what I was doing wrong. Its working fine now.&nbsp;</P><P>Before the ExportBiff, where we are fetching the second table through ObjectID I had given it wrong. Now its running fine. Thank you.</P><P>However the logging package is not working, something to do with the version. So I have commented it out.&nbsp;</P> Fri, 02 Jul 2021 04:25:59 GMT https://community.qlik.com/t5/Member-Articles/QLIKVIEW-AUTOMATION-WITH-PYTHON-IS-BACK/tac-p/1819249#M402 basav 2021-07-02T04:25:59Z Re: QLIKVIEW AUTOMATION WITH PYTHON IS BACK! https://community.qlik.com/t5/Member-Articles/QLIKVIEW-AUTOMATION-WITH-PYTHON-IS-BACK/tac-p/1819901#M403 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/6437">@matteo_mi</a>&nbsp;Good Day, I have got a new requirement, where I need to attach table image on the mail body, I am hoping you have an answer for this too, Any help is much appreciated. Thanks.&nbsp;</P><P>I searched online for this, but still no luck.</P> Mon, 05 Jul 2021 17:30:46 GMT https://community.qlik.com/t5/Member-Articles/QLIKVIEW-AUTOMATION-WITH-PYTHON-IS-BACK/tac-p/1819901#M403 basav 2021-07-05T17:30:46Z Re: QLIKVIEW AUTOMATION WITH PYTHON IS BACK! https://community.qlik.com/t5/Member-Articles/QLIKVIEW-AUTOMATION-WITH-PYTHON-IS-BACK/tac-p/1884254#M404 <P><SPAN class="VIiyi"><A href="https://community.qlik.com/t5/user/viewprofilepage/user-id/6437" target="_blank">@matteo_mi</A>&nbsp;, Good Day, <SPAN class="JLqJ4b ChMk0b" data-language-for-alternatives="en" data-language-to-translate-into="ru" data-phrase-index="1" data-number-of-phrases="2"><SPAN>I have got the same error "AttributeError: 'QlikView' object has no attribute 'reload' " even after changing q.reload(docname) to q.reload(doc)</SPAN></SPAN></SPAN> <SPAN class="VIiyi"><SPAN class="JLqJ4b ChMk0b" data-language-for-alternatives="en" data-language-to-translate-into="ru" data-phrase-index="1" data-number-of-phrases="2"><SPAN>. Please tell me what could be the problem. </SPAN></SPAN></SPAN></P> <P><SPAN class="VIiyi"><SPAN class="JLqJ4b ChMk0b" data-language-for-alternatives="en" data-language-to-translate-into="ru" data-phrase-index="1" data-number-of-phrases="2"><SPAN>Also, if I want to save the file after reload of new data, what will the script look like? Is that right? </SPAN></SPAN></SPAN></P> <P><SPAN class="VIiyi"><SPAN class="JLqJ4b ChMk0b" data-language-for-alternatives="en" data-language-to-translate-into="ru" data-phrase-index="1" data-number-of-phrases="2"><SPAN>class QlikView: </SPAN></SPAN></SPAN></P> <P><SPAN class="VIiyi"><SPAN class="JLqJ4b ChMk0b" data-language-for-alternatives="en" data-language-to-translate-into="ru" data-phrase-index="1" data-number-of-phrases="2"><SPAN>&nbsp;&nbsp;&nbsp; ... </SPAN></SPAN></SPAN></P> <P><SPAN class="VIiyi"><SPAN class="JLqJ4b ChMk0b" data-language-for-alternatives="en" data-language-to-translate-into="ru" data-phrase-index="1" data-number-of-phrases="2"><SPAN>&nbsp;&nbsp;&nbsp; def Save(self,doc): </SPAN></SPAN></SPAN></P> <P><SPAN class="VIiyi"><SPAN class="JLqJ4b ChMk0b" data-language-for-alternatives="en" data-language-to-translate-into="ru" data-phrase-index="1" data-number-of-phrases="2"><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; doc.Save() </SPAN></SPAN></SPAN></P> <P>&nbsp;</P> <P><SPAN class="VIiyi"><SPAN class="JLqJ4b ChMk0b" data-language-for-alternatives="en" data-language-to-translate-into="ru" data-phrase-index="1" data-number-of-phrases="2"><SPAN>def ManageDocument(): </SPAN></SPAN></SPAN></P> <P><SPAN class="VIiyi"><SPAN class="JLqJ4b ChMk0b" data-language-for-alternatives="en" data-language-to-translate-into="ru" data-phrase-index="1" data-number-of-phrases="2"><SPAN>&nbsp;&nbsp;&nbsp; ... </SPAN></SPAN></SPAN></P> <P><SPAN class="VIiyi"><SPAN class="JLqJ4b ChMk0b" data-language-for-alternatives="en" data-language-to-translate-into="ru" data-phrase-index="1" data-number-of-phrases="2"><SPAN>&nbsp;&nbsp;&nbsp; q.save(doc) </SPAN></SPAN></SPAN></P> Mon, 24 Jan 2022 04:47:05 GMT https://community.qlik.com/t5/Member-Articles/QLIKVIEW-AUTOMATION-WITH-PYTHON-IS-BACK/tac-p/1884254#M404 Gau 2022-01-24T04:47:05Z