Laravel Excel import save filename into database

Asked Sep 06 '22 at 10:50

Active Sep 06 '22 at 10:50

Viewed 70 times

Using maatwebsite plugin to import excel file data into database. But i want save the imported filename also?


class UsersImport implements ToModel, WithHeadingRow
{
    /**
    * @param array $row
    *
    * @return \Illuminate\Database\Eloquent\Model|null
    */
    public function model(array $row)
    {
        return new User([
            "first_name" => $row['first_name'],
            "last_name" => $row['last_name'],
            "email" => $row['email'],
            "mobile_number" => $row['mobile_number'],
            "role_id" => 2, // User Type User
            "status" => 1,
            "password" => Hash::make('password')
        ]);
    }
}```

Pls any one help me to get the FIle name also.
Note(Followed):https://dev.to/techtoolindia/import-excel-file-into-laravel-8-3kif

asked Sep 06 '22 at 10:50

dev1 iyarkaitechlab

In which table do you want to save the filename? On users table on the user record or on another table e.g. imports? – Theofanis Sep 06 '22 at 11:42
In user table and status value is file name . My file name is like placed and training. – dev1 iyarkaitechlab Sep 06 '22 at 15:35
Pls anyone help me to save the file name in DB during import excel sheet? – dev1 iyarkaitechlab Sep 07 '22 at 06:07
https://stackoverflow.com/questions/51572197/how-can-i-pass-parameter-in-the-laravel-excel Followed above link. Problem fixed – dev1 iyarkaitechlab Sep 07 '22 at 06:43

Laravel Excel import save filename into database

0 Answers0