So here is the first row (edited) of the import

So it seems to me there are ONLY 5 pieces of usable info in there

• Amount - 'gross'
• Currency 'currency',
• Entry date - date
• posted time - settlement date
• Bank Reference - gateway_txn_id

(we can also map 'Account Name' => 'gateway_account', - but it's always the same so it's not really useful from what I can see)

Is the 'Amount' in the original currency? I'm guessing it is & we need to covert to USD?

It looks like JP Morgan adds these defaults

'contact_type' => 'Individual',
  'direct_mail_appeal' => 'White Mail',
  'email' => 'nobody@wikimedia.org',
  'gateway' => 'jpmorgan', **(change to citibank)**
  'gift_source' => 'Community Gift',
  'no_thank_you' => 'No Contact Details',
  'payment_instrument' => 'JP Morgan EUR',  *(*Change to citibank)**
  'restrictions' => 'Unrestricted - General',

Do they all look good?
-I think we could add a CitiBank payment instrument - not sure we need one by currency?

• I also think we should add a CitiBank contact - JPMorgan is just creating tonnes of Anonymous contact I think maybe just one for all these Citibank peeps?

@LeanneS - any thoughts on any of the above?

Also we actually HAVE a citibank import - does this REPLACE that - or is there going to be 2 - the other seems to be for Orgs

Here is what is different

Column name changes
Global Reference Number ->Bank Reference
Date Posted -> Posted Time
Date Received -> Entry Date

• Columns not present **

Originator Name

Existing Defaults

'contact_type' => 'Organization',
'contact_source' => 'citibank import',
'gateway' => 'citibank',
'gift_source' => 'Community Gift',
'no_thank_you' => 'No Contact Details',
'payment_instrument' => 'Citibank International',
'restrictions' => 'Unrestricted - General',
'currency' => 'USD',

Change 494851 had a related patch set uploaded (by Eileen; owner: Eileen):
[wikimedia/fundraising/crm@master] Add Citibank import for individuals

https://gerrit.wikimedia.org/r/494851

@Eileenmcnaughton thanks, these look great. Some comments to your questions are below!

Amounts are in original currency and need to be converted.

The only other default I'd change besides the ones you've already suggested would be:

'gift_source' => 'Benefactor gift', if amount is over $1,000

I think we can have just one Citibank payment instrument and one Citibank contact that these all attach to when imported.

The other Citibank import isn't currently in use and for a different account. It was created when Finance switched over our accounts, but many of the wires that go into that other account are matching gifts that need to manually entered by Engage with soft credit info.

I just put this on staging - seems to be working OK

Thanks! I just tested and overall is working well. I imported the September tab and 1 of them was rejected as a duplicate. Could it be because there were 2 donations of the same amount?

Hi @LeanneS - it looks like we should be using the Bank Reference to detect duplicates. Can you check to see if that's unique across all the September rows?

@LeanneS, I see the problem with September's sheet now - there's a column with no header, duplicating the amounts, right before the column with header 'Bank Reference'. So that column's values are getting interpreted as the bank reference

Can you delete the ones from that import and try again with that column given a header or deleted?

Change 494851 merged by jenkins-bot:
[wikimedia/fundraising/crm@master] Add Citibank import for individuals

https://gerrit.wikimedia.org/r/494851

@Ejegg Oh interesting! It Looks like Finance added that in by accident. I'll test again.

Okay the latest test was a success!

I just deployed this - it looks like you worked with @Ejegg already to resolve issues so I'm assuming all is good now? Give it a whirl on live

@Eileenmcnaughton I attempted the same files on Live but it's giving me an error message: "This page isn’t working civicrm.wikimedia.org is currently unable to handle this request.
HTTP ERROR 500"

Might have been the install script not run yet - I just ran it and it created a new contact.

@Ejegg That worked! One thing I noticed is that the contacts all show under the contact "Citibank" rather than "Citibank Import." Not sure if that matters, but wanted to flag. :)

Thanks for getting this import created!

@Ppena @MBeat33 The Citibank donations are now in Civi!

@LeanneS I think I proposed Citibank import & then changed the name during coding? It's not a problem from our end the name

Okay great! Then I think we're all set. :) Thanks @Eileenmcnaughton.

@LeanneS shall we close it?

Close away!