[Données entreprises] Corriger l'import historique

[emilschn]

Problème de date lors de l'import https://github.com/MTES-MCT/stop-punaises/issues/753

[hmeneuvrier]

avant le premier fichier : mysql> SELECT COUNT(id) FROM signalement WHERE created_at LIKE '2024-06-14%'; +-----------+ | COUNT(id) | +-----------+ | 6482 | +-----------+

fichier 00 - signalements 0-A.csv :
[OK] 1701 signalement(s) have been fixed, 0 signalement(s) have not beeen found, 0 signalement(s) have NOT been fixed mysql> SELECT COUNT(id) FROM signalement WHERE created_at LIKE '2024-06-14%'; +-----------+ | COUNT(id) | +-----------+ | 5140 | +-----------+ 1 row in set (0.04 sec)

fichier 00 - signalements B-ELIS.csv:
[OK] 1635 signalement(s) have been fixed, 0 signalement(s) have not beeen found, 0 signalement(s) have NOT been fixed SELECT COUNT(id) FROM signalement WHERE created_at LIKE '2024-06-14%'; +-----------+ | COUNT(id) | +-----------+ | 3659 | +-----------+

fichier 00 - signalements M-Z 1.csv :
[OK] 0 signalement(s) have been fixed, 0 signalement(s) have not beeen found, 1299 signalement(s) have NOT been fixed SELECT COUNT(id) FROM signalement WHERE created_at LIKE '2024-06-14%'; +-----------+ | COUNT(id) | +-----------+ | 3659 | +-----------+

fichier 00 - signalements M-Z 2.csv :
[OK] 0 signalement(s) have been fixed, 0 signalement(s) have not beeen found, 632 signalement(s) have NOT been fixed SELECT COUNT(id) FROM signalement WHERE created_at LIKE '2024-06-14%'; +-----------+ | COUNT(id) | +-----------+ | 3659 | +-----------+

fichier 00 - Regroupement pour import - ENT-L.csv : [OK] 961 signalement(s) have been fixed, 313 signalement(s) have not beeen found, 66 signalement(s) have NOT been fixed SELECT COUNT(id) FROM signalement WHERE created_at LIKE '2024-06-14%'; +-----------+ | COUNT(id) | +-----------+ | 2906 | +-----------+ 1 row in set (0.04 sec)

Nouvelle tentative fichier 00 - signalements M-Z 1.csv :
[OK] 1297 signalement(s) have been fixed, 0 signalement(s) have not been found, 2 signalement(s) have NOT been fixed SELECT COUNT(id) FROM signalement WHERE created_at LIKE '2024-06-14%'; +-----------+ | COUNT(id) | +-----------+ | 1705 | +-----------+

Nouvelle tentative fichier 00 - signalements M-Z 2.csv : [OK] 632 signalement(s) have been fixed, 0 signalement(s) have not been found, 0 signalement(s) have NOT been fixed SELECT COUNT(id) FROM signalement WHERE created_at LIKE '2024-06-14%'; +-----------+ | COUNT(id) | +-----------+ | 1120 | +-----------+ 1 row in set (0.12 sec)

Nouvelle tentative fichier 00 - Regroupement pour import - ENT-L.csv : [OK] 1017 signalement(s) have been fixed, 191 signalement(s) have not been found, 0 signalement(s) have NOT been fixed SELECT COUNT(id) FROM signalement WHERE created_at LIKE '2024-06-14%'; +-----------+ | COUNT(id) | +-----------+ | 1075 | +-----------+