Error on CSV Transaction Import

Currently running v5.6.18-W121
image

Getting an error when importing a CSV into transactions. Its a simple CSV, just Date, Amount and Description. Tried to import via Firefox, Chrome and Windows Desktop app. All giving me the same error. The error gets sent to me via email in the form of a successful import message saying the following records were skipped, and every single record is in the list of skipped record all for the same reason.

{“transaction.date”:“Date from CSV”,“transaction.amount”:“-Amount From CSV”,“transaction.description”:“Description from CSV”,“transaction.bank_integration_id”:“HTTP/1.0 400 Bad Request\r\nCache-Control: no-cache, private\r\nContent-Type: application/json\r\nDate: Sat, 15 Jul 2023 11:35:02 GMT\r\n\r\n{"error":"Invalid primary key"}”}

[“The selected bank integration id is invalid.”]

I only have one bank setup on this company in Invoice Ninja and its primary key seems to be fine in the SQL database from what i can see. I’m at a loss for whats going on. Any ideas?

Sorry, fixed it. If anyone is getting this, i was getting this as my Web PHP version and CLI PHP version is mismatched. I had it this way as after upgrading to PHP 8.2 ages ago, some of the extensions to enable FPM for invoice ninja didnt have 8.2 variants yet so i left it on 8.1. Didnt cause an issue up until now. Change the FPM version over in my Apache config and installed the relevant dependencies. After that Import went through fine.

image

Glad to hear it’s working, thanks for sharing the solution!