Mettre toutes les variables de la base dans la vue des flux

[gdaudin]

No description provided.

[paulgirard]

I added office.

Now for the rest data are not in the database yet which means I have to update the import script too.
I will do that at the same time as #228

Would be of great help to have a exhaustive list of fields to add, please ;)
this is what we have in bdd_centrale
1 line_number
2 source_type
3 year
4 customs_region
5 customs_office
6 partner
7 export_import
8 product
9 origin
10 width_in_line
11 value
12 value_part_of_bundle
13 quantity
14 quantity_unit
15 value_per_unit
16 filepath
17 source
18 sheet
19 value_total
20 value_sub_total_1
21 value_sub_total_2
22 value_sub_total_3
23 data_collector
24 unverified
25 remarks
26 value_minus_unit_val_x_qty
27 absurd_observation
28 trade_deficit
29 trade_surplus
30 duty_quantity
31 duty_quantity_unit
32 duty_by_unit
33 duty_total
34 duty_part_of_bundle
35 duty_remarks
36 value_as_reported
37 computed_value
38 computed_up
39 computed_quantity
40 best_guess_national_prodxpart
41 best_guess_national_partner
42 best_guess_national_product
43 best_guess_region_prodxpart
44 best_guess_national_region

[gdaudin]

Bah... Nothing in there is not-useful. Put everything in ? Ok, I feel I will need to document stuff ?

[gdaudin]

Done around commit c8379cf12ebf31edcb4e152d96e62d169d57db96

[gdaudin]

Ah, en fait il y a un bug. Voir ce lien : http://toflit18.medialab.sciences-po.fr/#/exploration/flows?sourceType=Best%20Guess%20customs%20region%20product%20x%20partner&productClassification=product_sitc_EN&product=%5B%22Raw_materials%2C_inedible%2C_except_fuels%7Eproduct_sitc_EN%22%5D&partnerClassification=partner_grouping&partner=%5B%22France%7Epartner_grouping%22%5D&page=0&region=Marseille&kind=total&dateMin=1789&dateMax=1789&valueMin=100000&columns=%5B%22region%22%2C%22year%22%2C%22partner%22%2C%22import%22%2C%22value%22%2C%22office%22%5D

[gdaudin]

Bug réglé : merci Paul !
Par contre, il me semble qu’il manque une variable : customs_office

[gdaudin]

Je fais un essai d’intégration moi-même.

[gdaudin]

Dans toflit18 et toflit18_data