3

Trying to import contributions. The data file has integer for Financial Type. Import fails Error File says: "Financial Type is not valid: 1"

Everything I have read said to enter the Financial Type Id. My data table for Financial Type has IDs 1,2,3,4,5 How can 1 not be valid?

4

We’ve hit this too in the past -> solution is to use the Name of the Financial Type. eg Donation (instead of 1). PS - Also match the case.

| improve this answer | |
  • I followed your suggestion, and the problem was solved. Contrary to the documentation, the Financial Type is the Financial Type Name not the Financial Type ID. Thanks. – Ben Bachrach May 7 '19 at 23:28
  • Exactly - glad it helped you out. – KarinG - Semper IT May 8 '19 at 0:05
  • @BenBachrach - if you've found a bug in the documentation would be great if you can submit an update for that. – Aidan May 8 '19 at 8:22
  • I think it’s even _id in the header of that column in the import_errors csv file – KarinG - Semper IT May 8 '19 at 12:01
  • @Aidan - where do we submit updates for the documentation? – Ben Bachrach May 9 '19 at 7:36

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.