Home Forums Support Invoice import from Pancake only partially working – self hosted

This topic contains 5 replies, has 3 voices, and was last updated by  Hillel Coren 4 weeks, 1 day ago.

Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • #20358

    mikejandreau
    Participant

    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.

    #20359

    mikejandreau
    Participant

    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"} []

    • This reply was modified 9 months, 3 weeks ago by  mikejandreau.
    #20369

    mikejandreau
    Participant

    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.

    #20474

    Hillel Coren
    Keymaster

    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.

    #23024

    arzelia
    Participant

    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.

    #23049

    Hillel Coren
    Keymaster

    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.

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic.

Posted in: