https://community.qlik.com/t5/QlikView/Read-XML-from-files-on-SharePoint-list/m-p/1344733#M413976 <HTML><HEAD></HEAD><BODY><P>I have an Infopath for that stores to SharePoint. Something is corrupt in the form and occasionally the last line of XML code has invalid characters. I have a script that loops through each file and reads the code and if the invalid characters are found it flags the file and stores the filename and section of code into a table so I can open and correct it. For this to work, I have to open the SharePoint site before reloading. If I don't open it in Explorer it can't find the file location and skips that part of the script. As a work around, I used VBA code to force an Explorer window to open prior to reload.<SPAN style="font-size: 10pt;">The issue I run into is that this sometimes hangs up due to Security levels. The "Allow Macros" pop up appears. If I am not in front of our scheduler while it is reloading i will not see the pop up and it will then hang and and cause delays in our process. Does anyone know a better way to do this?</SPAN></P></BODY></HTML> Mon, 15 May 2017 12:10:16 GMT olivetwist 2017-05-15T12:10:16Z https://community.qlik.com/t5/QlikView/Read-XML-from-files-on-SharePoint-list/m-p/1344733#M413976 <HTML><HEAD></HEAD><BODY><P>I have an Infopath for that stores to SharePoint. Something is corrupt in the form and occasionally the last line of XML code has invalid characters. I have a script that loops through each file and reads the code and if the invalid characters are found it flags the file and stores the filename and section of code into a table so I can open and correct it. For this to work, I have to open the SharePoint site before reloading. If I don't open it in Explorer it can't find the file location and skips that part of the script. As a work around, I used VBA code to force an Explorer window to open prior to reload.<SPAN style="font-size: 10pt;">The issue I run into is that this sometimes hangs up due to Security levels. The "Allow Macros" pop up appears. If I am not in front of our scheduler while it is reloading i will not see the pop up and it will then hang and and cause delays in our process. Does anyone know a better way to do this?</SPAN></P></BODY></HTML> Mon, 15 May 2017 12:10:16 GMT https://community.qlik.com/t5/QlikView/Read-XML-from-files-on-SharePoint-list/m-p/1344733#M413976 olivetwist 2017-05-15T12:10:16Z https://community.qlik.com/t5/QlikView/Read-XML-from-files-on-SharePoint-list/m-p/1344734#M413977 <HTML><HEAD></HEAD><BODY><P>Maybe you could use a batch instead of a macro to open the explorer maybe triggerred per EXECUTE statement within the qlikview-load.</P><P></P><P><A href="http://www.supportnet.de/t/2208681" title="http://www.supportnet.de/t/2208681">WindowsXP: Datei Explorer per Batch aufrufen</A></P><P></P><P>- Marcus</P></BODY></HTML> Mon, 15 May 2017 12:43:38 GMT https://community.qlik.com/t5/QlikView/Read-XML-from-files-on-SharePoint-list/m-p/1344734#M413977 marcus_sommer 2017-05-15T12:43:38Z https://community.qlik.com/t5/QlikView/Read-XML-from-files-on-SharePoint-list/m-p/1344735#M413978 <HTML><HEAD></HEAD><BODY><P>Yep, that will do it. Sometimes I try to be too fancy instead of going with a simple solution.</P></BODY></HTML> Mon, 15 May 2017 13:28:01 GMT https://community.qlik.com/t5/QlikView/Read-XML-from-files-on-SharePoint-list/m-p/1344735#M413978 olivetwist 2017-05-15T13:28:01Z