[2025-12-29 15:51:13] [DEBUG] Loading configuration from config.php
[2025-12-29 15:51:13] [DEBUG] Configuration loaded successfully
[2025-12-29 15:51:13] [DEBUG] Database host: fcefrancxdck867a.mysql.db:3306
[2025-12-29 15:51:13] [DEBUG] Database name: fcefrancxdck867a
[2025-12-29 15:51:13] [DEBUG] Database user: fcefrancxdck867a
[2025-12-29 15:51:13] [DEBUG] Input file: /home/fcefrancxd-yp/www/scratch/fce_test.users.json
[2025-12-29 15:51:13] [DEBUG] Batch size: 100
[2025-12-29 15:51:13] [DEBUG] Skip duplicates: Yes
[2025-12-29 15:51:13] [DEBUG] Verbose mode: Yes
[2025-12-29 15:51:13] [DEBUG] PHP Version: 5.6.40
[2025-12-29 15:51:13] [DEBUG] Script start time: 2025-12-29 15:51:13
[2025-12-29 15:51:13] [DEBUG] Loading delegation mapping from delegation_mapping.json
[2025-12-29 15:51:13] [DEBUG] Delegation mapping loaded: 65 delegations mapped
[2025-12-29 15:51:13] [DEBUG] Loading sector mapping from sector_mapping.json
[2025-12-29 15:51:13] [DEBUG] Sector mapping loaded: 21 sectors mapped
[2025-12-29 15:51:13] [DEBUG] Loading sector to activiteparent mapping from sector_to_activiteparent_mapping.json
[2025-12-29 15:51:13] [DEBUG] Sector to activiteparent mapping loaded: 21 sectors mapped
[2025-12-29 15:51:13] [DEBUG] Building DSN connection string
[2025-12-29 15:51:13] [DEBUG] DSN: mysql:host=fcefrancxdck867a.mysql.db;port=3306;dbname=fcefrancxdck867a;charset=utf8mb4
[2025-12-29 15:51:13] [DEBUG] Attempting PDO connection...
[2025-12-29 15:51:13] [DEBUG] PDO connection established successfully
[2025-12-29 15:51:13] [DEBUG] Setting charset to utf8mb4
[2025-12-29 15:51:13] [DEBUG] Charset set successfully
[2025-12-29 15:51:13] [DEBUG] Checking if JSON file exists...
[2025-12-29 15:51:13] [DEBUG] JSON file found
[2025-12-29 15:51:13] [DEBUG] Reading JSON file contents...
[2025-12-29 15:51:13] [DEBUG] JSON file size: 9,721 bytes
[2025-12-29 15:51:13] [DEBUG] First 100 chars: [{
  "_id": {
    "$oid": "68bed4767bbf1f85db752cff"
  },
  "fceId": 733791,
  "email": "veronique.d
[2025-12-29 15:51:13] [DEBUG] Decoding JSON...
[2025-12-29 15:51:13] [DEBUG] JSON decoded
[2025-12-29 15:51:13] [DEBUG] JSON is valid
[2025-12-29 15:51:13] [DEBUG] Total users parsed: 2
[2025-12-29 15:51:13] [DEBUG] First user email: veronique.dijon@mercato-emploi.com
[2025-12-29 15:51:13] [DEBUG] Preparing INSERT statement...
[2025-12-29 15:51:13] [DEBUG] Preparing PDO statement...
[2025-12-29 15:51:13] [DEBUG] INSERT statement prepared successfully
[2025-12-29 15:51:13] [DEBUG] Preparing duplicate check statement...
[2025-12-29 15:51:13] [DEBUG] Duplicate check statement prepared
[2025-12-29 15:51:13] [DEBUG] Starting user processing loop
[2025-12-29 15:51:13] [DEBUG] Beginning database transaction
[2025-12-29 15:51:13] [DEBUG] Transaction started
[2025-12-29 15:51:13] [DEBUG] Processing user 1/2
[2025-12-29 15:51:13] [DEBUG] User email: veronique.dijon@mercato-emploi.com
[2025-12-29 15:51:13] [DEBUG] Checking if user exists: veronique.dijon@mercato-emploi.com
[2025-12-29 15:51:13] [DEBUG] User exists: No
[2025-12-29 15:51:13] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-29 15:51:13] [DEBUG] Data mapped, inserting user...
[2025-12-29 15:51:13] [ERROR] Insert failed for veronique.dijon@mercato-emploi.com: SQLSTATE[HY000]: General error: 3988 Conversion from collation utf8mb4_0900_ai_ci into utf8mb3_general_ci impossible for parameter
[2025-12-29 15:51:13] [ERROR] Error inserting user veronique.dijon@mercato-emploi.com: SQLSTATE[HY000]: General error: 3988 Conversion from collation utf8mb4_0900_ai_ci into utf8mb3_general_ci impossible for parameter
[2025-12-29 15:51:13] [ERROR] SQL State: HY000
[2025-12-29 15:51:13] [DEBUG] Processing user 2/2
[2025-12-29 15:51:13] [DEBUG] User email: christele@capyxia.com
[2025-12-29 15:51:13] [DEBUG] Checking if user exists: christele@capyxia.com
[2025-12-29 15:51:13] [DEBUG] User exists: No
[2025-12-29 15:51:13] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-29 15:51:13] [DEBUG] Data mapped, inserting user...
[2025-12-29 15:51:13] [DEBUG] User inserted successfully with ID: 6916
[2025-12-29 15:51:13] [DEBUG] Inserting user_delegation: user_id=6916, delegation_id=5576
[2025-12-29 15:51:13] [DEBUG] user_delegation inserted successfully
[2025-12-29 15:51:13] [DEBUG] Inserting user_activite: user_id=6916, activite_id=52 (sector=BUSINESS_SERVICES)
[2025-12-29 15:51:13] [ERROR] WARNING: Failed to insert user_activite: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'fcefrancxdck867a.user_activite' doesn't exist
[2025-12-29 15:51:13] [DEBUG] Inserting paiement: user_id=6916, year=2025, amount=253
[2025-12-29 15:51:13] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-29 15:51:13] [DEBUG] Processing complete, committing final batch
[2025-12-29 15:51:13] [DEBUG] Committing final 1 users
[2025-12-29 15:51:13] [DEBUG] Final commit successful
[2025-12-29 15:51:13] [DEBUG] ID mapping contains 1 entries
[2025-12-29 15:51:13] [DEBUG] Mapping file: /home/fcefrancxd-yp/www/scratch/user_id_mapping.json
[2025-12-29 15:51:13] [DEBUG] JSON mapping size: 192 bytes
[2025-12-29 15:51:13] [DEBUG] ID mapping saved successfully (192 bytes written)
[2025-12-29 15:51:13] [DEBUG] Import process completed
[2025-12-29 15:51:13] [DEBUG] Total duration: 0.15 seconds
[2025-12-29 15:51:13] [DEBUG] Average time per user: 0.075 seconds
[2025-12-29 15:51:13] [ERROR] Import completed with 1 error(s) - check error log
[2025-12-29 15:53:59] [DEBUG] Loading configuration from config.php
[2025-12-29 15:53:59] [DEBUG] Configuration loaded successfully
[2025-12-29 15:53:59] [DEBUG] Database host: fcefrancxdck867a.mysql.db:3306
[2025-12-29 15:53:59] [DEBUG] Database name: fcefrancxdck867a
[2025-12-29 15:53:59] [DEBUG] Database user: fcefrancxdck867a
[2025-12-29 15:53:59] [DEBUG] Input file: /home/fcefrancxd-yp/www/scratch/fce_test.users.json
[2025-12-29 15:53:59] [DEBUG] Batch size: 100
[2025-12-29 15:53:59] [DEBUG] Skip duplicates: Yes
[2025-12-29 15:53:59] [DEBUG] Verbose mode: Yes
[2025-12-29 15:53:59] [DEBUG] PHP Version: 5.6.40
[2025-12-29 15:53:59] [DEBUG] Script start time: 2025-12-29 15:53:59
[2025-12-29 15:53:59] [DEBUG] Loading delegation mapping from delegation_mapping.json
[2025-12-29 15:53:59] [DEBUG] Delegation mapping loaded: 65 delegations mapped
[2025-12-29 15:53:59] [DEBUG] Loading sector mapping from sector_mapping.json
[2025-12-29 15:53:59] [DEBUG] Sector mapping loaded: 21 sectors mapped
[2025-12-29 15:53:59] [DEBUG] Loading sector to activiteparent mapping from sector_to_activiteparent_mapping.json
[2025-12-29 15:53:59] [DEBUG] Sector to activiteparent mapping loaded: 21 sectors mapped
[2025-12-29 15:53:59] [DEBUG] Building DSN connection string
[2025-12-29 15:53:59] [DEBUG] DSN: mysql:host=fcefrancxdck867a.mysql.db;port=3306;dbname=fcefrancxdck867a;charset=utf8
[2025-12-29 15:53:59] [DEBUG] Attempting PDO connection...
[2025-12-29 15:53:59] [DEBUG] PDO connection established successfully
[2025-12-29 15:53:59] [DEBUG] Setting charset to utf8mb4
[2025-12-29 15:53:59] [DEBUG] Charset set successfully
[2025-12-29 15:53:59] [DEBUG] Checking if JSON file exists...
[2025-12-29 15:53:59] [DEBUG] JSON file found
[2025-12-29 15:53:59] [DEBUG] Reading JSON file contents...
[2025-12-29 15:53:59] [DEBUG] JSON file size: 9,721 bytes
[2025-12-29 15:53:59] [DEBUG] First 100 chars: [{
  "_id": {
    "$oid": "68bed4767bbf1f85db752cff"
  },
  "fceId": 733791,
  "email": "veronique.d
[2025-12-29 15:53:59] [DEBUG] Decoding JSON...
[2025-12-29 15:53:59] [DEBUG] JSON decoded
[2025-12-29 15:53:59] [DEBUG] JSON is valid
[2025-12-29 15:53:59] [DEBUG] Total users parsed: 2
[2025-12-29 15:53:59] [DEBUG] First user email: veronique.dijon@mercato-emploi.com
[2025-12-29 15:53:59] [DEBUG] Preparing INSERT statement...
[2025-12-29 15:53:59] [DEBUG] Preparing PDO statement...
[2025-12-29 15:53:59] [DEBUG] INSERT statement prepared successfully
[2025-12-29 15:53:59] [DEBUG] Preparing duplicate check statement...
[2025-12-29 15:53:59] [DEBUG] Duplicate check statement prepared
[2025-12-29 15:53:59] [DEBUG] Starting user processing loop
[2025-12-29 15:53:59] [DEBUG] Beginning database transaction
[2025-12-29 15:53:59] [DEBUG] Transaction started
[2025-12-29 15:53:59] [DEBUG] Processing user 1/2
[2025-12-29 15:53:59] [DEBUG] User email: veronique.dijon@mercato-emploi.com
[2025-12-29 15:53:59] [DEBUG] Checking if user exists: veronique.dijon@mercato-emploi.com
[2025-12-29 15:53:59] [DEBUG] User exists: No
[2025-12-29 15:53:59] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-29 15:53:59] [DEBUG] Data mapped, inserting user...
[2025-12-29 15:53:59] [ERROR] Insert failed for veronique.dijon@mercato-emploi.com: SQLSTATE[HY000]: General error: 3988 Conversion from collation utf8mb4_0900_ai_ci into utf8mb3_general_ci impossible for parameter
[2025-12-29 15:53:59] [ERROR] Error inserting user veronique.dijon@mercato-emploi.com: SQLSTATE[HY000]: General error: 3988 Conversion from collation utf8mb4_0900_ai_ci into utf8mb3_general_ci impossible for parameter
[2025-12-29 15:53:59] [ERROR] SQL State: HY000
[2025-12-29 15:53:59] [DEBUG] Processing user 2/2
[2025-12-29 15:53:59] [DEBUG] User email: christele@capyxia.com
[2025-12-29 15:53:59] [DEBUG] Checking if user exists: christele@capyxia.com
[2025-12-29 15:53:59] [DEBUG] User exists: Yes (ID: 6916)
[2025-12-29 15:53:59] [DEBUG] Processing complete, committing final batch
[2025-12-29 15:53:59] [DEBUG] No pending users to commit
[2025-12-29 15:53:59] [DEBUG] ID mapping contains 1 entries
[2025-12-29 15:53:59] [DEBUG] Mapping file: /home/fcefrancxd-yp/www/scratch/user_id_mapping.json
[2025-12-29 15:53:59] [DEBUG] JSON mapping size: 190 bytes
[2025-12-29 15:53:59] [DEBUG] ID mapping saved successfully (190 bytes written)
[2025-12-29 15:53:59] [DEBUG] Import process completed
[2025-12-29 15:53:59] [DEBUG] Total duration: 0.06 seconds
[2025-12-29 15:53:59] [DEBUG] Average time per user: 0.03 seconds
[2025-12-29 15:53:59] [ERROR] Import completed with 1 error(s) - check error log
[2025-12-29 15:55:23] [DEBUG] Loading configuration from config.php
[2025-12-29 15:55:23] [DEBUG] Configuration loaded successfully
[2025-12-29 15:55:23] [DEBUG] Database host: fcefrancxdck867a.mysql.db:3306
[2025-12-29 15:55:23] [DEBUG] Database name: fcefrancxdck867a
[2025-12-29 15:55:23] [DEBUG] Database user: fcefrancxdck867a
[2025-12-29 15:55:23] [DEBUG] Input file: /home/fcefrancxd-yp/www/scratch/fce_test.users.json
[2025-12-29 15:55:23] [DEBUG] Batch size: 100
[2025-12-29 15:55:23] [DEBUG] Skip duplicates: Yes
[2025-12-29 15:55:23] [DEBUG] Verbose mode: Yes
[2025-12-29 15:55:23] [DEBUG] PHP Version: 5.6.40
[2025-12-29 15:55:23] [DEBUG] Script start time: 2025-12-29 15:55:23
[2025-12-29 15:55:23] [DEBUG] Loading delegation mapping from delegation_mapping.json
[2025-12-29 15:55:23] [DEBUG] Delegation mapping loaded: 65 delegations mapped
[2025-12-29 15:55:23] [DEBUG] Loading sector mapping from sector_mapping.json
[2025-12-29 15:55:23] [DEBUG] Sector mapping loaded: 21 sectors mapped
[2025-12-29 15:55:23] [DEBUG] Loading sector to activiteparent mapping from sector_to_activiteparent_mapping.json
[2025-12-29 15:55:23] [DEBUG] Sector to activiteparent mapping loaded: 21 sectors mapped
[2025-12-29 15:55:23] [DEBUG] Building DSN connection string
[2025-12-29 15:55:23] [DEBUG] DSN: mysql:host=fcefrancxdck867a.mysql.db;port=3306;dbname=fcefrancxdck867a;charset=utf8
[2025-12-29 15:55:23] [DEBUG] Attempting PDO connection...
[2025-12-29 15:55:23] [DEBUG] PDO connection established successfully
[2025-12-29 15:55:23] [DEBUG] Setting charset to utf8mb4
[2025-12-29 15:55:23] [DEBUG] Charset set successfully
[2025-12-29 15:55:23] [DEBUG] Checking if JSON file exists...
[2025-12-29 15:55:23] [DEBUG] JSON file found
[2025-12-29 15:55:23] [DEBUG] Reading JSON file contents...
[2025-12-29 15:55:23] [DEBUG] JSON file size: 9,721 bytes
[2025-12-29 15:55:23] [DEBUG] First 100 chars: [{
  "_id": {
    "$oid": "68bed4767bbf1f85db752cff"
  },
  "fceId": 733791,
  "email": "veronique.d
[2025-12-29 15:55:23] [DEBUG] Decoding JSON...
[2025-12-29 15:55:23] [DEBUG] JSON decoded
[2025-12-29 15:55:23] [DEBUG] JSON is valid
[2025-12-29 15:55:23] [DEBUG] Total users parsed: 2
[2025-12-29 15:55:23] [DEBUG] First user email: veronique.dijon@mercato-emploi.com
[2025-12-29 15:55:23] [DEBUG] Preparing INSERT statement...
[2025-12-29 15:55:23] [DEBUG] Preparing PDO statement...
[2025-12-29 15:55:23] [DEBUG] INSERT statement prepared successfully
[2025-12-29 15:55:23] [DEBUG] Preparing duplicate check statement...
[2025-12-29 15:55:23] [DEBUG] Duplicate check statement prepared
[2025-12-29 15:55:23] [DEBUG] Starting user processing loop
[2025-12-29 15:55:23] [DEBUG] Beginning database transaction
[2025-12-29 15:55:23] [DEBUG] Transaction started
[2025-12-29 15:55:23] [DEBUG] Processing user 1/2
[2025-12-29 15:55:23] [DEBUG] User email: veronique.dijon@mercato-emploi.com
[2025-12-29 15:55:23] [DEBUG] Checking if user exists: veronique.dijon@mercato-emploi.com
[2025-12-29 15:55:23] [DEBUG] User exists: No
[2025-12-29 15:55:23] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-29 15:55:23] [DEBUG] Data mapped, inserting user...
[2025-12-29 15:55:23] [DEBUG] User inserted successfully with ID: 6917
[2025-12-29 15:55:23] [DEBUG] Inserting user_delegation: user_id=6917, delegation_id=5472
[2025-12-29 15:55:23] [DEBUG] user_delegation inserted successfully
[2025-12-29 15:55:23] [DEBUG] Inserting user_activite: user_id=6917, activite_id=37 (sector=DIGITAL_SERVICES_AND_CYBERSECURITY)
[2025-12-29 15:55:23] [ERROR] WARNING: Failed to insert user_activite: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'fcefrancxdck867a.user_activite' doesn't exist
[2025-12-29 15:55:23] [DEBUG] Inserting paiement: user_id=6917, year=2025, amount=269
[2025-12-29 15:55:23] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-29 15:55:23] [DEBUG] Processing user 2/2
[2025-12-29 15:55:23] [DEBUG] User email: christele@capyxia.com
[2025-12-29 15:55:23] [DEBUG] Checking if user exists: christele@capyxia.com
[2025-12-29 15:55:23] [DEBUG] User exists: Yes (ID: 6916)
[2025-12-29 15:55:23] [DEBUG] Processing complete, committing final batch
[2025-12-29 15:55:23] [DEBUG] Committing final 1 users
[2025-12-29 15:55:23] [DEBUG] Final commit successful
[2025-12-29 15:55:23] [DEBUG] ID mapping contains 2 entries
[2025-12-29 15:55:23] [DEBUG] Mapping file: /home/fcefrancxd-yp/www/scratch/user_id_mapping.json
[2025-12-29 15:55:23] [DEBUG] JSON mapping size: 393 bytes
[2025-12-29 15:55:23] [DEBUG] ID mapping saved successfully (393 bytes written)
[2025-12-29 15:55:23] [DEBUG] Import process completed
[2025-12-29 15:55:23] [DEBUG] Total duration: 0.06 seconds
[2025-12-29 15:55:23] [DEBUG] Average time per user: 0.03 seconds
[2025-12-29 15:55:23] [DEBUG] Import completed successfully with no errors
[2025-12-29 17:23:10] [DEBUG] Loading configuration from config.php
[2025-12-29 17:23:10] [DEBUG] Configuration loaded successfully
[2025-12-29 17:23:10] [DEBUG] Database host: fcefrancxdck867a.mysql.db:3306
[2025-12-29 17:23:10] [DEBUG] Database name: fcefrancxdck867a
[2025-12-29 17:23:10] [DEBUG] Database user: fcefrancxdck867a
[2025-12-29 17:23:10] [DEBUG] Input file: /home/fcefrancxd-yp/www/scratch/fce_test.users.json
[2025-12-29 17:23:10] [DEBUG] Batch size: 100
[2025-12-29 17:23:10] [DEBUG] Skip duplicates: Yes
[2025-12-29 17:23:10] [DEBUG] Verbose mode: Yes
[2025-12-29 17:23:10] [DEBUG] PHP Version: 5.6.40
[2025-12-29 17:23:10] [DEBUG] Script start time: 2025-12-29 17:23:10
[2025-12-29 17:23:10] [DEBUG] Loading delegation mapping from delegation_mapping.json
[2025-12-29 17:23:10] [DEBUG] Delegation mapping loaded: 65 delegations mapped
[2025-12-29 17:23:10] [DEBUG] Loading sector mapping from sector_mapping.json
[2025-12-29 17:23:10] [DEBUG] Sector mapping loaded: 21 sectors mapped
[2025-12-29 17:23:10] [DEBUG] Loading sector to activiteparent mapping from sector_to_activiteparent_mapping.json
[2025-12-29 17:23:10] [DEBUG] Sector to activiteparent mapping loaded: 21 sectors mapped
[2025-12-29 17:23:10] [DEBUG] Building DSN connection string
[2025-12-29 17:23:10] [DEBUG] DSN: mysql:host=fcefrancxdck867a.mysql.db;port=3306;dbname=fcefrancxdck867a;charset=utf8
[2025-12-29 17:23:10] [DEBUG] Attempting PDO connection...
[2025-12-29 17:23:10] [DEBUG] PDO connection established successfully
[2025-12-29 17:23:10] [DEBUG] Setting charset to utf8mb4
[2025-12-29 17:23:10] [DEBUG] Charset set successfully
[2025-12-29 17:23:10] [DEBUG] Checking if JSON file exists...
[2025-12-29 17:23:10] [DEBUG] JSON file found
[2025-12-29 17:23:10] [DEBUG] Reading JSON file contents...
[2025-12-29 17:23:10] [DEBUG] JSON file size: 9,721 bytes
[2025-12-29 17:23:10] [DEBUG] First 100 chars: [{
  "_id": {
    "$oid": "68bed4767bbf1f85db752cff"
  },
  "fceId": 733791,
  "email": "veronique.d
[2025-12-29 17:23:10] [DEBUG] Decoding JSON...
[2025-12-29 17:23:10] [DEBUG] JSON decoded
[2025-12-29 17:23:10] [DEBUG] JSON is valid
[2025-12-29 17:23:10] [DEBUG] Total users parsed: 2
[2025-12-29 17:23:10] [DEBUG] First user email: veronique.dijon@mercato-emploi.com
[2025-12-29 17:23:10] [DEBUG] Preparing INSERT statement...
[2025-12-29 17:23:10] [DEBUG] Preparing PDO statement...
[2025-12-29 17:23:10] [DEBUG] INSERT statement prepared successfully
[2025-12-29 17:23:10] [DEBUG] Preparing duplicate check statement...
[2025-12-29 17:23:10] [DEBUG] Duplicate check statement prepared
[2025-12-29 17:23:10] [DEBUG] Starting user processing loop
[2025-12-29 17:23:10] [DEBUG] Beginning database transaction
[2025-12-29 17:23:10] [DEBUG] Transaction started
[2025-12-29 17:23:10] [DEBUG] Processing user 1/2
[2025-12-29 17:23:10] [DEBUG] User email: veronique.dijon@mercato-emploi.com
[2025-12-29 17:23:10] [DEBUG] Checking if user exists: veronique.dijon@mercato-emploi.com
[2025-12-29 17:23:10] [DEBUG] User exists: No
[2025-12-29 17:23:10] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-29 17:23:10] [DEBUG] Data mapped, inserting user...
[2025-12-29 17:23:10] [DEBUG] User inserted successfully with ID: 6918
[2025-12-29 17:23:10] [DEBUG] Inserting user_delegation: user_id=6918, delegation_id=5472
[2025-12-29 17:23:10] [DEBUG] user_delegation inserted successfully
[2025-12-29 17:23:10] [DEBUG] Inserting user_activite: user_id=6918, activite_id=37 (sector=DIGITAL_SERVICES_AND_CYBERSECURITY)
[2025-12-29 17:23:10] [ERROR] WARNING: Failed to insert user_activite: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'fcefrancxdck867a.user_activite' doesn't exist
[2025-12-29 17:23:10] [DEBUG] Inserting paiement: user_id=6918, year=2025, amount=269
[2025-12-29 17:23:10] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-29 17:23:10] [DEBUG] Processing user 2/2
[2025-12-29 17:23:10] [DEBUG] User email: christele@capyxia.com
[2025-12-29 17:23:10] [DEBUG] Checking if user exists: christele@capyxia.com
[2025-12-29 17:23:10] [DEBUG] User exists: No
[2025-12-29 17:23:10] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-29 17:23:10] [DEBUG] Data mapped, inserting user...
[2025-12-29 17:23:10] [DEBUG] User inserted successfully with ID: 6919
[2025-12-29 17:23:10] [DEBUG] Inserting user_delegation: user_id=6919, delegation_id=5576
[2025-12-29 17:23:10] [DEBUG] user_delegation inserted successfully
[2025-12-29 17:23:10] [DEBUG] Inserting user_activite: user_id=6919, activite_id=52 (sector=BUSINESS_SERVICES)
[2025-12-29 17:23:10] [ERROR] WARNING: Failed to insert user_activite: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'fcefrancxdck867a.user_activite' doesn't exist
[2025-12-29 17:23:10] [DEBUG] Inserting paiement: user_id=6919, year=2025, amount=253
[2025-12-29 17:23:10] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-29 17:23:10] [DEBUG] Processing complete, committing final batch
[2025-12-29 17:23:10] [DEBUG] Committing final 2 users
[2025-12-29 17:23:10] [DEBUG] Final commit successful
[2025-12-29 17:23:10] [DEBUG] ID mapping contains 2 entries
[2025-12-29 17:23:10] [DEBUG] Mapping file: /home/fcefrancxd-yp/www/scratch/user_id_mapping.json
[2025-12-29 17:23:10] [DEBUG] JSON mapping size: 395 bytes
[2025-12-29 17:23:10] [DEBUG] ID mapping saved successfully (395 bytes written)
[2025-12-29 17:23:10] [DEBUG] Import process completed
[2025-12-29 17:23:10] [DEBUG] Total duration: 0.09 seconds
[2025-12-29 17:23:10] [DEBUG] Average time per user: 0.045 seconds
[2025-12-29 17:23:10] [DEBUG] Import completed successfully with no errors
[2025-12-29 17:27:09] [DEBUG] Loading configuration from config.php
[2025-12-29 17:27:09] [DEBUG] Configuration loaded successfully
[2025-12-29 17:27:09] [DEBUG] Database host: fcefrancxdck867a.mysql.db:3306
[2025-12-29 17:27:09] [DEBUG] Database name: fcefrancxdck867a
[2025-12-29 17:27:09] [DEBUG] Database user: fcefrancxdck867a
[2025-12-29 17:27:09] [DEBUG] Input file: /home/fcefrancxd-yp/www/scratch/fce_test.users.json
[2025-12-29 17:27:09] [DEBUG] Batch size: 100
[2025-12-29 17:27:09] [DEBUG] Skip duplicates: Yes
[2025-12-29 17:27:09] [DEBUG] Verbose mode: Yes
[2025-12-29 17:27:09] [DEBUG] PHP Version: 5.6.40
[2025-12-29 17:27:09] [DEBUG] Script start time: 2025-12-29 17:27:09
[2025-12-29 17:27:09] [DEBUG] Loading delegation mapping from delegation_mapping.json
[2025-12-29 17:27:09] [DEBUG] Delegation mapping loaded: 65 delegations mapped
[2025-12-29 17:27:09] [DEBUG] Loading sector mapping from sector_mapping.json
[2025-12-29 17:27:09] [DEBUG] Sector mapping loaded: 21 sectors mapped
[2025-12-29 17:27:09] [DEBUG] Loading sector to activiteparent mapping from sector_to_activiteparent_mapping.json
[2025-12-29 17:27:09] [DEBUG] Sector to activiteparent mapping loaded: 21 sectors mapped
[2025-12-29 17:27:09] [DEBUG] Building DSN connection string
[2025-12-29 17:27:09] [DEBUG] DSN: mysql:host=fcefrancxdck867a.mysql.db;port=3306;dbname=fcefrancxdck867a;charset=utf8
[2025-12-29 17:27:09] [DEBUG] Attempting PDO connection...
[2025-12-29 17:27:09] [DEBUG] PDO connection established successfully
[2025-12-29 17:27:09] [DEBUG] Setting charset to utf8mb4
[2025-12-29 17:27:09] [DEBUG] Charset set successfully
[2025-12-29 17:27:09] [DEBUG] Checking if JSON file exists...
[2025-12-29 17:27:09] [DEBUG] JSON file found
[2025-12-29 17:27:09] [DEBUG] Reading JSON file contents...
[2025-12-29 17:27:09] [DEBUG] JSON file size: 9,721 bytes
[2025-12-29 17:27:09] [DEBUG] First 100 chars: [{
  "_id": {
    "$oid": "68bed4767bbf1f85db752cff"
  },
  "fceId": 733791,
  "email": "veronique.d
[2025-12-29 17:27:09] [DEBUG] Decoding JSON...
[2025-12-29 17:27:09] [DEBUG] JSON decoded
[2025-12-29 17:27:09] [DEBUG] JSON is valid
[2025-12-29 17:27:09] [DEBUG] Total users parsed: 2
[2025-12-29 17:27:09] [DEBUG] First user email: veronique.dijon@mercato-emploi.com
[2025-12-29 17:27:09] [DEBUG] Preparing INSERT statement...
[2025-12-29 17:27:09] [DEBUG] Preparing PDO statement...
[2025-12-29 17:27:09] [DEBUG] INSERT statement prepared successfully
[2025-12-29 17:27:09] [DEBUG] Preparing duplicate check statement...
[2025-12-29 17:27:09] [DEBUG] Duplicate check statement prepared
[2025-12-29 17:27:09] [DEBUG] Starting user processing loop
[2025-12-29 17:27:09] [DEBUG] Beginning database transaction
[2025-12-29 17:27:09] [DEBUG] Transaction started
[2025-12-29 17:27:09] [DEBUG] Processing user 1/2
[2025-12-29 17:27:09] [DEBUG] User email: veronique.dijon@mercato-emploi.com
[2025-12-29 17:27:09] [DEBUG] Checking if user exists: veronique.dijon@mercato-emploi.com
[2025-12-29 17:27:09] [DEBUG] User exists: No
[2025-12-29 17:27:09] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-29 17:27:09] [DEBUG] Data mapped, inserting user...
[2025-12-29 17:27:09] [DEBUG] User inserted successfully with ID: 6920
[2025-12-29 17:27:09] [DEBUG] Inserting user_delegation: user_id=6920, delegation_id=5472
[2025-12-29 17:27:09] [DEBUG] user_delegation inserted successfully
[2025-12-29 17:27:09] [DEBUG] Inserting user_activite: user_id=6920, activite_id=37 (sector=DIGITAL_SERVICES_AND_CYBERSECURITY)
[2025-12-29 17:27:09] [ERROR] WARNING: Failed to insert user_activite: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'fcefrancxdck867a.user_activite' doesn't exist
[2025-12-29 17:27:09] [DEBUG] Inserting paiement: user_id=6920, year=2025, amount=269
[2025-12-29 17:27:09] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-29 17:27:09] [DEBUG] Processing user 2/2
[2025-12-29 17:27:09] [DEBUG] User email: christele@capyxia.com
[2025-12-29 17:27:09] [DEBUG] Checking if user exists: christele@capyxia.com
[2025-12-29 17:27:09] [DEBUG] User exists: No
[2025-12-29 17:27:09] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-29 17:27:09] [DEBUG] Data mapped, inserting user...
[2025-12-29 17:27:09] [DEBUG] User inserted successfully with ID: 6921
[2025-12-29 17:27:09] [DEBUG] Inserting user_delegation: user_id=6921, delegation_id=5576
[2025-12-29 17:27:09] [DEBUG] user_delegation inserted successfully
[2025-12-29 17:27:09] [DEBUG] Inserting user_activite: user_id=6921, activite_id=52 (sector=BUSINESS_SERVICES)
[2025-12-29 17:27:09] [ERROR] WARNING: Failed to insert user_activite: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'fcefrancxdck867a.user_activite' doesn't exist
[2025-12-29 17:27:09] [DEBUG] Inserting paiement: user_id=6921, year=2025, amount=253
[2025-12-29 17:27:09] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-29 17:27:09] [DEBUG] Processing complete, committing final batch
[2025-12-29 17:27:09] [DEBUG] Committing final 2 users
[2025-12-29 17:27:09] [DEBUG] Final commit successful
[2025-12-29 17:27:09] [DEBUG] ID mapping contains 2 entries
[2025-12-29 17:27:09] [DEBUG] Mapping file: /home/fcefrancxd-yp/www/scratch/user_id_mapping.json
[2025-12-29 17:27:09] [DEBUG] JSON mapping size: 395 bytes
[2025-12-29 17:27:09] [DEBUG] ID mapping saved successfully (395 bytes written)
[2025-12-29 17:27:09] [DEBUG] Import process completed
[2025-12-29 17:27:09] [DEBUG] Total duration: 0.07 seconds
[2025-12-29 17:27:09] [DEBUG] Average time per user: 0.035 seconds
[2025-12-29 17:27:09] [DEBUG] Import completed successfully with no errors
[2025-12-29 17:29:45] [DEBUG] Loading configuration from config.php
[2025-12-29 17:29:45] [DEBUG] Configuration loaded successfully
[2025-12-29 17:29:45] [DEBUG] Database host: fcefrancxdck867a.mysql.db:3306
[2025-12-29 17:29:45] [DEBUG] Database name: fcefrancxdck867a
[2025-12-29 17:29:45] [DEBUG] Database user: fcefrancxdck867a
[2025-12-29 17:29:45] [DEBUG] Input file: /home/fcefrancxd-yp/www/scratch/fce_test.users.json
[2025-12-29 17:29:45] [DEBUG] Batch size: 100
[2025-12-29 17:29:45] [DEBUG] Skip duplicates: Yes
[2025-12-29 17:29:45] [DEBUG] Verbose mode: Yes
[2025-12-29 17:29:45] [DEBUG] PHP Version: 5.6.40
[2025-12-29 17:29:45] [DEBUG] Script start time: 2025-12-29 17:29:45
[2025-12-29 17:29:45] [DEBUG] Loading delegation mapping from delegation_mapping.json
[2025-12-29 17:29:45] [DEBUG] Delegation mapping loaded: 65 delegations mapped
[2025-12-29 17:29:45] [DEBUG] Loading sector mapping from sector_mapping.json
[2025-12-29 17:29:45] [DEBUG] Sector mapping loaded: 21 sectors mapped
[2025-12-29 17:29:45] [DEBUG] Loading sector to activiteparent mapping from sector_to_activiteparent_mapping.json
[2025-12-29 17:29:45] [DEBUG] Sector to activiteparent mapping loaded: 21 sectors mapped
[2025-12-29 17:29:45] [DEBUG] Loading employees mapping from employees_mapping.json
[2025-12-29 17:29:45] [DEBUG] Employees mapping loaded: 10 values mapped
[2025-12-29 17:29:45] [DEBUG] Loading revenue mapping from revenue_mapping.json
[2025-12-29 17:29:45] [DEBUG] Revenue mapping loaded: 9 values mapped
[2025-12-29 17:29:45] [DEBUG] Loading professions mapping from professions_mapping.json
[2025-12-29 17:29:45] [DEBUG] Professions mapping loaded: 13 values mapped
[2025-12-29 17:29:45] [DEBUG] Building DSN connection string
[2025-12-29 17:29:45] [DEBUG] DSN: mysql:host=fcefrancxdck867a.mysql.db;port=3306;dbname=fcefrancxdck867a;charset=utf8
[2025-12-29 17:29:45] [DEBUG] Attempting PDO connection...
[2025-12-29 17:29:45] [DEBUG] PDO connection established successfully
[2025-12-29 17:29:45] [DEBUG] Setting charset to utf8
[2025-12-29 17:29:45] [DEBUG] Charset set successfully
[2025-12-29 17:29:45] [DEBUG] Checking if JSON file exists...
[2025-12-29 17:29:45] [DEBUG] JSON file found
[2025-12-29 17:29:45] [DEBUG] Reading JSON file contents...
[2025-12-29 17:29:45] [DEBUG] JSON file size: 9,721 bytes
[2025-12-29 17:29:45] [DEBUG] First 100 chars: [{
  "_id": {
    "$oid": "68bed4767bbf1f85db752cff"
  },
  "fceId": 733791,
  "email": "veronique.d
[2025-12-29 17:29:45] [DEBUG] Decoding JSON...
[2025-12-29 17:29:45] [DEBUG] JSON decoded
[2025-12-29 17:29:45] [DEBUG] JSON is valid
[2025-12-29 17:29:45] [DEBUG] Total users parsed: 2
[2025-12-29 17:29:45] [DEBUG] First user email: veronique.dijon@mercato-emploi.com
[2025-12-29 17:29:45] [DEBUG] Preparing INSERT statement...
[2025-12-29 17:29:45] [DEBUG] Preparing PDO statement...
[2025-12-29 17:29:45] [DEBUG] INSERT statement prepared successfully
[2025-12-29 17:29:45] [DEBUG] Preparing duplicate check statement...
[2025-12-29 17:29:45] [DEBUG] Duplicate check statement prepared
[2025-12-29 17:29:45] [DEBUG] Starting user processing loop
[2025-12-29 17:29:45] [DEBUG] Beginning database transaction
[2025-12-29 17:29:45] [DEBUG] Transaction started
[2025-12-29 17:29:45] [DEBUG] Processing user 1/2
[2025-12-29 17:29:45] [DEBUG] User email: veronique.dijon@mercato-emploi.com
[2025-12-29 17:29:45] [DEBUG] Checking if user exists: veronique.dijon@mercato-emploi.com
[2025-12-29 17:29:45] [DEBUG] User exists: No
[2025-12-29 17:29:45] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-29 17:29:45] [DEBUG] Data mapped, inserting user...
[2025-12-29 17:29:45] [DEBUG] User inserted successfully with ID: 6922
[2025-12-29 17:29:45] [DEBUG] Inserting delegation_user: user_id=6922, delegation_id=5472
[2025-12-29 17:29:45] [ERROR] WARNING: Failed to insert delegation_user: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'fcefrancxdck867a.delegation_user' doesn't exist
[2025-12-29 17:29:45] [DEBUG] Inserting activite_user: user_id=6922, activite_id=37 (sector=DIGITAL_SERVICES_AND_CYBERSECURITY)
[2025-12-29 17:29:45] [DEBUG] activite_user inserted successfully
[2025-12-29 17:29:45] [DEBUG] Inserting paiement: user_id=6922, year=2025, amount=269
[2025-12-29 17:29:45] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-29 17:29:45] [DEBUG] Processing user 2/2
[2025-12-29 17:29:45] [DEBUG] User email: christele@capyxia.com
[2025-12-29 17:29:45] [DEBUG] Checking if user exists: christele@capyxia.com
[2025-12-29 17:29:45] [DEBUG] User exists: No
[2025-12-29 17:29:45] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-29 17:29:45] [DEBUG] Data mapped, inserting user...
[2025-12-29 17:29:45] [DEBUG] User inserted successfully with ID: 6923
[2025-12-29 17:29:45] [DEBUG] Inserting delegation_user: user_id=6923, delegation_id=5576
[2025-12-29 17:29:45] [ERROR] WARNING: Failed to insert delegation_user: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'fcefrancxdck867a.delegation_user' doesn't exist
[2025-12-29 17:29:45] [DEBUG] Inserting activite_user: user_id=6923, activite_id=52 (sector=BUSINESS_SERVICES)
[2025-12-29 17:29:45] [DEBUG] activite_user inserted successfully
[2025-12-29 17:29:45] [DEBUG] Inserting paiement: user_id=6923, year=2025, amount=253
[2025-12-29 17:29:45] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-29 17:29:45] [DEBUG] Processing complete, committing final batch
[2025-12-29 17:29:45] [DEBUG] Committing final 2 users
[2025-12-29 17:29:45] [DEBUG] Final commit successful
[2025-12-29 17:29:45] [DEBUG] ID mapping contains 2 entries
[2025-12-29 17:29:45] [DEBUG] Mapping file: /home/fcefrancxd-yp/www/scratch/user_id_mapping.json
[2025-12-29 17:29:45] [DEBUG] JSON mapping size: 395 bytes
[2025-12-29 17:29:45] [DEBUG] ID mapping saved successfully (395 bytes written)
[2025-12-29 17:29:45] [DEBUG] Import process completed
[2025-12-29 17:29:45] [DEBUG] Total duration: 0.08 seconds
[2025-12-29 17:29:45] [DEBUG] Average time per user: 0.04 seconds
[2025-12-29 17:29:45] [DEBUG] Import completed successfully with no errors
[2025-12-29 17:51:00] [DEBUG] Loading configuration from config.php
[2025-12-29 17:51:00] [DEBUG] Configuration loaded successfully
[2025-12-29 17:51:00] [DEBUG] Database host: fcefrancxdck867a.mysql.db:3306
[2025-12-29 17:51:00] [DEBUG] Database name: fcefrancxdck867a
[2025-12-29 17:51:00] [DEBUG] Database user: fcefrancxdck867a
[2025-12-29 17:51:00] [DEBUG] Input file: /home/fcefrancxd-yp/www/scratch/fce_test.users.json
[2025-12-29 17:51:00] [DEBUG] Batch size: 100
[2025-12-29 17:51:00] [DEBUG] Skip duplicates: Yes
[2025-12-29 17:51:00] [DEBUG] Verbose mode: Yes
[2025-12-29 17:51:00] [DEBUG] PHP Version: 5.6.40
[2025-12-29 17:51:00] [DEBUG] Script start time: 2025-12-29 17:51:00
[2025-12-29 17:51:00] [DEBUG] Loading delegation mapping from delegation_mapping.json
[2025-12-29 17:51:00] [DEBUG] Delegation mapping loaded: 65 delegations mapped
[2025-12-29 17:51:00] [DEBUG] Loading sector mapping from sector_mapping.json
[2025-12-29 17:51:00] [DEBUG] Sector mapping loaded: 21 sectors mapped
[2025-12-29 17:51:00] [DEBUG] Loading sector to activiteparent mapping from sector_to_activiteparent_mapping.json
[2025-12-29 17:51:00] [DEBUG] Sector to activiteparent mapping loaded: 21 sectors mapped
[2025-12-29 17:51:00] [DEBUG] Loading employees mapping from employees_mapping.json
[2025-12-29 17:51:00] [DEBUG] Employees mapping loaded: 10 values mapped
[2025-12-29 17:51:00] [DEBUG] Loading revenue mapping from revenue_mapping.json
[2025-12-29 17:51:00] [DEBUG] Revenue mapping loaded: 9 values mapped
[2025-12-29 17:51:00] [DEBUG] Loading professions mapping from professions_mapping.json
[2025-12-29 17:51:00] [DEBUG] Professions mapping loaded: 13 values mapped
[2025-12-29 17:51:00] [DEBUG] Building DSN connection string
[2025-12-29 17:51:00] [DEBUG] DSN: mysql:host=fcefrancxdck867a.mysql.db;port=3306;dbname=fcefrancxdck867a;charset=utf8
[2025-12-29 17:51:00] [DEBUG] Attempting PDO connection...
[2025-12-29 17:51:00] [DEBUG] PDO connection established successfully
[2025-12-29 17:51:00] [DEBUG] Setting charset to utf8
[2025-12-29 17:51:00] [DEBUG] Charset set successfully
[2025-12-29 17:51:00] [DEBUG] Checking if JSON file exists...
[2025-12-29 17:51:00] [DEBUG] JSON file found
[2025-12-29 17:51:00] [DEBUG] Reading JSON file contents...
[2025-12-29 17:51:00] [DEBUG] JSON file size: 9,721 bytes
[2025-12-29 17:51:00] [DEBUG] First 100 chars: [{
  "_id": {
    "$oid": "68bed4767bbf1f85db752cff"
  },
  "fceId": 733791,
  "email": "veronique.d
[2025-12-29 17:51:00] [DEBUG] Decoding JSON...
[2025-12-29 17:51:00] [DEBUG] JSON decoded
[2025-12-29 17:51:00] [DEBUG] JSON is valid
[2025-12-29 17:51:00] [DEBUG] Total users parsed: 2
[2025-12-29 17:51:00] [DEBUG] First user email: veronique.dijon@mercato-emploi.com
[2025-12-29 17:51:00] [DEBUG] Preparing INSERT statement...
[2025-12-29 17:51:00] [DEBUG] Preparing PDO statement...
[2025-12-29 17:51:00] [DEBUG] INSERT statement prepared successfully
[2025-12-29 17:51:00] [DEBUG] Preparing duplicate check statement...
[2025-12-29 17:51:00] [DEBUG] Duplicate check statement prepared
[2025-12-29 17:51:00] [DEBUG] Starting user processing loop
[2025-12-29 17:51:00] [DEBUG] Beginning database transaction
[2025-12-29 17:51:00] [DEBUG] Transaction started
[2025-12-29 17:51:00] [DEBUG] Processing user 1/2
[2025-12-29 17:51:00] [DEBUG] User email: veronique.dijon@mercato-emploi.com
[2025-12-29 17:51:00] [DEBUG] Checking if user exists: veronique.dijon@mercato-emploi.com
[2025-12-29 17:51:00] [DEBUG] User exists: No
[2025-12-29 17:51:00] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-29 17:51:00] [DEBUG] Data mapped, inserting user...
[2025-12-29 17:51:00] [DEBUG] User inserted successfully with ID: 6924
[2025-12-29 17:51:00] [DEBUG] Inserting delegation_user: user_id=6924, delegation_id=5472
[2025-12-29 17:51:00] [ERROR] WARNING: Failed to insert delegation_user: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'fcefrancxdck867a.delegation_user' doesn't exist
[2025-12-29 17:51:00] [DEBUG] Inserting activite_user: user_id=6924, activite_id=37 (sector=DIGITAL_SERVICES_AND_CYBERSECURITY)
[2025-12-29 17:51:00] [DEBUG] activite_user inserted successfully
[2025-12-29 17:51:00] [DEBUG] Inserting paiement: user_id=6924, year=2025, amount=269
[2025-12-29 17:51:00] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-29 17:51:00] [DEBUG] Processing user 2/2
[2025-12-29 17:51:00] [DEBUG] User email: christele@capyxia.com
[2025-12-29 17:51:00] [DEBUG] Checking if user exists: christele@capyxia.com
[2025-12-29 17:51:00] [DEBUG] User exists: No
[2025-12-29 17:51:00] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-29 17:51:00] [DEBUG] Data mapped, inserting user...
[2025-12-29 17:51:00] [DEBUG] User inserted successfully with ID: 6925
[2025-12-29 17:51:00] [DEBUG] Inserting delegation_user: user_id=6925, delegation_id=5576
[2025-12-29 17:51:00] [ERROR] WARNING: Failed to insert delegation_user: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'fcefrancxdck867a.delegation_user' doesn't exist
[2025-12-29 17:51:00] [DEBUG] Inserting activite_user: user_id=6925, activite_id=52 (sector=BUSINESS_SERVICES)
[2025-12-29 17:51:00] [DEBUG] activite_user inserted successfully
[2025-12-29 17:51:00] [DEBUG] Inserting paiement: user_id=6925, year=2025, amount=253
[2025-12-29 17:51:00] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-29 17:51:00] [DEBUG] Processing complete, committing final batch
[2025-12-29 17:51:00] [DEBUG] Committing final 2 users
[2025-12-29 17:51:00] [DEBUG] Final commit successful
[2025-12-29 17:51:00] [DEBUG] ID mapping contains 2 entries
[2025-12-29 17:51:00] [DEBUG] Mapping file: /home/fcefrancxd-yp/www/scratch/user_id_mapping.json
[2025-12-29 17:51:00] [DEBUG] JSON mapping size: 395 bytes
[2025-12-29 17:51:00] [DEBUG] ID mapping saved successfully (395 bytes written)
[2025-12-29 17:51:00] [DEBUG] Import process completed
[2025-12-29 17:51:00] [DEBUG] Total duration: 0.09 seconds
[2025-12-29 17:51:00] [DEBUG] Average time per user: 0.045 seconds
[2025-12-29 17:51:00] [DEBUG] Import completed successfully with no errors
[2025-12-29 18:00:26] [DEBUG] Loading configuration from config.php
[2025-12-29 18:00:26] [DEBUG] Configuration loaded successfully
[2025-12-29 18:00:26] [DEBUG] Database host: fcefrancxdck867a.mysql.db:3306
[2025-12-29 18:00:26] [DEBUG] Database name: fcefrancxdck867a
[2025-12-29 18:00:26] [DEBUG] Database user: fcefrancxdck867a
[2025-12-29 18:00:26] [DEBUG] Input file: /home/fcefrancxd-yp/www/scratch/fce_test.users.json
[2025-12-29 18:00:26] [DEBUG] Batch size: 100
[2025-12-29 18:00:26] [DEBUG] Skip duplicates: Yes
[2025-12-29 18:00:26] [DEBUG] Verbose mode: Yes
[2025-12-29 18:00:26] [DEBUG] PHP Version: 5.6.40
[2025-12-29 18:00:26] [DEBUG] Script start time: 2025-12-29 18:00:26
[2025-12-29 18:00:26] [DEBUG] Loading delegation mapping from delegation_mapping.json
[2025-12-29 18:00:26] [DEBUG] Delegation mapping loaded: 65 delegations mapped
[2025-12-29 18:00:26] [DEBUG] Loading sector mapping from sector_mapping.json
[2025-12-29 18:00:26] [DEBUG] Sector mapping loaded: 21 sectors mapped
[2025-12-29 18:00:26] [DEBUG] Loading sector to activiteparent mapping from sector_to_activiteparent_mapping.json
[2025-12-29 18:00:26] [DEBUG] Sector to activiteparent mapping loaded: 21 sectors mapped
[2025-12-29 18:00:26] [DEBUG] Loading employees mapping from employees_mapping.json
[2025-12-29 18:00:26] [DEBUG] Employees mapping loaded: 10 values mapped
[2025-12-29 18:00:26] [DEBUG] Loading revenue mapping from revenue_mapping.json
[2025-12-29 18:00:26] [DEBUG] Revenue mapping loaded: 9 values mapped
[2025-12-29 18:00:26] [DEBUG] Loading professions mapping from professions_mapping.json
[2025-12-29 18:00:26] [DEBUG] Professions mapping loaded: 13 values mapped
[2025-12-29 18:00:26] [DEBUG] Building DSN connection string
[2025-12-29 18:00:26] [DEBUG] DSN: mysql:host=fcefrancxdck867a.mysql.db;port=3306;dbname=fcefrancxdck867a;charset=utf8
[2025-12-29 18:00:26] [DEBUG] Attempting PDO connection...
[2025-12-29 18:00:26] [DEBUG] PDO connection established successfully
[2025-12-29 18:00:26] [DEBUG] Setting charset to utf8
[2025-12-29 18:00:26] [DEBUG] Charset set successfully
[2025-12-29 18:00:26] [DEBUG] Checking if JSON file exists...
[2025-12-29 18:00:26] [DEBUG] JSON file found
[2025-12-29 18:00:26] [DEBUG] Reading JSON file contents...
[2025-12-29 18:00:26] [DEBUG] JSON file size: 9,721 bytes
[2025-12-29 18:00:26] [DEBUG] First 100 chars: [{
  "_id": {
    "$oid": "68bed4767bbf1f85db752cff"
  },
  "fceId": 733791,
  "email": "veronique.d
[2025-12-29 18:00:26] [DEBUG] Decoding JSON...
[2025-12-29 18:00:26] [DEBUG] JSON decoded
[2025-12-29 18:00:26] [DEBUG] JSON is valid
[2025-12-29 18:00:26] [DEBUG] Total users parsed: 2
[2025-12-29 18:00:26] [DEBUG] First user email: veronique.dijon@mercato-emploi.com
[2025-12-29 18:00:26] [DEBUG] Preparing INSERT statement...
[2025-12-29 18:00:26] [DEBUG] Preparing PDO statement...
[2025-12-29 18:00:26] [DEBUG] INSERT statement prepared successfully
[2025-12-29 18:00:26] [DEBUG] Preparing duplicate check statement...
[2025-12-29 18:00:26] [DEBUG] Duplicate check statement prepared
[2025-12-29 18:00:26] [DEBUG] Starting user processing loop
[2025-12-29 18:00:26] [DEBUG] Beginning database transaction
[2025-12-29 18:00:26] [DEBUG] Transaction started
[2025-12-29 18:00:26] [DEBUG] Processing user 1/2
[2025-12-29 18:00:26] [DEBUG] User email: veronique.dijon@mercato-emploi.com
[2025-12-29 18:00:26] [DEBUG] Checking if user exists: veronique.dijon@mercato-emploi.com
[2025-12-29 18:00:26] [DEBUG] User exists: No
[2025-12-29 18:00:26] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-29 18:00:26] [DEBUG] Data mapped, inserting user...
[2025-12-29 18:00:26] [DEBUG] User inserted successfully with ID: 6926
[2025-12-29 18:00:26] [DEBUG] Inserting user_delegation: user_id=6926, delegation_id=5472
[2025-12-29 18:00:26] [DEBUG] user_delegation inserted successfully
[2025-12-29 18:00:26] [DEBUG] Inserting activite_user: user_id=6926, activite_id=37 (sector=DIGITAL_SERVICES_AND_CYBERSECURITY)
[2025-12-29 18:00:26] [DEBUG] activite_user inserted successfully
[2025-12-29 18:00:26] [DEBUG] Inserting paiement: user_id=6926, year=2025, amount=269
[2025-12-29 18:00:26] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-29 18:00:26] [DEBUG] Processing user 2/2
[2025-12-29 18:00:26] [DEBUG] User email: christele@capyxia.com
[2025-12-29 18:00:26] [DEBUG] Checking if user exists: christele@capyxia.com
[2025-12-29 18:00:26] [DEBUG] User exists: No
[2025-12-29 18:00:26] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-29 18:00:26] [DEBUG] Data mapped, inserting user...
[2025-12-29 18:00:26] [DEBUG] User inserted successfully with ID: 6927
[2025-12-29 18:00:26] [DEBUG] Inserting user_delegation: user_id=6927, delegation_id=5576
[2025-12-29 18:00:26] [DEBUG] user_delegation inserted successfully
[2025-12-29 18:00:26] [DEBUG] Inserting activite_user: user_id=6927, activite_id=52 (sector=BUSINESS_SERVICES)
[2025-12-29 18:00:26] [DEBUG] activite_user inserted successfully
[2025-12-29 18:00:26] [DEBUG] Inserting paiement: user_id=6927, year=2025, amount=253
[2025-12-29 18:00:26] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-29 18:00:26] [DEBUG] Processing complete, committing final batch
[2025-12-29 18:00:26] [DEBUG] Committing final 2 users
[2025-12-29 18:00:26] [DEBUG] Final commit successful
[2025-12-29 18:00:26] [DEBUG] ID mapping contains 2 entries
[2025-12-29 18:00:26] [DEBUG] Mapping file: /home/fcefrancxd-yp/www/scratch/user_id_mapping.json
[2025-12-29 18:00:26] [DEBUG] JSON mapping size: 395 bytes
[2025-12-29 18:00:26] [DEBUG] ID mapping saved successfully (395 bytes written)
[2025-12-29 18:00:26] [DEBUG] Import process completed
[2025-12-29 18:00:26] [DEBUG] Total duration: 0.06 seconds
[2025-12-29 18:00:26] [DEBUG] Average time per user: 0.03 seconds
[2025-12-29 18:00:26] [DEBUG] Import completed successfully with no errors
[2025-12-30 09:58:34] [DEBUG] Loading configuration from config.php
[2025-12-30 09:58:34] [DEBUG] Configuration loaded successfully
[2025-12-30 09:58:34] [DEBUG] Database host: fcefrancxdck867a.mysql.db:3306
[2025-12-30 09:58:34] [DEBUG] Database name: fcefrancxdck867a
[2025-12-30 09:58:34] [DEBUG] Database user: fcefrancxdck867a
[2025-12-30 09:58:34] [DEBUG] Input file: /home/fcefrancxd-yp/www/scratch/fce_new.users.json
[2025-12-30 09:58:34] [DEBUG] Batch size: 100
[2025-12-30 09:58:34] [DEBUG] Skip duplicates: Yes
[2025-12-30 09:58:34] [DEBUG] Verbose mode: Yes
[2025-12-30 09:58:34] [DEBUG] PHP Version: 5.6.40
[2025-12-30 09:58:34] [DEBUG] Script start time: 2025-12-30 09:58:34
[2025-12-30 09:58:34] [DEBUG] Loading delegation mapping from delegation_mapping.json
[2025-12-30 09:58:34] [DEBUG] Delegation mapping loaded: 65 delegations mapped
[2025-12-30 09:58:34] [DEBUG] Loading sector mapping from sector_mapping.json
[2025-12-30 09:58:34] [DEBUG] Sector mapping loaded: 21 sectors mapped
[2025-12-30 09:58:34] [DEBUG] Loading sector to activiteparent mapping from sector_to_activiteparent_mapping.json
[2025-12-30 09:58:34] [DEBUG] Sector to activiteparent mapping loaded: 21 sectors mapped
[2025-12-30 09:58:34] [DEBUG] Loading employees mapping from employees_mapping.json
[2025-12-30 09:58:34] [DEBUG] Employees mapping loaded: 10 values mapped
[2025-12-30 09:58:34] [DEBUG] Loading revenue mapping from revenue_mapping.json
[2025-12-30 09:58:34] [DEBUG] Revenue mapping loaded: 9 values mapped
[2025-12-30 09:58:34] [DEBUG] Loading professions mapping from professions_mapping.json
[2025-12-30 09:58:34] [DEBUG] Professions mapping loaded: 13 values mapped
[2025-12-30 09:58:34] [DEBUG] Building DSN connection string
[2025-12-30 09:58:34] [DEBUG] DSN: mysql:host=fcefrancxdck867a.mysql.db;port=3306;dbname=fcefrancxdck867a;charset=utf8
[2025-12-30 09:58:34] [DEBUG] Attempting PDO connection...
[2025-12-30 09:58:34] [DEBUG] PDO connection established successfully
[2025-12-30 09:58:34] [DEBUG] Setting charset to utf8
[2025-12-30 09:58:34] [DEBUG] Charset set successfully
[2025-12-30 09:58:34] [DEBUG] Checking if JSON file exists...
[2025-12-30 09:58:34] [DEBUG] JSON file found
[2025-12-30 09:58:34] [DEBUG] Reading JSON file contents...
[2025-12-30 09:58:34] [DEBUG] JSON file size: 383,706 bytes
[2025-12-30 09:58:34] [DEBUG] First 100 chars: [{
  "_id": {
    "$oid": "68bf49b9734f3afd179d1d93"
  },
  "fceId": 934322,
  "email": "lydie.lauge
[2025-12-30 09:58:34] [DEBUG] Decoding JSON...
[2025-12-30 09:58:34] [DEBUG] JSON decoded
[2025-12-30 09:58:34] [DEBUG] JSON is valid
[2025-12-30 09:58:34] [DEBUG] Total users parsed: 125
[2025-12-30 09:58:34] [DEBUG] First user email: lydie.laugeon@infonecs.pf
[2025-12-30 09:58:34] [DEBUG] Preparing INSERT statement...
[2025-12-30 09:58:34] [DEBUG] Preparing PDO statement...
[2025-12-30 09:58:34] [DEBUG] INSERT statement prepared successfully
[2025-12-30 09:58:34] [DEBUG] Preparing duplicate check statement...
[2025-12-30 09:58:34] [DEBUG] Duplicate check statement prepared
[2025-12-30 09:58:34] [DEBUG] Starting user processing loop
[2025-12-30 09:58:34] [DEBUG] Beginning database transaction
[2025-12-30 09:58:34] [DEBUG] Transaction started
[2025-12-30 09:58:34] [DEBUG] Processing user 1/125
[2025-12-30 09:58:34] [DEBUG] User email: lydie.laugeon@infonecs.pf
[2025-12-30 09:58:34] [DEBUG] Checking if user exists: lydie.laugeon@infonecs.pf
[2025-12-30 09:58:34] [DEBUG] User exists: No
[2025-12-30 09:58:34] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:34] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:34] [DEBUG] User inserted successfully with ID: 6928
[2025-12-30 09:58:34] [DEBUG] Inserting user_delegation: user_id=6928, delegation_id=5512
[2025-12-30 09:58:34] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting activite_user: user_id=6928, activite_id=37 (sector=DIGITAL_SERVICES_AND_CYBERSECURITY)
[2025-12-30 09:58:34] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting paiement: user_id=6928, year=2025, amount=103
[2025-12-30 09:58:34] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:34] [DEBUG] Processing user 2/125
[2025-12-30 09:58:34] [DEBUG] User email: rcalzia@regine-calzia-avocat.fr
[2025-12-30 09:58:34] [DEBUG] Checking if user exists: rcalzia@regine-calzia-avocat.fr
[2025-12-30 09:58:34] [DEBUG] User exists: No
[2025-12-30 09:58:34] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:34] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:34] [DEBUG] User inserted successfully with ID: 6929
[2025-12-30 09:58:34] [DEBUG] Inserting user_delegation: user_id=6929, delegation_id=5487
[2025-12-30 09:58:34] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting activite_user: user_id=6929, activite_id=11 (sector=LEGAL)
[2025-12-30 09:58:34] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting paiement: user_id=6929, year=2025, amount=217
[2025-12-30 09:58:34] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:34] [DEBUG] Processing user 3/125
[2025-12-30 09:58:34] [DEBUG] User email: beaucourt.anais@holirh.fr
[2025-12-30 09:58:34] [DEBUG] Checking if user exists: beaucourt.anais@holirh.fr
[2025-12-30 09:58:34] [DEBUG] User exists: No
[2025-12-30 09:58:34] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:34] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:34] [DEBUG] User inserted successfully with ID: 6930
[2025-12-30 09:58:34] [DEBUG] Inserting user_delegation: user_id=6930, delegation_id=5480
[2025-12-30 09:58:34] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting activite_user: user_id=6930, activite_id=52 (sector=BUSINESS_SERVICES)
[2025-12-30 09:58:34] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting paiement: user_id=6930, year=2025, amount=74
[2025-12-30 09:58:34] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:34] [DEBUG] Processing user 4/125
[2025-12-30 09:58:34] [DEBUG] User email: alexandra@pepite-gestion.fr
[2025-12-30 09:58:34] [DEBUG] Checking if user exists: alexandra@pepite-gestion.fr
[2025-12-30 09:58:34] [DEBUG] User exists: No
[2025-12-30 09:58:34] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:34] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:34] [DEBUG] User inserted successfully with ID: 6931
[2025-12-30 09:58:34] [DEBUG] Inserting user_delegation: user_id=6931, delegation_id=5458
[2025-12-30 09:58:34] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting activite_user: user_id=6931, activite_id=52 (sector=BUSINESS_SERVICES)
[2025-12-30 09:58:34] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting paiement: user_id=6931, year=2025, amount=88
[2025-12-30 09:58:34] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:34] [DEBUG] Processing user 5/125
[2025-12-30 09:58:34] [DEBUG] User email: beyst.sportraining@gmail.com
[2025-12-30 09:58:34] [DEBUG] Checking if user exists: beyst.sportraining@gmail.com
[2025-12-30 09:58:34] [DEBUG] User exists: No
[2025-12-30 09:58:34] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:34] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:34] [DEBUG] User inserted successfully with ID: 6932
[2025-12-30 09:58:34] [DEBUG] Inserting user_delegation: user_id=6932, delegation_id=36
[2025-12-30 09:58:34] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting activite_user: user_id=6932, activite_id=30 (sector=HEALTH)
[2025-12-30 09:58:34] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting paiement: user_id=6932, year=2025, amount=236
[2025-12-30 09:58:34] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:34] [DEBUG] Processing user 6/125
[2025-12-30 09:58:34] [DEBUG] User email: contact@6emesens-coaching.fr
[2025-12-30 09:58:34] [DEBUG] Checking if user exists: contact@6emesens-coaching.fr
[2025-12-30 09:58:34] [DEBUG] User exists: No
[2025-12-30 09:58:34] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:34] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:34] [DEBUG] User inserted successfully with ID: 6933
[2025-12-30 09:58:34] [DEBUG] Inserting user_delegation: user_id=6933, delegation_id=5576
[2025-12-30 09:58:34] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting activite_user: user_id=6933, activite_id=37 (sector=DIGITAL_AND_TECHNOLOGIES)
[2025-12-30 09:58:34] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting paiement: user_id=6933, year=2025, amount=253
[2025-12-30 09:58:34] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:34] [DEBUG] Processing user 7/125
[2025-12-30 09:58:34] [DEBUG] User email: apsailly@gmail.com
[2025-12-30 09:58:34] [DEBUG] Checking if user exists: apsailly@gmail.com
[2025-12-30 09:58:34] [DEBUG] User exists: No
[2025-12-30 09:58:34] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:34] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:34] [DEBUG] User inserted successfully with ID: 6934
[2025-12-30 09:58:34] [DEBUG] Inserting user_delegation: user_id=6934, delegation_id=5458
[2025-12-30 09:58:34] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting activite_user: user_id=6934, activite_id=30 (sector=HEALTH)
[2025-12-30 09:58:34] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting paiement: user_id=6934, year=2025, amount=287
[2025-12-30 09:58:34] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:34] [DEBUG] Processing user 8/125
[2025-12-30 09:58:34] [DEBUG] User email: sandra.dasilva@immopret.fr
[2025-12-30 09:58:34] [DEBUG] Checking if user exists: sandra.dasilva@immopret.fr
[2025-12-30 09:58:34] [DEBUG] User exists: No
[2025-12-30 09:58:34] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:34] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:34] [DEBUG] User inserted successfully with ID: 6935
[2025-12-30 09:58:34] [DEBUG] Inserting user_delegation: user_id=6935, delegation_id=30
[2025-12-30 09:58:34] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting activite_user: user_id=6935, activite_id=12 (sector=INSURANCE_AND_BANKING)
[2025-12-30 09:58:34] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting paiement: user_id=6935, year=2025, amount=236
[2025-12-30 09:58:34] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:34] [DEBUG] Processing user 9/125
[2025-12-30 09:58:34] [DEBUG] User email: hello@vmconseilmarketing.com
[2025-12-30 09:58:34] [DEBUG] Checking if user exists: hello@vmconseilmarketing.com
[2025-12-30 09:58:34] [DEBUG] User exists: No
[2025-12-30 09:58:34] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:34] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:34] [DEBUG] User inserted successfully with ID: 6936
[2025-12-30 09:58:34] [DEBUG] Inserting user_delegation: user_id=6936, delegation_id=29
[2025-12-30 09:58:34] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting activite_user: user_id=6936, activite_id=19 (sector=COMMUNICATION)
[2025-12-30 09:58:34] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting paiement: user_id=6936, year=2025, amount=244
[2025-12-30 09:58:34] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:34] [DEBUG] Processing user 10/125
[2025-12-30 09:58:34] [DEBUG] User email: marion.costes@ton-experte-conseil.fr
[2025-12-30 09:58:34] [DEBUG] Checking if user exists: marion.costes@ton-experte-conseil.fr
[2025-12-30 09:58:34] [DEBUG] User exists: No
[2025-12-30 09:58:34] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:34] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:34] [DEBUG] User inserted successfully with ID: 6937
[2025-12-30 09:58:34] [DEBUG] Inserting user_delegation: user_id=6937, delegation_id=5495
[2025-12-30 09:58:34] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting activite_user: user_id=6937, activite_id=52 (sector=BUSINESS_SERVICES)
[2025-12-30 09:58:34] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting paiement: user_id=6937, year=2025, amount=240
[2025-12-30 09:58:34] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:34] [DEBUG] Processing user 11/125
[2025-12-30 09:58:34] [DEBUG] User email: caroline@noese-conseil.fr
[2025-12-30 09:58:34] [DEBUG] Checking if user exists: caroline@noese-conseil.fr
[2025-12-30 09:58:34] [DEBUG] User exists: No
[2025-12-30 09:58:34] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:34] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:34] [DEBUG] User inserted successfully with ID: 6938
[2025-12-30 09:58:34] [DEBUG] Inserting user_delegation: user_id=6938, delegation_id=5471
[2025-12-30 09:58:34] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting activite_user: user_id=6938, activite_id=27 (sector=EDUCATION_AND_TRAINING)
[2025-12-30 09:58:34] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting paiement: user_id=6938, year=2025, amount=241
[2025-12-30 09:58:34] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:34] [DEBUG] Processing user 12/125
[2025-12-30 09:58:34] [DEBUG] User email: sophie.lech.halloin@gmail.com
[2025-12-30 09:58:34] [DEBUG] Checking if user exists: sophie.lech.halloin@gmail.com
[2025-12-30 09:58:34] [DEBUG] User exists: No
[2025-12-30 09:58:34] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:34] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:34] [DEBUG] User inserted successfully with ID: 6939
[2025-12-30 09:58:34] [DEBUG] Inserting user_delegation: user_id=6939, delegation_id=5495
[2025-12-30 09:58:34] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting activite_user: user_id=6939, activite_id=52 (sector=BUSINESS_SERVICES)
[2025-12-30 09:58:34] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting paiement: user_id=6939, year=2025, amount=62
[2025-12-30 09:58:34] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:34] [DEBUG] Processing user 13/125
[2025-12-30 09:58:34] [DEBUG] User email: kalouvel@gmail.com
[2025-12-30 09:58:34] [DEBUG] Checking if user exists: kalouvel@gmail.com
[2025-12-30 09:58:34] [DEBUG] User exists: No
[2025-12-30 09:58:34] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:34] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:34] [DEBUG] User inserted successfully with ID: 6940
[2025-12-30 09:58:34] [DEBUG] Inserting user_delegation: user_id=6940, delegation_id=5458
[2025-12-30 09:58:34] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting activite_user: user_id=6940, activite_id=52 (sector=BUSINESS_SERVICES)
[2025-12-30 09:58:34] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting paiement: user_id=6940, year=2025, amount=287
[2025-12-30 09:58:34] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:34] [DEBUG] Processing user 14/125
[2025-12-30 09:58:34] [DEBUG] User email: amandine@adhocrh.com
[2025-12-30 09:58:34] [DEBUG] Checking if user exists: amandine@adhocrh.com
[2025-12-30 09:58:34] [DEBUG] User exists: No
[2025-12-30 09:58:34] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:34] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:34] [DEBUG] User inserted successfully with ID: 6941
[2025-12-30 09:58:34] [DEBUG] Inserting user_delegation: user_id=6941, delegation_id=5576
[2025-12-30 09:58:34] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting activite_user: user_id=6941, activite_id=52 (sector=BUSINESS_SERVICES)
[2025-12-30 09:58:34] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting paiement: user_id=6941, year=2025, amount=253
[2025-12-30 09:58:34] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:34] [DEBUG] Processing user 15/125
[2025-12-30 09:58:34] [DEBUG] User email: direction@securilis.fr
[2025-12-30 09:58:34] [DEBUG] Checking if user exists: direction@securilis.fr
[2025-12-30 09:58:34] [DEBUG] User exists: No
[2025-12-30 09:58:34] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:34] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:34] [DEBUG] User inserted successfully with ID: 6942
[2025-12-30 09:58:34] [DEBUG] Inserting user_delegation: user_id=6942, delegation_id=5508
[2025-12-30 09:58:34] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting activite_user: user_id=6942, activite_id=52 (sector=BUSINESS_SERVICES)
[2025-12-30 09:58:34] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting paiement: user_id=6942, year=2025, amount=248
[2025-12-30 09:58:34] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:34] [DEBUG] Processing user 16/125
[2025-12-30 09:58:34] [DEBUG] User email: virginie.assalit@viapaie.com
[2025-12-30 09:58:34] [DEBUG] Checking if user exists: virginie.assalit@viapaie.com
[2025-12-30 09:58:34] [DEBUG] User exists: No
[2025-12-30 09:58:34] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:34] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:34] [DEBUG] User inserted successfully with ID: 6943
[2025-12-30 09:58:34] [DEBUG] Inserting user_delegation: user_id=6943, delegation_id=5457
[2025-12-30 09:58:34] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting activite_user: user_id=6943, activite_id=52 (sector=BUSINESS_SERVICES)
[2025-12-30 09:58:34] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting paiement: user_id=6943, year=2025, amount=241
[2025-12-30 09:58:34] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:34] [DEBUG] Processing user 17/125
[2025-12-30 09:58:34] [DEBUG] User email: admin1@jenkell.com
[2025-12-30 09:58:34] [DEBUG] Checking if user exists: admin1@jenkell.com
[2025-12-30 09:58:34] [DEBUG] User exists: No
[2025-12-30 09:58:34] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:34] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:34] [DEBUG] User inserted successfully with ID: 6944
[2025-12-30 09:58:34] [DEBUG] Inserting user_delegation: user_id=6944, delegation_id=29
[2025-12-30 09:58:34] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting activite_user: user_id=6944, activite_id=54 (sector=ARTS_AND_CULTURE_SERVICES)
[2025-12-30 09:58:34] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting paiement: user_id=6944, year=2025, amount=244
[2025-12-30 09:58:34] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:34] [DEBUG] Processing user 18/125
[2025-12-30 09:58:34] [DEBUG] User email: paola.poujade@cdj66.fr
[2025-12-30 09:58:34] [DEBUG] Checking if user exists: paola.poujade@cdj66.fr
[2025-12-30 09:58:34] [DEBUG] User exists: No
[2025-12-30 09:58:34] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:34] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:34] [DEBUG] User inserted successfully with ID: 6945
[2025-12-30 09:58:34] [DEBUG] Inserting user_delegation: user_id=6945, delegation_id=5478
[2025-12-30 09:58:34] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting activite_user: user_id=6945, activite_id=11 (sector=LEGAL)
[2025-12-30 09:58:34] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting paiement: user_id=6945, year=2025, amount=264
[2025-12-30 09:58:34] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:34] [DEBUG] Processing user 19/125
[2025-12-30 09:58:34] [DEBUG] User email: centrelacademie@hotmail.com
[2025-12-30 09:58:34] [DEBUG] Checking if user exists: centrelacademie@hotmail.com
[2025-12-30 09:58:34] [DEBUG] User exists: No
[2025-12-30 09:58:34] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:34] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:34] [DEBUG] User inserted successfully with ID: 6946
[2025-12-30 09:58:34] [DEBUG] Inserting user_delegation: user_id=6946, delegation_id=5490
[2025-12-30 09:58:34] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting activite_user: user_id=6946, activite_id=27 (sector=EDUCATION_AND_TRAINING)
[2025-12-30 09:58:34] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting paiement: user_id=6946, year=2025, amount=253
[2025-12-30 09:58:34] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:34] [DEBUG] Processing user 20/125
[2025-12-30 09:58:34] [DEBUG] User email: lgarcia@liftplaq.fr
[2025-12-30 09:58:34] [DEBUG] Checking if user exists: lgarcia@liftplaq.fr
[2025-12-30 09:58:34] [DEBUG] User exists: No
[2025-12-30 09:58:34] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:34] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:34] [DEBUG] User inserted successfully with ID: 6947
[2025-12-30 09:58:34] [DEBUG] Inserting user_delegation: user_id=6947, delegation_id=5478
[2025-12-30 09:58:34] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting activite_user: user_id=6947, activite_id=34 (sector=INDUSTRY)
[2025-12-30 09:58:34] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting paiement: user_id=6947, year=2025, amount=257
[2025-12-30 09:58:34] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:34] [DEBUG] Processing user 21/125
[2025-12-30 09:58:34] [DEBUG] User email: contact@sabrinaverger.fr
[2025-12-30 09:58:34] [DEBUG] Checking if user exists: contact@sabrinaverger.fr
[2025-12-30 09:58:34] [DEBUG] User exists: No
[2025-12-30 09:58:34] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:34] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:34] [DEBUG] User inserted successfully with ID: 6948
[2025-12-30 09:58:34] [DEBUG] Inserting user_delegation: user_id=6948, delegation_id=5576
[2025-12-30 09:58:34] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting activite_user: user_id=6948, activite_id=52 (sector=BUSINESS_SERVICES)
[2025-12-30 09:58:34] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting paiement: user_id=6948, year=2025, amount=253
[2025-12-30 09:58:34] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:34] [DEBUG] Processing user 22/125
[2025-12-30 09:58:34] [DEBUG] User email: contact@hggfinance.com
[2025-12-30 09:58:34] [DEBUG] Checking if user exists: contact@hggfinance.com
[2025-12-30 09:58:34] [DEBUG] User exists: Yes (ID: 6899)
[2025-12-30 09:58:34] [DEBUG] Processing user 23/125
[2025-12-30 09:58:34] [DEBUG] User email: laferiaduvin@orange.fr
[2025-12-30 09:58:34] [DEBUG] Checking if user exists: laferiaduvin@orange.fr
[2025-12-30 09:58:34] [DEBUG] User exists: No
[2025-12-30 09:58:34] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:34] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:34] [DEBUG] User inserted successfully with ID: 6949
[2025-12-30 09:58:34] [DEBUG] Inserting user_delegation: user_id=6949, delegation_id=5496
[2025-12-30 09:58:34] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting activite_user: user_id=6949, activite_id=18 (sector=COMMERCE)
[2025-12-30 09:58:34] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting paiement: user_id=6949, year=2025, amount=237
[2025-12-30 09:58:34] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:34] [DEBUG] Processing user 24/125
[2025-12-30 09:58:34] [DEBUG] User email: lynda.cazilhac@cauripatrimoine.fr
[2025-12-30 09:58:34] [DEBUG] Checking if user exists: lynda.cazilhac@cauripatrimoine.fr
[2025-12-30 09:58:34] [DEBUG] User exists: No
[2025-12-30 09:58:34] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:34] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:34] [DEBUG] User inserted successfully with ID: 6950
[2025-12-30 09:58:34] [DEBUG] Inserting user_delegation: user_id=6950, delegation_id=5575
[2025-12-30 09:58:34] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting activite_user: user_id=6950, activite_id=21 (sector=PROFESSIONAL_AND_FINANCIAL_SERVICES)
[2025-12-30 09:58:34] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting paiement: user_id=6950, year=2025, amount=236
[2025-12-30 09:58:34] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:34] [DEBUG] Processing user 25/125
[2025-12-30 09:58:34] [DEBUG] User email: sonay@kartalproprete.fr
[2025-12-30 09:58:34] [DEBUG] Checking if user exists: sonay@kartalproprete.fr
[2025-12-30 09:58:34] [DEBUG] User exists: No
[2025-12-30 09:58:34] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:34] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:34] [DEBUG] User inserted successfully with ID: 6951
[2025-12-30 09:58:34] [DEBUG] Inserting user_delegation: user_id=6951, delegation_id=5471
[2025-12-30 09:58:34] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting activite_user: user_id=6951, activite_id=52 (sector=BUSINESS_SERVICES)
[2025-12-30 09:58:34] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting paiement: user_id=6951, year=2025, amount=218
[2025-12-30 09:58:34] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:34] [DEBUG] Processing user 26/125
[2025-12-30 09:58:34] [DEBUG] User email: laura.bollaert@notaires.fr
[2025-12-30 09:58:34] [DEBUG] Checking if user exists: laura.bollaert@notaires.fr
[2025-12-30 09:58:34] [DEBUG] User exists: No
[2025-12-30 09:58:34] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:34] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:34] [DEBUG] User inserted successfully with ID: 6952
[2025-12-30 09:58:34] [DEBUG] Inserting user_delegation: user_id=6952, delegation_id=5488
[2025-12-30 09:58:34] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting activite_user: user_id=6952, activite_id=11 (sector=LEGAL)
[2025-12-30 09:58:34] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting paiement: user_id=6952, year=2025, amount=218
[2025-12-30 09:58:34] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:34] [DEBUG] Processing user 27/125
[2025-12-30 09:58:34] [DEBUG] User email: a.laquenaire@orange.fr
[2025-12-30 09:58:34] [DEBUG] Checking if user exists: a.laquenaire@orange.fr
[2025-12-30 09:58:34] [DEBUG] User exists: Yes (ID: 6900)
[2025-12-30 09:58:34] [DEBUG] Processing user 28/125
[2025-12-30 09:58:34] [DEBUG] User email: vanessa@liloo.fr
[2025-12-30 09:58:34] [DEBUG] Checking if user exists: vanessa@liloo.fr
[2025-12-30 09:58:34] [DEBUG] User exists: Yes (ID: 6819)
[2025-12-30 09:58:34] [DEBUG] Processing user 29/125
[2025-12-30 09:58:34] [DEBUG] User email: cecilebazerque@gmail.com
[2025-12-30 09:58:34] [DEBUG] Checking if user exists: cecilebazerque@gmail.com
[2025-12-30 09:58:34] [DEBUG] User exists: No
[2025-12-30 09:58:34] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:34] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:34] [DEBUG] User inserted successfully with ID: 6953
[2025-12-30 09:58:34] [DEBUG] Inserting user_delegation: user_id=6953, delegation_id=5496
[2025-12-30 09:58:34] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting activite_user: user_id=6953, activite_id=32 (sector=REAL_ESTATE)
[2025-12-30 09:58:34] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting paiement: user_id=6953, year=2025, amount=237
[2025-12-30 09:58:34] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:34] [DEBUG] Processing user 30/125
[2025-12-30 09:58:34] [DEBUG] User email: sabine.ghys@gmail.com
[2025-12-30 09:58:34] [DEBUG] Checking if user exists: sabine.ghys@gmail.com
[2025-12-30 09:58:34] [DEBUG] User exists: No
[2025-12-30 09:58:34] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:34] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:34] [DEBUG] User inserted successfully with ID: 6954
[2025-12-30 09:58:34] [DEBUG] Inserting user_delegation: user_id=6954, delegation_id=5576
[2025-12-30 09:58:34] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting activite_user: user_id=6954, activite_id=30 (sector=HEALTH)
[2025-12-30 09:58:34] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting paiement: user_id=6954, year=2025, amount=253
[2025-12-30 09:58:34] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:34] [DEBUG] Processing user 31/125
[2025-12-30 09:58:34] [DEBUG] User email: contact@agence-ivec.com
[2025-12-30 09:58:34] [DEBUG] Checking if user exists: contact@agence-ivec.com
[2025-12-30 09:58:34] [DEBUG] User exists: No
[2025-12-30 09:58:34] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:34] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:34] [DEBUG] User inserted successfully with ID: 6955
[2025-12-30 09:58:34] [DEBUG] Inserting user_delegation: user_id=6955, delegation_id=5471
[2025-12-30 09:58:34] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting activite_user: user_id=6955, activite_id=32 (sector=REAL_ESTATE)
[2025-12-30 09:58:34] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting paiement: user_id=6955, year=2025, amount=192
[2025-12-30 09:58:34] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:34] [DEBUG] Processing user 32/125
[2025-12-30 09:58:34] [DEBUG] User email: carole.bortolotti@free.fr
[2025-12-30 09:58:34] [DEBUG] Checking if user exists: carole.bortolotti@free.fr
[2025-12-30 09:58:34] [DEBUG] User exists: No
[2025-12-30 09:58:34] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:34] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:34] [DEBUG] User inserted successfully with ID: 6956
[2025-12-30 09:58:34] [DEBUG] Inserting user_delegation: user_id=6956, delegation_id=5575
[2025-12-30 09:58:34] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting activite_user: user_id=6956, activite_id=30 (sector=HEALTH)
[2025-12-30 09:58:34] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting paiement: user_id=6956, year=2025, amount=236
[2025-12-30 09:58:34] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:34] [DEBUG] Processing user 33/125
[2025-12-30 09:58:34] [DEBUG] User email: montpellier@genealo-gie.fr
[2025-12-30 09:58:34] [DEBUG] Checking if user exists: montpellier@genealo-gie.fr
[2025-12-30 09:58:34] [DEBUG] User exists: No
[2025-12-30 09:58:34] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:34] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:34] [DEBUG] User inserted successfully with ID: 6957
[2025-12-30 09:58:34] [DEBUG] Inserting user_delegation: user_id=6957, delegation_id=32
[2025-12-30 09:58:34] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting activite_user: user_id=6957, activite_id=11 (sector=LEGAL)
[2025-12-30 09:58:34] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting paiement: user_id=6957, year=2025, amount=208
[2025-12-30 09:58:34] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:34] [DEBUG] Processing user 34/125
[2025-12-30 09:58:34] [DEBUG] User email: m2montaigu@yahoo.fr
[2025-12-30 09:58:34] [DEBUG] Checking if user exists: m2montaigu@yahoo.fr
[2025-12-30 09:58:34] [DEBUG] User exists: No
[2025-12-30 09:58:34] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:34] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:34] [DEBUG] User inserted successfully with ID: 6958
[2025-12-30 09:58:34] [DEBUG] Inserting user_delegation: user_id=6958, delegation_id=5463
[2025-12-30 09:58:34] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting activite_user: user_id=6958, activite_id=13 (sector=CONSTRUCTION)
[2025-12-30 09:58:34] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting paiement: user_id=6958, year=2025, amount=203
[2025-12-30 09:58:34] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:34] [DEBUG] Processing user 35/125
[2025-12-30 09:58:34] [DEBUG] User email: karineboustanyargellies@gmail.com
[2025-12-30 09:58:34] [DEBUG] Checking if user exists: karineboustanyargellies@gmail.com
[2025-12-30 09:58:34] [DEBUG] User exists: No
[2025-12-30 09:58:34] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:34] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:34] [DEBUG] User inserted successfully with ID: 6959
[2025-12-30 09:58:34] [DEBUG] Inserting user_delegation: user_id=6959, delegation_id=32
[2025-12-30 09:58:34] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting activite_user: user_id=6959, activite_id=32 (sector=REAL_ESTATE)
[2025-12-30 09:58:34] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting paiement: user_id=6959, year=2025, amount=86
[2025-12-30 09:58:34] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:34] [DEBUG] Processing user 36/125
[2025-12-30 09:58:34] [DEBUG] User email: c.brogle@altkirch-mobilier.com
[2025-12-30 09:58:34] [DEBUG] Checking if user exists: c.brogle@altkirch-mobilier.com
[2025-12-30 09:58:34] [DEBUG] User exists: No
[2025-12-30 09:58:34] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:34] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:34] [DEBUG] User inserted successfully with ID: 6960
[2025-12-30 09:58:34] [DEBUG] Inserting user_delegation: user_id=6960, delegation_id=5470
[2025-12-30 09:58:34] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting activite_user: user_id=6960, activite_id=18 (sector=COMMERCE)
[2025-12-30 09:58:34] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting paiement: user_id=6960, year=2025, amount=233
[2025-12-30 09:58:34] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:34] [DEBUG] Processing user 37/125
[2025-12-30 09:58:34] [DEBUG] User email: pharmacie.st.helier@orange.fr
[2025-12-30 09:58:34] [DEBUG] Checking if user exists: pharmacie.st.helier@orange.fr
[2025-12-30 09:58:34] [DEBUG] User exists: No
[2025-12-30 09:58:34] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:34] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:34] [DEBUG] User inserted successfully with ID: 6961
[2025-12-30 09:58:34] [DEBUG] Inserting user_delegation: user_id=6961, delegation_id=5511
[2025-12-30 09:58:34] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting activite_user: user_id=6961, activite_id=30 (sector=HEALTH)
[2025-12-30 09:58:34] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting paiement: user_id=6961, year=2025, amount=238
[2025-12-30 09:58:34] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:34] [DEBUG] Processing user 38/125
[2025-12-30 09:58:34] [DEBUG] User email: sophie.gelernter@outlook.fr
[2025-12-30 09:58:34] [DEBUG] Checking if user exists: sophie.gelernter@outlook.fr
[2025-12-30 09:58:34] [DEBUG] User exists: No
[2025-12-30 09:58:34] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:34] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:34] [DEBUG] User inserted successfully with ID: 6962
[2025-12-30 09:58:34] [DEBUG] Inserting user_delegation: user_id=6962, delegation_id=5486
[2025-12-30 09:58:34] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting activite_user: user_id=6962, activite_id=52 (sector=BUSINESS_SERVICES)
[2025-12-30 09:58:34] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting paiement: user_id=6962, year=2025, amount=215
[2025-12-30 09:58:34] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:34] [DEBUG] Processing user 39/125
[2025-12-30 09:58:34] [DEBUG] User email: c.pauvert@ateliervezes.fr
[2025-12-30 09:58:34] [DEBUG] Checking if user exists: c.pauvert@ateliervezes.fr
[2025-12-30 09:58:34] [DEBUG] User exists: No
[2025-12-30 09:58:34] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:34] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:34] [DEBUG] User inserted successfully with ID: 6963
[2025-12-30 09:58:34] [DEBUG] Inserting user_delegation: user_id=6963, delegation_id=5457
[2025-12-30 09:58:34] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting activite_user: user_id=6963, activite_id=18 (sector=COMMERCE)
[2025-12-30 09:58:34] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting paiement: user_id=6963, year=2025, amount=275
[2025-12-30 09:58:34] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:34] [DEBUG] Processing user 40/125
[2025-12-30 09:58:34] [DEBUG] User email: fabienne.dheyriat@wanadoo.fr
[2025-12-30 09:58:34] [DEBUG] Checking if user exists: fabienne.dheyriat@wanadoo.fr
[2025-12-30 09:58:34] [DEBUG] User exists: No
[2025-12-30 09:58:34] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:34] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:34] [DEBUG] User inserted successfully with ID: 6964
[2025-12-30 09:58:34] [DEBUG] Inserting user_delegation: user_id=6964, delegation_id=5574
[2025-12-30 09:58:34] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting activite_user: user_id=6964, activite_id=54 (sector=EVENTS)
[2025-12-30 09:58:34] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting paiement: user_id=6964, year=2025, amount=220
[2025-12-30 09:58:34] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:34] [DEBUG] Processing user 41/125
[2025-12-30 09:58:34] [DEBUG] User email: margaux.roussin@roussin-energies.fr
[2025-12-30 09:58:34] [DEBUG] Checking if user exists: margaux.roussin@roussin-energies.fr
[2025-12-30 09:58:34] [DEBUG] User exists: No
[2025-12-30 09:58:34] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:34] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:34] [DEBUG] User inserted successfully with ID: 6965
[2025-12-30 09:58:34] [DEBUG] Inserting user_delegation: user_id=6965, delegation_id=5480
[2025-12-30 09:58:34] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting activite_user: user_id=6965, activite_id=13 (sector=CONSTRUCTION)
[2025-12-30 09:58:34] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting paiement: user_id=6965, year=2025, amount=126
[2025-12-30 09:58:34] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:34] [DEBUG] Processing user 42/125
[2025-12-30 09:58:34] [DEBUG] User email: c.caplot@avocat-caplot.fr
[2025-12-30 09:58:34] [DEBUG] Checking if user exists: c.caplot@avocat-caplot.fr
[2025-12-30 09:58:34] [DEBUG] User exists: Yes (ID: 505)
[2025-12-30 09:58:34] [DEBUG] Processing user 43/125
[2025-12-30 09:58:34] [DEBUG] User email: melanie.marques@socatech.fr
[2025-12-30 09:58:34] [DEBUG] Checking if user exists: melanie.marques@socatech.fr
[2025-12-30 09:58:34] [DEBUG] User exists: No
[2025-12-30 09:58:34] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:34] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:34] [DEBUG] User inserted successfully with ID: 6966
[2025-12-30 09:58:34] [DEBUG] Inserting user_delegation: user_id=6966, delegation_id=5464
[2025-12-30 09:58:34] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting activite_user: user_id=6966, activite_id=34 (sector=INDUSTRY)
[2025-12-30 09:58:34] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting paiement: user_id=6966, year=2025, amount=211
[2025-12-30 09:58:34] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:34] [DEBUG] Processing user 44/125
[2025-12-30 09:58:34] [DEBUG] User email: esueur@gmail.com
[2025-12-30 09:58:34] [DEBUG] Checking if user exists: esueur@gmail.com
[2025-12-30 09:58:34] [DEBUG] User exists: Yes (ID: 6902)
[2025-12-30 09:58:34] [DEBUG] Processing user 45/125
[2025-12-30 09:58:34] [DEBUG] User email: isah.naturo@gmail.com
[2025-12-30 09:58:34] [DEBUG] Checking if user exists: isah.naturo@gmail.com
[2025-12-30 09:58:34] [DEBUG] User exists: No
[2025-12-30 09:58:34] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:34] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:34] [DEBUG] User inserted successfully with ID: 6967
[2025-12-30 09:58:34] [DEBUG] Inserting user_delegation: user_id=6967, delegation_id=5455
[2025-12-30 09:58:34] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting activite_user: user_id=6967, activite_id=30 (sector=HEALTH)
[2025-12-30 09:58:34] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting paiement: user_id=6967, year=2025, amount=231
[2025-12-30 09:58:34] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:34] [DEBUG] Processing user 46/125
[2025-12-30 09:58:34] [DEBUG] User email: mcsalabert@free.fr
[2025-12-30 09:58:34] [DEBUG] Checking if user exists: mcsalabert@free.fr
[2025-12-30 09:58:34] [DEBUG] User exists: No
[2025-12-30 09:58:34] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:34] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:34] [DEBUG] User inserted successfully with ID: 6968
[2025-12-30 09:58:34] [DEBUG] Inserting user_delegation: user_id=6968, delegation_id=5575
[2025-12-30 09:58:34] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting activite_user: user_id=6968, activite_id=16 (sector=AGRICULTURE_AND_FISHING)
[2025-12-30 09:58:34] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting paiement: user_id=6968, year=2025, amount=208
[2025-12-30 09:58:34] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:34] [DEBUG] Processing user 47/125
[2025-12-30 09:58:34] [DEBUG] User email: contact@bopik.fr
[2025-12-30 09:58:34] [DEBUG] Checking if user exists: contact@bopik.fr
[2025-12-30 09:58:34] [DEBUG] User exists: No
[2025-12-30 09:58:34] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:34] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:34] [DEBUG] User inserted successfully with ID: 6969
[2025-12-30 09:58:34] [DEBUG] Inserting user_delegation: user_id=6969, delegation_id=5480
[2025-12-30 09:58:34] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting activite_user: user_id=6969, activite_id=32 (sector=REAL_ESTATE)
[2025-12-30 09:58:34] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting paiement: user_id=6969, year=2025, amount=224
[2025-12-30 09:58:34] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:34] [DEBUG] Processing user 48/125
[2025-12-30 09:58:34] [DEBUG] User email: l.goutaland@boissonstores.fr
[2025-12-30 09:58:34] [DEBUG] Checking if user exists: l.goutaland@boissonstores.fr
[2025-12-30 09:58:34] [DEBUG] User exists: No
[2025-12-30 09:58:34] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:34] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:34] [DEBUG] User inserted successfully with ID: 6970
[2025-12-30 09:58:34] [DEBUG] Inserting user_delegation: user_id=6970, delegation_id=5459
[2025-12-30 09:58:34] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting activite_user: user_id=6970, activite_id=13 (sector=CONSTRUCTION)
[2025-12-30 09:58:34] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting paiement: user_id=6970, year=2025, amount=383
[2025-12-30 09:58:34] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:34] [DEBUG] Processing user 49/125
[2025-12-30 09:58:34] [DEBUG] User email: ndumax@galerieslafayette.com
[2025-12-30 09:58:34] [DEBUG] Checking if user exists: ndumax@galerieslafayette.com
[2025-12-30 09:58:34] [DEBUG] User exists: Yes (ID: 6857)
[2025-12-30 09:58:34] [DEBUG] Processing user 50/125
[2025-12-30 09:58:34] [DEBUG] User email: m-h.schneider@bt-umwelt.de
[2025-12-30 09:58:34] [DEBUG] Checking if user exists: m-h.schneider@bt-umwelt.de
[2025-12-30 09:58:34] [DEBUG] User exists: No
[2025-12-30 09:58:34] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:34] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:34] [DEBUG] User inserted successfully with ID: 6971
[2025-12-30 09:58:34] [DEBUG] Inserting user_delegation: user_id=6971, delegation_id=5470
[2025-12-30 09:58:34] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting activite_user: user_id=6971, activite_id=52 (sector=BUSINESS_SERVICES)
[2025-12-30 09:58:34] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting paiement: user_id=6971, year=2025, amount=245
[2025-12-30 09:58:34] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:34] [DEBUG] Processing user 51/125
[2025-12-30 09:58:34] [DEBUG] User email: noeureuilg@gmail.com
[2025-12-30 09:58:34] [DEBUG] Checking if user exists: noeureuilg@gmail.com
[2025-12-30 09:58:34] [DEBUG] User exists: No
[2025-12-30 09:58:34] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:34] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:34] [DEBUG] User inserted successfully with ID: 6972
[2025-12-30 09:58:34] [DEBUG] Inserting user_delegation: user_id=6972, delegation_id=5471
[2025-12-30 09:58:34] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:34] [DEBUG] Inserting activite_user: user_id=6972, activite_id=18 (sector=COMMERCE)
[2025-12-30 09:58:34] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=6972, year=2025, amount=210
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 52/125
[2025-12-30 09:58:35] [DEBUG] User email: aurelie.mauger@wanadoo.fr
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: aurelie.mauger@wanadoo.fr
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 6973
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=6973, delegation_id=5474
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=6973, activite_id=18 (sector=COMMERCE)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=6973, year=2025, amount=219
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 53/125
[2025-12-30 09:58:35] [DEBUG] User email: mbetton@conservateur-conseil.fr
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: mbetton@conservateur-conseil.fr
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 6974
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=6974, delegation_id=33
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=6974, activite_id=21 (sector=PROFESSIONAL_AND_FINANCIAL_SERVICES)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=6974, year=2025, amount=203
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 54/125
[2025-12-30 09:58:35] [DEBUG] User email: f.lalouch@athenasr.com
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: f.lalouch@athenasr.com
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 6975
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=6975, delegation_id=5483
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=6975, activite_id=11 (sector=LEGAL)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=6975, year=2025, amount=214
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 55/125
[2025-12-30 09:58:35] [DEBUG] User email: sophie.gimeno@talco-lr.com
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: sophie.gimeno@talco-lr.com
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 6976
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=6976, delegation_id=32
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=6976, activite_id=37 (sector=DIGITAL_AND_TECHNOLOGIES)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=6976, year=2025, amount=246
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 56/125
[2025-12-30 09:58:35] [DEBUG] User email: sandra-bourgeois@outlook.com
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: sandra-bourgeois@outlook.com
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 6977
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=6977, delegation_id=5480
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=6977, activite_id=52 (sector=PERSONAL_SERVICES)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=6977, year=2025, amount=224
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 57/125
[2025-12-30 09:58:35] [DEBUG] User email: l.calvayrac@gmail.com
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: l.calvayrac@gmail.com
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 6978
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=6978, delegation_id=5471
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=6978, activite_id=37 (sector=DIGITAL_SERVICES_AND_CYBERSECURITY)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=6978, year=2025, amount=201
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 58/125
[2025-12-30 09:58:35] [DEBUG] User email: claire@faciology.fr
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: claire@faciology.fr
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 6979
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=6979, delegation_id=5475
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=6979, activite_id=30 (sector=HEALTH)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=6979, year=2025, amount=220
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 59/125
[2025-12-30 09:58:35] [DEBUG] User email: sophie.hocine@abimetal.fr
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: sophie.hocine@abimetal.fr
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 6980
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=6980, delegation_id=5576
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=6980, activite_id=13 (sector=CONSTRUCTION)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=6980, year=2025, amount=232
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 60/125
[2025-12-30 09:58:35] [DEBUG] User email: vidal-catherine@sfr.fr
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: vidal-catherine@sfr.fr
[2025-12-30 09:58:35] [DEBUG] User exists: Yes (ID: 5726)
[2025-12-30 09:58:35] [DEBUG] Processing user 61/125
[2025-12-30 09:58:35] [DEBUG] User email: agnesluquesmit@gmail.com
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: agnesluquesmit@gmail.com
[2025-12-30 09:58:35] [DEBUG] User exists: Yes (ID: 5849)
[2025-12-30 09:58:35] [DEBUG] Processing user 62/125
[2025-12-30 09:58:35] [DEBUG] User email: florie-blanc@blancom.fr
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: florie-blanc@blancom.fr
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 6981
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=6981, delegation_id=5478
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=6981, activite_id=19 (sector=COMMUNICATION)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=6981, year=2025, amount=225
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 63/125
[2025-12-30 09:58:35] [DEBUG] User email: pauline@choquet-conseil.com
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: pauline@choquet-conseil.com
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 6982
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=6982, delegation_id=29
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=6982, activite_id=52 (sector=BUSINESS_SERVICES)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=6982, year=2025, amount=225
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 64/125
[2025-12-30 09:58:35] [DEBUG] User email: clabrunye@ohlala-conseil.fr
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: clabrunye@ohlala-conseil.fr
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 6983
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=6983, delegation_id=5483
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=6983, activite_id=52 (sector=BUSINESS_SERVICES)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=6983, year=2025, amount=209
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 65/125
[2025-12-30 09:58:35] [DEBUG] User email: nmagali882@gmail.com
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: nmagali882@gmail.com
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 6984
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=6984, delegation_id=5478
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=6984, activite_id=30 (sector=HEALTH)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=6984, year=2025, amount=213
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 66/125
[2025-12-30 09:58:35] [DEBUG] User email: maryseflorens14@gmail.com
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: maryseflorens14@gmail.com
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 6985
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=6985, delegation_id=5576
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=6985, activite_id=30 (sector=HEALTH)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=6985, year=2025, amount=240
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 67/125
[2025-12-30 09:58:35] [DEBUG] User email: celine.camgrand@coopsud.com
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: celine.camgrand@coopsud.com
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 6986
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=6986, delegation_id=5478
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=6986, activite_id=16 (sector=AGRICULTURE_AND_FISHING)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=6986, year=2025, amount=225
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 68/125
[2025-12-30 09:58:35] [DEBUG] User email: beatrice@woodbeework.com
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: beatrice@woodbeework.com
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 6987
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=6987, delegation_id=5478
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=6987, activite_id=34 (sector=INDUSTRY)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=6987, year=2025, amount=225
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 69/125
[2025-12-30 09:58:35] [DEBUG] User email: aureliev@oxygen-rp.com
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: aureliev@oxygen-rp.com
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 6988
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=6988, delegation_id=5483
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=6988, activite_id=19 (sector=COMMUNICATION)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=6988, year=2025, amount=236
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 70/125
[2025-12-30 09:58:35] [DEBUG] User email: b.morgen@ecpartenaire.com
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: b.morgen@ecpartenaire.com
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 6989
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=6989, delegation_id=5471
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=6989, activite_id=21 (sector=PROFESSIONAL_AND_FINANCIAL_SERVICES)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=6989, year=2025, amount=227
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 71/125
[2025-12-30 09:58:35] [DEBUG] User email: marie.rubio@cooperative-u.fr
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: marie.rubio@cooperative-u.fr
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 6990
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=6990, delegation_id=32
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=6990, activite_id=18 (sector=COMMERCE)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=6990, year=2025, amount=272
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 72/125
[2025-12-30 09:58:35] [DEBUG] User email: slformation@lemarchandel-formation.fr
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: slformation@lemarchandel-formation.fr
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 6991
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=6991, delegation_id=5511
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=6991, activite_id=27 (sector=EDUCATION_AND_TRAINING)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=6991, year=2025, amount=260
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 73/125
[2025-12-30 09:58:35] [DEBUG] User email: nathalie.lefebvre-bertin@phileas-world.fr
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: nathalie.lefebvre-bertin@phileas-world.fr
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 6992
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=6992, delegation_id=5511
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=6992, activite_id=27 (sector=EDUCATION_AND_TRAINING)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=6992, year=2025, amount=203
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 74/125
[2025-12-30 09:58:35] [DEBUG] User email: gmercadier81@hotmail.com
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: gmercadier81@hotmail.com
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 6993
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=6993, delegation_id=5457
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=6993, activite_id=27 (sector=EDUCATION_AND_TRAINING)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=6993, year=2025, amount=222
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 75/125
[2025-12-30 09:58:35] [DEBUG] User email: stephanie.bertolle.agt@axa.fr
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: stephanie.bertolle.agt@axa.fr
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 6994
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=6994, delegation_id=5492
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=6994, activite_id=12 (sector=INSURANCE_AND_BANKING)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=6994, year=2025, amount=252
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 76/125
[2025-12-30 09:58:35] [DEBUG] User email: valerie@ag2v.fr
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: valerie@ag2v.fr
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 6995
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=6995, delegation_id=29
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=6995, activite_id=27 (sector=EDUCATION_AND_TRAINING)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=6995, year=2025, amount=212
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 77/125
[2025-12-30 09:58:35] [DEBUG] User email: docteur.plonait@orange.fr
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: docteur.plonait@orange.fr
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 6996
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=6996, delegation_id=5478
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=6996, activite_id=30 (sector=HEALTH)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=6996, year=2025, amount=208
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 78/125
[2025-12-30 09:58:35] [DEBUG] User email: christelle.peyrelesur@gmail.com
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: christelle.peyrelesur@gmail.com
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 6997
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=6997, delegation_id=5483
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=6997, activite_id=21 (sector=PROFESSIONAL_AND_FINANCIAL_SERVICES)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=6997, year=2025, amount=228
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 79/125
[2025-12-30 09:58:35] [DEBUG] User email: direction@arcpolynesie.pf
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: direction@arcpolynesie.pf
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 6998
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=6998, delegation_id=5512
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=6998, activite_id=21 (sector=PROFESSIONAL_AND_FINANCIAL_SERVICES)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=6998, year=2025, amount=228
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 80/125
[2025-12-30 09:58:35] [DEBUG] User email: christelle.batard@azae.com
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: christelle.batard@azae.com
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 6999
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=6999, delegation_id=5457
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=6999, activite_id=52 (sector=PERSONAL_SERVICES)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=6999, year=2025, amount=262
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 81/125
[2025-12-30 09:58:35] [DEBUG] User email: karine.pilon@greffe-tc-evry.fr
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: karine.pilon@greffe-tc-evry.fr
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 7000
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=7000, delegation_id=21
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=7000, activite_id=11 (sector=LEGAL)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=7000, year=2025, amount=224
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 82/125
[2025-12-30 09:58:35] [DEBUG] User email: laetitiagiubbi@agencesens.com
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: laetitiagiubbi@agencesens.com
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 7001
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=7001, delegation_id=5573
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=7001, activite_id=19 (sector=COMMUNICATION)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=7001, year=2025, amount=219
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 83/125
[2025-12-30 09:58:35] [DEBUG] User email: axelle.meunier@credipro.fr
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: axelle.meunier@credipro.fr
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 7002
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=7002, delegation_id=30
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=7002, activite_id=52 (sector=BUSINESS_SERVICES)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=7002, year=2025, amount=219
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 84/125
[2025-12-30 09:58:35] [DEBUG] User email: c.giardina@g-dh.fr
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: c.giardina@g-dh.fr
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 7003
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=7003, delegation_id=5480
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=7003, activite_id=13 (sector=CONSTRUCTION)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=7003, year=2025, amount=232
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 85/125
[2025-12-30 09:58:35] [DEBUG] User email: laure@caissotti.com
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: laure@caissotti.com
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 7004
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=7004, delegation_id=29
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=7004, activite_id=18 (sector=COMMERCE)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=7004, year=2025, amount=233
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 86/125
[2025-12-30 09:58:35] [DEBUG] User email: cynthia@atelierfleuriste.com
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: cynthia@atelierfleuriste.com
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 7005
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=7005, delegation_id=29
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=7005, activite_id=18 (sector=COMMERCE)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=7005, year=2025, amount=233
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 87/125
[2025-12-30 09:58:35] [DEBUG] User email: sandradelislecoaching@gmail.com
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: sandradelislecoaching@gmail.com
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 7006
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=7006, delegation_id=5469
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=7006, activite_id=52 (sector=PERSONAL_SERVICES)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=7006, year=2025, amount=222
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 88/125
[2025-12-30 09:58:35] [DEBUG] User email: mgirard@asteliaavocats.fr
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: mgirard@asteliaavocats.fr
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 7007
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=7007, delegation_id=5507
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=7007, activite_id=11 (sector=LEGAL)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=7007, year=2025, amount=224
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 89/125
[2025-12-30 09:58:35] [DEBUG] User email: condaminelegalconsulting@outlook.com
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: condaminelegalconsulting@outlook.com
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 7008
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=7008, delegation_id=5483
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=7008, activite_id=11 (sector=LEGAL)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=7008, year=2025, amount=209
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 90/125
[2025-12-30 09:58:35] [DEBUG] User email: smanel@bolmas-editions.com
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: smanel@bolmas-editions.com
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 7009
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=7009, delegation_id=5458
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=7009, activite_id=18 (sector=COMMERCE)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=7009, year=2025, amount=213
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 91/125
[2025-12-30 09:58:35] [DEBUG] User email: arttifs42120@orange.fr
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: arttifs42120@orange.fr
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 7010
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=7010, delegation_id=5477
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=7010, activite_id=18 (sector=COMMERCE)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=7010, year=2025, amount=278
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 92/125
[2025-12-30 09:58:35] [DEBUG] User email: claire.baute@gmail.com
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: claire.baute@gmail.com
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 7011
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=7011, delegation_id=5492
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=7011, activite_id=30 (sector=HEALTH)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=7011, year=2025, amount=219
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 93/125
[2025-12-30 09:58:35] [DEBUG] User email: a.meo@mhcannes.notaires.fr
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: a.meo@mhcannes.notaires.fr
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 7012
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=7012, delegation_id=29
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=7012, activite_id=11 (sector=LEGAL)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=7012, year=2025, amount=233
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 94/125
[2025-12-30 09:58:35] [DEBUG] User email: studio508portrait@gmail.com
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: studio508portrait@gmail.com
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 7013
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=7013, delegation_id=5458
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=7013, activite_id=54 (sector=ARTS_AND_CULTURE_SERVICES)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=7013, year=2025, amount=213
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 95/125
[2025-12-30 09:58:35] [DEBUG] User email: doune.b@wanadoo.fr
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: doune.b@wanadoo.fr
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 7014
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=7014, delegation_id=5474
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=7014, activite_id=18 (sector=COMMERCE)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=7014, year=2025, amount=373
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 96/125
[2025-12-30 09:58:35] [DEBUG] User email: magali.lavillenie@gmail.com
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: magali.lavillenie@gmail.com
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 7015
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=7015, delegation_id=29
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=7015, activite_id=30 (sector=HEALTH)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=7015, year=2025, amount=207
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 97/125
[2025-12-30 09:58:35] [DEBUG] User email: leslie.gensse@domolandes.fr
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: leslie.gensse@domolandes.fr
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 7016
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=7016, delegation_id=5496
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=7016, activite_id=52 (sector=BUSINESS_SERVICES)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=7016, year=2025, amount=246
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 98/125
[2025-12-30 09:58:35] [DEBUG] User email: marie-line.foucault@auxillia.fr
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: marie-line.foucault@auxillia.fr
[2025-12-30 09:58:35] [DEBUG] User exists: Yes (ID: 4459)
[2025-12-30 09:58:35] [DEBUG] Processing user 99/125
[2025-12-30 09:58:35] [DEBUG] User email: aurelie@ngxe.fr
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: aurelie@ngxe.fr
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 7017
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=7017, delegation_id=5483
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=7017, activite_id=37 (sector=DIGITAL_AND_TECHNOLOGIES)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=7017, year=2025, amount=209
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 100/125
[2025-12-30 09:58:35] [DEBUG] User email: martine.ferrage@gmail.com
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: martine.ferrage@gmail.com
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 7018
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=7018, delegation_id=5483
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=7018, activite_id=18 (sector=COMMERCE)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=7018, year=2025, amount=242
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 101/125
[2025-12-30 09:58:35] [DEBUG] User email: christelle.henry@ecomail.fr
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: christelle.henry@ecomail.fr
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 7019
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=7019, delegation_id=5486
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=7019, activite_id=52 (sector=BUSINESS_SERVICES)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=7019, year=2025, amount=216
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 102/125
[2025-12-30 09:58:35] [DEBUG] User email: sdebluze@hotmail.com
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: sdebluze@hotmail.com
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 7020
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=7020, delegation_id=30
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=7020, activite_id=52 (sector=BUSINESS_SERVICES)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=7020, year=2025, amount=203
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 103/125
[2025-12-30 09:58:35] [DEBUG] User email: homadeconceptstore@gmail.com
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: homadeconceptstore@gmail.com
[2025-12-30 09:58:35] [DEBUG] User exists: Yes (ID: 6317)
[2025-12-30 09:58:35] [DEBUG] Processing user 104/125
[2025-12-30 09:58:35] [DEBUG] User email: i.bouttau@sfr.fr
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: i.bouttau@sfr.fr
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 7021
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=7021, delegation_id=5490
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=7021, activite_id=11 (sector=LEGAL)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=7021, year=2025, amount=211
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 105/125
[2025-12-30 09:58:35] [DEBUG] User email: spileersaline@gmail.com
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: spileersaline@gmail.com
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 7022
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=7022, delegation_id=29
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=7022, activite_id=13 (sector=CONSTRUCTION)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=7022, year=2025, amount=33
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 106/125
[2025-12-30 09:58:35] [DEBUG] User email: questiondallure@gmail.com
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: questiondallure@gmail.com
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 7023
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=7023, delegation_id=29
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=7023, activite_id=52 (sector=PERSONAL_SERVICES)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=7023, year=2025, amount=38
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 107/125
[2025-12-30 09:58:35] [DEBUG] User email: contact@anga-coaching.fr
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: contact@anga-coaching.fr
[2025-12-30 09:58:35] [DEBUG] User exists: Yes (ID: 5099)
[2025-12-30 09:58:35] [DEBUG] Processing user 108/125
[2025-12-30 09:58:35] [DEBUG] User email: coralinaro@yahoo.com
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: coralinaro@yahoo.com
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 7024
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=7024, delegation_id=29
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=7024, activite_id=30 (sector=HEALTH)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=7024, year=2025, amount=207
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 109/125
[2025-12-30 09:58:35] [DEBUG] User email: ciavaldini.mariecaroline@gmail.com
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: ciavaldini.mariecaroline@gmail.com
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 7025
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=7025, delegation_id=29
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=7025, activite_id=30 (sector=HEALTH)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=7025, year=2025, amount=224
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 110/125
[2025-12-30 09:58:35] [DEBUG] User email: margauxhaemmerer@hubliss.fr
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: margauxhaemmerer@hubliss.fr
[2025-12-30 09:58:35] [DEBUG] User exists: Yes (ID: 5842)
[2025-12-30 09:58:35] [DEBUG] Processing user 111/125
[2025-12-30 09:58:35] [DEBUG] User email: laetitia.ramadier@espace-audit-ramadier.fr
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: laetitia.ramadier@espace-audit-ramadier.fr
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 7026
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=7026, delegation_id=5462
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=7026, activite_id=21 (sector=PROFESSIONAL_AND_FINANCIAL_SERVICES)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=7026, year=2025, amount=203
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 112/125
[2025-12-30 09:58:35] [DEBUG] User email: valtonkarine@gmail.com
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: valtonkarine@gmail.com
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 7027
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=7027, delegation_id=5507
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=7027, activite_id=18 (sector=COMMERCE)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=7027, year=2025, amount=206
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Batch size reached (100 users), committing transaction
[2025-12-30 09:58:35] [DEBUG] Transaction committed
[2025-12-30 09:58:35] [DEBUG] New transaction started
[2025-12-30 09:58:35] [DEBUG] Processing user 113/125
[2025-12-30 09:58:35] [DEBUG] User email: nd.conseil31@gmail.com
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: nd.conseil31@gmail.com
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 7028
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=7028, delegation_id=5483
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=7028, activite_id=52 (sector=BUSINESS_SERVICES)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=7028, year=2025, amount=407
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 114/125
[2025-12-30 09:58:35] [DEBUG] User email: hpoucheret@partner31.fr
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: hpoucheret@partner31.fr
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 7029
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=7029, delegation_id=5483
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=7029, activite_id=21 (sector=PROFESSIONAL_AND_FINANCIAL_SERVICES)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=7029, year=2025, amount=214
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 115/125
[2025-12-30 09:58:35] [DEBUG] User email: camille.rabattu@provence-producteur.fr
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: camille.rabattu@provence-producteur.fr
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 7030
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=7030, delegation_id=5464
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=7030, activite_id=16 (sector=AGRICULTURE_AND_FISHING)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=7030, year=2025, amount=219
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 116/125
[2025-12-30 09:58:35] [DEBUG] User email: mnlnettoyage@orange.fr
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: mnlnettoyage@orange.fr
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 7031
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=7031, delegation_id=30
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=7031, activite_id=52 (sector=BUSINESS_SERVICES)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=7031, year=2025, amount=220
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 117/125
[2025-12-30 09:58:35] [DEBUG] User email: marie.bourrel.chine@gmail.com
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: marie.bourrel.chine@gmail.com
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:35] [DEBUG] User inserted successfully with ID: 7032
[2025-12-30 09:58:35] [DEBUG] Inserting user_delegation: user_id=7032, delegation_id=5457
[2025-12-30 09:58:35] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting activite_user: user_id=7032, activite_id=52 (sector=PERSONAL_SERVICES)
[2025-12-30 09:58:35] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:35] [DEBUG] Inserting paiement: user_id=7032, year=2025, amount=205
[2025-12-30 09:58:35] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:35] [DEBUG] Processing user 118/125
[2025-12-30 09:58:35] [DEBUG] User email: hello@cabinet-sophie.com
[2025-12-30 09:58:35] [DEBUG] Checking if user exists: hello@cabinet-sophie.com
[2025-12-30 09:58:35] [DEBUG] User exists: No
[2025-12-30 09:58:35] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:35] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:36] [DEBUG] User inserted successfully with ID: 7033
[2025-12-30 09:58:36] [DEBUG] Inserting user_delegation: user_id=7033, delegation_id=5483
[2025-12-30 09:58:36] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:36] [DEBUG] Inserting activite_user: user_id=7033, activite_id=52 (sector=BUSINESS_SERVICES)
[2025-12-30 09:58:36] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:36] [DEBUG] Inserting paiement: user_id=7033, year=2025, amount=209
[2025-12-30 09:58:36] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:36] [DEBUG] Processing user 119/125
[2025-12-30 09:58:36] [DEBUG] User email: amandine.anneet@mma.fr
[2025-12-30 09:58:36] [DEBUG] Checking if user exists: amandine.anneet@mma.fr
[2025-12-30 09:58:36] [DEBUG] User exists: No
[2025-12-30 09:58:36] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:36] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:36] [DEBUG] User inserted successfully with ID: 7034
[2025-12-30 09:58:36] [DEBUG] Inserting user_delegation: user_id=7034, delegation_id=5492
[2025-12-30 09:58:36] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:36] [DEBUG] Inserting activite_user: user_id=7034, activite_id=12 (sector=INSURANCE_AND_BANKING)
[2025-12-30 09:58:36] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:36] [DEBUG] Inserting paiement: user_id=7034, year=2025, amount=228
[2025-12-30 09:58:36] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:36] [DEBUG] Processing user 120/125
[2025-12-30 09:58:36] [DEBUG] User email: a.surgand@lutz.alsace
[2025-12-30 09:58:36] [DEBUG] Checking if user exists: a.surgand@lutz.alsace
[2025-12-30 09:58:36] [DEBUG] User exists: No
[2025-12-30 09:58:36] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:36] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:36] [DEBUG] User inserted successfully with ID: 7035
[2025-12-30 09:58:36] [DEBUG] Inserting user_delegation: user_id=7035, delegation_id=5470
[2025-12-30 09:58:36] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:36] [DEBUG] Inserting activite_user: user_id=7035, activite_id=13 (sector=CONSTRUCTION)
[2025-12-30 09:58:36] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:36] [DEBUG] Inserting paiement: user_id=7035, year=2025, amount=229
[2025-12-30 09:58:36] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:36] [DEBUG] Processing user 121/125
[2025-12-30 09:58:36] [DEBUG] User email: lilisagot@gmail.com
[2025-12-30 09:58:36] [DEBUG] Checking if user exists: lilisagot@gmail.com
[2025-12-30 09:58:36] [DEBUG] User exists: Yes (ID: 6770)
[2025-12-30 09:58:36] [DEBUG] Processing user 122/125
[2025-12-30 09:58:36] [DEBUG] User email: audegir@orange.fr
[2025-12-30 09:58:36] [DEBUG] Checking if user exists: audegir@orange.fr
[2025-12-30 09:58:36] [DEBUG] User exists: No
[2025-12-30 09:58:36] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:36] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:36] [DEBUG] User inserted successfully with ID: 7036
[2025-12-30 09:58:36] [DEBUG] Inserting user_delegation: user_id=7036, delegation_id=5464
[2025-12-30 09:58:36] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:36] [DEBUG] Inserting activite_user: user_id=7036, activite_id=30 (sector=HEALTH)
[2025-12-30 09:58:36] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:36] [DEBUG] Inserting paiement: user_id=7036, year=2025, amount=207
[2025-12-30 09:58:36] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:36] [DEBUG] Processing user 123/125
[2025-12-30 09:58:36] [DEBUG] User email: maite@smouton.com
[2025-12-30 09:58:36] [DEBUG] Checking if user exists: maite@smouton.com
[2025-12-30 09:58:36] [DEBUG] User exists: No
[2025-12-30 09:58:36] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:36] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:36] [DEBUG] User inserted successfully with ID: 7037
[2025-12-30 09:58:36] [DEBUG] Inserting user_delegation: user_id=7037, delegation_id=5470
[2025-12-30 09:58:36] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:36] [DEBUG] Inserting activite_user: user_id=7037, activite_id=19 (sector=COMMUNICATION)
[2025-12-30 09:58:36] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:36] [DEBUG] Inserting paiement: user_id=7037, year=2025, amount=203
[2025-12-30 09:58:36] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:36] [DEBUG] Processing user 124/125
[2025-12-30 09:58:36] [DEBUG] User email: anne.crecy@orange.fr
[2025-12-30 09:58:36] [DEBUG] Checking if user exists: anne.crecy@orange.fr
[2025-12-30 09:58:36] [DEBUG] User exists: No
[2025-12-30 09:58:36] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:36] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:36] [DEBUG] User inserted successfully with ID: 7038
[2025-12-30 09:58:36] [DEBUG] Inserting user_delegation: user_id=7038, delegation_id=5492
[2025-12-30 09:58:36] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:36] [DEBUG] Inserting activite_user: user_id=7038, activite_id=32 (sector=REAL_ESTATE)
[2025-12-30 09:58:36] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:36] [DEBUG] Inserting paiement: user_id=7038, year=2025, amount=219
[2025-12-30 09:58:36] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:36] [DEBUG] Processing user 125/125
[2025-12-30 09:58:36] [DEBUG] User email: magali.chatelain@star-aj.fr
[2025-12-30 09:58:36] [DEBUG] Checking if user exists: magali.chatelain@star-aj.fr
[2025-12-30 09:58:36] [DEBUG] User exists: No
[2025-12-30 09:58:36] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 09:58:36] [DEBUG] Data mapped, inserting user...
[2025-12-30 09:58:36] [DEBUG] User inserted successfully with ID: 7039
[2025-12-30 09:58:36] [DEBUG] Inserting user_delegation: user_id=7039, delegation_id=5475
[2025-12-30 09:58:36] [DEBUG] user_delegation inserted successfully
[2025-12-30 09:58:36] [DEBUG] Inserting activite_user: user_id=7039, activite_id=11 (sector=LEGAL)
[2025-12-30 09:58:36] [DEBUG] activite_user inserted successfully
[2025-12-30 09:58:36] [DEBUG] Inserting paiement: user_id=7039, year=2025, amount=430
[2025-12-30 09:58:36] [DEBUG] paiement inserted successfully (year=2025)
[2025-12-30 09:58:36] [DEBUG] Processing complete, committing final batch
[2025-12-30 09:58:36] [DEBUG] Committing final 12 users
[2025-12-30 09:58:36] [DEBUG] Final commit successful
[2025-12-30 09:58:36] [DEBUG] ID mapping contains 125 entries
[2025-12-30 09:58:36] [DEBUG] Mapping file: /home/fcefrancxd-yp/www/scratch/user_id_mapping.json
[2025-12-30 09:58:36] [DEBUG] JSON mapping size: 24,219 bytes
[2025-12-30 09:58:36] [DEBUG] ID mapping saved successfully (24219 bytes written)
[2025-12-30 09:58:36] [DEBUG] Import process completed
[2025-12-30 09:58:36] [DEBUG] Total duration: 2.08 seconds
[2025-12-30 09:58:36] [DEBUG] Average time per user: 0.017 seconds
[2025-12-30 09:58:36] [DEBUG] Import completed successfully with no errors
[2025-12-30 10:33:19] [DEBUG] Loading configuration from config.php
[2025-12-30 10:33:19] [DEBUG] Configuration loaded successfully
[2025-12-30 10:33:19] [DEBUG] Database host: fcefrancxdck867a.mysql.db:3306
[2025-12-30 10:33:19] [DEBUG] Database name: fcefrancxdck867a
[2025-12-30 10:33:19] [DEBUG] Database user: fcefrancxdck867a
[2025-12-30 10:33:19] [DEBUG] Input file: /home/fcefrancxd-yp/www/scratch/fce_9.users.json
[2025-12-30 10:33:19] [DEBUG] Batch size: 100
[2025-12-30 10:33:19] [DEBUG] Skip duplicates: Yes
[2025-12-30 10:33:19] [DEBUG] Verbose mode: Yes
[2025-12-30 10:33:19] [DEBUG] PHP Version: 5.6.40
[2025-12-30 10:33:19] [DEBUG] Script start time: 2025-12-30 10:33:19
[2025-12-30 10:33:19] [DEBUG] Loading delegation mapping from delegation_mapping.json
[2025-12-30 10:33:19] [DEBUG] Delegation mapping loaded: 65 delegations mapped
[2025-12-30 10:33:19] [DEBUG] Loading sector mapping from sector_mapping.json
[2025-12-30 10:33:19] [DEBUG] Sector mapping loaded: 21 sectors mapped
[2025-12-30 10:33:19] [DEBUG] Loading sector to activiteparent mapping from sector_to_activiteparent_mapping.json
[2025-12-30 10:33:19] [DEBUG] Sector to activiteparent mapping loaded: 21 sectors mapped
[2025-12-30 10:33:19] [DEBUG] Loading employees mapping from employees_mapping.json
[2025-12-30 10:33:19] [DEBUG] Employees mapping loaded: 10 values mapped
[2025-12-30 10:33:19] [DEBUG] Loading revenue mapping from revenue_mapping.json
[2025-12-30 10:33:19] [DEBUG] Revenue mapping loaded: 9 values mapped
[2025-12-30 10:33:19] [DEBUG] Loading professions mapping from professions_mapping.json
[2025-12-30 10:33:19] [DEBUG] Professions mapping loaded: 13 values mapped
[2025-12-30 10:33:19] [DEBUG] Building DSN connection string
[2025-12-30 10:33:19] [DEBUG] DSN: mysql:host=fcefrancxdck867a.mysql.db;port=3306;dbname=fcefrancxdck867a;charset=utf8
[2025-12-30 10:33:19] [DEBUG] Attempting PDO connection...
[2025-12-30 10:33:19] [DEBUG] PDO connection established successfully
[2025-12-30 10:33:19] [DEBUG] Setting charset to utf8
[2025-12-30 10:33:19] [DEBUG] Charset set successfully
[2025-12-30 10:33:19] [DEBUG] Checking if JSON file exists...
[2025-12-30 10:33:19] [DEBUG] JSON file found
[2025-12-30 10:33:19] [DEBUG] Reading JSON file contents...
[2025-12-30 10:33:19] [DEBUG] JSON file size: 20,146 bytes
[2025-12-30 10:33:19] [DEBUG] First 100 chars: [{
  "_id": {
    "$oid": "685a93b88c4e27aface89595"
  },
  "fceId": 475378,
  "email": "sarl.ellebo
[2025-12-30 10:33:19] [DEBUG] Decoding JSON...
[2025-12-30 10:33:19] [DEBUG] JSON decoded
[2025-12-30 10:33:19] [DEBUG] JSON is valid
[2025-12-30 10:33:19] [DEBUG] Total users parsed: 9
[2025-12-30 10:33:19] [DEBUG] First user email: sarl.elleboutique@gmail.com
[2025-12-30 10:33:19] [DEBUG] Preparing INSERT statement...
[2025-12-30 10:33:19] [DEBUG] Preparing PDO statement...
[2025-12-30 10:33:19] [DEBUG] INSERT statement prepared successfully
[2025-12-30 10:33:19] [DEBUG] Preparing duplicate check statement...
[2025-12-30 10:33:19] [DEBUG] Duplicate check statement prepared
[2025-12-30 10:33:19] [DEBUG] Starting user processing loop
[2025-12-30 10:33:19] [DEBUG] Beginning database transaction
[2025-12-30 10:33:19] [DEBUG] Transaction started
[2025-12-30 10:33:19] [DEBUG] Processing user 1/9
[2025-12-30 10:33:19] [DEBUG] User email: sarl.elleboutique@gmail.com
[2025-12-30 10:33:19] [DEBUG] Checking if user exists: sarl.elleboutique@gmail.com
[2025-12-30 10:33:19] [DEBUG] User exists: No
[2025-12-30 10:33:19] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 10:33:19] [DEBUG] Data mapped, inserting user...
[2025-12-30 10:33:19] [DEBUG] User inserted successfully with ID: 7040
[2025-12-30 10:33:19] [DEBUG] Inserting user_delegation: user_id=7040, delegation_id=5483
[2025-12-30 10:33:19] [DEBUG] user_delegation inserted successfully
[2025-12-30 10:33:19] [DEBUG] Inserting activite_user: user_id=7040, activite_id=18 (sector=COMMERCE)
[2025-12-30 10:33:19] [DEBUG] activite_user inserted successfully
[2025-12-30 10:33:19] [DEBUG] User has no payment data (details_paiement)
[2025-12-30 10:33:19] [DEBUG] Processing user 2/9
[2025-12-30 10:33:19] [DEBUG] User email: paola.poujade@cdj66.fr
[2025-12-30 10:33:19] [DEBUG] Checking if user exists: paola.poujade@cdj66.fr
[2025-12-30 10:33:19] [DEBUG] User exists: Yes (ID: 6945)
[2025-12-30 10:33:19] [DEBUG] Processing user 3/9
[2025-12-30 10:33:19] [DEBUG] User email: veronique.garguet-duport@safti.fr
[2025-12-30 10:33:19] [DEBUG] Checking if user exists: veronique.garguet-duport@safti.fr
[2025-12-30 10:33:19] [DEBUG] User exists: No
[2025-12-30 10:33:19] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 10:33:19] [DEBUG] Data mapped, inserting user...
[2025-12-30 10:33:19] [DEBUG] User inserted successfully with ID: 7041
[2025-12-30 10:33:19] [DEBUG] Inserting user_delegation: user_id=7041, delegation_id=5488
[2025-12-30 10:33:19] [DEBUG] user_delegation inserted successfully
[2025-12-30 10:33:19] [DEBUG] Inserting activite_user: user_id=7041, activite_id=32 (sector=REAL_ESTATE)
[2025-12-30 10:33:19] [DEBUG] activite_user inserted successfully
[2025-12-30 10:33:19] [DEBUG] User has no payment data (details_paiement)
[2025-12-30 10:33:19] [DEBUG] Processing user 4/9
[2025-12-30 10:33:19] [DEBUG] User email: sophie.buhler@notaires.fr
[2025-12-30 10:33:19] [DEBUG] Checking if user exists: sophie.buhler@notaires.fr
[2025-12-30 10:33:19] [DEBUG] User exists: No
[2025-12-30 10:33:19] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 10:33:19] [DEBUG] Data mapped, inserting user...
[2025-12-30 10:33:19] [DEBUG] User inserted successfully with ID: 7042
[2025-12-30 10:33:19] [DEBUG] Inserting user_delegation: user_id=7042, delegation_id=29
[2025-12-30 10:33:19] [DEBUG] user_delegation inserted successfully
[2025-12-30 10:33:19] [DEBUG] Inserting activite_user: user_id=7042, activite_id=11 (sector=LEGAL)
[2025-12-30 10:33:19] [DEBUG] activite_user inserted successfully
[2025-12-30 10:33:19] [DEBUG] User has no payment data (details_paiement)
[2025-12-30 10:33:19] [DEBUG] Processing user 5/9
[2025-12-30 10:33:19] [DEBUG] User email: olga@klytia.paris
[2025-12-30 10:33:19] [DEBUG] Checking if user exists: olga@klytia.paris
[2025-12-30 10:33:19] [DEBUG] User exists: Yes (ID: 6192)
[2025-12-30 10:33:19] [DEBUG] Processing user 6/9
[2025-12-30 10:33:19] [DEBUG] User email: stephanie@lecerisierblanc.com
[2025-12-30 10:33:19] [DEBUG] Checking if user exists: stephanie@lecerisierblanc.com
[2025-12-30 10:33:19] [DEBUG] User exists: No
[2025-12-30 10:33:19] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 10:33:19] [DEBUG] Data mapped, inserting user...
[2025-12-30 10:33:19] [DEBUG] User inserted successfully with ID: 7043
[2025-12-30 10:33:19] [DEBUG] Inserting user_delegation: user_id=7043, delegation_id=29
[2025-12-30 10:33:19] [DEBUG] user_delegation inserted successfully
[2025-12-30 10:33:19] [DEBUG] Inserting activite_user: user_id=7043, activite_id=18 (sector=COMMERCE)
[2025-12-30 10:33:19] [DEBUG] activite_user inserted successfully
[2025-12-30 10:33:19] [DEBUG] User has no payment data (details_paiement)
[2025-12-30 10:33:19] [DEBUG] Processing user 7/9
[2025-12-30 10:33:19] [DEBUG] User email: nathalie@lecerisierblanc.com
[2025-12-30 10:33:19] [DEBUG] Checking if user exists: nathalie@lecerisierblanc.com
[2025-12-30 10:33:19] [DEBUG] User exists: No
[2025-12-30 10:33:19] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 10:33:19] [DEBUG] Data mapped, inserting user...
[2025-12-30 10:33:19] [DEBUG] User inserted successfully with ID: 7044
[2025-12-30 10:33:19] [DEBUG] Inserting user_delegation: user_id=7044, delegation_id=29
[2025-12-30 10:33:19] [DEBUG] user_delegation inserted successfully
[2025-12-30 10:33:19] [DEBUG] Inserting activite_user: user_id=7044, activite_id=18 (sector=COMMERCE)
[2025-12-30 10:33:19] [DEBUG] activite_user inserted successfully
[2025-12-30 10:33:19] [DEBUG] User has no payment data (details_paiement)
[2025-12-30 10:33:19] [DEBUG] Processing user 8/9
[2025-12-30 10:33:19] [DEBUG] User email: virginie.delepoulle@apidae-consulting.com
[2025-12-30 10:33:19] [DEBUG] Checking if user exists: virginie.delepoulle@apidae-consulting.com
[2025-12-30 10:33:19] [DEBUG] User exists: No
[2025-12-30 10:33:19] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 10:33:19] [DEBUG] Data mapped, inserting user...
[2025-12-30 10:33:19] [DEBUG] User inserted successfully with ID: 7045
[2025-12-30 10:33:19] [DEBUG] Inserting user_delegation: user_id=7045, delegation_id=5483
[2025-12-30 10:33:19] [DEBUG] user_delegation inserted successfully
[2025-12-30 10:33:19] [DEBUG] Inserting activite_user: user_id=7045, activite_id=52 (sector=BUSINESS_SERVICES)
[2025-12-30 10:33:19] [DEBUG] activite_user inserted successfully
[2025-12-30 10:33:19] [DEBUG] User has no payment data (details_paiement)
[2025-12-30 10:33:19] [DEBUG] Processing user 9/9
[2025-12-30 10:33:19] [DEBUG] User email: s.espinasse@cduc.fr
[2025-12-30 10:33:19] [DEBUG] Checking if user exists: s.espinasse@cduc.fr
[2025-12-30 10:33:19] [DEBUG] User exists: No
[2025-12-30 10:33:19] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 10:33:19] [DEBUG] Data mapped, inserting user...
[2025-12-30 10:33:19] [DEBUG] User inserted successfully with ID: 7046
[2025-12-30 10:33:19] [DEBUG] Inserting user_delegation: user_id=7046, delegation_id=5483
[2025-12-30 10:33:19] [DEBUG] user_delegation inserted successfully
[2025-12-30 10:33:19] [DEBUG] Inserting activite_user: user_id=7046, activite_id=18 (sector=COMMERCE)
[2025-12-30 10:33:19] [DEBUG] activite_user inserted successfully
[2025-12-30 10:33:19] [DEBUG] User has no payment data (details_paiement)
[2025-12-30 10:33:19] [DEBUG] Processing complete, committing final batch
[2025-12-30 10:33:19] [DEBUG] Committing final 7 users
[2025-12-30 10:33:19] [DEBUG] Final commit successful
[2025-12-30 10:33:19] [DEBUG] ID mapping contains 9 entries
[2025-12-30 10:33:19] [DEBUG] Mapping file: /home/fcefrancxd-yp/www/scratch/user_id_mapping.json
[2025-12-30 10:33:19] [DEBUG] JSON mapping size: 1,760 bytes
[2025-12-30 10:33:19] [DEBUG] ID mapping saved successfully (1760 bytes written)
[2025-12-30 10:33:19] [DEBUG] Import process completed
[2025-12-30 10:33:19] [DEBUG] Total duration: 0.17 seconds
[2025-12-30 10:33:19] [DEBUG] Average time per user: 0.019 seconds
[2025-12-30 10:33:19] [DEBUG] Import completed successfully with no errors
[2025-12-30 10:47:03] [DEBUG] Loading configuration from config.php
[2025-12-30 10:47:03] [DEBUG] Configuration loaded successfully
[2025-12-30 10:47:03] [DEBUG] Database host: fcefrancxdck867a.mysql.db:3306
[2025-12-30 10:47:03] [DEBUG] Database name: fcefrancxdck867a
[2025-12-30 10:47:03] [DEBUG] Database user: fcefrancxdck867a
[2025-12-30 10:47:03] [DEBUG] Input file: /home/fcefrancxd-yp/www/scratch/fce_27.users.json
[2025-12-30 10:47:03] [DEBUG] Batch size: 100
[2025-12-30 10:47:03] [DEBUG] Skip duplicates: Yes
[2025-12-30 10:47:03] [DEBUG] Verbose mode: Yes
[2025-12-30 10:47:03] [DEBUG] PHP Version: 5.6.40
[2025-12-30 10:47:03] [DEBUG] Script start time: 2025-12-30 10:47:03
[2025-12-30 10:47:03] [DEBUG] Loading delegation mapping from delegation_mapping.json
[2025-12-30 10:47:03] [DEBUG] Delegation mapping loaded: 65 delegations mapped
[2025-12-30 10:47:03] [DEBUG] Loading sector mapping from sector_mapping.json
[2025-12-30 10:47:03] [DEBUG] Sector mapping loaded: 21 sectors mapped
[2025-12-30 10:47:03] [DEBUG] Loading sector to activiteparent mapping from sector_to_activiteparent_mapping.json
[2025-12-30 10:47:03] [DEBUG] Sector to activiteparent mapping loaded: 21 sectors mapped
[2025-12-30 10:47:03] [DEBUG] Loading employees mapping from employees_mapping.json
[2025-12-30 10:47:03] [DEBUG] Employees mapping loaded: 10 values mapped
[2025-12-30 10:47:03] [DEBUG] Loading revenue mapping from revenue_mapping.json
[2025-12-30 10:47:03] [DEBUG] Revenue mapping loaded: 9 values mapped
[2025-12-30 10:47:03] [DEBUG] Loading professions mapping from professions_mapping.json
[2025-12-30 10:47:03] [DEBUG] Professions mapping loaded: 13 values mapped
[2025-12-30 10:47:03] [DEBUG] Building DSN connection string
[2025-12-30 10:47:03] [DEBUG] DSN: mysql:host=fcefrancxdck867a.mysql.db;port=3306;dbname=fcefrancxdck867a;charset=utf8
[2025-12-30 10:47:03] [DEBUG] Attempting PDO connection...
[2025-12-30 10:47:03] [DEBUG] PDO connection established successfully
[2025-12-30 10:47:03] [DEBUG] Setting charset to utf8
[2025-12-30 10:47:03] [DEBUG] Charset set successfully
[2025-12-30 10:47:03] [DEBUG] Checking if JSON file exists...
[2025-12-30 10:47:03] [DEBUG] JSON file found
[2025-12-30 10:47:03] [DEBUG] Reading JSON file contents...
[2025-12-30 10:47:03] [DEBUG] JSON file size: 62,303 bytes
[2025-12-30 10:47:03] [DEBUG] First 100 chars: [{
  "_id": {
    "$oid": "68bedc327bbf1f85db753648"
  },
  "fceId": 931885,
  "email": "nola.brauno
[2025-12-30 10:47:03] [DEBUG] Decoding JSON...
[2025-12-30 10:47:03] [DEBUG] JSON decoded
[2025-12-30 10:47:03] [DEBUG] JSON is valid
[2025-12-30 10:47:03] [DEBUG] Total users parsed: 28
[2025-12-30 10:47:03] [DEBUG] First user email: nola.braunogue@capifrance.fr
[2025-12-30 10:47:03] [DEBUG] Preparing INSERT statement...
[2025-12-30 10:47:03] [DEBUG] Preparing PDO statement...
[2025-12-30 10:47:03] [DEBUG] INSERT statement prepared successfully
[2025-12-30 10:47:03] [DEBUG] Preparing duplicate check statement...
[2025-12-30 10:47:03] [DEBUG] Duplicate check statement prepared
[2025-12-30 10:47:03] [DEBUG] Starting user processing loop
[2025-12-30 10:47:03] [DEBUG] Beginning database transaction
[2025-12-30 10:47:03] [DEBUG] Transaction started
[2025-12-30 10:47:03] [DEBUG] Processing user 1/28
[2025-12-30 10:47:03] [DEBUG] User email: nola.braunogue@capifrance.fr
[2025-12-30 10:47:03] [DEBUG] Checking if user exists: nola.braunogue@capifrance.fr
[2025-12-30 10:47:03] [DEBUG] User exists: No
[2025-12-30 10:47:03] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 10:47:03] [DEBUG] Data mapped, inserting user...
[2025-12-30 10:47:03] [DEBUG] User inserted successfully with ID: 7047
[2025-12-30 10:47:03] [DEBUG] Inserting user_delegation: user_id=7047, delegation_id=5472
[2025-12-30 10:47:03] [DEBUG] user_delegation inserted successfully
[2025-12-30 10:47:03] [DEBUG] Inserting activite_user: user_id=7047, activite_id=18 (sector=COMMERCE)
[2025-12-30 10:47:03] [DEBUG] activite_user inserted successfully
[2025-12-30 10:47:03] [DEBUG] User has no payment data (details_paiement)
[2025-12-30 10:47:03] [DEBUG] Processing user 2/28
[2025-12-30 10:47:03] [DEBUG] User email: gervaiscaroline@yahoo.com
[2025-12-30 10:47:03] [DEBUG] Checking if user exists: gervaiscaroline@yahoo.com
[2025-12-30 10:47:03] [DEBUG] User exists: No
[2025-12-30 10:47:03] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 10:47:03] [DEBUG] Data mapped, inserting user...
[2025-12-30 10:47:03] [DEBUG] User inserted successfully with ID: 7048
[2025-12-30 10:47:03] [DEBUG] Inserting user_delegation: user_id=7048, delegation_id=5469
[2025-12-30 10:47:03] [DEBUG] user_delegation inserted successfully
[2025-12-30 10:47:03] [DEBUG] Inserting activite_user: user_id=7048, activite_id=18 (sector=COMMERCE)
[2025-12-30 10:47:03] [DEBUG] activite_user inserted successfully
[2025-12-30 10:47:03] [DEBUG] User has no payment data (details_paiement)
[2025-12-30 10:47:03] [DEBUG] Processing user 3/28
[2025-12-30 10:47:03] [DEBUG] User email: labigourdane65@gmail.com
[2025-12-30 10:47:03] [DEBUG] Checking if user exists: labigourdane65@gmail.com
[2025-12-30 10:47:03] [DEBUG] User exists: No
[2025-12-30 10:47:03] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 10:47:03] [DEBUG] Data mapped, inserting user...
[2025-12-30 10:47:03] [DEBUG] User inserted successfully with ID: 7049
[2025-12-30 10:47:03] [DEBUG] Inserting user_delegation: user_id=7049, delegation_id=5472
[2025-12-30 10:47:03] [DEBUG] user_delegation inserted successfully
[2025-12-30 10:47:03] [DEBUG] Inserting activite_user: user_id=7049, activite_id=31 (sector=TOURISM_AND_HOSPITALITY)
[2025-12-30 10:47:03] [DEBUG] activite_user inserted successfully
[2025-12-30 10:47:03] [DEBUG] User has no payment data (details_paiement)
[2025-12-30 10:47:03] [DEBUG] Processing user 4/28
[2025-12-30 10:47:03] [DEBUG] User email: vdevilledeperiere@agence.generali.fr
[2025-12-30 10:47:03] [DEBUG] Checking if user exists: vdevilledeperiere@agence.generali.fr
[2025-12-30 10:47:03] [DEBUG] User exists: No
[2025-12-30 10:47:03] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 10:47:03] [DEBUG] Data mapped, inserting user...
[2025-12-30 10:47:03] [DEBUG] User inserted successfully with ID: 7050
[2025-12-30 10:47:03] [DEBUG] Inserting user_delegation: user_id=7050, delegation_id=5462
[2025-12-30 10:47:03] [DEBUG] user_delegation inserted successfully
[2025-12-30 10:47:03] [DEBUG] Inserting activite_user: user_id=7050, activite_id=12 (sector=INSURANCE_AND_BANKING)
[2025-12-30 10:47:03] [DEBUG] activite_user inserted successfully
[2025-12-30 10:47:03] [DEBUG] User has no payment data (details_paiement)
[2025-12-30 10:47:03] [DEBUG] Processing user 5/28
[2025-12-30 10:47:03] [DEBUG] User email: angelina@exeko.ai
[2025-12-30 10:47:03] [DEBUG] Checking if user exists: angelina@exeko.ai
[2025-12-30 10:47:03] [DEBUG] User exists: No
[2025-12-30 10:47:03] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 10:47:03] [DEBUG] Data mapped, inserting user...
[2025-12-30 10:47:03] [DEBUG] User inserted successfully with ID: 7051
[2025-12-30 10:47:03] [DEBUG] Inserting user_delegation: user_id=7051, delegation_id=5495
[2025-12-30 10:47:03] [DEBUG] user_delegation inserted successfully
[2025-12-30 10:47:03] [DEBUG] Inserting activite_user: user_id=7051, activite_id=37 (sector=DIGITAL_AND_TECHNOLOGIES)
[2025-12-30 10:47:03] [DEBUG] activite_user inserted successfully
[2025-12-30 10:47:03] [DEBUG] User has no payment data (details_paiement)
[2025-12-30 10:47:03] [DEBUG] Processing user 6/28
[2025-12-30 10:47:03] [DEBUG] User email: laurence@respelida.fr
[2025-12-30 10:47:03] [DEBUG] Checking if user exists: laurence@respelida.fr
[2025-12-30 10:47:03] [DEBUG] User exists: No
[2025-12-30 10:47:03] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 10:47:03] [DEBUG] Data mapped, inserting user...
[2025-12-30 10:47:03] [DEBUG] User inserted successfully with ID: 7052
[2025-12-30 10:47:03] [DEBUG] Inserting user_delegation: user_id=7052, delegation_id=5462
[2025-12-30 10:47:03] [DEBUG] user_delegation inserted successfully
[2025-12-30 10:47:03] [DEBUG] Inserting activite_user: user_id=7052, activite_id=52 (sector=BUSINESS_SERVICES)
[2025-12-30 10:47:03] [DEBUG] activite_user inserted successfully
[2025-12-30 10:47:03] [DEBUG] User has no payment data (details_paiement)
[2025-12-30 10:47:03] [DEBUG] Processing user 7/28
[2025-12-30 10:47:03] [DEBUG] User email: contact@gothrough.fr
[2025-12-30 10:47:03] [DEBUG] Checking if user exists: contact@gothrough.fr
[2025-12-30 10:47:03] [DEBUG] User exists: No
[2025-12-30 10:47:03] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 10:47:03] [DEBUG] Data mapped, inserting user...
[2025-12-30 10:47:03] [DEBUG] User inserted successfully with ID: 7053
[2025-12-30 10:47:03] [DEBUG] Inserting user_delegation: user_id=7053, delegation_id=32
[2025-12-30 10:47:03] [DEBUG] user_delegation inserted successfully
[2025-12-30 10:47:03] [DEBUG] Inserting activite_user: user_id=7053, activite_id=52 (sector=BUSINESS_SERVICES)
[2025-12-30 10:47:03] [DEBUG] activite_user inserted successfully
[2025-12-30 10:47:03] [DEBUG] User has no payment data (details_paiement)
[2025-12-30 10:47:03] [DEBUG] Processing user 8/28
[2025-12-30 10:47:03] [DEBUG] User email: malbroucka91@gmail.com
[2025-12-30 10:47:03] [DEBUG] Checking if user exists: malbroucka91@gmail.com
[2025-12-30 10:47:03] [DEBUG] User exists: No
[2025-12-30 10:47:03] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 10:47:03] [DEBUG] Data mapped, inserting user...
[2025-12-30 10:47:03] [DEBUG] User inserted successfully with ID: 7054
[2025-12-30 10:47:03] [DEBUG] Inserting user_delegation: user_id=7054, delegation_id=21
[2025-12-30 10:47:03] [DEBUG] user_delegation inserted successfully
[2025-12-30 10:47:03] [DEBUG] Inserting activite_user: user_id=7054, activite_id=18 (sector=COMMERCE)
[2025-12-30 10:47:03] [DEBUG] activite_user inserted successfully
[2025-12-30 10:47:03] [DEBUG] User has no payment data (details_paiement)
[2025-12-30 10:47:03] [DEBUG] Processing user 9/28
[2025-12-30 10:47:03] [DEBUG] User email: lairderiendeco@icloud.com
[2025-12-30 10:47:03] [DEBUG] Checking if user exists: lairderiendeco@icloud.com
[2025-12-30 10:47:03] [DEBUG] User exists: No
[2025-12-30 10:47:03] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 10:47:03] [DEBUG] Data mapped, inserting user...
[2025-12-30 10:47:03] [DEBUG] User inserted successfully with ID: 7055
[2025-12-30 10:47:03] [DEBUG] Inserting user_delegation: user_id=7055, delegation_id=5485
[2025-12-30 10:47:03] [DEBUG] user_delegation inserted successfully
[2025-12-30 10:47:03] [DEBUG] Inserting activite_user: user_id=7055, activite_id=54 (sector=EVENTS)
[2025-12-30 10:47:03] [DEBUG] activite_user inserted successfully
[2025-12-30 10:47:03] [DEBUG] User has no payment data (details_paiement)
[2025-12-30 10:47:03] [DEBUG] Processing user 10/28
[2025-12-30 10:47:03] [DEBUG] User email: fhdanne@gmail.com
[2025-12-30 10:47:03] [DEBUG] Checking if user exists: fhdanne@gmail.com
[2025-12-30 10:47:03] [DEBUG] User exists: No
[2025-12-30 10:47:03] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 10:47:03] [DEBUG] Data mapped, inserting user...
[2025-12-30 10:47:03] [DEBUG] User inserted successfully with ID: 7056
[2025-12-30 10:47:03] [DEBUG] Inserting user_delegation: user_id=7056, delegation_id=5482
[2025-12-30 10:47:03] [DEBUG] user_delegation inserted successfully
[2025-12-30 10:47:03] [DEBUG] Inserting activite_user: user_id=7056, activite_id=37 (sector=DIGITAL_AND_TECHNOLOGIES)
[2025-12-30 10:47:03] [DEBUG] activite_user inserted successfully
[2025-12-30 10:47:03] [DEBUG] User has no payment data (details_paiement)
[2025-12-30 10:47:03] [DEBUG] Processing user 11/28
[2025-12-30 10:47:03] [DEBUG] User email: juliederoquefeuil@hotmail.com
[2025-12-30 10:47:03] [DEBUG] Checking if user exists: juliederoquefeuil@hotmail.com
[2025-12-30 10:47:04] [DEBUG] User exists: No
[2025-12-30 10:47:04] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 10:47:04] [DEBUG] Data mapped, inserting user...
[2025-12-30 10:47:04] [DEBUG] User inserted successfully with ID: 7057
[2025-12-30 10:47:04] [DEBUG] Inserting user_delegation: user_id=7057, delegation_id=5473
[2025-12-30 10:47:04] [DEBUG] user_delegation inserted successfully
[2025-12-30 10:47:04] [DEBUG] Inserting activite_user: user_id=7057, activite_id=37 (sector=DIGITAL_AND_TECHNOLOGIES)
[2025-12-30 10:47:04] [DEBUG] activite_user inserted successfully
[2025-12-30 10:47:04] [DEBUG] User has no payment data (details_paiement)
[2025-12-30 10:47:04] [DEBUG] Processing user 12/28
[2025-12-30 10:47:04] [DEBUG] User email: mbetton@conservateur-conseil.fr
[2025-12-30 10:47:04] [DEBUG] Checking if user exists: mbetton@conservateur-conseil.fr
[2025-12-30 10:47:04] [DEBUG] User exists: Yes (ID: 6974)
[2025-12-30 10:47:04] [DEBUG] Processing user 13/28
[2025-12-30 10:47:04] [DEBUG] User email: clementine.raymond@pepites-studio.com
[2025-12-30 10:47:04] [DEBUG] Checking if user exists: clementine.raymond@pepites-studio.com
[2025-12-30 10:47:04] [DEBUG] User exists: Yes (ID: 6454)
[2025-12-30 10:47:04] [DEBUG] Processing user 14/28
[2025-12-30 10:47:04] [DEBUG] User email: leonie.suau@courtage-conseils.fr
[2025-12-30 10:47:04] [DEBUG] Checking if user exists: leonie.suau@courtage-conseils.fr
[2025-12-30 10:47:04] [DEBUG] User exists: No
[2025-12-30 10:47:04] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 10:47:04] [DEBUG] Data mapped, inserting user...
[2025-12-30 10:47:04] [DEBUG] User inserted successfully with ID: 7058
[2025-12-30 10:47:04] [DEBUG] Inserting user_delegation: user_id=7058, delegation_id=5576
[2025-12-30 10:47:04] [DEBUG] user_delegation inserted successfully
[2025-12-30 10:47:04] [DEBUG] Inserting activite_user: user_id=7058, activite_id=12 (sector=INSURANCE_AND_BANKING)
[2025-12-30 10:47:04] [DEBUG] activite_user inserted successfully
[2025-12-30 10:47:04] [DEBUG] User has no payment data (details_paiement)
[2025-12-30 10:47:04] [DEBUG] Processing user 15/28
[2025-12-30 10:47:04] [DEBUG] User email: delphine.audenard@avocat.fr
[2025-12-30 10:47:04] [DEBUG] Checking if user exists: delphine.audenard@avocat.fr
[2025-12-30 10:47:04] [DEBUG] User exists: No
[2025-12-30 10:47:04] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 10:47:04] [DEBUG] Data mapped, inserting user...
[2025-12-30 10:47:04] [DEBUG] User inserted successfully with ID: 7059
[2025-12-30 10:47:04] [DEBUG] Inserting user_delegation: user_id=7059, delegation_id=5482
[2025-12-30 10:47:04] [DEBUG] user_delegation inserted successfully
[2025-12-30 10:47:04] [DEBUG] Inserting activite_user: user_id=7059, activite_id=11 (sector=LEGAL)
[2025-12-30 10:47:04] [DEBUG] activite_user inserted successfully
[2025-12-30 10:47:04] [DEBUG] User has no payment data (details_paiement)
[2025-12-30 10:47:04] [DEBUG] Processing user 16/28
[2025-12-30 10:47:04] [DEBUG] User email: mfi@afexios-provence.com
[2025-12-30 10:47:04] [DEBUG] Checking if user exists: mfi@afexios-provence.com
[2025-12-30 10:47:04] [DEBUG] User exists: Yes (ID: 6893)
[2025-12-30 10:47:04] [DEBUG] Processing user 17/28
[2025-12-30 10:47:04] [DEBUG] User email: hubert.christine1@gmail.com
[2025-12-30 10:47:04] [DEBUG] Checking if user exists: hubert.christine1@gmail.com
[2025-12-30 10:47:04] [DEBUG] User exists: No
[2025-12-30 10:47:04] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 10:47:04] [DEBUG] Data mapped, inserting user...
[2025-12-30 10:47:04] [DEBUG] User inserted successfully with ID: 7060
[2025-12-30 10:47:04] [DEBUG] Inserting user_delegation: user_id=7060, delegation_id=5573
[2025-12-30 10:47:04] [DEBUG] user_delegation inserted successfully
[2025-12-30 10:47:04] [DEBUG] Inserting activite_user: user_id=7060, activite_id=18 (sector=COMMERCE)
[2025-12-30 10:47:04] [DEBUG] activite_user inserted successfully
[2025-12-30 10:47:04] [DEBUG] User has no payment data (details_paiement)
[2025-12-30 10:47:04] [DEBUG] Processing user 18/28
[2025-12-30 10:47:04] [DEBUG] User email: audreyhillebrand@gmail.com
[2025-12-30 10:47:04] [DEBUG] Checking if user exists: audreyhillebrand@gmail.com
[2025-12-30 10:47:04] [DEBUG] User exists: No
[2025-12-30 10:47:04] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 10:47:04] [DEBUG] Data mapped, inserting user...
[2025-12-30 10:47:04] [DEBUG] User inserted successfully with ID: 7061
[2025-12-30 10:47:04] [DEBUG] Inserting user_delegation: user_id=7061, delegation_id=5486
[2025-12-30 10:47:04] [DEBUG] user_delegation inserted successfully
[2025-12-30 10:47:04] [DEBUG] Inserting activite_user: user_id=7061, activite_id=52 (sector=BUSINESS_SERVICES)
[2025-12-30 10:47:04] [DEBUG] activite_user inserted successfully
[2025-12-30 10:47:04] [DEBUG] User has no payment data (details_paiement)
[2025-12-30 10:47:04] [DEBUG] Processing user 19/28
[2025-12-30 10:47:04] [DEBUG] User email: juliette@semawe.fr
[2025-12-30 10:47:04] [DEBUG] Checking if user exists: juliette@semawe.fr
[2025-12-30 10:47:04] [DEBUG] User exists: No
[2025-12-30 10:47:04] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 10:47:04] [DEBUG] Data mapped, inserting user...
[2025-12-30 10:47:04] [DEBUG] User inserted successfully with ID: 7062
[2025-12-30 10:47:04] [DEBUG] Inserting user_delegation: user_id=7062, delegation_id=5480
[2025-12-30 10:47:04] [DEBUG] user_delegation inserted successfully
[2025-12-30 10:47:04] [DEBUG] Inserting activite_user: user_id=7062, activite_id=52 (sector=BUSINESS_SERVICES)
[2025-12-30 10:47:04] [DEBUG] activite_user inserted successfully
[2025-12-30 10:47:04] [DEBUG] User has no payment data (details_paiement)
[2025-12-30 10:47:04] [DEBUG] Processing user 20/28
[2025-12-30 10:47:04] [DEBUG] User email: colombosandra@orange.fr
[2025-12-30 10:47:04] [DEBUG] Checking if user exists: colombosandra@orange.fr
[2025-12-30 10:47:04] [DEBUG] User exists: No
[2025-12-30 10:47:04] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 10:47:04] [DEBUG] Data mapped, inserting user...
[2025-12-30 10:47:04] [DEBUG] User inserted successfully with ID: 7063
[2025-12-30 10:47:04] [DEBUG] Inserting user_delegation: user_id=7063, delegation_id=5573
[2025-12-30 10:47:04] [DEBUG] user_delegation inserted successfully
[2025-12-30 10:47:04] [DEBUG] Inserting activite_user: user_id=7063, activite_id=18 (sector=COMMERCE)
[2025-12-30 10:47:04] [DEBUG] activite_user inserted successfully
[2025-12-30 10:47:04] [DEBUG] User has no payment data (details_paiement)
[2025-12-30 10:47:04] [DEBUG] Processing user 21/28
[2025-12-30 10:47:04] [DEBUG] User email: anais.vimbaye@gmail.com
[2025-12-30 10:47:04] [DEBUG] Checking if user exists: anais.vimbaye@gmail.com
[2025-12-30 10:47:04] [DEBUG] User exists: No
[2025-12-30 10:47:04] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 10:47:04] [DEBUG] Data mapped, inserting user...
[2025-12-30 10:47:04] [DEBUG] User inserted successfully with ID: 7064
[2025-12-30 10:47:04] [DEBUG] Inserting user_delegation: user_id=7064, delegation_id=5573
[2025-12-30 10:47:04] [DEBUG] user_delegation inserted successfully
[2025-12-30 10:47:04] [DEBUG] Inserting activite_user: user_id=7064, activite_id=30 (sector=HEALTH)
[2025-12-30 10:47:04] [DEBUG] activite_user inserted successfully
[2025-12-30 10:47:04] [DEBUG] User has no payment data (details_paiement)
[2025-12-30 10:47:04] [DEBUG] Processing user 22/28
[2025-12-30 10:47:04] [DEBUG] User email: arginthe.regina@gmail.com
[2025-12-30 10:47:04] [DEBUG] Checking if user exists: arginthe.regina@gmail.com
[2025-12-30 10:47:04] [DEBUG] User exists: No
[2025-12-30 10:47:04] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 10:47:04] [DEBUG] Data mapped, inserting user...
[2025-12-30 10:47:04] [DEBUG] User inserted successfully with ID: 7065
[2025-12-30 10:47:04] [DEBUG] Inserting user_delegation: user_id=7065, delegation_id=5573
[2025-12-30 10:47:04] [DEBUG] user_delegation inserted successfully
[2025-12-30 10:47:04] [DEBUG] Inserting activite_user: user_id=7065, activite_id=3 (sector=AGRI_FOOD)
[2025-12-30 10:47:04] [DEBUG] activite_user inserted successfully
[2025-12-30 10:47:04] [DEBUG] User has no payment data (details_paiement)
[2025-12-30 10:47:04] [DEBUG] Processing user 23/28
[2025-12-30 10:47:04] [DEBUG] User email: laure.daragnes@gmail.com
[2025-12-30 10:47:04] [DEBUG] Checking if user exists: laure.daragnes@gmail.com
[2025-12-30 10:47:04] [DEBUG] User exists: No
[2025-12-30 10:47:04] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 10:47:04] [DEBUG] Data mapped, inserting user...
[2025-12-30 10:47:04] [DEBUG] User inserted successfully with ID: 7066
[2025-12-30 10:47:04] [DEBUG] Inserting user_delegation: user_id=7066, delegation_id=5573
[2025-12-30 10:47:04] [DEBUG] user_delegation inserted successfully
[2025-12-30 10:47:04] [DEBUG] Inserting activite_user: user_id=7066, activite_id=37 (sector=DIGITAL_SERVICES_AND_CYBERSECURITY)
[2025-12-30 10:47:04] [DEBUG] activite_user inserted successfully
[2025-12-30 10:47:04] [DEBUG] User has no payment data (details_paiement)
[2025-12-30 10:47:04] [DEBUG] Processing user 24/28
[2025-12-30 10:47:04] [DEBUG] User email: djeya.enc@gmail.com
[2025-12-30 10:47:04] [DEBUG] Checking if user exists: djeya.enc@gmail.com
[2025-12-30 10:47:04] [DEBUG] User exists: No
[2025-12-30 10:47:04] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 10:47:04] [DEBUG] Data mapped, inserting user...
[2025-12-30 10:47:04] [DEBUG] User inserted successfully with ID: 7067
[2025-12-30 10:47:04] [DEBUG] Inserting user_delegation: user_id=7067, delegation_id=5573
[2025-12-30 10:47:04] [DEBUG] user_delegation inserted successfully
[2025-12-30 10:47:04] [DEBUG] Inserting activite_user: user_id=7067, activite_id=55 (sector=TRANSPORT_AND_LOGISTICS)
[2025-12-30 10:47:04] [DEBUG] activite_user inserted successfully
[2025-12-30 10:47:04] [DEBUG] User has no payment data (details_paiement)
[2025-12-30 10:47:04] [DEBUG] Processing user 25/28
[2025-12-30 10:47:04] [DEBUG] User email: soyadabeysang@yahoo.fr
[2025-12-30 10:47:04] [DEBUG] Checking if user exists: soyadabeysang@yahoo.fr
[2025-12-30 10:47:04] [DEBUG] User exists: No
[2025-12-30 10:47:04] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 10:47:04] [DEBUG] Data mapped, inserting user...
[2025-12-30 10:47:04] [DEBUG] User inserted successfully with ID: 7068
[2025-12-30 10:47:04] [DEBUG] Inserting user_delegation: user_id=7068, delegation_id=5471
[2025-12-30 10:47:04] [DEBUG] user_delegation inserted successfully
[2025-12-30 10:47:04] [DEBUG] Inserting activite_user: user_id=7068, activite_id=30 (sector=HEALTH)
[2025-12-30 10:47:04] [DEBUG] activite_user inserted successfully
[2025-12-30 10:47:04] [DEBUG] User has no payment data (details_paiement)
[2025-12-30 10:47:04] [DEBUG] Processing user 26/28
[2025-12-30 10:47:04] [DEBUG] User email: vmeozzi@aimeozzi.fr
[2025-12-30 10:47:04] [DEBUG] Checking if user exists: vmeozzi@aimeozzi.fr
[2025-12-30 10:47:04] [DEBUG] User exists: No
[2025-12-30 10:47:04] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 10:47:04] [DEBUG] Data mapped, inserting user...
[2025-12-30 10:47:04] [DEBUG] User inserted successfully with ID: 7069
[2025-12-30 10:47:04] [DEBUG] Inserting user_delegation: user_id=7069, delegation_id=5575
[2025-12-30 10:47:04] [DEBUG] user_delegation inserted successfully
[2025-12-30 10:47:04] [DEBUG] Inserting activite_user: user_id=7069, activite_id=13 (sector=CONSTRUCTION)
[2025-12-30 10:47:04] [DEBUG] activite_user inserted successfully
[2025-12-30 10:47:04] [DEBUG] User has no payment data (details_paiement)
[2025-12-30 10:47:04] [DEBUG] Processing user 27/28
[2025-12-30 10:47:04] [DEBUG] User email: cindy@ardea-digital.fr
[2025-12-30 10:47:04] [DEBUG] Checking if user exists: cindy@ardea-digital.fr
[2025-12-30 10:47:04] [DEBUG] User exists: No
[2025-12-30 10:47:04] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 10:47:04] [DEBUG] Data mapped, inserting user...
[2025-12-30 10:47:04] [DEBUG] User inserted successfully with ID: 7070
[2025-12-30 10:47:04] [DEBUG] Inserting user_delegation: user_id=7070, delegation_id=5463
[2025-12-30 10:47:04] [DEBUG] user_delegation inserted successfully
[2025-12-30 10:47:04] [DEBUG] Inserting activite_user: user_id=7070, activite_id=37 (sector=DIGITAL_AND_TECHNOLOGIES)
[2025-12-30 10:47:04] [DEBUG] activite_user inserted successfully
[2025-12-30 10:47:04] [DEBUG] User has no payment data (details_paiement)
[2025-12-30 10:47:04] [DEBUG] Processing user 28/28
[2025-12-30 10:47:04] [DEBUG] User email: solene@instant-exception.com
[2025-12-30 10:47:04] [DEBUG] Checking if user exists: solene@instant-exception.com
[2025-12-30 10:47:04] [DEBUG] User exists: No
[2025-12-30 10:47:04] [DEBUG] Mapping MongoDB data to MySQL fields
[2025-12-30 10:47:04] [DEBUG] Data mapped, inserting user...
[2025-12-30 10:47:04] [DEBUG] User inserted successfully with ID: 7071
[2025-12-30 10:47:04] [DEBUG] Inserting user_delegation: user_id=7071, delegation_id=5463
[2025-12-30 10:47:04] [DEBUG] user_delegation inserted successfully
[2025-12-30 10:47:04] [DEBUG] Inserting activite_user: user_id=7071, activite_id=54 (sector=EVENTS)
[2025-12-30 10:47:04] [DEBUG] activite_user inserted successfully
[2025-12-30 10:47:04] [DEBUG] User has no payment data (details_paiement)
[2025-12-30 10:47:04] [DEBUG] Processing complete, committing final batch
[2025-12-30 10:47:04] [DEBUG] Committing final 25 users
[2025-12-30 10:47:04] [DEBUG] Final commit successful
[2025-12-30 10:47:04] [DEBUG] ID mapping contains 28 entries
[2025-12-30 10:47:04] [DEBUG] Mapping file: /home/fcefrancxd-yp/www/scratch/user_id_mapping.json
[2025-12-30 10:47:04] [DEBUG] JSON mapping size: 5,419 bytes
[2025-12-30 10:47:04] [DEBUG] ID mapping saved successfully (5419 bytes written)
[2025-12-30 10:47:04] [DEBUG] Import process completed
[2025-12-30 10:47:04] [DEBUG] Total duration: 0.48 seconds
[2025-12-30 10:47:04] [DEBUG] Average time per user: 0.017 seconds
[2025-12-30 10:47:04] [DEBUG] Import completed successfully with no errors
[2026-01-03 05:43:14] [DEBUG] Loading configuration from config.php
[2026-01-03 05:43:14] [DEBUG] Configuration loaded successfully
[2026-01-03 05:43:14] [DEBUG] Database host: fcefrancxdck867a.mysql.db:3306
[2026-01-03 05:43:14] [DEBUG] Database name: fcefrancxdck867a
[2026-01-03 05:43:14] [DEBUG] Database user: fcefrancxdck867a
[2026-01-03 05:43:14] [DEBUG] Input file: /home/fcefrancxd/www/scratch/fce_27.users.json
[2026-01-03 05:43:14] [DEBUG] Batch size: 100
[2026-01-03 05:43:14] [DEBUG] Skip duplicates: Yes
[2026-01-03 05:43:14] [DEBUG] Verbose mode: Yes
[2026-01-03 05:43:14] [DEBUG] PHP Version: 5.6.40
[2026-01-03 05:43:14] [DEBUG] Script start time: 2026-01-03 05:43:14
[2026-01-03 05:43:14] [DEBUG] Loading delegation mapping from delegation_mapping.json
[2026-01-03 05:43:14] [DEBUG] Delegation mapping loaded: 65 delegations mapped
[2026-01-03 05:43:14] [DEBUG] Loading sector mapping from sector_mapping.json
[2026-01-03 05:43:14] [DEBUG] Sector mapping loaded: 21 sectors mapped
[2026-01-03 05:43:14] [DEBUG] Loading sector to activiteparent mapping from sector_to_activiteparent_mapping.json
[2026-01-03 05:43:14] [DEBUG] Sector to activiteparent mapping loaded: 21 sectors mapped
[2026-01-03 05:43:14] [DEBUG] Loading employees mapping from employees_mapping.json
[2026-01-03 05:43:14] [DEBUG] Employees mapping loaded: 10 values mapped
[2026-01-03 05:43:14] [DEBUG] Loading revenue mapping from revenue_mapping.json
[2026-01-03 05:43:14] [DEBUG] Revenue mapping loaded: 9 values mapped
[2026-01-03 05:43:14] [DEBUG] Loading professions mapping from professions_mapping.json
[2026-01-03 05:43:14] [DEBUG] Professions mapping loaded: 13 values mapped
[2026-01-03 05:43:14] [DEBUG] Building DSN connection string
[2026-01-03 05:43:14] [DEBUG] DSN: mysql:host=fcefrancxdck867a.mysql.db;port=3306;dbname=fcefrancxdck867a;charset=utf8
[2026-01-03 05:43:14] [DEBUG] Attempting PDO connection...
[2026-01-03 05:43:14] [DEBUG] PDO connection established successfully
[2026-01-03 05:43:14] [DEBUG] Setting charset to utf8
[2026-01-03 05:43:14] [DEBUG] Charset set successfully
[2026-01-03 05:43:14] [DEBUG] Checking if JSON file exists...
[2026-01-03 05:43:14] [DEBUG] JSON file found
[2026-01-03 05:43:14] [DEBUG] Reading JSON file contents...
[2026-01-03 05:43:14] [DEBUG] JSON file size: 62,303 bytes
[2026-01-03 05:43:14] [DEBUG] First 100 chars: [{
  "_id": {
    "$oid": "68bedc327bbf1f85db753648"
  },
  "fceId": 931885,
  "email": "nola.brauno
[2026-01-03 05:43:14] [DEBUG] Decoding JSON...
[2026-01-03 05:43:14] [DEBUG] JSON decoded
[2026-01-03 05:43:14] [DEBUG] JSON is valid
[2026-01-03 05:43:14] [DEBUG] Total users parsed: 28
[2026-01-03 05:43:14] [DEBUG] First user email: nola.braunogue@capifrance.fr
[2026-01-03 05:43:14] [DEBUG] Preparing INSERT statement...
[2026-01-03 05:43:14] [DEBUG] Preparing PDO statement...
[2026-01-03 05:43:14] [DEBUG] INSERT statement prepared successfully
[2026-01-03 05:43:14] [DEBUG] Preparing duplicate check statement...
[2026-01-03 05:43:14] [DEBUG] Duplicate check statement prepared
[2026-01-03 05:43:14] [DEBUG] Starting user processing loop
[2026-01-03 05:43:14] [DEBUG] Beginning database transaction
[2026-01-03 05:43:14] [DEBUG] Transaction started
[2026-01-03 05:43:14] [DEBUG] Processing user 1/28
[2026-01-03 05:43:14] [DEBUG] User email: nola.braunogue@capifrance.fr
[2026-01-03 05:43:14] [DEBUG] Checking if user exists: nola.braunogue@capifrance.fr
[2026-01-03 05:43:14] [DEBUG] User exists: Yes (ID: 7047)
[2026-01-03 05:43:14] [DEBUG] Processing user 2/28
[2026-01-03 05:43:14] [DEBUG] User email: gervaiscaroline@yahoo.com
[2026-01-03 05:43:14] [DEBUG] Checking if user exists: gervaiscaroline@yahoo.com
[2026-01-03 05:43:14] [DEBUG] User exists: Yes (ID: 7048)
[2026-01-03 05:43:14] [DEBUG] Processing user 3/28
[2026-01-03 05:43:14] [DEBUG] User email: labigourdane65@gmail.com
[2026-01-03 05:43:14] [DEBUG] Checking if user exists: labigourdane65@gmail.com
[2026-01-03 05:43:14] [DEBUG] User exists: Yes (ID: 7049)
[2026-01-03 05:43:14] [DEBUG] Processing user 4/28
[2026-01-03 05:43:14] [DEBUG] User email: vdevilledeperiere@agence.generali.fr
[2026-01-03 05:43:14] [DEBUG] Checking if user exists: vdevilledeperiere@agence.generali.fr
[2026-01-03 05:43:14] [DEBUG] User exists: Yes (ID: 7050)
[2026-01-03 05:43:14] [DEBUG] Processing user 5/28
[2026-01-03 05:43:14] [DEBUG] User email: angelina@exeko.ai
[2026-01-03 05:43:14] [DEBUG] Checking if user exists: angelina@exeko.ai
[2026-01-03 05:43:14] [DEBUG] User exists: Yes (ID: 7051)
[2026-01-03 05:43:14] [DEBUG] Processing user 6/28
[2026-01-03 05:43:14] [DEBUG] User email: laurence@respelida.fr
[2026-01-03 05:43:14] [DEBUG] Checking if user exists: laurence@respelida.fr
[2026-01-03 05:43:14] [DEBUG] User exists: Yes (ID: 7052)
[2026-01-03 05:43:14] [DEBUG] Processing user 7/28
[2026-01-03 05:43:14] [DEBUG] User email: contact@gothrough.fr
[2026-01-03 05:43:14] [DEBUG] Checking if user exists: contact@gothrough.fr
[2026-01-03 05:43:14] [DEBUG] User exists: Yes (ID: 7053)
[2026-01-03 05:43:14] [DEBUG] Processing user 8/28
[2026-01-03 05:43:14] [DEBUG] User email: malbroucka91@gmail.com
[2026-01-03 05:43:14] [DEBUG] Checking if user exists: malbroucka91@gmail.com
[2026-01-03 05:43:14] [DEBUG] User exists: Yes (ID: 7054)
[2026-01-03 05:43:14] [DEBUG] Processing user 9/28
[2026-01-03 05:43:14] [DEBUG] User email: lairderiendeco@icloud.com
[2026-01-03 05:43:14] [DEBUG] Checking if user exists: lairderiendeco@icloud.com
[2026-01-03 05:43:14] [DEBUG] User exists: Yes (ID: 7055)
[2026-01-03 05:43:14] [DEBUG] Processing user 10/28
[2026-01-03 05:43:14] [DEBUG] User email: fhdanne@gmail.com
[2026-01-03 05:43:14] [DEBUG] Checking if user exists: fhdanne@gmail.com
[2026-01-03 05:43:14] [DEBUG] User exists: Yes (ID: 7056)
[2026-01-03 05:43:14] [DEBUG] Processing user 11/28
[2026-01-03 05:43:14] [DEBUG] User email: juliederoquefeuil@hotmail.com
[2026-01-03 05:43:14] [DEBUG] Checking if user exists: juliederoquefeuil@hotmail.com
[2026-01-03 05:43:14] [DEBUG] User exists: Yes (ID: 7057)
[2026-01-03 05:43:14] [DEBUG] Processing user 12/28
[2026-01-03 05:43:14] [DEBUG] User email: mbetton@conservateur-conseil.fr
[2026-01-03 05:43:14] [DEBUG] Checking if user exists: mbetton@conservateur-conseil.fr
[2026-01-03 05:43:14] [DEBUG] User exists: Yes (ID: 6974)
[2026-01-03 05:43:14] [DEBUG] Processing user 13/28
[2026-01-03 05:43:14] [DEBUG] User email: clementine.raymond@pepites-studio.com
[2026-01-03 05:43:14] [DEBUG] Checking if user exists: clementine.raymond@pepites-studio.com
[2026-01-03 05:43:14] [DEBUG] User exists: Yes (ID: 6454)
[2026-01-03 05:43:14] [DEBUG] Processing user 14/28
[2026-01-03 05:43:14] [DEBUG] User email: leonie.suau@courtage-conseils.fr
[2026-01-03 05:43:14] [DEBUG] Checking if user exists: leonie.suau@courtage-conseils.fr
[2026-01-03 05:43:14] [DEBUG] User exists: Yes (ID: 7058)
[2026-01-03 05:43:14] [DEBUG] Processing user 15/28
[2026-01-03 05:43:14] [DEBUG] User email: delphine.audenard@avocat.fr
[2026-01-03 05:43:14] [DEBUG] Checking if user exists: delphine.audenard@avocat.fr
[2026-01-03 05:43:14] [DEBUG] User exists: Yes (ID: 7059)
[2026-01-03 05:43:14] [DEBUG] Processing user 16/28
[2026-01-03 05:43:14] [DEBUG] User email: mfi@afexios-provence.com
[2026-01-03 05:43:14] [DEBUG] Checking if user exists: mfi@afexios-provence.com
[2026-01-03 05:43:14] [DEBUG] User exists: Yes (ID: 6893)
[2026-01-03 05:43:14] [DEBUG] Processing user 17/28
[2026-01-03 05:43:14] [DEBUG] User email: hubert.christine1@gmail.com
[2026-01-03 05:43:14] [DEBUG] Checking if user exists: hubert.christine1@gmail.com
[2026-01-03 05:43:14] [DEBUG] User exists: Yes (ID: 7060)
[2026-01-03 05:43:14] [DEBUG] Processing user 18/28
[2026-01-03 05:43:14] [DEBUG] User email: audreyhillebrand@gmail.com
[2026-01-03 05:43:14] [DEBUG] Checking if user exists: audreyhillebrand@gmail.com
[2026-01-03 05:43:14] [DEBUG] User exists: Yes (ID: 7061)
[2026-01-03 05:43:14] [DEBUG] Processing user 19/28
[2026-01-03 05:43:14] [DEBUG] User email: juliette@semawe.fr
[2026-01-03 05:43:14] [DEBUG] Checking if user exists: juliette@semawe.fr
[2026-01-03 05:43:14] [DEBUG] User exists: Yes (ID: 7062)
[2026-01-03 05:43:14] [DEBUG] Processing user 20/28
[2026-01-03 05:43:14] [DEBUG] User email: colombosandra@orange.fr
[2026-01-03 05:43:14] [DEBUG] Checking if user exists: colombosandra@orange.fr
[2026-01-03 05:43:14] [DEBUG] User exists: Yes (ID: 7063)
[2026-01-03 05:43:14] [DEBUG] Processing user 21/28
[2026-01-03 05:43:14] [DEBUG] User email: anais.vimbaye@gmail.com
[2026-01-03 05:43:14] [DEBUG] Checking if user exists: anais.vimbaye@gmail.com
[2026-01-03 05:43:14] [DEBUG] User exists: Yes (ID: 7064)
[2026-01-03 05:43:14] [DEBUG] Processing user 22/28
[2026-01-03 05:43:14] [DEBUG] User email: arginthe.regina@gmail.com
[2026-01-03 05:43:14] [DEBUG] Checking if user exists: arginthe.regina@gmail.com
[2026-01-03 05:43:14] [DEBUG] User exists: Yes (ID: 7065)
[2026-01-03 05:43:14] [DEBUG] Processing user 23/28
[2026-01-03 05:43:14] [DEBUG] User email: laure.daragnes@gmail.com
[2026-01-03 05:43:14] [DEBUG] Checking if user exists: laure.daragnes@gmail.com
[2026-01-03 05:43:14] [DEBUG] User exists: Yes (ID: 7066)
[2026-01-03 05:43:14] [DEBUG] Processing user 24/28
[2026-01-03 05:43:14] [DEBUG] User email: djeya.enc@gmail.com
[2026-01-03 05:43:14] [DEBUG] Checking if user exists: djeya.enc@gmail.com
[2026-01-03 05:43:14] [DEBUG] User exists: Yes (ID: 7067)
[2026-01-03 05:43:14] [DEBUG] Processing user 25/28
[2026-01-03 05:43:14] [DEBUG] User email: soyadabeysang@yahoo.fr
[2026-01-03 05:43:14] [DEBUG] Checking if user exists: soyadabeysang@yahoo.fr
[2026-01-03 05:43:14] [DEBUG] User exists: Yes (ID: 7068)
[2026-01-03 05:43:14] [DEBUG] Processing user 26/28
[2026-01-03 05:43:14] [DEBUG] User email: vmeozzi@aimeozzi.fr
[2026-01-03 05:43:14] [DEBUG] Checking if user exists: vmeozzi@aimeozzi.fr
[2026-01-03 05:43:14] [DEBUG] User exists: Yes (ID: 7069)
[2026-01-03 05:43:14] [DEBUG] Processing user 27/28
[2026-01-03 05:43:14] [DEBUG] User email: cindy@ardea-digital.fr
[2026-01-03 05:43:14] [DEBUG] Checking if user exists: cindy@ardea-digital.fr
[2026-01-03 05:43:14] [DEBUG] User exists: Yes (ID: 7070)
[2026-01-03 05:43:14] [DEBUG] Processing user 28/28
[2026-01-03 05:43:14] [DEBUG] User email: solene@instant-exception.com
[2026-01-03 05:43:14] [DEBUG] Checking if user exists: solene@instant-exception.com
[2026-01-03 05:43:14] [DEBUG] User exists: Yes (ID: 7071)
[2026-01-03 05:43:14] [DEBUG] Processing complete, committing final batch
[2026-01-03 05:43:14] [DEBUG] No pending users to commit
[2026-01-03 05:43:14] [DEBUG] ID mapping contains 28 entries
[2026-01-03 05:43:14] [DEBUG] Mapping file: /home/fcefrancxd/www/scratch/user_id_mapping.json
[2026-01-03 05:43:14] [DEBUG] JSON mapping size: 5,369 bytes
[2026-01-03 05:43:14] [DEBUG] ID mapping saved successfully (5369 bytes written)
[2026-01-03 05:43:14] [DEBUG] Import process completed
[2026-01-03 05:43:14] [DEBUG] Total duration: 0.22 seconds
[2026-01-03 05:43:14] [DEBUG] Average time per user: 0.008 seconds
[2026-01-03 05:43:14] [DEBUG] Import completed successfully with no errors