Comments (3)
Please share an example csv and your code to reproduce
from laravel-excel.
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.
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)
- [Bug]: "MyCLabs\Enum\Enum" triggered while exporting HOT 3
- [Bug]: Can't Export queued PDF file HOT 5
- [Bug]: XMLReader::read(): /home/server_path/public_html/project_name/:2: parser error : error parsing attribute name HOT 1
- Why my date column always return int value?. How can I get the origin value? because its int value is wrong HOT 4
- [Bug]: Could not find zip member zip:///{filePath}.xlsx#_rels\.rels when specifying the disk HOT 5
- Large Import of MultiSheets with Chunk and Queued Reading the ReadChunk Crashes HOT 7
- [Bug] : i am getting Allowed memory size of 4294967296 bytes exhausted (tried to allocate 304091136 bytes) error.
- [Bug]: /usr/share/nginx/html/storage/framework/cache/laravel-excel/laravel-excel-1psS0VMO9G0yPaBxMh62mwjJyCePqZAD.html is an Invalid HTML file. HOT 2
- [Bug]: columnWidths invalid HOT 1
- [Bug]: PHPStan invalid return type: `Laravel\Scout\Builder` HOT 5
- [Bug]: ErrorException: Undefined variable: sheetExport HOT 6
- [Bug]: Is an Invalid HTML file. HOT 5
- A change in ./src/Sheet.php in v3.1.47 moving WithDrawings from open to close method ignores WithHeadings headings() implementation [Bug]:
- [Bug]: No ReaderType or WriterType could be detected. Make sure you either pass a valid extension to the filename or pass an explicit type. HOT 5
- [Bug]: Empty line error A1 in csv and excel HOT 3
- [Bug]: "Spreadsheet objects cannot be serialized" error with batch cell caching HOT 3
- [Bug]: WithColumnWidths not working with ShouldAutoSize in PDF HOT 4
- [Bug]: the column displayed in the error message is not the correct one for validation rules require_with:*.<number> HOT 2
- [Bug]: "Call to undefined function Maatwebsite\\Excel\\resolve()" HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
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.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from laravel-excel.