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!

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.

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).

...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?...

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??...

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.

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.