Body: <p>Hope you are all keeping well in this strange times!</p>
  <p>We are currently trying to import some contributions in into the system from a CSV file (updating) but can't get past an error that is coming up. The error is coming up for all the records we are trying to import - Invalid value for field(s) : field ID;</p>
  <p>Currently we are mapping the contacts External ID number to Contribution ID when running the import so could this be causing the problem.
  As these contributions are new contributions (to existing donors with the system) why does contribution ID / Invoice ID / Transaction ID need to be a required field.
  Currently the csv only only contains the External ID as the URN.</p>
  <p>Any held would really be appreciated.</p>
  <p>Many thanks
  Terry</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-10-01T13:56:33.213Z
Comments.Text: I think if they are new contributions you should use 'Insert new contributions' for the import mode rather than 'Update'. But I may have misunderstood your 'from a CSV file (updating)'.
Comments.UserDisplayName: RebeccaTregenna
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-10-01T15:28:29.427Z
Comments.Text: Hi, thank you for your reply. The contributions are "new" as such, but are from existing donors / contributors that are already held in the system. Hope that makes sense. Should these be classed as new in the import, rather than updating? Many thanks, Terry
Comments.UserDisplayName: TCVTerry
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-10-02T12:52:40.763Z
Comments.Text: Yes, as the 'update' would refer to an existing contribution you are updating, rather than a contact.  So for new contribution there's no 'contribution id' in the system
Comments.UserDisplayName: RebeccaTregenna
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-10-05T09:24:51.987Z
Comments.Text: Thanks Rebecca thats great, all sorted now :)
Comments.UserDisplayName: TCVTerry
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-10-05T12:20:01.763Z
Comments.Text: Great. Glad it's working now.
Comments.UserDisplayName: RebeccaTregenna
Tags: <contributions><data-import>
Title: Importing Contributions - Data errors
ThreadText: # Importing Contributions - Data errors
  
  (Asked by: username_0 on 2020-10-01)
  
  Hope you are all keeping well in this strange times!
  
  We are currently trying to import some contributions in into the system from a CSV file (updating) but can't get past an error that is coming up. The error is coming up for all the records we are trying to import - Invalid value for field(s) : field ID;
  
  Currently we are mapping the contacts External ID number to Contribution ID when running the import so could this be causing the problem.
  As these contributions are new contributions (to existing donors with the system) why does contribution ID / Invoice ID / Transaction ID need to be a required field.
  Currently the csv only only contains the External ID as the URN.
  
  Any held would really be appreciated.
  
  Many thanks
  Terry
  
  **Tags:** contributions, data-import
  
  > **Comments:**
  > **username_1**: I think if they are new contributions you should use 'Insert new contributions' for the import mode rather than 'Update'. But I may have misunderstood your 'from a CSV file (updating)'.  
  > **username_0**: Hi, thank you for your reply. The contributions are "new" as such, but are from existing donors / contributors that are already held in the system. Hope that makes sense. Should these be classed as new in the import, rather than updating? Many thanks, Terry  
  > **username_1**: Yes, as the 'update' would refer to an existing contribution you are updating, rather than a contact.  So for new contribution there's no 'contribution id' in the system  
  > **username_0**: Thanks Rebecca thats great, all sorted now :)  
  > **username_1**: Great. Glad it's working now.  
  
  ---
  
  ## 0 answers
  
  