Welcome, Guest
Username: Password: Remember me

TOPIC: Export to Applications - Field Names

Export to Applications - Field Names 2 years 4 months ago #76924

  • alpurdon
  • alpurdon's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 5
  • Karma: 0
The export to Excel the column/field names should include any special chaacters, which ok for Excel, but the Excel file is the imprt to Access, they aren't valid field names and get converted to a generic 'Fieldn' name.

Thanks
The administrator has disabled public write access.

Aw: Export to Applications - Field Names 2 years 4 months ago #76936

  • Steve
  • Steve's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 494
  • Thank you received: 46
  • Karma: 17
Hello,

sorry, I don't understand your idea or problem. Can you explain it again and give an example what is wrong or what should be done?
Mit freundlichen Grüßen/Best regards,

Stefan Gohlke
LimeSurvey Team
The administrator has disabled public write access.
The following user(s) said Thank You: DenisChenu

Re: Export to Applications - Field Names 2 years 4 months ago #76963

  • alpurdon
  • alpurdon's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 5
  • Karma: 0
Attached is an Export to Excel with abbreviated headings and convert spaces to underscore. MS Access and most apps don't usually accept special char as fields names. Thus, choosing first row as field names has that condition. []../\ and others aren't acceptable field name chars.

This isn't uncommon, I've other exporting apps that present the same challenge.

Thanks and Hopefully I've sxplained better.

Al
Attachments:
The administrator has disabled public write access.

Re: Export to Applications - Field Names 2 years 4 months ago #76980

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 6236
  • Thank you received: 794
  • Karma: 238
Hello,
It's an excel export, not an access export ;).

You can : change the header title in excel before inporting in acces. Use question code and not question ext when exporting.
The administrator has disabled public write access.

Re: Export to Applications - Field Names 2 years 4 months ago #77001

  • alpurdon
  • alpurdon's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 5
  • Karma: 0
Thanks, but the attached file with questions codes has the same result. And why would I want to edit 27 colums each time I want to export and process results??

Thanks, again
The administrator has disabled public write access.

Re: Export to Applications - Field Names 2 years 4 months ago #77003

  • alpurdon
  • alpurdon's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 5
  • Karma: 0
Here's the attachment, forgot to zip in prev msg

Thanks
Attachments:
The administrator has disabled public write access.

Aw: Re: Export to Applications - Field Names 2 years 4 months ago #77727

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5302
  • Thank you received: 291
  • Karma: 247
The Excel export was never designer to be imported at MS Access, so I don't consider this a bug because it works fine at Excel.

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)limesurvey.org'"
The administrator has disabled public write access.
Time to create page: 0.124 seconds
Donation Image