Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
btrompetter
Contributor III
Contributor III

Error occured when loading sheets from QlikViewProject

Hallo,

when I load the layoutfile from one Dashboard I always get this error

ScalabilityGeneratorError.png

2014-07-29 10:10:43;SelectActionsUserControl::LoadDocument;qv.Parser.Xml.QlikViewDocumentXmlParseException: An error occured when loading sheets from QlikViewProject

   at qv.Parser.Xml.QlikViewDocumentXmlParserV11SR1.Load(String directoryPathToTopLayout)

   at qv.Parser.QlikViewDocumentParserFactory.Create(String documentFolderPath)

   at qv.UserControls.SelectActionsWPFUserControl.LoadDocument()

Tha Layoutfile was created with Qlikview 11.2 SR7 Desktop Client.

I try to load the layoutfile from another Dashboard and this is working.

What cause this error?

The Dashboard has 10 Shaeets and some sheets are only visible for special useres.

Thanks for help.

Best wishes

Bastian

3 Replies
Sebastian_Fredenberg

Hi Bastian,

So if I understand correctly you can import files but just not those exported for this document?

First of all, if you look in the export folder - can you see a great deal of .xml files, basically one per object and some additionals?  If you have 10 sheet in the document there should for example be 10 xml-files for these sheets (by defaults SH01,SH02 etc)

Secondly, do the objectsnames in this document follow standard/default naming (LB11, TX123, SH06 etc) or have they been renamed? If they have been renamed - if any contain special characters that that might explain it.

My suspicions are that either there are special characters in objectnames or that not all sheets and objects were exported as xml filel (as you mentioned some sheets are not shown for all)

cheers

Sebastian

btrompetter
Contributor III
Contributor III
Author

Hey Sebastian,

I can see many xml files in the export folder. What are special characters which cause the issue?

I attached my layoutfile folder.

I renamed one Sheet from SH10 into DEBUG

I have one & in the filename and one file like ENG Std%2E 3.xml

Best wishes

Bastian

Sebastian_Fredenberg

Hi Bastian,

I took a look at the files and it is indeed the filename "ENG Std%2E 3.xml" that causes the issue. In the QlikViewProject.xml (used by the scalability tools) the corresponding name is "Document\ENG Std. 3". So the actual xml file percent encodes the dot fin the filename but not in the QlikViewProject.xml.

Anyway, I replaced %2E with a dot  ("ENG Std. 3.xml") and I can import the file so that should do the trick.

The easy solution for now if this occurs is to replace any "%XX" to the characters they represent, but it's possible that we do an update to the tools or documentation ragerding this sisue as well.

Cheers

/Sebastian