Willkommen, Gast
Benutzername: Passwort: Angemeldet bleiben:

THEMA: Export to Applications - Field Names

Export to Applications - Field Names 2 Jahre 6 Monate her #76924

  • alpurdon
  • alpurdons Avatar
  • OFFLINE
  • Fresh Lemon
  • Beiträge: 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
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Aw: Export to Applications - Field Names 2 Jahre 5 Monate her #76936

  • Steve
  • Steves Avatar
  • OFFLINE
  • LimeSurvey Team
  • Beiträge: 494
  • Dank erhalten: 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
Der Administrator hat öffentliche Schreibrechte deaktiviert.
Folgende Benutzer bedankten sich: DenisChenu

Re: Export to Applications - Field Names 2 Jahre 5 Monate her #76963

  • alpurdon
  • alpurdons Avatar
  • OFFLINE
  • Fresh Lemon
  • Beiträge: 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
Anhang:
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Re: Export to Applications - Field Names 2 Jahre 5 Monate her #76980

  • DenisChenu
  • DenisChenus Avatar
  • OFFLINE
  • Moderator Lime
  • Beiträge: 6334
  • Dank erhalten: 818
  • Karma: 243
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.
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Re: Export to Applications - Field Names 2 Jahre 5 Monate her #77001

  • alpurdon
  • alpurdons Avatar
  • OFFLINE
  • Fresh Lemon
  • Beiträge: 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
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Re: Export to Applications - Field Names 2 Jahre 5 Monate her #77003

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

Thanks
Anhang:
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Aw: Re: Export to Applications - Field Names 2 Jahre 5 Monate her #77727

  • Mazi
  • Mazis Avatar
  • OFFLINE
  • LimeSurvey Team
  • Beiträge: 5325
  • Dank erhalten: 296
  • Karma: 249
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'"
Der Administrator hat öffentliche Schreibrechte deaktiviert.
Ladezeit der Seite: 0.142 Sekunden
Donation Image