Welcome to the LimeSurvey Community Forum

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

csv import problems of an excel file

  • Falk
  • Falk's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
9 years 6 months ago - 9 years 6 months ago #112247 by Falk
Hello,

I tried to import an excel table with about 20 attributes and 3500 records/profiles.
A.) But when the import wizzard asks me "Please select the fields which should be imported as attributes..." I cannot select or drag&drop a single attribute but just all the attributes in one block.

I think this is not working correct. (shall I send you a screenshot from that?)
Do you have any idea what goes wrong here and why?...

Additional info:
I use Firefox 26.0. The csv file was ;-separated and contains a header line and also three known attributes: email, firstname, lastname. I use the actual LS version 2.05.

My final goal:
I would like to link/bind the attributes/fields/columns of my table with my questions so that the answers are put into the right dataset field automatically. I suppose that this is supported, right?

If not how can I efficiently export the result data of the survey and merge them with my excel table's records and attributes?

B.) During import I also have a typeset problem:
All words/data are cut which have a German ß, ä, ö, ü or é, and others. (Lime survey must accept this!! I cannt change that.)
I set 'file typeset' to automatic and tried also a lot of others like 'UTF8 unicode'. But none worked, unfortunately.

Thank you so much for your help for my two problems!
Last edit: 9 years 6 months ago by Falk.
The topic has been locked.
  • Falk
  • Falk's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
9 years 6 months ago #112253 by Falk
Replied by Falk on topic csv import problems of an excel file
addition...

Meanwhile I found out that there is at least one bug here as point A) above works at csv files with comma separation. The problem A appears at semicolon separation.
But the typeset problem B I cannot solve. Please tell me what I shall do that all letters are accepted poperly.
The topic has been locked.
  • Falk
  • Falk's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
9 years 6 months ago #112256 by Falk
Replied by Falk on topic csv import problems of an excel file
I cannot use comma separation. There are lots of commas in my data!
To create csv files I just use Windows Excel's 'csv (DOS)' export. That's just what is expected for your import! Its typeset and its standard separation setting (semicolon).
The topic has been locked.
  • Falk
  • Falk's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
9 years 6 months ago - 9 years 6 months ago #112260 by Falk
Replied by Falk on topic csv import problems of an excel file
...or better Excel's general csv export format.
You can easily try that out by yourself. You should have the same problems!...

I also realised now that I cannot show or mark the whole central participants table:
Setting 25 or 50 records per page works. But setting higher values like 100..5000 just does not work.
So I would have a problem to e.g. delete the whole participants table as it would be necessary to delete 50-records-wise.
Is this another bug then?...
Last edit: 9 years 6 months ago by Falk.
The topic has been locked.
  • Falk
  • Falk's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
9 years 6 months ago - 9 years 6 months ago #112311 by Falk
Replied by Falk on topic csv import problems of an excel file
Would there be anybody to at least confirm (or refuse) my problems please ?
I wonder why there is nobody caring this article.

It should be easy for you to reconstruct my processes.
So, can you confirm my problem??...
Last edit: 9 years 6 months ago by Falk.
The topic has been locked.
  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
9 years 6 months ago #112316 by holch
Replied by holch on topic csv import problems of an excel file
One problem is that excel is not following the csv standard, which is comma separated. They invented that comma separated is with a semi-colon. Doesn't make much sense, right?

There have been some problems before with the charset, but I think in the newest versions this shouldn't be a problem anymore and if I recall right the Limesurvey is solving the excel export problem by supporting the non standard semi-colon separation.

I will check with my current version of 2.05, because of course something that worked fine before can have a bug.

I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.

The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
9 years 6 months ago #112396 by DenisChenu
Replied by DenisChenu on topic csv import problems of an excel file
LibreOffice calc is really better than excel ....

But last version have some update for import participant, some bug fix.

AND : most important
- If you think you find a bug : bug report is done for this
- Remind LimeSUrvey is made on our free time
- Remind LimeSurvey forum help is made on our free time.

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose