konafets / laravel-csv-validator
A Laravel package to validate CSV files using cyberduck/laravel-excel
Requires
- php: ^7.0
- cyber-duck/laravel-excel: ^1.2
- laravel/framework: ^5.5
This package is auto-updated.
Last update: 2024-10-17 11:41:19 UTC
README
A Laravel 5.5 package to validate csv, excel and OpenOffice data.
The idea behind the package is simple: Just use the same validation logic and syntax as in request validating.
The package does so far only supports CSV / Excel files with a header row
Installation
Execute composer command.
composer require konafets/laravel-csv-validator:1.0-dev
Thanks to Laravels Auto-Discovery, you are done. The ServiceProvider and Alias is registered automatically.
Basic usage
$csvPath = 'employees.csv';
$rules = [
'First Name' => 'required|string',
'Last Name' => 'required|string',
'Year of Birth' => 'required|numeric',
];
$csvValidator = CsvValidator::make($csvPath, $rules);
if($csvValidator->fails()) {
$errors = $csvValidator->getErrors();
} else {
$csvData = $csvValidator->getData();
}
Rules
$rules = [
'First Name' => 'required|string',
'Last Name' => 'required|string',
'Year of Birth' => 'required|numeric',
];
In this example, the first row of the CSV need to have three columns named First Name
, Last Name
and Year of Birth
. There might be others columns as well in your file but we don't care for them.
This keys will be used as attribute names for error message.
For more details of the rules see.
Error messages
You can get error messages after calling fails().
$errors = $csvValidator->getErrors();
foreach ($errors as $rowIndex => $row) {
foreach ($row as $column => $messages) {
echo 'Row ' . $rowIndex . ', Col ' . $column . ': ' . implode(',' , $messages) . '<br>';
}
}
CSV data
You also can get CSV data after calling fails().
$csvData = $csvValidator->getData();
Exception
The Validator throws an exception when:
- your CSV does not have any data.
- Heading key not found.
Some example code
try {
$csvValidator = CsvValidator::make($csv_path, $rules, $encoding);
if($csvValidator->fails()) {
// Do something..
}
} catch (\Exception $e) {
echo $e->getMessage();
}
Credits
This package is heavily inspired by https://github.com/SUKOHI/CsvValidator. They use maatwebsite/excel
as the underlying Excel library, while this package uses box/sprout
.