Error while importing excel on server

[HarshitTotuka-CL]

I am getting this issue on excel file import on web server. But this is working fine on local server.

No ReaderType or WriterType could be detected. Make sure you either pass a valid extension to the filename or pass an explicit type.

code i have used:

<?php

namespace App\Http\Controllers;

use App\Http\Requests\SettingRequest;
use App\Imports\DriverImport;
use App\Imports\OrderImport;
use Aws\S3\Exception\S3Exception;
use Aws\S3\S3Client;
use Illuminate\Support\Facades\DB;
use Maatwebsite\Excel\Facades\Excel;

class S3Controller extends Controller
{
    public function importFile(SettingRequest $request)
    {
        $importType = $request->input('import_type');
        $dispatcherId = $request->input('dispatcher_id');
        $filePath = $request->input('file_path'); // S3 file path

        if ($importType === 'driver') {
            $import = new DriverImport($dispatcherId);
        } elseif ($importType === 'order') {
            $import = new OrderImport($dispatcherId);
            DB::table('orders')->truncate();
            // DB::table('orderassignemts')->truncate();
        } else {
            return response()->json(['error' => 'Invalid import type'], 400);
        }

        try {
            // Download file from S3
            $s3 = new S3Client([
                'version' => 'latest',
                'region' => env('AWS_DEFAULT_REGION'),
                'credentials' => [
                    'key' => env('AWS_ACCESS_KEY_ID'),
                    'secret' => env('AWS_SECRET_ACCESS_KEY'),
                ],
                'http' => [
                    'verify' => false,
                ],
            ]);

            $result = $s3->getObject([
                'Bucket' => env('AWS_BUCKET'),
                'Key' => $filePath,
            ]);

            $fileContent = $result['Body']->getContents();
            $tempFilePath = tempnam(sys_get_temp_dir(), 'import_'); 
            file_put_contents($tempFilePath, $fileContent);

            // Process the Excel data and save it to the database

            Excel::import($import, $tempFilePath);
            $rowsProcessed = $import->getRowCount();
            $rowsskipped = $import->getRowsSkipped();
            $skippedRowNumber = $import->getSkippedRows();

            unlink($tempFilePath);

            return response()->json([
                'message' => 'Data processed successfully',
                'Rows_processed' => $rowsProcessed,
                'Rows_Skipped' => $rowsskipped,
                'Rows' => $skippedRowNumber,
            ]);
        } catch (S3Exception $e) {
            return response()->json(['error' => $e->getMessage()], 500);
        } catch (\Exception $e) {
            return response()->json(['error' => $e->getMessage()], 500);
        }
    }
}

Please help to resolve this issue.

[patrickbrouwers]

Your file doesn't have an extension so there's no way to know what kind of file you expect to be imported . Either add an extension or provide the reader type

[HarshitTotuka-CL]

https://xyz-1.amazonaws.com/dispatchers/2/imports/orders/1718992646_ff3f4cae-b847-4a6b-b2f9-52fd7e575fe6.xlsx?....

this is my generated url that i am generating , and this is the file path that they are sending on import api :dispatchers/2/imports/orders/1718992646_ff3f4cae-b847-4a6b-b2f9-52fd7e575fe6.xlsx

[patrickbrouwers]

$tempFilePath = tempnam(sys_get_temp_dir(), 'import_');

Doesn't have the extension

[HarshitTotuka-CL]

I don't want to add the extension explicitly.
The weird thing is , that this code is completely running fine in my local server , but not when hosted

[patrickbrouwers]

Then pass the writer type explicitly like the exceptions says. Excel::import($import, $tempFilePath, null, 'Xlsx'); If you don't want to do that, I'm sorry but then I can't really help you 😅

Also, why don't you use a S3 disk directly in the Excel::import Excel::import($import, $filePath, 's3') That way you don't have to write all that S3 downloading yourself.