id: materials
label: PIC Material Index
migration_group: epic_pic
source:
  plugin: csv
  path: "modules/custom/epic_migration/assets/csv/ola_pic_materials_index.csv"
  enclosure: '"'
  header_row_count: 0
  keys:
    - record_id
    - mi_code
  column_names:
     0:
      record_id: record_id
     1:
       mi_code: mi_code
     2:
       material_seq: material_seq
     3:
       material_symbol_code: material_symbol_code
     4:
       symbol_location: symbol_location
process:
  field_material: mi_code
  field_material_symbol_code: material_symbol_code
  field_symbol_location: symbol_location
destination:
  plugin: 'entity_reference_revisions:paragraph'
  default_bundle: materials_filters
migration_dependencies:
  required: { }
  optional: { }

id: epic_pic_data
label: PIC Data migration
migration_group: epic_pic
source:
  plugin: csv
  path: "modules/custom/epic_migration/assets/csv/ola_pic_data.csv"
  enclosure: '"'
  header_row_count: 0
  keys:
    - record_id
  column_names:
*
*
*
*
process:
  type:
    plugin: default_value
    default_value: lens
  title: Product_brand_name
*
*
*
*
  'field_materials_filters/target_id':
    -
      plugin: migration_lookup
      migration: materials
      no_stub: true
      source: id
    -
      plugin: extract
      index:
        - '0'
  'field_materials_filters/target_revision_id':
    -
      plugin: migration_lookup
      migration: materials
      no_stub: true
      source: id
    -
      plugin: extract
      index:
        - 1
destination:
  plugin: entity:node
migration_dependencies:
  required:
    - materials
  optional: { }