CiviCRM Community Forums (archive)

can u be more specific? I dont think it should make too much of a difference whether its drupal or joomla. you can get on IRC and we can chat further there

lobo

Nevermind, I was able to figure out how to do that by digging through the code. This post can be closed.

Basically I was looking for a way to import a custom option that was multiselect and had 100s of options. As I didn't really want to enter each one by hand (the admin interface is pretty clunky for large amounts of data,) I was looking to do this via code or SQL. SQL didn't seem like a great idea as the schema is a bit complex and I don't know it well enough to know 100% I was putting data into all tables that needed it. I then stumbled upon the API for custom options in the wiki. The documentation was ok but lacking, and most of the examples were done in a drupal context. Links to SVN for other testing exampled did not work so I decided to experiment a bit and eventually got the API to work in a Joomla environment.

After I did an import (simple script that took info from a spreadsheet,) I noticed that all of the select options were marked as inactive. The documentation doesn't indicate how to pass in an array of active values so I dug through the API code a bit and discovered the option was there, just not documented. Using the option I found in the code I was able to pass in an array for the is_active column and all worked as I had hoped.