CiviCRM Community Forums (archive)

I am looking at the config. advice at http://wiki.civicrm.org/confluence/display/CRMDOC/CiviCase+Configuration which is for 2.2 (I had been directed here in another post to configure CiviCase) with the view to adding over 100 case types by SQL. However in the 3.0alphaB this table seems to have many more fields. This implies I cannot use the example given "Insert case types using a SQL script". I'm a little unfamiliar with SQL so I suppose I will have to do this by hand unless there is an example SQL anywhere.

2.2 (taken from above URL) INSERT INTO
`civicrm_option_value` (`option_group_id`, `label`, `value`, `name`, `grouping`, `filter`, `is_default`, `weight`, `description`, `is_optgroup`, `is_reserved`, `is_active`)

3.0 (taken from my actual DB) INSERT INTO
`civicrm_option_value` (`id`, `option_group_id`, `label`, `value`, `name`, `grouping`, `filter`, `is_default`, `weight`, `description`, `is_optgroup`, `is_reserved`, `is_active`, `component_id`, `visibility_id`)

Advice appreciated.

Yes, thanks I did that and came to the conclusion that because I had 3 other values that needed incrementing it would be best just to create each Case Type in the normal way to avoid errors. Then I have to create the individual xml files. Be done soon.