Hello, I have ~240 selectable categories that users will be selecting using a multicheckbox. I created the field however, I do not plan on hand entering all 240 entries. I also ran into a similar issue creating a state drop down box however, I did actually enter in all the states by hand.

I created the following query to see the drop down values:

Select a.*
from jos_comprofiler_field_values a, jos_comprofiler_fields b
where a.fieldid = b.fieldid and a.fieldid = 78

This is where 78 is the fieldid of the multicheckbox. It shows the 2 values I entered in by hand.

Without breaking anything can I just insert values into jos_comprofiler_field_values table? I am not very familiar with MySQL will fieldvalueid autoincrement?

1.) Am I going to break something or asking for trouble?
2.) Can we get importing values implemented on the front end in a future release?

Post edited by: krileon, at: 2010/03/15 18:53

In case you haven't solved this already...

If you have your 240 entries in, say, an Excel-spreadsheet or Open Offic Calc, you might want to do it with JIX. That way you won't have to type the names of each of your selectable categories if they already exist somewhere else.

Post edited by: palmqviststefan, at: 2010/03/16 22:45