CiviCRM Community Forums (archive)

Hi,

I don't know if I'm missing something obvious, but I want to import activities and have them attached to an organisation, but it seems to default to attaching to individuals.   I have a field that matches the strict dedupe rule for orgs but I can't work out how to make the import use this instead of the contact matching fields defined in the strict dedupe rule for individuals.

Any ideas appreciated.

thanks,
Anthony.

Hi Lobo,

Yeah that's what I found out when I looked at CRM/Activity/Import/Parser/Activity.php that is it only supports importing activities and linking to contacts.  Should this be documented somewhere?  I'm not quite sure where it should go.

I thought about doing my own datasource and modifying it, but I think I'm going to use a version of what you did elsewhere and just script my own import.  It's a bit brute force but time constraints require the use of force at times

Thanks,
Anthony.

Hi Lobo,

Yeah thanks, I was using something for what must have been the same project for you (importing student and household records) as a base.  One question I have for my understanding... is there a reason you build up your query to insert an activity rather than using the API call civicrm_activity_create?

Regards,
Malks.

Hi,

The activity api does allow you to add to custom fields - in fact it is one of two apis for which there is a test

However, the format in the (v2) test is pretty non-standard - not sure if it also supports the standard format for custom fields ($params['custom_12']= 'custom data')


        //  Create an activity with custom data
        $params = array(
                'source_contact_id'   => 17,
                'subject'             => 'Discussion on Apis for v2',
                'activity_date_time'  => date('Ymd'),
                'duration'            => 120,
                'location'            => 'Pensulvania',
                'details'             => 'a test activity',
                'status_id'           => 1,
                'activity_name'       => 'Test activity type',
                'custom'              => array( array(
                 array( 'value' => 'bite my test data',
                        'type'  => 'String',
                        'custom_field_id' => 11,
                        'custom_group_id' => 9,
                        'table_name'      => 'civicrm_value_activity_custom_9',
                        'column_name'     => 'activity_custom_11',
                        'is_multiple'     => 0,
                        'file_id'         => null
                        ) ) )
                        );
        $result = civicrm_activity_create( $params );

Hi,

Sure, publish it somewhere (eg. github).

For eileen, yerk, another thing to put back in shape or at least test with custom_xxx. (now on contacts, seems to be custom_xx_yy)

X+

but I don't speak regex so can't scan & check

You should learn it, that's a wonderful tool to create wonderfully complicated to debug problems

X+