No field matches populate when importing a csv

[rguttersohn]

I am sure I've missed a step somewhere. When I drag and drop the csv file, it uploads correctly, but the corresponding fields do not populate with the fields from the csv file.

I am using:

• filament:3.0-stable
• filament-import:2.0.1-beta
• Laravel:10x

For this example, I have a table called Posts with three columns: id (auto increment), title, author.

Here is my ListPosts.php file:

namespace App\Filament\Resources\PostResource\Pages;

use App\Filament\Resources\PostResource;
use Filament\Actions;
use Filament\Resources\Pages\ListRecords;
use Konnco\FilamentImport\Actions\ImportAction;
use Konnco\FilamentImport\ImportField;

class ListPosts extends ListRecords
{
    protected static string $resource = PostResource::class;

    protected function getHeaderActions(): array
    {
        return [
            ImportAction::make()
                ->fields([
                    ImportField::make('title')
                        ->required(),
                    ImportField::make('author')
                        ->required(),
                ])
            ];
    }

  
}

When I manually update the table using the form, the data is saved accordingly.

The closest issue I found was here where a user was getting an error that I also received when I tried to see if uploading an xlsx file would work. Not sure if the issues are related.

Here is my config file:

return [
    'accepted_mimes' => [
        'application/vnd.ms-excel',
        'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',
        'text/csv',
        'text/plain',
        'csv',
        'txt',
        'application/csv'
    ],
    'temporary_files' => [
        'disk' => 'local',
        'directory' => 'filament-import',
    ],
];

[rguttersohn]

More details:

I've confirmed the csv files are saving under store/app/filament-import.

Here is what I see after uploading a file:

[adriaardila]

After some investigating, I found that the files are being uploaded to storage/framework/caches/laravel-excel and sometimes storage/app/filament-import and storage/app/livewire-tmp.

The files in /laravel-excel are -- for some reason -- saving as blank txt files. Could this be the issue? I cannot figure out why they are being saved as txt AND are blank.

Or are the files suppose to be in /filament-import or /livewire-tmp? Which directory do I need to pay attention to when it comes to filament-import?

Can you test if the 2.0.0-beta version works for you? If it does it means the PR i did fixing remote disk uploads like S3 broke something for local uploads so it should be an easy fix.

[rguttersohn]

I switched to 2.0.0-beta and it's still not working.

I also created a new table and new filament resource for the table and now I am getting an error saying "Maatwebsite \ Excel \ Exceptions \ NoTypeDetectedException".' I am new to Laravel and am having a hard time reading the errors to figure out where it's coming from.

I deleted all of the temporary files from /filament-import, /livewire-tmp and framework/cache/laravel-excel to see what happens when I attempt an import. They are saved under filament-import AND laravel-excel. However, the laravel-excel files are convert from csv to txt files and are blank. The ones saved in filament-import look good to me.

I wonder if my issue is more of a config issue than something up with the package version. I just don't know where to turn to address this. Could using docker be causing the issue?

[rguttersohn]

OK didn't see the dropdown for vendor frames. Here is where the exception is being thrown from vendor / maatwebsite / excel / src / Factories / ReaderFactory.php : 84

private static function identify(TemporaryFile $temporaryFile): string

    {

        try {

            return IOFactory::identify($temporaryFile->getLocalPath());

        } catch (Exception $e) {

            throw new NoTypeDetectedException(null, null, $e);

        }

    }

That to me reads like its a config issue and that php is not obtaining the localpath to my temporary file.

[adriaardila]

Okay, the thing you mention about the laravel-excel files being blanks happened to me too and in my case it was because the library was looking for the livewire-tmp folder in my local storage, even when I had it setup to s3. Did you change anything in your livewire.php config?

Try setting it like this:

'temporary_file_upload' => [
        'disk' => 'local',        // Example: 'local', 's3'              | Default: 'default'
        'rules' => null,       // Example: ['file', 'mimes:png,jpg']  | Default: ['required', 'file', 'max:12288'] (12MB)
        'directory' => 'livewire-tmp',   // Example: 'tmp'                      | Default: 'livewire-tmp'
        'middleware' => null,  // Example: 'throttle:5,1'             | Default: 'throttle:60,1'
        'preview_mimes' => [   // Supported file types for temporary pre-signed file URLs...
            'png', 'gif', 'bmp', 'svg', 'wav', 'mp4',
            'mov', 'avi', 'wmv', 'mp3', 'm4a',
            'jpg', 'jpeg', 'mpga', 'webp', 'wma', 'ttf'
        ],
        'max_upload_time' => 5, // Max duration (in minutes) before an upload is invalidated...
    ],

Then, when you upload the xlsx or csv, make sure it's actually uploaded in the livewire-tmp local folder, if it is not there then the importer won't find the file since it looks for the tmp file stored by livewire.

Also check that permissions in the folder are correct and files can be written to it

[adriaardila]

I just tested it and indeed I broke something with the last PR, let me fix it and make a PR

[adriaardila]

Just made a PR to fix this issue with local disks, apparently my last PR fixing s3 broke not remote disks.

Tested it with local disk as well as s3 disk and all tests passing, so it should be fine now

#125

[rguttersohn]

Great. Your PR fixed my issue.