laravel-ex | Laravel Example for OpenShift | Cloud library

I'm trying to use the import funtionality of Laravel excel, but it always return the Route: undefined error even if the route is registered. Please see my code, and details below.

web.php

I have a csv file with data inside. I want import it to my database. If there's repeated data in csv file, I don't want it to create new repeated records, what I want is to update it.

But the problem is, it's creating new repeated records.

Controller (abbreviated):

I was trying to import csv file using Laravel-Excel 3.1. In the csv file have a date column and it's format is 'dd/mm/yy', example - "24/07/20". I am using ToModel method. How can I save intu the database in format of "yyyy/mm/dd", exaple - "2020/07/24". My code is as followed.

I'm currently working on a Laravel project using the Laravel-Excel package.

It is working fine, except for a use case i'm trying to solve I'm trying to solve for a few hours now.

Each CSV files I'm reading begins with the Heading Rows, and that's particularly practical, but some of my CSV Files begin with annotations like #CSV DD V2.4.3 at row 1 followed by the Heading Rows at row 2.

So, I need to find out how to determine the real line where the heading rows are located to avoid that unwanted line. I especially need to make it work in the headingRow() method implemented by the WithHeadingRow interface. is there a way t grab lines from the csv file to determine the correct heading row line ?

Hope you'll find out , thanks in advance

I am trying to export records to a CSV which queries a relation but my file keeps returning nothing but the headings.

I am making use of the laravel-excel package to do this.

Controller Method

I am using the ready package as a base, I have done all steps in the readme.md file and was able to login as "einstein" user. So all seems to be configured correctly.

Later I have changed the credentials for the ldap server, which is using Active Directory.

While runing command php artisan ldap:test i receive message that i was able to connect correctly. Laravel logs says the same, but I cannot log in to laravel app. While running the command php artisan ldap:import ldap get message that no users where find

In the log file i see something like this:

maybe is a problem with a simple solution, but i have a few hours trying to figure out. Sorry for my bad english...

I have a project that manage Products, Clients, Orders, Currencies and other things, the most important thing here is the Product's operations with the database, i use Laravel 8 with Maatwebsite/excel package to manage imports of xlsx files with all the information about products.

The process of import the file is working perfectly, i have a ProductObserver file that triggers events only when i use the CRUD, the problem is that these events do not trigger when the import occurs.

I'll post all the files that i consider relevant for the process.

ProductObserver.php

I am curious how can I know when a queued job completed successfully to potentially notify the relevant user, if they choose to receive notifications.

Specifically I am working with a Laravel Excel export with the ShouldQueue trait. It includes a handy method to handle failed jobs, so I can notify the user on failure if needed (see https://docs.laravel-excel.com/3.1/exports/queued.html#handling-failures-in-queued-exports). I'm assuming there isn't some success method that is either undocumented, or documented where I am not finding it, so....

Is there a way to use Laravel's queuing system to detect when a job is finished? Even if I don't truly know the status (success or fail) and I only know the job is done, I could check for the existence of the export file to confirm it was successful to trigger notification.

Thanks.

This is my blade Looks like :