Welcome, Guest
Username: Password: Remember me

TOPIC: Import question

Import question 10 months 3 weeks ago #96325

  • dlips
  • dlips's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 2
  • Karma: 0
Hello everyone

My aim is to have a dropdown-question where the participant can select the city where he's from. Finally, there are about 400 cities to register. So, I don't have the intention to write each city into the answer by hand... Rather I'd like to import the cities from the excel-list I already have. For that, I registered 3 cities, exported the file (see export-file) and wanted to adjust the necessairy colum.
BUT the Problem is that as soon the File is opened with MS Excel (I didnt't change anything in the file and then saved it as a comma-separated csv-file (import.csv)) I can't (re)import the file because I get the error "You can't import a question which doesn't support the current survey's base language". Without open the file with excel and just importing it again, everthing runs smoothly.
I tried to solve the problem by doing the following things:
- changed the base language (English and German)
- saved the excel-file as other types of csv.
- searched the forum/web for help.

I guess, the problem is around MS Excel.
But I haven't found a solution. Maybe you have it.

Thanks for your support.
Attachments:
Last Edit: 10 months 3 weeks ago by dlips.
The administrator has disabled public write access.

Import question 10 months 3 weeks ago #96328

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 5845
  • Thank you received: 715
  • Karma: 222
Think best is to use directly the "Quic add" function.

Just paste something like this:
CODE1;Name of the firts town
CODE2;Name of the second town
etc ...
The administrator has disabled public write access.
The following user(s) said Thank You: dlips

Import question 10 months 3 weeks ago #96366

  • dlips
  • dlips's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 2
  • Karma: 0
Thx for your answer.

Meanwhile, I've got exactly what I was looking for=) With the description from the following link I could edit the question as I wanted.

www.aptigence.com.au/home/index.php?url=...ons.html&serendipity[cview]=linear

Best regards
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.097 seconds
Donation Image