Giter Club home page Giter Club logo

Comments (3)

patrickbrouwers avatar patrickbrouwers commented on May 24, 2024 1

Please share an example csv and your code to reproduce

from laravel-excel.

bensonarafat avatar bensonarafat commented on May 24, 2024

Here is my import class

class SubscriberImport implements ToModel, WithHeadingRow, WithCustomCsvSettings
{
    use Importable;

    public function model(array $row)
    {
        if (!isset($row['email'])) {
            return null;
        }
        return new Subscriber([
            "name" => $row['name'],
            "address" => $row['address'],
            "email" => $row['email']
        ]);
    }

    public function batchSize(): int
    {
        return 1000;
    }

    public function uniqueBy()
    {
        return 'email';
    }

    public function getCsvSettings(): array
    {
        return [
            'delimiter' => ',',
            'enclosure' => '"',
            'contiguous' => false,
            'input_encoding' => 'UTF-8',
        ];
    }
}

from my controller

    public function importReceipient(Request $request)
    {
        $request->validate([
            'file' =>  'required|mimetypes:text/csv,text/plain,application/csv,text/comma-separated-values,text/anytext,application/octet-stream,application/txt'
        ]);
        try {
            (new SubscriberImport)->import($request->file('file'));
            return redirect()->back()->with(["success" => "Subscribers Added"]);
        } catch (Exception $e) {
            return redirect()->back()->with(["error" => "Oops, there was an error."]);
        }
    }

CSV => https://docs.google.com/spreadsheets/d/1Qm53rK2uNrSwz6YQxq6IqbTtoC_aOaRLkn43UqgQtcI/edit?usp=sharing
Row 6 has this character. i highlighted it with red.

from laravel-excel.

patrickbrouwers avatar patrickbrouwers commented on May 24, 2024

Your file is most likely not UTF-8 but another encoding. You should define the right input decoding in csv settings

from laravel-excel.

Related Issues (20)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.