IFRCGo / go-api

MIT License
14 stars 6 forks source link

[PROD] Project import, new columns #1851

Open szabozoltan69 opened 1 year ago

szabozoltan69 commented 1 year ago

Issue

The project import uses an old state of deployments_project table, it reads only 22 columns. The recent project table has 41.

Let's catch up the importer with the recent columns. At least contact name, visibility, description would be the minimum to add.

 name                                     
 programme_type                           
 primary_sector_id                        
 start_date                               
 end_date                                 
 budget_amount                            
 status                                   
 reporting_ns_id                          
 user_id                                  
 operation_type                           
 modified_at                              
 regional_project_id                      
 dtype_id                                 
 event_id                                 
 reached_other                            
 reached_female                           
 reached_male                             
 reached_total                            
 target_other                             
 target_female                            
 target_male                              
 target_total                             
 project_country_id                       
 visibility                               
 actual_expenditure                       
 name_ar                                  
 name_en                                  
 name_es                                  
 name_fr                                  
 modified_by_id                           
 reporting_ns_contact_email               
 reporting_ns_contact_name                
 reporting_ns_contact_role                
 description                              
 description_ar                           
 description_en                           
 description_es                           
 description_fr                           
 document_id                              
 translation_module_original_language     
 translation_module_skip_auto_translation 

Already done:
        COUNTRY = 'Country'
        DISTRICT = 'Regions'
        REPORTING_NS = 'Reporting NS'
        DISASTER_TYPE = 'Disaster Type'
        OPERATION_TYPE = 'Operation Type'
        PROGRAMME_TYPE = 'Programme Type'
        PRIMARY_SECTOR = 'Primary Sector'
        TAGS = 'Tags'
        STATUS = 'Status'
        PROJECT_NAME = 'Project Name'
        START_DATE = 'Start Date'
        END_DATE = 'End Date'
        BUDGET = 'Budget(CHF)'
        TARGETED_MALES = 'Targeted Males'
        TARGETED_FEMALES = 'Targeted Females'
        TARGETED_OTHER = 'Targeted Others'
        TARGETED_TOTAL = 'Targeted Total'
        REACHED_MALES = 'Reached Males'
        REACHED_FEMALES = 'Reached Females'
        REACHED_OTHERS = 'Reached Others'
        REACHED_TOTAL = 'Reached Total'
tovari commented 5 months ago

We need to update the import template as well.