Here is the list of the column in this excel file and the order:
You can add more than one title and one participant / right-owner by work. You just have to one line with the same IDA reference (see the example).
IDA_REF: IDA reference of a work, you will have to generate it.
INTERNAL REF: Internal reference of the work from your database
MAIN TITLE: Maint title of the work
SUBTITLE: Subtitle of the work
TITLE LANGUAGE: Language of the title
REF_EPISODE: If it is a series, the episode number (numeric only)
SEASON: If it is a series, the season number (numeric only)
IDA_REF of the master: If it is a series, the IDA ref. of the master of this series. In IDA all work in a series are linked to one master.
PRODUCTION YEAR: Year of production
SHOOTING_COUNTRY: Country of production
SHOOTING LANGUAGE: Language of production
INTIAL DESTINATION: Initial destination of the work
KEYWORDS: Keywords of the works ( 5 keywords minimum by work separated by a space)
DURATION: duration in second
DISTRIBUTION TYPE: Type of distribution
PARTICIPANT REFERENCE: Internal reference of the participant/Right owner from your database
PARTICIPANT LASTNAME: last name of the participant/Right owner
PARTICIPANT FIRSTNAME: First name of the participant/Right owner
IPI: IPI name number of the participant/Right owner
PARTICIPANT SOCIETY: Society code of the participant
ROLE: Role of the participant
A RIGHTS: Percentage of share for the primary rights for the right owner
B RIGHTS: Percentage of share for the secondary rights for the right owner
MASTER : IF this work is a master then set the value to "yes"
If you want information concerning the meaning of the fields in IDA, you can download the lastest nomenclature file in the download section
Close - click here