2017 © Pedro Peláez
 

library csv-validator

A Laravel package to validate csv data.

image

sukohi/csv-validator

A Laravel package to validate csv data.

  • Friday, May 13, 2016
  • by Sukohi
  • Repository
  • 1 Watchers
  • 3 Stars
  • 8,052 Installations
  • PHP
  • 0 Dependents
  • 0 Suggesters
  • 5 Forks
  • 0 Open issues
  • 7 Versions
  • 18 % Grown

The README.md

CsvValidator

A Laravel package that allows you to validate csv data.
This package is compatible with Laravel 5.7 -> 8.X, (*1)

Installation

Run this command., (*2)

composer require sukohi/csv-validator:3.*

Basic usage

You can use a rule called Csv as usual validation.
And all the validation rules of Laravel is available for $csv_rules as follows., (*3)

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use Sukohi\CsvValidator\Rules\Csv;

class CsvValidatorController extends Controller
{
    public function store(Request $request) {

        $csv_rules = [
            0 => 'required',
            1 => 'integer',
            2 => 'required|min:10'
        ];

        $request->validate([
            'users_csv' => [
                new Csv($csv_rules) // <- here
            ]
        ]);

        // Do something..

    }
}

with Options

$csv_rules = [
    0 => 'required',
    1 => 'integer',
    2 => 'required|min:10'
];
$options = [
    'encoding' => 'sjsin-win',
    'start_row' => 1,   // <- Starting validation from row one, not zero. (*1)
    'end_row' => 4,     // <- Ending validation
    'row_callback' => function($row_number, $row_data) {

        return true;    // `false` means skipping validation

    }
];
$request->validate([
    'csv_file' => [
        new Csv($csv_rules, $options)
    ]
]);

(*1) For example, if you don't want to validate the header row, it means the first row, set 2 here., (*4)

Note: The former coding is also available., (*5)

new Csv($csv_rules, 'sjis-win')

Csv rules

You can skip column like this., (*6)

$csv_rules = [
    0 => 'required',
    3 => 'required|min:10'
];

$request->validate([
    'csv_file' => [
        new Csv($csv_rules)
    ]
]);

Retrieve

You can access csv data by adding _data after attribute of csv file as follows., (*7)

$csv_data = $request->csv_file_data;    // when attribute is `csv_file`

Messages

Attributes of error messages are like this., (*8)

The A1 field is required.
The C1 field is required.
The C2 must be at least 10 characters.
The C3 must be at least 10 characters.
The C4 field is required.

Contributor

Thank you for your contributions!, (*9)

License

This package is licensed under the MIT License., (*10)

Copyright 2020 Sukohi Kuhoh, (*11)

The Versions

13/05 2016

2.0.x-dev

2.0.9999999.9999999-dev

A Laravel package to validate csv data.

  Sources   Download

LGPL

The Requires

 

by Avatar Sukohi

13/05 2016

dev-master

9999999-dev

A Laravel package to validate csv data.

  Sources   Download

LGPL

The Requires

 

by Avatar Sukohi

13/05 2016

2.0.0

2.0.0.0

A Laravel package to validate csv data.

  Sources   Download

LGPL

The Requires

 

by Avatar Sukohi

13/05 2016

1.0.x-dev

1.0.9999999.9999999-dev

A Laravel package to validate csv data.

  Sources   Download

LGPL

The Requires

 

by Avatar Sukohi

13/05 2016

1.0.2

1.0.2.0

A Laravel package to validate csv data.

  Sources   Download

LGPL

The Requires

 

by Avatar Sukohi

13/05 2016

1.0.1

1.0.1.0

  Sources   Download

LGPL

The Requires

 

by Avatar Sukohi

12/05 2016

1.0.0

1.0.0.0

  Sources   Download

The Requires

 

by Avatar Sukohi