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

This topic contains 3 replies, has 2 voices, and was last updated by  Hillel Coren 4 months, 3 weeks ago.

Viewing 4 posts - 1 through 4 (of 4 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 5 months, 1 week 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.

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

You must be logged in to reply to this topic.

Posted in: