Error when importing
related question: ❓┊helpHow to get ownerRecord inside RecordImporter?
i upload the csv and all the rows fail. not sure what im missing
csv:
i upload the csv and all the rows fail. not sure what im missing
csv:
name,surname,email,company
eric,mp,em@test.com,Test companyname,surname,email,company
eric,mp,em@test.com,Test companylocal.ERROR: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'attempts' at row 1 (Connection: mysql, SQL: update `jobs` set `reserved_at` = 1717144796, `attempts` = 256 where `id` = 256) {"userId":1,"exception":"[object] (Illuminate\\Database\\QueryException(code: 22003)local.ERROR: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'attempts' at row 1 (Connection: mysql, SQL: update `jobs` set `reserved_at` = 1717144796, `attempts` = 256 where `id` = 256) {"userId":1,"exception":"[object] (Illuminate\\Database\\QueryException(code: 22003)Tables\Actions\ImportAction::make('importContacts')
->importer(ContactsImporter::class)
->options([
'ownerRecordId' => $this->getOwnerRecord()->id
]),Tables\Actions\ImportAction::make('importContacts')
->importer(ContactsImporter::class)
->options([
'ownerRecordId' => $this->getOwnerRecord()->id
]),<?php
namespace App\Filament\Imports;
use App\Models\Contact;
use App\Models\EventContact;
use Filament\Actions\Imports\ImportColumn;
use Filament\Actions\Imports\Importer;
use Filament\Actions\Imports\Models\Import;
class ContactsImporter extends Importer
{
protected static ?string $model = Contact::class;
public static function getColumns(): array
{
return [
ImportColumn::make('name')
->requiredMapping()
->rules(['required', 'max:255']),
ImportColumn::make('surname')
->requiredMapping()
->rules(['required', 'max:255']),
ImportColumn::make('email')
->requiredMapping()
->rules(['required', 'max:255', 'email']),
ImportColumn::make('company')
->requiredMapping()
->rules(['required', 'max:255']),
];
}
public function resolveRecord(): ?Contact
{
$contact = Contact::firstOrNew([
'email' => $this->data['email'],
]);
EventContact::updateOrCreate([
'contact_id' => $contact->id,
'event_id' => $this->options['ownerRecordId'],
]);
return $contact;
}
}<?php
namespace App\Filament\Imports;
use App\Models\Contact;
use App\Models\EventContact;
use Filament\Actions\Imports\ImportColumn;
use Filament\Actions\Imports\Importer;
use Filament\Actions\Imports\Models\Import;
class ContactsImporter extends Importer
{
protected static ?string $model = Contact::class;
public static function getColumns(): array
{
return [
ImportColumn::make('name')
->requiredMapping()
->rules(['required', 'max:255']),
ImportColumn::make('surname')
->requiredMapping()
->rules(['required', 'max:255']),
ImportColumn::make('email')
->requiredMapping()
->rules(['required', 'max:255', 'email']),
ImportColumn::make('company')
->requiredMapping()
->rules(['required', 'max:255']),
];
}
public function resolveRecord(): ?Contact
{
$contact = Contact::firstOrNew([
'email' => $this->data['email'],
]);
EventContact::updateOrCreate([
'contact_id' => $contact->id,
'event_id' => $this->options['ownerRecordId'],
]);
return $contact;
}
}