Import with belongsToMany relationship ?

[dgillier]

Hello,

I'm trying to import some data and I have belongsToMany relationships in my Model.
I've got this in my User model :

public function leadershipStatus() { return $this->belongsToMany(LeaderStatus::class); }

I tried this ImportClass model function with ToModel:
($this->leaderships is loaded in a construct function)

$leadership = $this->leaderships->where('name',$row['leadership'])->first();
$user = new User([
            'log_name'              => $row['user_login'],
            'email'                 => $row['user_email'],
            'role'                  => 'User',
           ...
        ]);
            
return $user->leadershipStatus()->attach($leadership);
        

I've got this error:
SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'user_id' cannot be null

It's failing because at this stage there is no id assigned to the record...
(I 'm also using 'WithUpserts')

Any suggestion on how to do that ?
Thanks, Denis

[MicuRobert]

Hi @dgillier,

Did you find a solution for this?

[dgillier]

Nope, just doing a two step process :(

[MicuRobert]

Seems I found a solution in the docs https://docs.laravel-excel.com/3.1/imports/model.html#handling-persistence-on-your-own.

Here is an example based on your question. I leave it here, maybe it will help others in future.

`public function onRow(\Maatwebsite\Excel\Row $row)
{
$row = $row->toArray();

$user = User::firstOrCreate([
    'log_name'              => $row['user_login'],
    'email'                 => $row['user_email'],
    'role'                  => 'User',
   ...
]);

$leadership = $this->leaderships->where('name',$row['leadership'])->first();
$user->leadershipStatus()->attach($leadership);

}`