Home arrow Support arrow Forums
LimeSurvey Forums
Welcome, Guest
Please Login or Register.    Lost Password?
[done] error importing a CSV survey (1 viewing) (1) Guest
Go to bottom Favoured: 0
TOPIC: [done] error importing a CSV survey
#5412
paulw (User)
Fresh Lemon
Posts: 18
graphgraph
User Offline Click here to see the profile of this user
[done] error importing a CSV survey 1 Year, 4 Months ago Karma: 0  
I've created a survey, which I intend to use as a base for several similar surveys. I've exported the survey to a CSV and then tried to import it back in (without making changes).

I get the error: Import of this survey file failed
File does not contain LimeSurvey data in the correct format.

What is the correct format?

I'm using 1.5

thanks for any assistance...
 
Logged Logged  
 
Last Edit: 2008/11/17 12:14 By Mazi.
  The administrator has disabled public write access.
#5417
ElMatador69 (Moderator)
LimeSurvey Team
Posts: 1603
graphgraph
User Offline Click here to see the profile of this user
Re:error importing a CSV survey 1 Year, 4 Months ago Karma: 31  
Hi,

With which version were you doing the export?
Can you provide your survey? Open a post in the bugtracker and attach it, You can mark the post as private, if your survey is confidental.

Another possibility is, try to import your survey on the LimeSurvey-Demo-Site. Tell us if it works for you.
 
Logged Logged  
 
Get in touch with the LimeSurvey Development Team via IRC
If our informations and answers were useful to you, please consider a donation to the LimeSurvey Project!
  The administrator has disabled public write access.
#5441
paulw (User)
Fresh Lemon
Posts: 18
graphgraph
User Offline Click here to see the profile of this user
Re:error importing a CSV survey 1 Year, 4 Months ago Karma: 0  
ok - will try both those things. I'm using ver1.5 - the exported csv file came from 1.5 and I'm basicaly trying to upload it back in...
 
Logged Logged  
  The administrator has disabled public write access.
#5442
paulw (User)
Fresh Lemon
Posts: 18
graphgraph
User Offline Click here to see the profile of this user
Re:error importing a CSV survey 1 Year, 4 Months ago Karma: 0  
...tried to upload the file on the online demo - got exactly the same error message.
I'm writing out a bugtracker now - just need to wait for some details on PHP version and the like.
Thanks
 
Logged Logged  
  The administrator has disabled public write access.
#5460
fasta_playa (User)
Fresh Lemon
Posts: 9
graphgraph
User Offline Click here to see the profile of this user
Re:error importing a CSV survey 1 Year, 4 Months ago Karma: 0  
I am having the exact same issue. I did edit the file

Error
Import of this survey file failed
File does not contain LimeSurvey data in the correct format.
 
Logged Logged  
  The administrator has disabled public write access.
#5461
wquatan (User)
Junior Lime
Posts: 24
graphgraph
User Offline Click here to see the profile of this user
Re:error importing a CSV survey 1 Year, 4 Months ago Karma: 0  
I had the same problem in 1.49RC2.

I solved it by using another Question-name or Code (in a list). If I remember well I used "TYPE" as name and changed it in something like "TYP1"
That solved my problem. Seems sort of reserved-word related

Now I'm using 1.50 and doing Export/import all the time without problems

Walter<br><br>Post edited by: wquatan, at: 2007/08/22 21:54
 
Logged Logged  
  The administrator has disabled public write access.
#5462
fasta_playa (User)
Fresh Lemon
Posts: 9
graphgraph
User Offline Click here to see the profile of this user
Re:error importing a CSV survey 1 Year, 4 Months ago Karma: 0  
And you did this in the QUESTIONS TABLE section of your csv file?

Under which section header did you have to change your data?:
qid, sid, gid, type, title, question, preg, help, other, mandatory, lid, question_order, language

I'm on v1.52
 
Logged Logged  
  The administrator has disabled public write access.
#5463
wquatan (User)
Junior Lime
Posts: 24
graphgraph
User Offline Click here to see the profile of this user
Re:error importing a CSV survey 1 Year, 4 Months ago Karma: 0  
No, I did it in the Original Survey, exported again followed by the Import
 
Logged Logged  
  The administrator has disabled public write access.
#5465
paulw (User)
Fresh Lemon
Posts: 18
graphgraph
User Offline Click here to see the profile of this user
Re:error importing a CSV survey - excel issue 1 Year, 4 Months ago Karma: 0  
ok - I have now successfully imported the file.

The first time I exported a CSV file, I did so by opening it to Excel and then saving it again (as a CSV file).

The second time, I exported the CSV file directly to a folder without opening it in Excel. This one, I imported back in successfully.

So for now, if i want to make changes I'll just open the csv file in notepad or some such, and see if that resolves the issue. I have left a note in the bugtracker indicating that I think excel is causing the problem...

Paul
 
Logged Logged  
  The administrator has disabled public write access.
#5479
fasta_playa (User)
Fresh Lemon
Posts: 9
graphgraph
User Offline Click here to see the profile of this user
Re:error importing a CSV survey - excel issue 1 Year, 4 Months ago Karma: 0  
Just a quick look at the difference between a clean file and one edited with excel shows that excel removed the quotes (&quot around each object.
 
Logged Logged  
  The administrator has disabled public write access.
Go to top