#!/usr/bin/env php
🔍 Analyse du fichier member.sql...

📝 Encodage détecté : UTF-8
📋 Structure trouvée - 54 colonnes :

   1. id                        = 17964
   2. member_pro_type_id        = 0
   3. login                     = antiquite-hurbain-18
   4. email                     = gerald.hurbain@orange.fr
   5. mc_rate                   = 2
   6. url                       = http://www.brocantiqhurbain.fr
   7. facebook_url              = NULL
   8. twitter_url               = NULL
   9. google_plus_url           = NULL
  10. sncao                     = 
  11. society                   = antiquité hurbain
  12. rcs                       = 448037473
  13. name                      = hurbain gerald
  14. surname                   = 
  15. address                   = 188 rue jean jaures
  16. zip                       = 59174
  17. geo_city_id               = 23611
  18. geo_district_id           = 307
  19. geo_departement_id        = 59
  20. geo_region_id             = 31
  21. geo_country_id            = 1
  22. tel                       = 0327287546
  23. fax                       = 
  24. gsm                       = 0681893908
  25. googlemap                 = NULL
  26. lgt                       = 3.4882965
  27. lat                       = 50.3491584
  28. cap                       = NULL
  29. syndic_id                 = 0
  30. group_id                  = 0
  31. confirm_key               = NULL
  32. valid                     = 1
  33. pending                   = 0
  34. op_id                     = 1
  35. customer                  = 0
  36. gallery                   = 0
  37. member_type_id            = 2
  38. max_items                 = 0
  39. translation_credits       = 0
  40. send_me_email             = 0
  41. mail_open_date            = NULL
  42. mail_click_date           = NULL
  43. last_visite_date          = NULL
  44. last_connection_date      = NULL
  45. last_contact_date         = NULL
  46. next_contact_date         = NULL
  47. start_date                = NULL
  48. end_date                  = NULL
  49. created_at                = 2007-12-11 00:00:00
  50. updated_at                = 2011-06-15 11:11:56
  51. proantic                  = 0
  52. anticstore                = 0
  53. password                  = 91959671
  54. member_culture            = fr_FR

🔍 Analyse du mapping requis :

✅ Colonnes SOURCE qui peuvent être mappées :
   ✓ id → id
   ✓ email → email
   ✓ password → password
   ✓ name → first_name
   ✓ surname → last_name
   ✓ society → company_name
   ✓ tel → phone
   ✓ address → address
   ✓ zip → zip_code
   ✓ url → website
   ✓ geo_country_id → country_id
   ✓ geo_region_id → region_id
   ✓ geo_departement_id → departement_id
   ✓ geo_city_id → city_id
   ✓ lat → gps_latitude
   ✓ lgt → gps_longitude
   ✓ created_at → created_at

⚠️  Colonnes DESTINATION obligatoires sans mapping :
   ! roles (VALEUR PAR DÉFAUT REQUISE)
   ! is_verified (VALEUR PAR DÉFAUT REQUISE)
   ! status (VALEUR PAR DÉFAUT REQUISE)
   ! subscription_plan (VALEUR PAR DÉFAUT REQUISE)
   ! is_active (VALEUR PAR DÉFAUT REQUISE)
   ! is_seller_enabled (VALEUR PAR DÉFAUT REQUISE)

📋 Colonnes SOURCE non mappées :
   ? member_pro_type_id
   ? login
   ? mc_rate
   ? facebook_url
   ? twitter_url
   ? google_plus_url
   ? sncao
   ? rcs
   ? geo_district_id
   ? fax
   ? gsm
   ? googlemap
   ? cap
   ? syndic_id
   ? group_id
   ? confirm_key
   ? valid
   ? pending
   ? op_id
   ? customer
   ? gallery
   ? member_type_id
   ? max_items
   ? translation_credits
   ? send_me_email
   ? mail_open_date
   ? mail_click_date
   ? last_visite_date
   ? last_connection_date
   ? last_contact_date
   ? next_contact_date
   ? start_date
   ? end_date
   ? updated_at
   ? proantic
   ? anticstore
   ? member_culture

🔧 Mapping corrigé généré :

'member.sql' => [
    'table' => 'member',
    'mapping' => [
        'id' => 'id',
        'email' => 'email',
        'password' => 'password',
        'name' => 'first_name',
        'surname' => 'last_name',
        'society' => 'company_name',
        'tel' => 'phone',
        'address' => 'address',
        'zip' => 'zip_code',
        'url' => 'website',
        'geo_country_id' => 'country_id',
        'geo_region_id' => 'region_id',
        'geo_departement_id' => 'departement_id',
        'geo_city_id' => 'city_id',
        'lat' => 'gps_latitude',
        'lgt' => 'gps_longitude',
        'created_at' => 'created_at',

        // Valeurs par défaut pour colonnes obligatoires
        '_DEFAULT_roles' => '["ROLE_USER"]',
        '_DEFAULT_status' => 'active',
        '_DEFAULT_subscription_plan' => 'free',
        '_DEFAULT_is_active' => 1,
        '_DEFAULT_is_seller_enabled' => 1,
        '_DEFAULT_is_verified' => 1,

        // Colonnes ignorées
        'member_pro_type_id' => 'IGNORE',
        'login' => 'IGNORE',
        'mc_rate' => 'IGNORE',
        'facebook_url' => 'IGNORE',
        'twitter_url' => 'IGNORE',
        'google_plus_url' => 'IGNORE',
        'sncao' => 'IGNORE',
        'rcs' => 'IGNORE',
        'geo_district_id' => 'IGNORE',
        'fax' => 'IGNORE',
        'gsm' => 'IGNORE',
        'googlemap' => 'IGNORE',
        'cap' => 'IGNORE',
        'syndic_id' => 'IGNORE',
        'group_id' => 'IGNORE',
        'confirm_key' => 'IGNORE',
        'valid' => 'IGNORE',
        'pending' => 'IGNORE',
        'op_id' => 'IGNORE',
        'customer' => 'IGNORE',
        'gallery' => 'IGNORE',
        'member_type_id' => 'IGNORE',
        'max_items' => 'IGNORE',
        'translation_credits' => 'IGNORE',
        'send_me_email' => 'IGNORE',
        'mail_open_date' => 'IGNORE',
        'mail_click_date' => 'IGNORE',
        'last_visite_date' => 'IGNORE',
        'last_connection_date' => 'IGNORE',
        'last_contact_date' => 'IGNORE',
        'next_contact_date' => 'IGNORE',
        'start_date' => 'IGNORE',
        'end_date' => 'IGNORE',
        'updated_at' => 'IGNORE',
        'proantic' => 'IGNORE',
        'anticstore' => 'IGNORE',
        'member_culture' => 'IGNORE',
    ]
],