Alban Posts - Answer Overflow

Alban

•Created by Alban on 11/11/2024 in #❓┊help

Import action, unsetting columns not working

I am using the import functionality, but I am facing some problems with the Import columns I need to add 2 columns that are not related with the model because I have some extra logic in the beforeSave that i want to implement but I am getting error:

[2024-11-11 11:54:13] local.ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'start_year' in 'field list' (Connection: mysql, SQL: insert into `codes`

[2024-11-11 11:54:13] local.ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'start_year' in 'field list' (Connection: mysql, SQL: insert into `codes`

I thought that with the unset I would be able to fix it, but it seems I was wrong.

   public function beforeSave(): void
    {
        // do some extra logic here with start and stop year columns


        // Remove start_year and stop_year from $this->data
        unset($this->data['start_year'], $this->data['stop_year']);

    }

   public function beforeSave(): void
    {
        // do some extra logic here with start and stop year columns


        // Remove start_year and stop_year from $this->data
        unset($this->data['start_year'], $this->data['stop_year']);

    }

These are the columns:

public static function getColumns(): array
    {
        return [
            ImportColumn::make('code')
                ->requiredMapping()
                ->rules(['required', 'max:255']),
            ImportColumn::make('brand')
                ->requiredMapping()
                ->rules(['required', 'max:255']),
            ImportColumn::make('part')
                ->requiredMapping()
                ->relationship()
                ->rules(['required']),
            ImportColumn::make('start_year')
                ->label('Start Year')
                ->rules(['nullable', 'max:4']), // Optional since it's only for CarModel
            ImportColumn::make('stop_year')
                ->label('Stop Year')
                ->rules(['nullable', 'max:4']), // Optional since it's only for CarModel
        ];
    }

public static function getColumns(): array
    {
        return [
            ImportColumn::make('code')
                ->requiredMapping()
                ->rules(['required', 'max:255']),
            ImportColumn::make('brand')
                ->requiredMapping()
                ->rules(['required', 'max:255']),
            ImportColumn::make('part')
                ->requiredMapping()
                ->relationship()
                ->rules(['required']),
            ImportColumn::make('start_year')
                ->label('Start Year')
                ->rules(['nullable', 'max:4']), // Optional since it's only for CarModel
            ImportColumn::make('stop_year')
                ->label('Stop Year')
                ->rules(['nullable', 'max:4']), // Optional since it's only for CarModel
        ];
    }

3 replies

Gaming

Programming