Welcome, Guest
Username: Password: Remember me

TOPIC: Survey attributes

Survey attributes 7 months 2 weeks ago #99559

  • fredwhite
  • fredwhite's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 3
  • Karma: 0
I have metadata about surveys-- beyond what is in lime_surveys and _language_settings tables-- I need to store somewhere. It's pretty easy to add new question_attributes for questions and store them in the "EAV" table format. How come there is no "survey_attributes" table like there is "question_attributes"?

What do other people do? Is it ok to add columns to the surveys table? I usually avoid this. Maybe add my own survey_attributes table and interface and leave the LS db and core alone?
The administrator has disabled public write access.

Survey attributes 7 months 2 weeks ago #99565

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 5838
  • Thank you received: 714
  • Karma: 222
Hi Fred :).

We have a new table in 2.05 / Plugin system :
id,plugin_id,model,model_id,jey,value

It's done for this .

For a 1.92: best it's to add an column.
The administrator has disabled public write access.

Survey attributes 7 months 2 weeks ago #99588

  • fredwhite
  • fredwhite's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 3
  • Karma: 0
Hi Denis,

I'm using 1.92. I tested adding a couple of fields to lime_surveys and then adding and editing a survey. It seems ok.

To display the fields in LS admin screen, it looks like I'd also need to edit the admin/editsurveysettings.php?


Fred
The administrator has disabled public write access.

Survey attributes 7 months 1 week ago #99600

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 5838
  • Thank you received: 714
  • Karma: 222
Yep,

It's in editsurveysettings.php, and maybe in some other file, but think only here is OK. And for default value, if i remind, there are somewhere all default setting.

Denis
The administrator has disabled public write access.

Survey attributes 7 months 1 week ago #99615

  • fredwhite
  • fredwhite's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 3
  • Karma: 0
Thanks. I'll give it a try.
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.116 seconds
Donation Image