Import Contribution Fails - Financial Type

Question

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?

KarinG - Semper IT · Accepted Answer · 2019-05-07 20:54:09Z

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.

answered May 7 '19 at 20:54

14.2k1 gold badge9 silver badges43 bronze badges

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

| show 3 more comments

1 Answer 1