chill-import-from-canvas

champs-libres/chill-import-from-canvas

Fork 0

8a9966d84c Suppression des fichiers README et script d'importation des tiers feat-add-cork-social-actions Boris Waaub 2026-03-16 13:55:17 +01:00
ced84f50c2 Ajout d'un fichier de paramétrage Excel pour l'importation des données Boris Waaub 2026-03-16 13:52:50 +01:00
04d1e35ba4 Ajout de la procédure automatisée pour l'importation des données et mise à jour des instructions dans le README Boris Waaub 2026-03-16 13:50:06 +01:00
c388967ebd feat: Enhance CSV import process and data cleanup Boris Waaub 2026-03-16 13:48:12 +01:00
8481acfe5d Ajout du fichier d'exemple de configuration pour la base de données PostgreSQL Boris Waaub 2026-03-14 10:50:17 +01:00
5a90126f98 Ajout de la gestion des actions sociales dans l'importation des données et correction des colonnes dans les fichiers CSV Boris Waaub 2026-03-14 10:50:10 +01:00
45755bf797 Correction of finding postcode + set the center postcode as coordinates for address without reference master juminet 2025-09-16 13:41:48 +02:00
08e87503f0 Correction: do not attribute center_id = 1 to person juminet 2025-09-16 10:52:37 +02:00
20517a109b Improved person import with the linkage to reference addresses juminet 2025-09-02 12:42:29 +02:00
c17b2ae524 FIXED import person with the new gender entity juminet 2025-09-02 11:03:35 +02:00
5bfc7f4a02 Small typos in import.sql juminet 2025-08-29 13:01:54 +02:00
6b8ca0caa3 Add sql for third party juminet 2025-08-14 18:14:13 +02:00
c5f892c27d FEATURE import users nobohan 2025-07-11 15:53:40 +02:00
82f69f9845 FEATURE add sql for import location_type and location nobohan 2025-07-11 11:48:24 +02:00
fd4e68faa8 FEATURE ajout reprise de localisations - prepare nobohan 2025-07-10 16:21:06 +02:00
3651b1a09b Improve/correct import SQL queries nobohan 2024-09-19 17:59:44 +02:00
db52c72d22 Add another method to prepare the import tables nobohan 2024-09-17 15:37:16 +02:00
9c90e5ac07 Add single python script for translating third party information into SQL nobohan 2024-02-16 09:48:07 +01:00
543a4569fd update script with resinam troubles Mathieu Jaumotte 2023-05-05 17:16:30 +02:00
36e3bf3b4b modifs mineures du canevas sur les headers (v0.6.1) Mathieu Jaumotte 2023-03-15 17:02:35 +01:00
ddfe9b53b3 Merge branch 'dev' Mathieu Jaumotte 2023-03-15 13:25:29 +01:00
cea5190174 update readme dev Mathieu Jaumotte 2023-03-15 11:55:06 +01:00
ca3ce608c0 Merge branch 'dev' Mathieu Jaumotte 2023-03-15 10:25:12 +01:00
f3bda2a22e add readme Mathieu Jaumotte 2023-03-15 10:24:39 +01:00
4e866c2d8e Merge branch 'dev' Mathieu Jaumotte 2023-03-14 12:21:17 +01:00
6b11efd18e add v0.6.0 of excel canvas Mathieu Jaumotte 2023-03-14 12:20:28 +01:00
290a9b917f Things to think when running script Mathieu Jaumotte 2023-03-14 12:05:52 +01:00
b68e0399cc 62-63. Add and link comments to periods, pin last comment Mathieu Jaumotte 2023-03-11 16:51:43 +01:00
07df6c4292 default value for socialissue_id, user_id, scope_id Mathieu Jaumotte 2023-03-11 16:50:11 +01:00
d9152fc090 60. Link jobs to periods Mathieu Jaumotte 2023-03-11 15:27:56 +01:00
12f0ec0ae4 59. Link origin to periods Mathieu Jaumotte 2023-03-11 14:08:56 +01:00
264fdb5888 58. Link scopes to periods Mathieu Jaumotte 2023-03-11 15:11:47 +01:00
7893eb3c81 57. Link referrer to periods Mathieu Jaumotte 2023-03-11 13:39:42 +01:00
1adf47e63e 56. Link socialissues to periods Mathieu Jaumotte 2023-03-11 10:49:57 +01:00
314e625c91 55. Copy period in period_location_history Mathieu Jaumotte 2023-03-10 19:58:25 +01:00
59daee4790 53-54. Link period to person or temporary address location Mathieu Jaumotte 2023-03-10 19:27:31 +01:00
6900d66206 52. Link participations to periods Mathieu Jaumotte 2023-03-10 18:32:09 +01:00
f513dd1b36 Add a setval() query after INSERT INTO when id is not nextval() Mathieu Jaumotte 2023-03-10 17:53:05 +01:00
67d020d322 50-51. Insert in accompanyingPeriods table Mathieu Jaumotte 2023-03-10 17:51:58 +01:00
477565f6e1 Improve undo delete clause to avoid removing still referenced rows Mathieu Jaumotte 2023-03-10 16:49:12 +01:00
e569d77bd2 Fix WHERE jsonb comparison Mathieu Jaumotte 2023-03-10 16:20:58 +01:00
0ab77b77ed improve setval id if remove all rows Mathieu Jaumotte 2023-03-10 16:18:51 +01:00
307cfcbe74 46. Add household composition Mathieu Jaumotte 2023-03-10 16:17:27 +01:00
081ce76085 renaming alias Mathieu Jaumotte 2023-03-10 16:16:27 +01:00
cadcddddb5 Improve date management for not specified dates Mathieu Jaumotte 2023-03-10 13:08:41 +01:00
dd3769e2a0 use validfrom in address insertion Mathieu Jaumotte 2023-03-10 12:55:53 +01:00
1cc1b83435 add gendercomment in person insertion Mathieu Jaumotte 2023-03-10 12:45:23 +01:00
9ac2553eb0 Fix phone numbers format Mathieu Jaumotte 2023-03-10 12:16:51 +01:00
0c7ea76178 42. Insert query bloc for center history insertion Mathieu Jaumotte 2023-03-08 23:44:39 +01:00
5f78276762 Rename aliases in undo queries Mathieu Jaumotte 2023-03-08 23:43:47 +01:00
5a6daae5a4 43-44. Insert household and link to person, address, position Mathieu Jaumotte 2023-03-08 21:06:33 +01:00
3978ee8b1a Fix WHERE jsonb comparison Mathieu Jaumotte 2023-03-08 21:05:06 +01:00
838bcb78ff 33-34 Fix phone format Mathieu Jaumotte 2023-03-08 21:04:09 +01:00
f3170d0c87 cleaning Mathieu Jaumotte 2023-03-08 17:49:13 +01:00
1a6f3953ca 42. Add address, and link it to person Mathieu Jaumotte 2023-03-01 21:20:19 +01:00
139dd6209a 33-34. Format phone numbers Mathieu Jaumotte 2023-03-01 20:57:25 +01:00
25510c1efe fix query for person insertion Mathieu Jaumotte 2023-03-01 19:17:09 +01:00
a36ee22be6 fix numberofchildren cast Mathieu Jaumotte 2023-03-01 17:34:47 +01:00
b6f26900a7 20-32. Prepare import personnes and periodes tables Mathieu Jaumotte 2023-02-19 14:58:11 +01:00
dd89aa6ff1 improve title comment block Mathieu Jaumotte 2023-02-17 19:42:14 +01:00
4dc09c559a fix setval with coalesce (reset id too if no rows) Mathieu Jaumotte 2023-02-17 17:29:12 +01:00
cb12f3000b 13. Complete chill_person_social_issue table Mathieu Jaumotte 2023-02-17 19:15:55 +01:00
e14f6896e3 12. complete users table (referrer) Mathieu Jaumotte 2023-02-17 17:53:54 +01:00
7b4f04ef40 11. complete scopes table Mathieu Jaumotte 2023-02-17 09:49:16 +01:00
6d64060965 10. complete chill_main_user_job table Mathieu Jaumotte 2023-02-16 19:42:34 +01:00
396444790f 9. complete chill_person_accompanying_period_origin table Mathieu Jaumotte 2023-02-17 09:43:37 +01:00
44d24155a1 8. complete chill_person_accompanying_period_closingmotive table Mathieu Jaumotte 2023-02-16 18:28:36 +01:00
32da5540fe 7. complete chill_person_household_position table Mathieu Jaumotte 2023-02-15 21:57:36 +01:00
de8450267d 6. complete chill_person_household_composition_type table Mathieu Jaumotte 2023-02-15 21:40:40 +01:00
27ef1034be 5. complete chill_person_marital_status table Mathieu Jaumotte 2023-02-15 21:28:13 +01:00
40ebabf3f6 4. complete country table Mathieu Jaumotte 2023-02-15 20:56:50 +01:00
9cd1f19f89 3. complete table chill_main_civility Mathieu Jaumotte 2023-02-15 20:21:26 +01:00
06b0aab237 2. prepare date columns Mathieu Jaumotte 2023-02-15 18:08:06 +01:00
f018a5d115 1. cast column id Mathieu Jaumotte 2023-02-15 17:54:26 +01:00
0d68d28448 add dist csv and rename sql folder Mathieu Jaumotte 2023-02-17 10:01:55 +01:00
610506a121 update gitignore Mathieu Jaumotte 2023-02-15 14:58:11 +01:00
8e478ac099 initial commit Mathieu Jaumotte 2023-02-15 14:56:04 +01:00

Commit Graph Select branches Hide Pull Requests dev feat-add-cork-social-actions master Mono Color

Commit Graph

Select branches

Hide Pull Requests

dev

feat-add-cork-social-actions

master