topic XML load error in QlikView

XML load error

ysj — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am trying create reload the dashboard using below condition but not able to do that.

getting below error:

XML document must have a top level element.

Dashboard script Script:

LET vFilePath='\TaskLogIndex\TaskLogIndex_*.xml';

LET vSize =FileSize('$(vFilePath)'); //test the file size

IF vSize > 3000 THEN

LOAD

LogID,

TaskName,

Date,

Time,

ClusterID,

FullLogPath,

FileSize() as fsz

FROM $(vFilePath)(XmlSimple, Table is [Root/LogIndex]);

ENDIF

Thank you,

Re: XML load error

Anil_Babu_Samineni — Mon, 04 Sep 2017 07:40:51 GMT

This error occurs when you have extra Tag in your XML code?

Re: XML load error

ysj — Mon, 04 Sep 2017 08:39:36 GMT

Thank you anil,

Could you please help me.

I want to load file which is greater than 3 KB but my IF condition doesnt work properly.

please provide your thoughts.

Re: XML load error

Anil_Babu_Samineni — Mon, 04 Sep 2017 09:02:18 GMT

Try this?

LET vSize = filesize(myfile);

IF '$(vSize)' > 3000 THEN

LOAD * FROM myfile;

ENDIF

So, In your expression you may forget this?

LET vFilePath='\TaskLogIndex\TaskLogIndex_*.xml';

LET vSize =FileSize('$(vFilePath)'); //test the file size

IF '$(vSize)' > 3000 THEN

LOAD

LogID,

TaskName,

Date,

Time,

ClusterID,

FullLogPath,

FileSize() as fsz

FROM $(vFilePath)(XmlSimple, Table is [Root/LogIndex]);

ENDIF

Re: XML load error

avinashelite — Mon, 04 Sep 2017 09:14:56 GMT

IF $(vSize) > 3000 then

...

ENDIF

Re: XML load error

jonathandienst — Mon, 04 Sep 2017 09:27:46 GMT

In spite of the previous comments, this syntax is correct, so changing it is not necessary:

IF vSize > 3000 THEN

The error you are getting is that the XML file is not well-formed as it lacks a root (or top-level) element. A well-formed XML dopcument will have the layout

<?xml version="1.0" ?>

<rootnode>

<elementnode></elementnode>

...

</rootnode>

Your document may be lacking the header node and/or root node

https://www.google.co.za/search?source=hp&q=well-formed+XML&oq=well-formed+XML

Re: XML load error

Clever_Anjos — Mon, 04 Sep 2017 11:16:26 GMT

You probably are trying to load a corrupted file, would you mind posting it?