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