The LimeSurvey Fund-Raiser 2012 is complete. Thank you for donating a total of 25,000 USD!     List of donors »

Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Customize table names

Customize table names 2 months 2 weeks ago #93125

  • arto78
  • arto78's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 4
  • Karma: 0
Hi guys.
I'm new to this so excuse my ignorance :)

Is it possible to explicitly say what my table name should be in the database before actually creating it? The same question goes for column names :)

For instance if I have a question 'What is you name?' I want to be able to have a column 'Name' in my table where the answer is stored.
Thanks in advance!
Last Edit: 2 months 2 weeks ago by arto78. Reason: Not precise enough
The administrator has disabled public write access.

Customize table names 2 months 2 weeks ago #93132

  • holch
  • holch's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 1972
  • Thank you received: 156
  • Karma: 80
why would you need something like that in the database? LS needs to create it's own tables automatically.

However, the results output usually has headers like you require. I assume it is not important to have the columns of the mysql database name, but the output in excel or csv, right?
Have a look at the manual! It is a really valuable source for information. Here some helpful links:
Manual (EN) | Question Types | Question Attributes | Workarounds

If you found this answer helpful and it saved you some time please consider a donation to the project to keep Limesurvey going!
The administrator has disabled public write access.

Customize table names 2 months 2 weeks ago #93138

  • arto78
  • arto78's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 4
  • Karma: 0
Thanks for the response.

It's mostly for aesthetics.

With the example I gave before the answers are stored in a column called something like 'EXK3X2'.

I am not interested in those columns LS generates by default. Only those that are generated specifically from my questions.
The administrator has disabled public write access.
  • Page:
  • 1
Moderators: DenisChenu, ITEd
Time to create page: 0.161 seconds
Donation Image