Welcome, Guest
Username: Password: Remember me

TOPIC: Problems importing tab delimited text files

Problems importing tab delimited text files 1 year 6 months ago #86266

  • olliebown
  • olliebown's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 2
  • Karma: 0
I am trying to export and then reimport a survey with lots of added questions. I have exported the survey to a txt file, opened it in Excel, added my survey questions and saved it again as a tab delimited text file (UTF-16 Unicode). When I import the survey back into lime survey the import appears to be successful (the report screen contains some information). However, the survey does not appear. I notice that if I simply export and then re-import it works fine.

I attach the file. The results of the import are as follows:

Surveys: 1
Languages: 1
Question groups: 1
Questions: 7
Question attributes: 7
Answers: 0
Subquestions: 0
Default answers: 7
Assessments: 0
quotas: 0 (0 quota members and 0 quota language settings
Attachments:
The administrator has disabled public write access.

Re: Problems importing tab delimited text files 1 year 6 months ago #86286

  • TMSWhite
  • TMSWhite's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 759
  • Thank you received: 81
  • Karma: 36
You've found a bug, which I reported on your behalf. It works fine in 1.92, but behaves exactly as you describe in 2.0

When I run the database consistency check, it appears that LS never creates the needed entry in the surveys table. There are rows for questions and attributes, but there is no matching surveyid.
Last Edit: 1 year 6 months ago by TMSWhite.
The administrator has disabled public write access.

Re: Problems importing tab delimited text files 1 year 6 months ago #86322

  • olliebown
  • olliebown's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 2
  • Karma: 0
Thank you.

for the benefit of anyone else who has the same problem, here is a workaround.

In the bug discussion c_schmitz says "Datecreated field in the TSV contains an invalid date format". Just open the file in a text editor, search for "datecreated" and reformat the date to the form YYYY-MM-DD (mine was in the form DD/MM/YYYY).

I've now got my survey imported. Fingers crossed it's good to go.

It's a pleasure to be able to import from a spreadsheet like this.
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.122 seconds
Donation Image