Answers.Body: <p>If you're not using the in core CiviAccounts bits - then changing the financial_type_id is ok. We do lots of retyping (update more specific financial_type_ids ad-hoc) - on projects where we do our own Accounting integration i.e. bypassing the core CiviAccounts.</p>
  
  <p>PS - forgot to note that updating campaign_id should be safe</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-05-24T15:42:41.067Z
Answers.Text: And if there is use (or plan to use) CiviAccounts in the future -- are there other tables that can be updated in a similar way, or do you recommend not touching the tables directly in that case?
Answers.UserDisplayName: Laryn
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-05-24T16:37:38.197Z
Answers.Text: I'd turn it around: only if/when you're going to using CiviAccounts (Financial tables) in future - then write a script that will update/insert all financial bits in all tables in involved - and I urge you to run some consistency/checks as part of that. Especially, if your org has subsequent recurring contributions.
Answers.UserDisplayName: KarinG - Semper IT
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-05-24T15:14:23.003Z
Answers.LastActivityDate: 2016-05-24T15:14:23.003Z
Answers.UserDisplayName: KarinG - Semper IT
Body: <p>When using "Import Contributions > Update Existing Contributions" I can import a Financial Type using the full name of an existing (and active) Financial Type. However, if I try to use the full name of an existing (and active) campaign it does not seem to work consistently. </p>
  
  <p><strong>EDIT</strong> 
  I notice that in the database the <code>civicrm_contribution</code> table has fields for <code>financial_type_id</code> and <code>campaign_id</code> -- <strong>is there any danger in using some SQL directly to populate these values?</strong> (ie. can anyone verify that if I set those IDs correctly in this table, it won't conflict with anything else)</p>
  
Tags: <civicontribute><mysql><civicampaign><sql><financial-types>
Title: Can I change a contribution's values for Financial Type and Campaign directly in SQL without danger?
ThreadText: # Can I change a contribution's values for Financial Type and Campaign directly in SQL without danger?
  
  (Asked by: username_0 on 2016-05-23)
  
  When using "Import Contributions > Update Existing Contributions" I can import a Financial Type using the full name of an existing (and active) Financial Type. However, if I try to use the full name of an existing (and active) campaign it does not seem to work consistently.
  
  **EDIT**
  I notice that in the database the `civicrm_contribution` table has fields for `financial_type_id` and `campaign_id` -- **is there any danger in using some SQL directly to populate these values?** (ie. can anyone verify that if I set those IDs correctly in this table, it won't conflict with anything else)
  
  **Tags:** civicontribute, mysql, civicampaign, sql, financial-types
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2016-05-24. Score: 1
  
  If you're not using the in core CiviAccounts bits - then changing the financial\_type\_id is ok. We do lots of retyping (update more specific financial\_type\_ids ad-hoc) - on projects where we do our own Accounting integration i.e. bypassing the core CiviAccounts.
  
  PS - forgot to note that updating campaign\_id should be safe
  
  > **Comments:**
  > **username_0**: And if there is use (or plan to use) CiviAccounts in the future -- are there other tables that can be updated in a similar way, or do you recommend not touching the tables directly in that case?  
  > **username_1**: I'd turn it around: only if/when you're going to using CiviAccounts (Financial tables) in future - then write a script that will update/insert all financial bits in all tables in involved - and I urge you to run some consistency/checks as part of that. Especially, if your org has subsequent recurring contributions.  
  
  ---
  
  