topic Re: loading XML file QlikSense in App Development

loading XML file QlikSense

ilanbaruch — Wed, 21 Jul 2021 14:10:11 GMT

hi all,

trying to load XML file , receiving an error invalid parameters...

any ideas ?

advanced thanks

Re: loading XML file QlikSense

PadmaPriya — Wed, 21 Jul 2021 14:21:39 GMT

Hello @ilanbaruch

Please have a look at below threads:

https://community.qlik.com/t5/Scalability/Invalid-parameters-when-executing-scenario/m-p/1658162#M1664

https://community.qlik.com/t5/New-to-Qlik-Sense/Invalid-Parameter/m-p/21622

Thanks,

Padma Priya

Qlik Support

Re: loading XML file QlikSense

rwunderlich — Wed, 21 Jul 2021 16:46:08 GMT

Your filename is "string.csv". Does this file contain xml or delimited data? Can you post a bit of the file contents?

-Rob

Re: loading XML file QlikSense

ilanbaruch — Wed, 28 Jul 2021 05:12:29 GMT

Hi Rob,

thank you for your replay,

attached the file content:

<?xml version="1.0"?>
"<DocumentElement>
<Row>
<EMP_NO>1</EMP_NO>
<EMP_NAME>DANIEL</EMP_NAME>
<DATE_START>2003-11-17T00:00:00+02:00</DATE_START>
<PERMGROUP>0</PERMGROUP>
</Row>
<Row>
<EMP_NO>7</EMP_NO>
<EMP_NAME>LARISA</EMP_NAME>
<DATE_START>2005-12-01T00:00:00+02:00</DATE_START>
<PERMGROUP>9999</PERMGROUP>
</Row>
<Row>
<EMP_NO>10</EMP_NO>
<EMP_NAME>LEVI</EMP_NAME>
<DATE_START>2005-01-02T00:00:00+02:00</DATE_START>
<PERMGROUP>9999</PERMGROUP>
</Row>
<Row>
<EMP_NO>26</EMP_NO>
<EMP_NAME>AMIR</EMP_NAME>
<DATE_START>2000-01-29T00:00:00+02:00</DATE_START>
<PERMGROUP>9998</PERMGROUP>
</Row>
<Row>
<EMP_NO>27</EMP_NO>
<EMP_NAME>OFIR</EMP_NAME>
<DATE_START>2004-03-01T00:00:00+02:00</DATE_START>
<PERMGROUP>9998</PERMGROUP>
</Row>
<Row>
<EMP_NO>37</EMP_NO>
<EMP_NAME>ALEX</EMP_NAME>
<DATE_START>2004-10-18T00:00:00+02:00</DATE_START>
<PERMGROUP>9998</PERMGROUP>
</Row>
<Row>
<EMP_NO>43</EMP_NO>
<EMP_NAME>YURI</EMP_NAME>
<DATE_START>2007-02-04T00:00:00+02:00</DATE_START>
<PERMGROUP>9999</PERMGROUP>
</Row>
<Row>
<EMP_NO>46</EMP_NO>
<EMP_NAME>DANA</EMP_NAME>
<DATE_START>2005-10-26T00:00:00+02:00</DATE_START>
<PERMGROUP>9999</PERMGROUP>
</Row>
<Row>
<EMP_NO>47</EMP_NO>
<EMP_NAME>SHOSHANA</EMP_NAME>
<DATE_START>2002-11-10T00:00:00+02:00</DATE_START>
<PERMGROUP>9999</PERMGROUP>
</Row>
<Row>
<EMP_NO>48</EMP_NO>
<EMP_NAME>GUY</EMP_NAME>
<DATE_START>2007-01-23T00:00:00+02:00</DATE_START>
<PERMGROUP>9999</PERMGROUP>
</Row>
</DocumentElement>"

Re: loading XML file QlikSense

rwunderlich — Thu, 29 Jul 2021 18:13:07 GMT

I don't think there should be quotes around the file contents?

-Rob