csv import problems of an excel file

More
3 years 1 month ago - 3 years 1 month ago #112247 by Falk
Falk created the topic: csv import problems of an excel file
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: 3 years 1 month ago by Falk.

Please Log in to join the conversation.

More
3 years 1 month ago #112253 by Falk
Falk replied the 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.

Please Log in to join the conversation.

More
3 years 1 month ago #112256 by Falk
Falk replied the 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).

Please Log in to join the conversation.

More
3 years 1 month ago - 3 years 1 month ago #112260 by Falk
Falk replied the 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: 3 years 1 month ago by Falk.

Please Log in to join the conversation.

More
3 years 1 month ago - 3 years 1 month ago #112311 by Falk
Falk replied the 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: 3 years 1 month ago by Falk.

Please Log in to join the conversation.

More
3 years 1 month ago #112316 by holch
holch replied the 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'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
Some helpful links: Manual (EN) | Question Types | Workarounds

Please Log in to join the conversation.

More
3 years 1 month ago #112396 by DenisChenu
DenisChenu replied the 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 (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now