Content Comparison

Table of Contents

Data file

File: Medications&Innm2Load

Table of Contents

Data file

File: Medications&Innm2Load

Page: "Original-2017-08-26"

Upload steps & logic

Step 1- Load Innms

1. Source page "innm"
2. Mapping:
   1. innm_identifier = column `C`
   2. name = column `A`
3. Check exist by `innm_identifier`
   1. If not exist - Insert new.
      
      1. status=INACTIVE (DICTIONARY: innm_status)
      2. is_active=TRUE

Step 2 - Load Routes

1. Source page: "Dic: route"
2. Mapping:
   sasad
   1. name = column `A`
   1. Check exist by `value`
      1. If not exist - Insert new.

   Step 3 - Load Medications

   1. Source page: "Original-2017-07-26"
   2. Delete * from medications (delete old data)
   3. Mapping:
      1. name = column `C`(3)

      2. is_active = TRUE

      3. start_at = `2017/07/26`
      4. end_at = `3000/01/01`
      5. route = column `D`(4) + search in Dictionary `medication_route` by name
      6. container_dosage
         1. = column ````e
      7. package_qty = column `G`(6)
      8. package_min_qty = column `G`(6)
      9. code_ATX = column `H`(7)
      10. manufacturer_name_country =column `I`(8) + Parsing Procedure 1
      11. certificate = column `J`(9)
      12. expired_certificate_date = column `K`(10) + format `DD.MM.YYYY`
   4. cd

   Parsing procedure Manufacturer & Country

   1. Parsing string by format: `manufacturer_name`,`country_name` 
   2. Examples: 
      1. Юнікем Лабораторіз Лімітед , Індія;
      2. Асіно Фарма АГ , Швейцарія
   3. Mapping for structure Manufacturer_info
      1. name = `manufacturer_name`
      2. country = `country_name` search in Dictionary `Country` by name