ADDITIONAL ATTRIBUTES TO BE COLUMNS AT TABLE DATABASE

More
2 years 7 months ago #118711 by gbombonato
gbombonato created the topic: ADDITIONAL ATTRIBUTES TO BE COLUMNS AT TABLE DATABASE
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

Please Log in to join the conversation.

More
2 years 7 months ago #118724 by gbombonato
gbombonato replied the 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

Please Log in to join the conversation.

More
2 years 7 months ago #118732 by holch
holch replied the 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?

I'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
Some helpful links: Manual (EN) | Question Types | Workarounds

Please Log in to join the conversation.

More
2 years 7 months ago #118736 by gbombonato
gbombonato replied the 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.

Please Log in to join the conversation.

More
2 years 7 months ago #118737 by holch
holch replied the 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.

I'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
Some helpful links: Manual (EN) | Question Types | Workarounds

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!