chill-import-from-canvas

champs-libres/chill-import-from-canvas

Fork 0

3651b1a09b Improve/correct import SQL queries master nobohan 2024-09-19 17:59:44 +0200
db52c72d22 Add another method to prepare the import tables nobohan 2024-09-17 15:37:16 +0200
9c90e5ac07 Add single python script for translating third party information into SQL nobohan 2024-02-16 09:48:07 +0100
543a4569fd update script with resinam troubles Mathieu Jaumotte 2023-05-05 17:16:30 +0200
36e3bf3b4b modifs mineures du canevas sur les headers (v0.6.1) Mathieu Jaumotte 2023-03-15 17:02:35 +0100
ddfe9b53b3 Merge branch 'dev' Mathieu Jaumotte 2023-03-15 13:25:29 +0100
cea5190174 update readme dev Mathieu Jaumotte 2023-03-15 11:55:06 +0100
ca3ce608c0 Merge branch 'dev' Mathieu Jaumotte 2023-03-15 10:25:12 +0100
f3bda2a22e add readme Mathieu Jaumotte 2023-03-15 10:24:39 +0100
4e866c2d8e Merge branch 'dev' Mathieu Jaumotte 2023-03-14 12:21:17 +0100
6b11efd18e add v0.6.0 of excel canvas Mathieu Jaumotte 2023-03-14 12:20:28 +0100
290a9b917f Things to think when running script Mathieu Jaumotte 2023-03-14 12:05:52 +0100
b68e0399cc 62-63. Add and link comments to periods, pin last comment Mathieu Jaumotte 2023-03-11 16:51:43 +0100
07df6c4292 default value for socialissue_id, user_id, scope_id Mathieu Jaumotte 2023-03-11 16:50:11 +0100
d9152fc090 60. Link jobs to periods Mathieu Jaumotte 2023-03-11 15:27:56 +0100
12f0ec0ae4 59. Link origin to periods Mathieu Jaumotte 2023-03-11 14:08:56 +0100
264fdb5888 58. Link scopes to periods Mathieu Jaumotte 2023-03-11 15:11:47 +0100
7893eb3c81 57. Link referrer to periods Mathieu Jaumotte 2023-03-11 13:39:42 +0100
1adf47e63e 56. Link socialissues to periods Mathieu Jaumotte 2023-03-11 10:49:57 +0100
314e625c91 55. Copy period in period_location_history Mathieu Jaumotte 2023-03-10 19:58:25 +0100
59daee4790 53-54. Link period to person or temporary address location Mathieu Jaumotte 2023-03-10 19:27:31 +0100
6900d66206 52. Link participations to periods Mathieu Jaumotte 2023-03-10 18:32:09 +0100
f513dd1b36 Add a setval() query after INSERT INTO when id is not nextval() Mathieu Jaumotte 2023-03-10 17:53:05 +0100
67d020d322 50-51. Insert in accompanyingPeriods table Mathieu Jaumotte 2023-03-10 17:51:58 +0100
477565f6e1 Improve undo delete clause to avoid removing still referenced rows Mathieu Jaumotte 2023-03-10 16:49:12 +0100
e569d77bd2 Fix WHERE jsonb comparison Mathieu Jaumotte 2023-03-10 16:20:58 +0100
0ab77b77ed improve setval id if remove all rows Mathieu Jaumotte 2023-03-10 16:18:51 +0100
307cfcbe74 46. Add household composition Mathieu Jaumotte 2023-03-10 16:17:27 +0100
081ce76085 renaming alias Mathieu Jaumotte 2023-03-10 16:16:27 +0100
cadcddddb5 Improve date management for not specified dates Mathieu Jaumotte 2023-03-10 13:08:41 +0100
dd3769e2a0 use validfrom in address insertion Mathieu Jaumotte 2023-03-10 12:55:53 +0100
1cc1b83435 add gendercomment in person insertion Mathieu Jaumotte 2023-03-10 12:45:23 +0100
9ac2553eb0 Fix phone numbers format Mathieu Jaumotte 2023-03-10 12:16:51 +0100
0c7ea76178 42. Insert query bloc for center history insertion Mathieu Jaumotte 2023-03-08 23:44:39 +0100
5f78276762 Rename aliases in undo queries Mathieu Jaumotte 2023-03-08 23:43:47 +0100
5a6daae5a4 43-44. Insert household and link to person, address, position Mathieu Jaumotte 2023-03-08 21:06:33 +0100
3978ee8b1a Fix WHERE jsonb comparison Mathieu Jaumotte 2023-03-08 21:05:06 +0100
838bcb78ff 33-34 Fix phone format Mathieu Jaumotte 2023-03-08 21:04:09 +0100
f3170d0c87 cleaning Mathieu Jaumotte 2023-03-08 17:49:13 +0100
1a6f3953ca 42. Add address, and link it to person Mathieu Jaumotte 2023-03-01 21:20:19 +0100
139dd6209a 33-34. Format phone numbers Mathieu Jaumotte 2023-03-01 20:57:25 +0100
25510c1efe fix query for person insertion Mathieu Jaumotte 2023-03-01 19:17:09 +0100
a36ee22be6 fix numberofchildren cast Mathieu Jaumotte 2023-03-01 17:34:47 +0100
b6f26900a7 20-32. Prepare import personnes and periodes tables Mathieu Jaumotte 2023-02-19 14:58:11 +0100
dd89aa6ff1 improve title comment block Mathieu Jaumotte 2023-02-17 19:42:14 +0100
4dc09c559a fix setval with coalesce (reset id too if no rows) Mathieu Jaumotte 2023-02-17 17:29:12 +0100
cb12f3000b 13. Complete chill_person_social_issue table Mathieu Jaumotte 2023-02-17 19:15:55 +0100
e14f6896e3 12. complete users table (referrer) Mathieu Jaumotte 2023-02-17 17:53:54 +0100
7b4f04ef40 11. complete scopes table Mathieu Jaumotte 2023-02-17 09:49:16 +0100
6d64060965 10. complete chill_main_user_job table Mathieu Jaumotte 2023-02-16 19:42:34 +0100
396444790f 9. complete chill_person_accompanying_period_origin table Mathieu Jaumotte 2023-02-17 09:43:37 +0100
44d24155a1 8. complete chill_person_accompanying_period_closingmotive table Mathieu Jaumotte 2023-02-16 18:28:36 +0100
32da5540fe 7. complete chill_person_household_position table Mathieu Jaumotte 2023-02-15 21:57:36 +0100
de8450267d 6. complete chill_person_household_composition_type table Mathieu Jaumotte 2023-02-15 21:40:40 +0100
27ef1034be 5. complete chill_person_marital_status table Mathieu Jaumotte 2023-02-15 21:28:13 +0100
40ebabf3f6 4. complete country table Mathieu Jaumotte 2023-02-15 20:56:50 +0100
9cd1f19f89 3. complete table chill_main_civility Mathieu Jaumotte 2023-02-15 20:21:26 +0100
06b0aab237 2. prepare date columns Mathieu Jaumotte 2023-02-15 18:08:06 +0100
f018a5d115 1. cast column id Mathieu Jaumotte 2023-02-15 17:54:26 +0100
0d68d28448 add dist csv and rename sql folder Mathieu Jaumotte 2023-02-17 10:01:55 +0100
610506a121 update gitignore Mathieu Jaumotte 2023-02-15 14:58:11 +0100
8e478ac099 initial commit Mathieu Jaumotte 2023-02-15 14:56:04 +0100

Commit Graph Select branches Hide Pull Requests dev master Mono Color

Commit Graph

Select branches

Hide Pull Requests

dev

master