CiviCRM Community Forums (archive)

Trying to convert historical event transactions by importing text files into civicrm_contribution, civicrm_participant & civicrm_participant_payment via PHPMYAdmin.  Hitting up against foreign key contraints on the contribution table and will probably have issues on the others.

Is it okay to drop the FK constraints on contribution table?  I notice that these fields are getting populated with NULL values via the front-end interface, i.e., when I key an event registration & payment on to a contact record manually, these FKs are not required and set to NULL.

Need to know if I drop these constraints and then reset them after the conversion is done if everything will be A-OKAY?

I agree with you and it's not my favorite modus operandi either but it might save me a day or two of work so I'd like to know what the consequences are.  Is there any documentation re: FK Constraints on the contribution and participant tables?  For example, I know that I am able to import contribution & participant records which are not linked to a contribution_page_id via the Import Interface and it sets the contribute_page_id value to null in the contribution table.  This is a FK constraint so I cannot import a NULL into this field and yet the system is obviously dropping this constraint in order to create the contribution record.

I also know that since I cannot link the contribution to the participant record via the interface, I imported the transaction id to both the contribute and the participant record and then created a text file with the contribute_id & participant_id and loaded the participant_payment table to create the link between the 2 records.  I've done this for 3 years worth of event history with no issues but it is extremely time-consuming and I'm out of time so I'm looking for a way to speed up the process.

Is there anyone out there who has run a conversion by dropping FK constraints and loading the tables directly via PHPMyAdmin?