public function importAppointments() { if (Input::hasFile('file')) { $file = Input::file('file'); Appointment::truncate(); Excel::load($file, function ($reader) { $reader->setDateFormat('j/n/Y H:i:s'); $results = $reader->get(); foreach ($results as $result) { $args = ['user_id' => 2, 'lead_id' => $result->lead_id, 'agent_id' => NULL, 'appointment_confirmed' => $result->confirmed, 'appointment_date' => Carbon::parse($result->appointment_set_date)]; Appointment::create($args); $lead = Lead::find($result->lead_id); if ($lead) { $lead->lead_acceptance_type = $result->dta; $lead->save(); } var_dump($result); } }); } }