CSV export character issues

More
6 days 23 hours ago #206600 by Brettski
Hi,
Loving Lime Survey; I wish to use it to collect new prospect data, which we then wish to export into a custom SQL Server based CRM system that we develop. My developer advises he wishes to work with CSV files rather than the proprietary XML. When we export survey responses in CSV format, the export uses the question descriptions as column headers which often include non-alpha-numeric chars such as commas and slashes etc (which are required for the survey questions, this causes our import to fall over. I appreciate there is an option to export field names only, which gets around this issue, however, the field names are very impossible to map, whereas questions are helpful here. Is there any way to extract the non-A/N chars as part of the export?
Thanks to anyone who can assist.
Brett

Please Log in to join the conversation.

More
6 days 16 hours ago #206647 by DenisChenu
?

CSV export allow Expression manager code for export, i don't understand here.

In API : api.limesurvey.org/classes/remotecontrol...hod_export_responses string $sHeadingType = 'code'

What do you export ?
How do you export ?

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.

Please Log in to join the conversation.

More
6 days 16 hours ago #206649 by Brettski
Thanks DenisChenu,
I wish to export every question and every response into a CSV file. The header/column headers would be the questions with each survey response as a row. The problem is the questions containing special codes are exported as column/field headers in the CSV which breaks the import into SQL.
Thanks

Please Log in to join the conversation.

More
6 days 16 hours ago #206651 by DenisChenu
Ah,

The survey description … maybe look at R syntax export ? Or SPSS syntax export?
You can try with Triple-S syntax export too : extensions.sondages.pro/export-statistic...ase/triple-s-export/ it's a standard format.

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.

Please Log in to join the conversation.

More
6 days 15 hours ago #206657 by holch
Replied by holch on topic CSV export character issues
You can choose to export the whole header including questions or just the question code. The question code, by default can not include anything else than alphanumeric characters.


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

Please Log in to join the conversation.

More
6 days 16 minutes ago #206695 by Brettski
Many thanks however the resultant file is not usable.
It appears CSV is the only std format we can use for MS SQL, I am limited to this. As questions can contain non-A/N chars this will fail unless we use export question codes only, which is not workable due to the ambiguous nature of question codes. The survey tool needs another field at the question level "field description" which would be hidden from the published survey and could contain representative text for export with the response. The export would contain just the field description and responses only, not the Q code or actual survey questions. Lime?

Please Log in to join the conversation.

More
6 days 15 minutes ago #206696 by Brettski
Thanks, however as I included in my original question the code is not usable as it is too ambiguous for mapping purposes.

The survey tool needs another field at the question level "field description" which would be hidden from the published survey and could contain representative text for export with the response. The export would contain just the field description and responses only, not the Q code or actual survey questions. Lime?

Please Log in to join the conversation.

More
4 days 10 hours ago #206778 by holch
Replied by holch on topic CSV export character issues
I don't understand why the question code would be ambiguous. It is you that is setting the question code, and it must be unique per survey. Not sure where the problem is, so I probably can't help any further here.

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

Please Log in to join the conversation.

More
2 days 23 hours ago #206798 by Brettski
Thanks anyway Holch... problem is that the survey creators are different to the mapping people, meaning that we will need to maintain data dictionaries which I would like to avoid. If Lime had another field at the question level, there would be no problem.
Regards,

Please Log in to join the conversation.

More
2 days 23 hours ago #206799 by jelo
Replied by jelo on topic CSV export character issues
I recommend to open a bug report or feature request to make your case about the mapping issue. If you can describe it as a bug, you can raise more awareness ;-) But not sure if that is the case here. From breaking characters to a missing questio field to map users might need some more explanation in the bug/feature report.

The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users

Please Log in to join the conversation.

More
2 days 23 hours ago #206801 by Brettski
Thanks mate

Please Log in to join the conversation.

More
2 days 22 hours ago - 2 days 22 hours ago #206805 by DenisChenu
@holch : he want to export dictionnary of survey, not something other.

I already send 3 way of export dictionnary differnt than core, i really don't see why LimeSurvey core offer another non standard way.

We have
R , used by a lot of people and open source
SPSS : used by a lot of people, not free, but PSPP exist
Triple-S : standard

And more : we already have STATA

If needed a specific way : create a plugin (or ask a partner ) are the best solution.

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.
Last edit: 2 days 22 hours ago by DenisChenu.

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now