Con el siguiente código importaremos un CSV a la base de datos. La primera fila debe llevar el nombre que usaremos para obtener los valores (ejemplo adress: $result->address)
public function import(){
Excel::load('CENSO_A.csv', function($reader) {
$results = $reader->all();
foreach($results as $result) {
$cens = new Cens;
$cens->order_number = $result->order_number;
$cens->dni = $result->dni;
$cens->password = 'pass';
$cens->name = $result->name;
$cens->address = $result->address;
$cens->address_cp = $result->address_cp;
$cens->address_city = $result->address_city;
$cens->city = $result->city;
$cens->state = $result->state;
$cens->sector = $result->sector;
$cens->cens = $result->cens;
$cens->save();
}
});
}
