CiviCRM Community Forums (archive)

Hi Guys and Gals,

I created a module that eats CSVs and creates events using the fantabulous API but I'm having an issue:

I have to import and match participants to these events, and since I can't match to custom data "Old Event ID" in the particpation import screen, I was wondering if you guys have any idea how to force Event Id's on the Event Create API Call.

When I try passing something like this, my ID gets ignored.

$params = array(
         'version'=>3,
              'id'=>$data[0],
        'title'=> $data[1],
            'description' => $data[2],
       'event_type_id'=>4,
       'loc_block_id'=>1,
            'start_date'=>$data[3],
            'end_date'=>$data[4],
            'custom_5'=>$data[0],


I understand that mysql has the ID set to autoincrement, but when I tried disabling it for the duration of the import, I wasn't able to renable it in a way that left anything working. :/

While you are having fun with the api (glad you like it , I'd write as well a custom import for the participants

As the first step, fetch all the events (including the custom_ old id) create a table that map oldid (the key) and new id and use it to populate the event_id on api.participant.create

X+