Check out the LimeSurvey source code on GitHub!
Welcome, Guest
Username: Password:

TOPIC: Customize table names

Customize table names 3 years 9 months 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: 3 years 9 months ago by arto78. Reason: Not precise enough
The administrator has disabled public write access.

Customize table names 3 years 9 months ago #93132

  • holch
  • holch's Avatar
  • Online
  • LimeSurvey Team
  • Posts: 5445
  • Thank you received: 814
  • Karma: 240
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 | [url=https://manual.limesurvey.org/Workarounds[/url]

If you found this answer helpful and it saved you some time please consider a [url=https://donate.limesurvey.org[/url] to the...
The administrator has disabled public write access.

Customize table names 3 years 9 months 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.
Time to create page: 0.225 seconds
Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form