Testing Flexible CSV Import...
==============================

1. Testing CSV header validation...
   Testing: Minimal CSV (name, email, businessType)
   Headers found: name, email, businessType
   ✓ All required columns present

   Testing: Extended CSV (7 columns)
   Headers found: name, email, phone, businessType, leadStatus, leadValue, leadSource
   ✓ All required columns present

2. Testing business type auto-creation...
❌ Error: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO) (Connection: mysql, SQL: select * from `business_types` where LOWER(name) = salon limit 1)
Stack trace:
#0 /home/lfix/mail-dev.osllc.us/vendor/laravel/framework/src/Illuminate/Database/Connection.php(978): Illuminate\Database\Connection->runQueryCallback('select * from `...', Array, Object(Closure))
#1 /home/lfix/mail-dev.osllc.us/vendor/laravel/framework/src/Illuminate/Database/Connection.php(957): Illuminate\Database\Connection->tryAgainIfCausedByLostConnection(Object(Illuminate\Database\QueryException), 'select * from `...', Array, Object(Closure))
#2 /home/lfix/mail-dev.osllc.us/vendor/laravel/framework/src/Illuminate/Database/Connection.php(780): Illuminate\Database\Connection->handleQueryException(Object(Illuminate\Database\QueryException), 'select * from `...', Array, Object(Closure))
#3 /home/lfix/mail-dev.osllc.us/vendor/laravel/framework/src/Illuminate/Database/Connection.php(397): Illuminate\Database\Connection->run('select * from `...', Array, Object(Closure))
#4 /home/lfix/mail-dev.osllc.us/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3188): Illuminate\Database\Connection->select('select * from `...', Array, true)
#5 /home/lfix/mail-dev.osllc.us/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3173): Illuminate\Database\Query\Builder->runSelect()
#6 /home/lfix/mail-dev.osllc.us/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3763): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#7 /home/lfix/mail-dev.osllc.us/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3172): Illuminate\Database\Query\Builder->onceWithColumns(Array, Object(Closure))
#8 /home/lfix/mail-dev.osllc.us/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(902): Illuminate\Database\Query\Builder->get(Array)
#9 /home/lfix/mail-dev.osllc.us/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(884): Illuminate\Database\Eloquent\Builder->getModels(Array)
#10 /home/lfix/mail-dev.osllc.us/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(366): Illuminate\Database\Eloquent\Builder->get(Array)
#11 /home/lfix/mail-dev.osllc.us/app/Services/BusinessTypeService.php(28): Illuminate\Database\Eloquent\Builder->first()
#12 /home/lfix/mail-dev.osllc.us/test_flexible_import.php(58): App\Services\BusinessTypeService->getOrCreateByName('salon')
#13 {main}

==============================
Ready to test via web interface!
1. Start server: php artisan serve
2. Visit: http://localhost:8000/leads/import
3. Upload test_minimal_leads.csv or test_salon_leads.csv
4. Check results in database