Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Error in import : This is not a valid LimeSurvey survey structure XML file.

  • boggiano
  • boggiano's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 2 months ago #180474 by boggiano
I am trying to import a very large exported survey ( ~ 15MB).

But as soon it finished upload, I am getting the message:

"
Success
File upload succeeded.
Error
This is not a valid LimeSurvey survey structure XML file.
"

I am on:
Linux Mint 18
Limesurvey Version 3.15.8+190130
Mysql Ver 15.1 Distrib 10.0.38-MariaDB


I tried to modify php.ini with memory_limit, post_max_size, upload_max_filesize... but no luck.
Xml file seems good to me (xmllint has no complains about it)

Here the link to the lss file :
s000.tinyupload.com/download.php?file_id...94151399462691057618


Thanks
The topic has been locked.
More
5 years 2 months ago - 5 years 2 months ago #180478 by jelo

boggiano wrote: But as soon it finished upload, I am getting the message:
Success
File upload succeeded.
Error
This is not a valid LimeSurvey survey structure XML file.
"


There is currently no indication for uploadsize issues around PHP.
You would then receive different issues (e.g. Entity Too Large from the webserver).
You can see the max limit when looking at the import dialog.
"Select survey structure file (*.lss, *.txt) or survey archive (*.lsa) (maximum file size: X.XX MB)

The file is uploaded, but the file itself seems to be incompatible or buggy.
A bug inside LimeSurvey is possible too.

What exact PHP version is running on the webserver?

The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
Last edit: 5 years 2 months ago by jelo.
The topic has been locked.
  • boggiano
  • boggiano's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 2 months ago #180479 by boggiano

jelo wrote: You would then receive different issues (e.g. Entity Too Large from the webserver).
You can see the max limit when looking at the import dialog.

Yes I agree with you!
Right now I have:
upload_max_filesize = 520M
(just for testing, of course!)

jelo wrote: The file is uploaded, but the file itself seems to be incompatible or buggy.
A bug inside LimeSurvey is possible too.


I used xmllint just to be sure about the syntax and it's seems ok!
Also I tried to delete some records by hand and I come up that the problem is the size of the file (or the number of records).
I deleted a bunch of records until I managed to import it, than adding a single "simple" (no strange chars) record I add the same issue.

jelo wrote: What exact PHP version is running on the webserver?


PHP 7.0.33-0ubuntu0.16.04.1
The topic has been locked.
More
5 years 2 months ago #180484 by jelo
Do you know the exact version of LimeSurvey, where this export is from?
The XML file contains 410464 lines.
Looks to me like a bug in the export and/or import routines.

I can reproduce the issue. I currently rule out the server stack.
Please open a bug ticket now and attach the surveyfile.

We had such issues in the past. Can be certain char which breaks the import, but not the export. XML can be fine for the XML parser, but not for the LimeSurvey import routines. So please open the bug ticket now.

The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The topic has been locked.
More
5 years 2 months ago #180485 by jelo
Update: I was able to import a LSS file after deleting stuff inside the XML file. Will need to reproduce some steps to be sure.

The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The topic has been locked.
  • boggiano
  • boggiano's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 2 months ago #180490 by boggiano

jelo wrote: Do you know the exact version of LimeSurvey, where this export is from?

2.72.2+171017.
But keep in mind that I can't even import it in the same environment or copy the survey.


jelo wrote: Please open a bug ticket now and attach the surveyfile.


I already did it! :)
bugs.limesurvey.org/view.php?id=14527

jelo wrote: We had such issues in the past. Can be certain char which breaks the import, but not the export.



It could be but, I as wrote before, I deleted records from the file until I was able to import it.
Than adding a single clean record the import failed again (so I am thinking about file size or number of records/fields rather than bad chars!)
The topic has been locked.
More
5 years 2 months ago #180491 by jelo

boggiano wrote: It could be but, I as wrote before, I deleted records from the file until I was able to import it.

What do you mean be record?

I didn't delete xml rows, just content inside. So no questions where removed.



The questioncodes need to be converted. D18_1 will become D181. LimeSurvey will do that for your.

The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The topic has been locked.
  • boggiano
  • boggiano's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 2 months ago - 5 years 2 months ago #180493 by boggiano

jelo wrote: What do you mean be record?
I didn't delete xml rows, just content inside. So no questions where removed.


I deleted a bunch of "<row></row>".
You did better!!

Which size has the new file, now ?

So, maybe, it is really a file size matter !


EDIT:
as written in the ticket I deleted all contents inside the tags:

<surveyls_welcometext>
<surveyls_endtext>
<surveyls_url>
<surveyls_email_remind>
<surveyls_email_invite>
<email_admin_responses>


And it worked!!
Last edit: 5 years 2 months ago by boggiano.
The topic has been locked.
More
5 years 2 months ago #180495 by jelo

boggiano wrote: So, maybe, it is really a file size matter !

No, it's a character/content issue. At least for LimeSurvey it is an issue. The XML itself is fine, so no external tool will flag an issue inside the XML file.

Case closed.

The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The following user(s) said Thank You: boggiano
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose