[2026-01-11 01:23:41] [DEBUG] Loading configuration from config.php [2026-01-11 01:23:42] [DEBUG] Configuration loaded successfully [2026-01-11 01:23:42] [DEBUG] Database host: fcefrancxdck867a.mysql.db:3306 [2026-01-11 01:23:42] [DEBUG] Database name: fcefrancxdck867a [2026-01-11 01:23:42] [DEBUG] Database user: fcefrancxdck867a [2026-01-11 01:23:42] [DEBUG] Input file: /home/fcefrancxd/www/scratch/fce_27.users.json [2026-01-11 01:23:42] [DEBUG] Batch size: 100 [2026-01-11 01:23:42] [DEBUG] Skip duplicates: Yes [2026-01-11 01:23:42] [DEBUG] Verbose mode: Yes [2026-01-11 01:23:42] [DEBUG] PHP Version: 5.6.40 [2026-01-11 01:23:42] [DEBUG] Script start time: 2026-01-11 01:23:42 [2026-01-11 01:23:42] [DEBUG] Loading delegation mapping from delegation_mapping.json [2026-01-11 01:23:42] [DEBUG] Delegation mapping loaded: 65 delegations mapped [2026-01-11 01:23:42] [DEBUG] Loading sector mapping from sector_mapping.json [2026-01-11 01:23:42] [DEBUG] Sector mapping loaded: 21 sectors mapped [2026-01-11 01:23:42] [DEBUG] Loading sector to activiteparent mapping from sector_to_activiteparent_mapping.json [2026-01-11 01:23:42] [DEBUG] Sector to activiteparent mapping loaded: 21 sectors mapped [2026-01-11 01:23:42] [DEBUG] Loading employees mapping from employees_mapping.json [2026-01-11 01:23:42] [DEBUG] Employees mapping loaded: 10 values mapped [2026-01-11 01:23:42] [DEBUG] Loading revenue mapping from revenue_mapping.json [2026-01-11 01:23:42] [DEBUG] Revenue mapping loaded: 9 values mapped [2026-01-11 01:23:42] [DEBUG] Loading professions mapping from professions_mapping.json [2026-01-11 01:23:42] [DEBUG] Professions mapping loaded: 13 values mapped === MongoDB to MySQL User Import === Connecting to database... [2026-01-11 01:23:42] [DEBUG] Building DSN connection string [2026-01-11 01:23:42] [DEBUG] DSN: mysql:host=fcefrancxdck867a.mysql.db;port=3306;dbname=fcefrancxdck867a;charset=utf8 [2026-01-11 01:23:42] [DEBUG] Attempting PDO connection... [2026-01-11 01:23:42] [DEBUG] PDO connection established successfully [2026-01-11 01:23:42] [DEBUG] Setting charset to utf8 [2026-01-11 01:23:42] [DEBUG] Charset set successfully [OK] Connected to database Reading JSON file: /home/fcefrancxd/www/scratch/fce_27.users.json [2026-01-11 01:23:42] [DEBUG] Checking if JSON file exists... [2026-01-11 01:23:42] [DEBUG] JSON file found [2026-01-11 01:23:42] [DEBUG] Reading JSON file contents... [2026-01-11 01:23:42] [DEBUG] JSON file size: 62,303 bytes [2026-01-11 01:23:42] [DEBUG] First 100 chars: [{ "_id": { "$oid": "68bedc327bbf1f85db753648" }, "fceId": 931885, "email": "nola.brauno [2026-01-11 01:23:42] [DEBUG] Decoding JSON... [2026-01-11 01:23:42] [DEBUG] JSON decoded [2026-01-11 01:23:42] [DEBUG] JSON is valid [2026-01-11 01:23:42] [DEBUG] Total users parsed: 28 [2026-01-11 01:23:42] [DEBUG] First user email: nola.braunogue@capifrance.fr [OK] Loaded 28 users from JSON [2026-01-11 01:23:42] [DEBUG] Preparing INSERT statement... [2026-01-11 01:23:42] [DEBUG] Preparing PDO statement... [2026-01-11 01:23:42] [DEBUG] INSERT statement prepared successfully [2026-01-11 01:23:42] [DEBUG] Preparing duplicate check statement... [2026-01-11 01:23:42] [DEBUG] Duplicate check statement prepared Processing users... [2026-01-11 01:23:42] [DEBUG] Starting user processing loop [2026-01-11 01:23:42] [DEBUG] Beginning database transaction [2026-01-11 01:23:42] [DEBUG] Transaction started [2026-01-11 01:23:42] [DEBUG] Processing user 1/28 [2026-01-11 01:23:42] [DEBUG] User email: nola.braunogue@capifrance.fr [2026-01-11 01:23:42] [DEBUG] Checking if user exists: nola.braunogue@capifrance.fr [2026-01-11 01:23:42] [DEBUG] User exists: Yes (ID: 7047) [SKIP] Skipped (exists): nola.braunogue@capifrance.fr [2026-01-11 01:23:42] [DEBUG] Processing user 2/28 [2026-01-11 01:23:42] [DEBUG] User email: gervaiscaroline@yahoo.com [2026-01-11 01:23:42] [DEBUG] Checking if user exists: gervaiscaroline@yahoo.com [2026-01-11 01:23:42] [DEBUG] User exists: Yes (ID: 7048) [SKIP] Skipped (exists): gervaiscaroline@yahoo.com [2026-01-11 01:23:42] [DEBUG] Processing user 3/28 [2026-01-11 01:23:42] [DEBUG] User email: labigourdane65@gmail.com [2026-01-11 01:23:42] [DEBUG] Checking if user exists: labigourdane65@gmail.com [2026-01-11 01:23:42] [DEBUG] User exists: Yes (ID: 7049) [SKIP] Skipped (exists): labigourdane65@gmail.com [2026-01-11 01:23:42] [DEBUG] Processing user 4/28 [2026-01-11 01:23:42] [DEBUG] User email: vdevilledeperiere@agence.generali.fr [2026-01-11 01:23:42] [DEBUG] Checking if user exists: vdevilledeperiere@agence.generali.fr [2026-01-11 01:23:42] [DEBUG] User exists: Yes (ID: 7050) [SKIP] Skipped (exists): vdevilledeperiere@agence.generali.fr [2026-01-11 01:23:42] [DEBUG] Processing user 5/28 [2026-01-11 01:23:42] [DEBUG] User email: angelina@exeko.ai [2026-01-11 01:23:42] [DEBUG] Checking if user exists: angelina@exeko.ai [2026-01-11 01:23:42] [DEBUG] User exists: Yes (ID: 7051) [SKIP] Skipped (exists): angelina@exeko.ai [2026-01-11 01:23:42] [DEBUG] Processing user 6/28 [2026-01-11 01:23:42] [DEBUG] User email: laurence@respelida.fr [2026-01-11 01:23:42] [DEBUG] Checking if user exists: laurence@respelida.fr [2026-01-11 01:23:42] [DEBUG] User exists: Yes (ID: 7052) [SKIP] Skipped (exists): laurence@respelida.fr [2026-01-11 01:23:42] [DEBUG] Processing user 7/28 [2026-01-11 01:23:42] [DEBUG] User email: contact@gothrough.fr [2026-01-11 01:23:42] [DEBUG] Checking if user exists: contact@gothrough.fr [2026-01-11 01:23:42] [DEBUG] User exists: Yes (ID: 7053) [SKIP] Skipped (exists): contact@gothrough.fr [2026-01-11 01:23:42] [DEBUG] Processing user 8/28 [2026-01-11 01:23:42] [DEBUG] User email: malbroucka91@gmail.com [2026-01-11 01:23:42] [DEBUG] Checking if user exists: malbroucka91@gmail.com [2026-01-11 01:23:42] [DEBUG] User exists: Yes (ID: 7054) [SKIP] Skipped (exists): malbroucka91@gmail.com [2026-01-11 01:23:42] [DEBUG] Processing user 9/28 [2026-01-11 01:23:42] [DEBUG] User email: lairderiendeco@icloud.com [2026-01-11 01:23:42] [DEBUG] Checking if user exists: lairderiendeco@icloud.com [2026-01-11 01:23:42] [DEBUG] User exists: Yes (ID: 7055) [SKIP] Skipped (exists): lairderiendeco@icloud.com [2026-01-11 01:23:42] [DEBUG] Processing user 10/28 [2026-01-11 01:23:42] [DEBUG] User email: fhdanne@gmail.com [2026-01-11 01:23:42] [DEBUG] Checking if user exists: fhdanne@gmail.com [2026-01-11 01:23:42] [DEBUG] User exists: Yes (ID: 7056) [SKIP] Skipped (exists): fhdanne@gmail.com [2026-01-11 01:23:42] [DEBUG] Processing user 11/28 [2026-01-11 01:23:42] [DEBUG] User email: juliederoquefeuil@hotmail.com [2026-01-11 01:23:42] [DEBUG] Checking if user exists: juliederoquefeuil@hotmail.com [2026-01-11 01:23:42] [DEBUG] User exists: Yes (ID: 7057) [SKIP] Skipped (exists): juliederoquefeuil@hotmail.com [2026-01-11 01:23:42] [DEBUG] Processing user 12/28 [2026-01-11 01:23:42] [DEBUG] User email: mbetton@conservateur-conseil.fr [2026-01-11 01:23:42] [DEBUG] Checking if user exists: mbetton@conservateur-conseil.fr [2026-01-11 01:23:42] [DEBUG] User exists: Yes (ID: 6974) [SKIP] Skipped (exists): mbetton@conservateur-conseil.fr [2026-01-11 01:23:42] [DEBUG] Processing user 13/28 [2026-01-11 01:23:42] [DEBUG] User email: clementine.raymond@pepites-studio.com [2026-01-11 01:23:42] [DEBUG] Checking if user exists: clementine.raymond@pepites-studio.com [2026-01-11 01:23:42] [DEBUG] User exists: Yes (ID: 6454) [SKIP] Skipped (exists): clementine.raymond@pepites-studio.com [2026-01-11 01:23:42] [DEBUG] Processing user 14/28 [2026-01-11 01:23:42] [DEBUG] User email: leonie.suau@courtage-conseils.fr [2026-01-11 01:23:42] [DEBUG] Checking if user exists: leonie.suau@courtage-conseils.fr [2026-01-11 01:23:42] [DEBUG] User exists: Yes (ID: 7058) [SKIP] Skipped (exists): leonie.suau@courtage-conseils.fr [2026-01-11 01:23:42] [DEBUG] Processing user 15/28 [2026-01-11 01:23:42] [DEBUG] User email: delphine.audenard@avocat.fr [2026-01-11 01:23:42] [DEBUG] Checking if user exists: delphine.audenard@avocat.fr [2026-01-11 01:23:42] [DEBUG] User exists: Yes (ID: 7059) [SKIP] Skipped (exists): delphine.audenard@avocat.fr [2026-01-11 01:23:42] [DEBUG] Processing user 16/28 [2026-01-11 01:23:42] [DEBUG] User email: mfi@afexios-provence.com [2026-01-11 01:23:42] [DEBUG] Checking if user exists: mfi@afexios-provence.com [2026-01-11 01:23:42] [DEBUG] User exists: Yes (ID: 6893) [SKIP] Skipped (exists): mfi@afexios-provence.com [2026-01-11 01:23:42] [DEBUG] Processing user 17/28 [2026-01-11 01:23:42] [DEBUG] User email: hubert.christine1@gmail.com [2026-01-11 01:23:42] [DEBUG] Checking if user exists: hubert.christine1@gmail.com [2026-01-11 01:23:42] [DEBUG] User exists: Yes (ID: 7060) [SKIP] Skipped (exists): hubert.christine1@gmail.com [2026-01-11 01:23:42] [DEBUG] Processing user 18/28 [2026-01-11 01:23:42] [DEBUG] User email: audreyhillebrand@gmail.com [2026-01-11 01:23:42] [DEBUG] Checking if user exists: audreyhillebrand@gmail.com [2026-01-11 01:23:42] [DEBUG] User exists: Yes (ID: 7061) [SKIP] Skipped (exists): audreyhillebrand@gmail.com [2026-01-11 01:23:42] [DEBUG] Processing user 19/28 [2026-01-11 01:23:42] [DEBUG] User email: juliette@semawe.fr [2026-01-11 01:23:42] [DEBUG] Checking if user exists: juliette@semawe.fr [2026-01-11 01:23:42] [DEBUG] User exists: Yes (ID: 7062) [SKIP] Skipped (exists): juliette@semawe.fr [2026-01-11 01:23:42] [DEBUG] Processing user 20/28 [2026-01-11 01:23:42] [DEBUG] User email: colombosandra@orange.fr [2026-01-11 01:23:42] [DEBUG] Checking if user exists: colombosandra@orange.fr [2026-01-11 01:23:42] [DEBUG] User exists: Yes (ID: 7063) [SKIP] Skipped (exists): colombosandra@orange.fr [2026-01-11 01:23:42] [DEBUG] Processing user 21/28 [2026-01-11 01:23:42] [DEBUG] User email: anais.vimbaye@gmail.com [2026-01-11 01:23:42] [DEBUG] Checking if user exists: anais.vimbaye@gmail.com [2026-01-11 01:23:42] [DEBUG] User exists: Yes (ID: 7064) [SKIP] Skipped (exists): anais.vimbaye@gmail.com [2026-01-11 01:23:42] [DEBUG] Processing user 22/28 [2026-01-11 01:23:42] [DEBUG] User email: arginthe.regina@gmail.com [2026-01-11 01:23:42] [DEBUG] Checking if user exists: arginthe.regina@gmail.com [2026-01-11 01:23:42] [DEBUG] User exists: Yes (ID: 7065) [SKIP] Skipped (exists): arginthe.regina@gmail.com [2026-01-11 01:23:42] [DEBUG] Processing user 23/28 [2026-01-11 01:23:42] [DEBUG] User email: laure.daragnes@gmail.com [2026-01-11 01:23:42] [DEBUG] Checking if user exists: laure.daragnes@gmail.com [2026-01-11 01:23:42] [DEBUG] User exists: Yes (ID: 7066) [SKIP] Skipped (exists): laure.daragnes@gmail.com [2026-01-11 01:23:42] [DEBUG] Processing user 24/28 [2026-01-11 01:23:42] [DEBUG] User email: djeya.enc@gmail.com [2026-01-11 01:23:42] [DEBUG] Checking if user exists: djeya.enc@gmail.com [2026-01-11 01:23:42] [DEBUG] User exists: Yes (ID: 7067) [SKIP] Skipped (exists): djeya.enc@gmail.com [2026-01-11 01:23:42] [DEBUG] Processing user 25/28 [2026-01-11 01:23:42] [DEBUG] User email: soyadabeysang@yahoo.fr [2026-01-11 01:23:42] [DEBUG] Checking if user exists: soyadabeysang@yahoo.fr [2026-01-11 01:23:42] [DEBUG] User exists: Yes (ID: 7068) [SKIP] Skipped (exists): soyadabeysang@yahoo.fr [2026-01-11 01:23:42] [DEBUG] Processing user 26/28 [2026-01-11 01:23:42] [DEBUG] User email: vmeozzi@aimeozzi.fr [2026-01-11 01:23:42] [DEBUG] Checking if user exists: vmeozzi@aimeozzi.fr [2026-01-11 01:23:42] [DEBUG] User exists: Yes (ID: 7069) [SKIP] Skipped (exists): vmeozzi@aimeozzi.fr [2026-01-11 01:23:42] [DEBUG] Processing user 27/28 [2026-01-11 01:23:42] [DEBUG] User email: cindy@ardea-digital.fr [2026-01-11 01:23:42] [DEBUG] Checking if user exists: cindy@ardea-digital.fr [2026-01-11 01:23:42] [DEBUG] User exists: Yes (ID: 7070) [SKIP] Skipped (exists): cindy@ardea-digital.fr [2026-01-11 01:23:42] [DEBUG] Processing user 28/28 [2026-01-11 01:23:42] [DEBUG] User email: solene@instant-exception.com [2026-01-11 01:23:42] [DEBUG] Checking if user exists: solene@instant-exception.com [2026-01-11 01:23:42] [DEBUG] User exists: Yes (ID: 7071) [SKIP] Skipped (exists): solene@instant-exception.com [2026-01-11 01:23:42] [DEBUG] Processing complete, committing final batch [2026-01-11 01:23:42] [DEBUG] No pending users to commit Saving ID mapping... [2026-01-11 01:23:42] [DEBUG] ID mapping contains 28 entries [2026-01-11 01:23:42] [DEBUG] Mapping file: /home/fcefrancxd/www/scratch/user_id_mapping.json [2026-01-11 01:23:42] [DEBUG] JSON mapping size: 5,369 bytes [2026-01-11 01:23:42] [DEBUG] ID mapping saved successfully (5369 bytes written) [OK] ID mapping saved to: /home/fcefrancxd/www/scratch/user_id_mapping.json [2026-01-11 01:23:42] [DEBUG] Import process completed [2026-01-11 01:23:42] [DEBUG] Total duration: 0.15 seconds [2026-01-11 01:23:42] [DEBUG] Average time per user: 0.005 seconds === Import Complete === Total users: 28 Inserted: 0 Skipped: 28 Errors: 0 Duration: 0.15s [2026-01-11 01:23:42] [DEBUG] Import completed successfully with no errors