CSV Seeder
Seed your database with CSV files
This package allows CSV based seeds.
Installation
Require this package in your composer.json and run composer update (or run composer require flynsarmy/csv-seeder:2.* directly):
For PHP 7.4+
"flynsarmy/csv-seeder": "2.0.*"
For older PHP versions
"flynsarmy/csv-seeder": "1.*"
Usage
Your CSV's header row should match the DB columns you wish to import. IE to import id and name columns, your CSV should look like:
id,name
1,Foo
2,Bar
Seed classes must extend Flynsarmy\CsvSeeder\CsvSeeder, they must define the destination database table and CSV file path, and finally they must call parent::run() like so:
use Flynsarmy\CsvSeeder\CsvSeeder;
class StopsTableSeeder extends CsvSeeder {
public function __construct()
{
$this->table = 'your_table';
$this->filename = base_path().'/database/seeds/csvs/your_csv.csv';
}
public function run()
{
// Recommended when importing larger CSVs
DB::disableQueryLog();
// Uncomment the below to wipe the table clean before populating
DB::table($this->table)->truncate();
parent::run();
}
}
Drop your CSV into /database/seeds/csvs/your_csv.csv or whatever path you specify in your constructor above.
Configuration
In addition to setting the database table and CSV filename, the following configuration options are available. They can be set in your class constructor:
connection(string '') Connection to use for inserts. Leave empty for default connection.insert_chunk_size(int 500) An SQL insert statement will trigger everyinsert_chunk_sizenumber of rows while reading the CSVcsv_delimiter(string ,) The CSV field delimiter.hashable(array [password]) List of fields to be hashed before import, useful if you are importing users and need their passwords hashed. UsesHash::make(). Note: This is EXTREMELY SLOW. If you have a lot of rows in your CSV your import will take quite a long time.offset_rows(int 0) How many rows at the start of the CSV to ignore. Warning: If used, you probably want to set a mapping as your header row in the CSV will be skipped.mapping(array []) Associative array of csvCol => dbCol. See examples section for details. If not specified, the first row (after offset) of the CSV will be used as the mapping.should_trim(bool false) Whether to trim the data in each cell of the CSV during import.timestamps(bool false) Whether or not to add created_at and updated_at columns on import.created_at(string current time in ISO 8601 format) Only used iftimestampsistrueupdated_at(string current time in ISO 8601 format) Only used iftimestampsistrue
Examples
CSV with pipe delimited values:
public function __construct()
{
$this->table = 'users';
$this->csv_delimiter = '|';
$this->filename = base_path().'/database/seeds/csvs/your_csv.csv';
}
Specifying which CSV columns to import:
public function __construct()
{
$this->table = 'users';
$this->csv_delimiter = '|';
$this->filename = base_path().'/database/seeds/csvs/your_csv.csv';
$this->mapping = [
0 => 'first_name',
1 => 'last_name',
5 => 'age',
];
}
Trimming the whitespace from the imported data:
public function __construct()
{
$this->table = 'users';
$this->csv_delimiter = '|';
$this->filename = base_path().'/database/seeds/csvs/your_csv.csv';
$this->mapping = [
0 => 'first_name',
1 => 'last_name',
5 => 'age',
];
$this->should_trim = true;
}
Skipping the CSV header row (Note: A mapping is required if this is done):
public function __construct()
{
$this->table = 'users';
$this->csv_delimiter = '|';
$this->filename = base_path().'/database/seeds/csvs/your_csv.csv';
$this->offset_rows = 1;
$this->mapping = [
0 => 'first_name',
1 => 'last_name',
2 => 'password',
];
$this->should_trim = true;
}
Specifying the DB connection to use:
public function __construct()
{
$this->table = 'users';
$this->connection = 'my_connection';
$this->filename = base_path().'/database/seeds/csvs/your_csv.csv';
}
Migration Guide
2.0
$seeder->hashableis now anarrayof columns rather than a single column name. Wrap your old string value in[].
License
CsvSeeder is open-sourced software licensed under the MIT license
6 Nov 16, 2022
3 Aug 5, 2022
1 Nov 20, 2021
745 Jan 7, 2023
12 Dec 11, 2022
3.3k Dec 30, 2022
45 Jul 25, 2022
41 Dec 14, 2022
4.6k Dec 28, 2022
2.5k Dec 27, 2022
2.2k Jan 9, 2023
602 Dec 27, 2022
533 Dec 30, 2022
4.3k Jan 7, 2023
5.5k Jan 1, 2023
8.9k Dec 28, 2022
441 Dec 11, 2022
470 Dec 8, 2022
580 Dec 5, 2022