Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

ADDITIONAL ATTRIBUTES TO BE COLUMNS AT TABLE DATABASE

  • gbombonato
  • gbombonato's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
8 years 11 months ago #118711 by gbombonato
I am doing a survey not anonymous
So, i create additional attributes for codes list: attribute_1 and attribute_2
I made a list with this header:
firstname,lastname,email,token,attribute_1,attribute_2
Mary,Poppins,mary@bol.com,tokmary,name1,name2
and insert many other records at this csv list

After i import this list, and all ok
I see all these fields populated by data from csv file:
firstname,lastname,email,token,attribute_1,attribute_2

But i see LimeSurvey create at database table for this survey, only fields
firstname,lastname,email,token
and populate with correct values of completed surveys

Table database dont show fields attribute_1,attribute_2
Can i do something for these fields be columns at database table?
And get correct values from surveys, same it do for fields firstname,lastname,email,token
This is important to do filters with the full set of answers

Thank You
The topic has been locked.
  • gbombonato
  • gbombonato's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
8 years 11 months ago #118724 by gbombonato
I found one solution
I create a EQUATION field with name atrib1 and i insert {TOKEN:ATTRIBUTE_1}
So, i save value of attribute_1 and any other additional attributes
The topic has been locked.
  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
8 years 11 months ago #118732 by holch
You actually don't need to save the token attributes in the results table. When exporting results, you can mark that you want the token attributes joined into the results table and they are then available for analysis as well.

Do you say that the custom attributes are not available for export?

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

The topic has been locked.
  • gbombonato
  • gbombonato's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
8 years 11 months ago #118736 by gbombonato
Thank you for your answer
Easy and elegant

I said i dont know how make additional attribute fields be saved at results table.
The topic has been locked.
  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
8 years 11 months ago #118737 by holch
When you go into "Responses & statistics" of your survey, you should be able to export results to different formats. There is also the option to include token information in the export.

You can make a few adjustments to what is to be exported.

On the bottom right there is a box that says "token control". There you can choose which of the token attributes should be included into your results file. I hope this helps.

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

The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose