We recently upgraded from LTS 4.6 to 5.3.1 (in July). Via the GUI we can see the Payment Method that we'd like to import -> Moneris -> id=6

enter image description here

Importing with Payment Method:

  • Moneris -> fails: Reason: Payment Instrument is not valid: Moneris
  • 6 -> fails: Reason: Payment Instrument is not valid: 6

What else can I try?


Ok next thing to try is to check the civicrm_option_value table. Note it has a name column (in addition to what you can see in the GUI in 5.3.x). In the old days this name column was exposed and could be set independently: here it was set to Offline Credit Card - Importing with Payment method:

  • Offline Credit Card -> works!

enter image description here

  • could you mark your answer as solved? That might help others as well. – Jaap Jansma - CiviCooP Aug 9 '18 at 9:30
  • SE only lets you accept your own answer in 2days – KarinG - Semper IT Aug 9 '18 at 12:22
  • @KarinG-SemperIT any idea why it is no longer exposed via the gui? – themak Oct 12 '18 at 20:06
  • Not sure if it was intentional or by accident. – KarinG - Semper IT Oct 12 '18 at 23:27

This could also be a translation issue. After upgrading to 5.3.1 we had to change 'Cheque' to 'Check'. Haven't dug into that one yet.

  • 1
    Hi Andrew - I suspect that Translation perhaps changes Label but not Name. The importer definitively appears to match for Name (which is no longer exposed in the GUI) – KarinG - Semper IT Aug 9 '18 at 14:40

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.