1 year ago

Import CSV files and Excel using file streamed from S3

Posted 1 year ago by RossUK

I have a job to process large uploaded csv files. I want to process these as a queued job. Because the queued jobs can not accept a file as a passed in parameter I had the idea of uploading the file to S3 first then use the file from s3 in my csv processing job.

I have tried this using Maatwebsite/Laravel-Excel but it wont accept the streamed file from S3.

$contents = Storage::disk('s3')->get($filename);
        $results = Excel::load($contents);

So I can process the csv in the background can anyone recommend a better way of doing this or maybe a better csv, excel import library.

Please sign in or create an account to participate in this conversation.