84.4.5.85 CUSTOM > WON > ASSET CSV SUPPLEMENTARY DATA

Import Scope
The "WON - Asset CSV Supplementary Data" import allows importing into the Etere database all WON assets contained within a .CSV file.
Import prerequisites
The following elements must exist in Etere's flexi-metadata structure (in "Configuration > Settings > MAM > Flexi-metadata"):
Element name - ABC
Element type : string
Element name - LBC
Element type : string
Element name - SBC
Element type : string
Element name - TX Ext
Element type : string
The following elements must exist in Etere's flexi-metadata structure (in "Configuration > Settings > MAM > Flexi-metadata"): 
Element description - WON-Product Code
Element type : string
Element description - WON-Version
Element type : string
Element description - WON-Season
Element type : integer
Element description - WON-Broadcasting Title
Element type : string
Element description - WON-Extended title (list)
Element type : string
Element description - WON-Internal Number
Element type : string
Element description - WON-Season Title
Element type : string
Element description - WON-Episode No
Element type : string
Element description - WON-Best Available Duration
Element type : string
Element description - WON-Department
Element type : string
Element description - WON-Media Id
Element type : string
Element description - WON-Category
Element type : string
Element description - WON-Type
Element type : string
Element description - WON-Type (Nature)
Element type : string
Element description - WON-Type (Product type)
Element type : string
Element description - WON-Country of Production
Element type : string
Element description - WON-Regional parental rating
Element type : string
Element description - WON-Aspect ratio
Element type : string
Element description - WON-Aspect ratio (best available)
Element type : string
Element description - WON-Aspect ratio of the product
Element type : integer
Element description - WON-First transmission date of current version
Element type : datetime
Element description - WON-Original Title
Element type : string
Element description - WON-Default description
Element type : string
Element description - WON-Description
Element type : string
Element description - WON-Short Description
Element type : string
Element description - WON-Short Description printed press
Element type : string
Element description - WON-Long Description printed press
Element type : string
Element description - WON-Short Teletext Description
Element type : string
Element description - WON-Identification
Element type : string
File specifications
The file must be a .CSV
Each line should define the information (fields) of an asset (or a segment of it)
Line fields must be separated by a semicolon (;). For instance:
W63546;[IDM];3;Cat eyes;Cat eyes;1;4523;Animal;112:00.00;Viacom España;
The number of fields per line depends on:
Segmented assets - 33 fields
Non-segmented assets - 29 fields
Lines related to EDL segments (i.e. where fields #30 - #33 are compiled) MUST be specified in ascending order, for instance:
line 173 - corresponds to 1st segment
line 174 - corresponds to 2nd segment
line 175 - corresponds to 3rd segment
The import of EDL segments depends on whether assets are ingested or not:
not ingested - EDL segments are inserted as "visible segments"
ingested - EDL segments are ignored (i.e. not inserted)
Import process
For each line, the system checks if that line should be either processed or skipped (ignored). Following lines are skipped:
First line, that is, the header line
Lines which field #02 (Version) is [IDM]
Lines which field #11 (Media ID) is empty
The existence of assets is determined by the Field#11 (Media ID), which is checked as follows:
If the Field#11 (Media ID) starts with ABC, it's compared with the "ABC" flexi-metadata
If the Field#11 (Media ID) starts with LBC, it's compared with  by the "LBC" flexi-metadata
If the Field#11 (Media ID) starts with SBC, it's compared with the "SBC" flexi-metadata
If the Field#11 (Media ID) starts with other string, it's compared with the "TX External" flexi-metadata
If the asset exists in the Etere database its information is updated. If the asset doesn't exist a new asset is created.
Fields are mapped according to the following table:
CSV file
ETERE database
No. - 1
WON Field : Product Code
Flexi-metadata description: WON-Product Code
Type : string
No. - 2
WON Field : WON Field : Version
Flexi-metadata description: WON-Version
Type : string
No. - 3
WON Field : Season
Flexi-metadata description: WON -Season
Table.field : fserie.season¹
Type : integer
No. - 4
WON Field : Broadcasting Title
Flexi-metadata description: WON-Broadcasting Title
Table.field : filmati.descrizio
Type : string
No. - 5
WON Field : Extended title (list)
Flexi-metadata description: WON-Extended title (list)
Type : string
No. - 6
WON Field : Internal Number
Flexi-metadata description: WON-Internal Number
Type : string
No. - 7
WON Field : Seasons Title
Flexi-metadata description: WON-Season Title
Table.field : fserie.descrizio¹
Type : string
No. - 8
WON Field : Episode No
Flexi-metadata description: WON-Episode No
Table.field : filmati.puntata¹
Type : string
No. - 9
WON Field : Best Availalbe Duration
Flexi-metadata description: WON-Best Available Duration
Table.field : filmati.duration
Type : hh:mm:ss
No. - 10
WON Field : Department
Flexi-metadata description: WON-Department
Type : string
No. - 11
WON Field : Media Id
Flexi-metadata description: WON-Media Id
Table.field : filmati.cod_progra²
Type : string
No. - 12
WON Field : Category
Flexi-metadata description: WON-Category
Type : string
No. - 13
WON Field : Type
Flexi-metadata description: WON-Type
Type : string
No. - 14
WON Field : Type (Nature)
Flexi-metadata description: WON-Type (Nature)
Type : string
No. - 15
WON Field : Type (Product type)
Flexi-metadata description: WON-Type (Product type)
Table.field : filmati.newtype³
Type : string
No. - 16
WON Field : Country of Production
Flexi-metadata description: WON-Country of Production
Table.field : fserie.paese
Type : string
No. - 17
WON Field : Regional parental rating
Flexi-metadata description: WON-Regional parental rating
Type : string
No. - 18
WON Field : Aspect ratio
Flexi-metadata description : WON-Aspect ratio
Type : string
No. - 19
WON Field : Aspect ratio (best available)
Flexi-metadata description : WON-Aspect ratio (best available)
Type : string
No. - 20
WON Field : Aspect ratio of the product
Flexi-metadata description : WON-Aspect ratio of the product
Type : string
No. - 21
WON Field : First transmission date of c.v.
Flexi-metadata description : WON-First transmission date of current version
Type : datetime
No. - 22
WON Field : Original Title
Flexi-metadata description : WON-Original Title
Type : string
No. - 23
WON Field : Default description
Flexi-metadata description : WON-Default description
Type : string
No. - 24
WON Field : Description
Flexi-metadata description : WON-Description
Type : string
No. - 25
WON Field : Short Description
Flexi-metadata description : WON-Short Description
Type : string
No. - 26
WON Field : Short Description printed press
Flexi-metadata description : WON-Short Description printed press
Type : string
No. - 27
WON Field : Long Description printed press
Flexi-metadata description : WON-Long Description printed press
Type : string
No. - 28
WON Field : Short Teletext Description
Flexi-metadata description : WON-Short Teletext Description
Type : string
No. - 29
WON Field : Identification
Flexi-metadata description : WON-Identification
Type : string
No. - 30
WON Field : Tc In
Table.field : finterruzioni.markin
Type : hh.mm.ss.ff
No. - 31
WON Field : Tc Out
Table.field : finterruzioni.markout
Type : hh.mm.ss.ff
No. - 32
WON Field : Seg Duration
Table.field : durata segmento
Type : mm.ss.ff
No. - 33
WON Field : Program segment
Table.field : No.segmento
Type : integer
¹ : Assets are considered as "tv seasons" if field#3 (season) is not null, and field#7 (seasons title) and field#8 (episode no.) are greater than zero
² : The code of new assets is generated according to the rules configured in Etere ("Configuration > Settings > Basic > Code")
³ : The type of new assets is based on the description, it can be "Programme", "Episode" or "Seasons".
Launch the import
Once all parameters have been correctly set, just press the <Import> button to launch the import operation.

Import_custom_won_asset_csv_supplementary_data

•File to import: Specify the directory from where CSV files will be retrieved for the import.
Sample file to import
The file to be imported using this method will have to the following structure in order to be correctly imported:
Product code    ;Version        ;Season ;Broadcasting title             ;Extended title (list)          ;Internal no.   ;Season title   ;Episode no.    ;Best available duration;Department     ;Media ID       ;Category               ;Type   ;Type (Nature)  ;Type (Product type)    ;Country of production  ;Regional parental rating       ;Aspect ratio   ;Aspect ratio (best available)  ;Aspect ratio of the product    ;First transmission date of current version     ;Original title                 ;Default description                    ;Description    ;Short description      ;Short description printed press                ;Long description printed press                         ;Short teletext description                             ;Identification
-------------------------------------------------------------------------------------------
               ;[IDM]          ;       ;La ciudad de los ni¤os perdidos;La ciudad de los ni¤os perdidos;               ;               ;               ;112:00.00              ;Viacom Espa¤a  ;               ;Movies - Fantasy       ;       ;Production     ;Programme              ;Spain                  ;                               ;               ;                               ;                               ;                                               ;La ciudad de los ni¤os perdidos;Long summary printed press:            ;               ;                       ;                                               ;"FRANCIA. 1995.Director: Jean-Pierre Jeunet            ; Reparto: Ron Perlman, Daniel Emilfork, Judith Vittet.";;
-------------------------------------------------------------------------------------------
               ;SPUM           ;       ;La ciudad de los ni¤os perdidos;La ciudad de los ni¤os perdidos;               ;               ;               ;102:03.03              ;Viacom Espa¤a  ;SBC000808      ;Movies - Fantasy       ;       ;Production     ;Programme              ;Spain                  ;                               ;               ;                               ;                               ;04/05/2012                                     ;La ciudad de los ni¤os perdidos;Long summary printed press:            ;               ;                       ;                                               ;"FRANCIA. 1995.Director: Jean-Pierre Jeunet            ; Reparto: Ron Perlman, Daniel Emilfork, Judith Vittet.";;
-------------------------------------------------------------------------------------------
               ;[IDM]          ;       ;El 7§ d¡a                      ;El 7§ d¡a                      ;               ;               ;               ;103:00.00              ;Viacom Espa¤a  ;               ;Movies - Drama         ;       ;Production     ;Programme              ;Spain                  ;                               ;               ;                               ;                               ;                                               ;El 7§ d¡a                      ;Long summary printed press:            ;               ;                       ;                                               ;"ESPA¥A. 2004.Director: Carlos Saura                   ; Reparto:Juan Diego, Jos‚ Luis G¢mez, Jos‚ Garcia."    ;;