84.4.5.36 STANDARD > SIAE ROM-ROF CSV

Import Scope
The SIAE ROM-ROF CSV import allows importing a file in CSV format containing SIAE data to be added/updated to specific assets in order to compile their ROF and ROM registers. The import will be performed under the following specifications:
•The text file must be a comma-separated-values (CSV)
•Each line contains SIAE data for one asset, data fields must be separated by a comma (;)
•Imported fields refer to asset fields available in Media Library > SIAE tab
•If the asset related to a SIAE data doesn't exist an error message will be returned in the "Errors" tab
•In case an asset already has the importing SIAE fields, existing data will be updated with the imported one.
•If the Type of music generation is not indicated in the file, it would not be imported as value “33” (by default),  the following rules would apply:
▪If the data type is Phonogram, it would be imported as value “11”.
▪If the data type is Video clips, it would be imported as value “22”.
▪If the data type is Base, it would be imported as value “33”.
▪If the data type is Live without base, it would be imported as value “44”. 
Import parameters
This export allows the following parameters to be set and then [saved]:

Import_standard_siae_rom-rof_csv

•File to import: Browse and select the subtitles file to be imported into the system.
NB: Please note that only files with CSV extension are supported.
•Default RPC type when missing in file: When the code of RPC type is not found in the file, specify here the default RPC type to be used when importing the file into Etere.  The value entered in this parameter must not exceed 2 characters. 
Launch the import
Once all parameters have been correctly set, just press the <Import> button to launch the import operation.
Sample file to import
The file to be imported using this method will have to the following structure in order to be correctly imported:
CARTNUMBER - CC89263
VIDEO TITLE : PRONTI, PARTENZA, VIA!
COMPOSITORE : TADDUCCI, CANOVA
ELABORATORE : ELAB-TEST-A
CARTNUMBER - CC8925K
VIDEO TITLE : L'EVENTO
COMPOSITORE : ANTONACCI
ELABORATORE : ELAB-TEST-B, ELAB-COMPOSITORE : TEST-C
CARTNUMBER - CC8925L
VIDEO TITLE : DUE RESPIRI
COMPOSITORE : RAMAZZOTTI, 
COMPOSITORE : CHIARAVALLI
CARTNUMBER - CC8926C
VIDEO TITLE : I SEE YOU
COMPOSITORE : TAYLOR
CARTNUMBER - CC8924S
VIDEO TITLE : IO FACCIO
COMPOSITORE : DAGANIU, CASTOLDI
CARTNUMBER - CC8926B
VIDEO TITLE : LA SCOPERTA DELL'ALBA
COMPOSITORE : CASACCI, DI LEO
CARTNUMBER - CC8925P
VIDEO TITLE : LA MORTE (NON ESISTE)
COMPOSITORE : BIANCONI
CARTNUMBER - CC8926E
VIDEO TITLE : I COULD BE THE ONE
COMPOSITORE : BERLING, ROMERO
CARTNUMBER - C130062
VIDEO TITLE : F*UCKING PROBLEMS
COMPOSITORE : GRAHAM
CARTNUMBER - CC8926Q
VIDEO TITLE : DAVANTI AGLI OCCHI
COMPOSITORE : TARDUCCI
CARTNUMBER - CC8927A
VIDEO TITLE : DEMONS TO DIAMONDS
COMPOSITORE : SALMO
CARTNUMBER - CC8927B
VIDEO TITLE : ORO E ARGENTO
COMPOSITORE : VELLA, ROMANO, BILARDO
CARTNUMBER - C130222
VIDEO TITLE : SUIT & TIE (VIDEO with LYRICS)
COMPOSITORE : TIMBERLAKE, JAY-Z
CARTNUMBER - C130123
VIDEO TITLE : CLARITY
COMPOSITORE : ZASLAVSKI
CARTNUMBER - C122981
VIDEO TITLE : COUGH COUGH
COMPOSITORE : ROBERTSHAW
CARTNUMBER - C130201
VIDEO TITLE : THRIFT SHOP
COMPOSITORE : HAGGERTY, LEWIS
CARTNUMBER - C130141
VIDEO TITLE : GIVE UP
COMPOSITORE : KANE
CARTNUMBER - C130186
VIDEO TITLE : POMPEII
COMPOSITORE : SMITH
CARTNUMBER - C130229
VIDEO TITLE : BECAUSE WE CAN
COMPOSITORE : BON JOVI
CARTNUMBER - CC8929E
VIDEO TITLE : HEAVEN
COMPOSITORE : GORE
CARTNUMBER - CC8870J
VIDEO TITLE : DIMENTICARTI E' POCO
COMPOSITORE : ANTONACCI
CARTNUMBER - CC8870K
VIDEO TITLE : SI SCRIVE SCHIAVITU' SI LEGGE LIBERTA'
COMPOSITORE : COGLIATI, LUCIA
CARTNUMBER - CC89291
VIDEO TITLE : COMUNQUE
COMPOSITORE : DRAGONA
CARTNUMBER - CC8929F
VIDEO TITLE : IL FARO E IL MARE
COMPOSITORE : VACCA
CARTNUMBER - C130339
VIDEO TITLE : NOW
COMPOSITORE : PARAMORE
CARTNUMBER - CC8870N
VIDEO TITLE : LA TERRA DEGLI UOMINI
COMPOSITORE : CHERUBINI
CARTNUMBER - CC8869D
VIDEO TITLE : FOREVER ALONE
COMPOSITORE : SINIGALLIA
CARTNUMBER - C130038
VIDEO TITLE : KISS YOU
COMPOSITORE : YACOUB
CARTNUMBER - CC8869L
VIDEO TITLE : L'ESSENZIALE
COMPOSITORE : MENGONI MARCO