How to use Excel file with IDA ?
Generate IDA keys
Generate XML imports (add and global update method) with XLS
Generate XML updates (field by field method) with XLS
Generate XML EOD (Export On Demand) with XLS
GENERATION OF IMPORT FILES FOR ADDING IDA WORKS using CSV (excel) files
Insert only a CSV file please [File using ";" as separator between each field]
The order and a quick explaination of the fields in the CSV File - click here
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 reference of a work, you will have to generate it.
: Internal reference of the work from your database
: Maint title of the work
: Subtitle of the work
: Language of the title
: If it is a series, the episode number (numeric only)
: 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.
: Year of production
: Country of production
: Language of production
: Initial destination of the work
: Keywords of the works ( 5 keywords minimum by work separated by a space)
: duration in second
: Type of distribution
: Internal reference of the participant/Right owner from your database
: last name of the participant/Right owner
: First name of the participant/Right owner
: IPI name number of the participant/Right owner
: Society code of the participant
: Role of the participant
: Percentage of share for the primary rights for the right owner
: Percentage of share for the secondary rights for the right owner
: 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
Page generated in 0,000194 second(s)