- Posts: 14
- Thank you received: 1
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
- Topic Author
- Offline
- New Member
Less
More
8 years 11 months ago #118711
by gbombonato
ADDITIONAL ATTRIBUTES TO BE COLUMNS AT TABLE DATABASE was created 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
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
- Topic Author
- Offline
- New Member
Less
More
- Posts: 14
- Thank you received: 1
8 years 11 months ago #118724
by gbombonato
Replied by gbombonato on topic ADDITIONAL ATTRIBUTES TO BE COLUMNS AT TABLE DATABASE
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
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
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 11746
- Thank you received: 2750
8 years 11 months ago #118732
by holch
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Replied by holch on topic ADDITIONAL ATTRIBUTES TO BE COLUMNS AT TABLE DATABASE
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?
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
- Topic Author
- Offline
- New Member
Less
More
- Posts: 14
- Thank you received: 1
8 years 11 months ago #118736
by gbombonato
Replied by gbombonato on topic ADDITIONAL ATTRIBUTES TO BE COLUMNS AT TABLE DATABASE
Thank you for your answer
Easy and elegant
I said i dont know how make additional attribute fields be saved at results table.
Easy and elegant
I said i dont know how make additional attribute fields be saved at results table.
The topic has been locked.
- holch
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 11746
- Thank you received: 2750
8 years 11 months ago #118737
by holch
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Replied by holch on topic ADDITIONAL ATTRIBUTES TO BE COLUMNS AT TABLE DATABASE
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.
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.