CiviCRM Community Forums (archive)

Hi, we're running CiviCRM 4.2.7 on Drupal 7.

I'm having a problem importing event locations into CiviEvent.  We have over 200 locations for events in a CSV and we'd like to import that list so users can choose from these events ("Use Existing Location") instead of entering these locations as a New Location every time we create an event.

I tried importing the Event Locations via the Address Create API but that process requires a contact_id (for adding Contact Addresses) and other posts in the forum indicate that there is no API-driven way to add Event Locations.

So I wrote SQL to import the locations from CSV into civicrm_address and for each imported address, I added a corresponding record in civicrm_loc_block.  The records in civicrm_address and civicrm_loc_block for my 200+ imported event locations look identical to the 3 event locations that I manually typed in while adding new events (other than the differences in address and city values, of course).

However, when I add a new event and try to select from existing locations ("Use Existing Location"), I'm still only seeing the 3 event locations that I manually added while creating previous events.  None of the 200+ imported event locations are visible in the dropdown.

Is there somewhere else beside civicrm_address and civicrm_loc_block that I need to reference these new Event Locations so that I can choose one of them when adding new events?  Do event locations not show up in the

Thanks for any suggestions you can provide!  -JC