You are here

Home » API reference » Migrate Spreadsheet 8

migrate_spreadsheet.schema.yml in Migrate Spreadsheet 8

Same filename and directory in other branches
  1. 2.0.x config/schema/migrate_spreadsheet.schema.yml
config/schema/migrate_spreadsheet.schema.yml

File

config/schema/migrate_spreadsheet.schema.yml
View source 
  1. migrate.source.spreadsheet:

  2.   type: migrate_source

  3.   label: 'Spreadsheet'

  4.   mapping:

  5.     file:

  6.       type: string

  7.       label: 'Path to the source spredsheet file'

  8.     worksheet:

  9.       type: string

  10.       label: 'The worksheet name'

  11.     origin:

  12.       type: string

  13.       label: 'The top-left cell of data area'

  14.     header_row:

  15.       type: integer

  16.       label: 'The row containing the header'

  17.     columns:

  18.       type: sequence

  19.       label: 'Columns to be read from spreadsheet'

  20.       sequence:

  21.         type: string

  22.         label: 'Column'

  23.     row_index_column:

  24.       type: string

  25.       label: 'Name of row index "zero based" value'

  26.     keys:

  27.       type: sequence

  28.       label: 'Column name(s) which represent the key uniquely identifying each record'

  29.       sequence:

  30.         type: mapping

  31.         label: 'Schema'

  32.         mapping:

  33.           type:

  34.             type: string

  35.             label: 'Field type'