Invoice import from Pancake only partially working - self hosted

Self-Hosted | v4/Legacy
1

I have a few hundred invoices I’m trying to import from Pancake, most are failing with the error " The following records failed to import, they either already exist or are missing required fields."

I deleted all invoices prior to importing, so I know it’s not an existing invoice issue.

What fields would be required? Also, if they were required, wouldn’t the import fail on all of them, given Pancake has them all formatted in the same manner?

I’m self hosting on v 4.5.12. No errors are being logged in the laravel-error.log file at all.

2

I tried reimporting and got an error in laravel-error.log

[2019-04-08 20:15:23] production.ERROR: Symfony\Component\HttpKernel\Exception\MethodNotAllowedHttpException [405] : …/vendor/laravel/framework/src/Illuminate/Routing/RouteCollection.php [Line 251] => {"context":"PHP","user_id":0,"account_id":0,"user_name":"","method":"GET","user_agent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.86 Safari/537.36","locale":"en","ip":"98.110.233.39","count":1,"is_console":"no","is_api":"no","db_server":"mysql","url":"import"} []

3

We found the error:

Pancake exports the name of the Client as: FIRST LAST - COMPANY NAME

But importing the Invoices looks for the Client name as just FIRST LAST.

It would be super helpful if the error output cited this, instead of just the generic error in my original post.

4

Sorry for the late response, my email notification was in my spam folder.

I agree, we plan to rework the import feature and improve the error messages in v2.

5

I also just imported from Pancake. The first last name for mine works fine. Just that all the resulting address fields is empty. Might be because Pancake’s Address is a single multi-line field, but in InvoiceNinja it is multiple fields of Street, Apt/Unit, City, etc.

6

Thanks for posting! That would explain it, the app is expecting separate fields.

I think you’d need to pre-process the CSV file in Excel to fix it.