CiviCRM Community Forums (archive)

Hi!  Am in the midst of a database conversion and I'm wondering if there is any way to import participant records AND create their corresponding contribute records at the same time?  I don't see anything in the Import Participants or Import Contributions which lets me enter the key between the records.

Via the admin interface, I manually added an event transaction and applied the payment to see what records were created in what tables.  Need to confirm that if this has to be done via mysql are these the ONLY 3 tables that I need to update?

civicrm_contribute
civicrm_participant
civicrm_participant_payment

Would prefer a way to do this via the admin interface rather than SQL.  Just trying to figure out the best way to preserve these 8 years of history that I am converting into CiviCRM at the moment.  Please let me know if there is a way to do this.

Thanks,
Annalee

Thanks, Stoob.  What I ended up doing was to import the contribution & participant through the interface and  put a unique id in the transaction id field in the contribution record and the same unique id in the event source field of the participant record.  Once all of the contribute and participant records were in, I exported the civicrm_contribution & civicrm_participant tables out and put them in Access and matched them up to create my civicrm_participant_payment records. I created a file that exactly matched the table but left the ID column blank.  Then I used PhpMyAdmin to import the records into the table and voila! the participant & contribution record were matched up.  Had my data been pristine, I would have preferred running everything through mysql as my host has a 300 record limit on imports.