IDA

1- You must verify that works you want update are well present in IDA database.

2- Create a file XLS or XML with information you want import in IDA.

NB : If you want make a global update, you must to use the same order than if you create an ADD file.

If you wish to update or enrich only specific fields, you must use other file formats depending on the field you want to update/enrich. You can add, modify, or delete specific fields when using this type of update (field-by-field UPDATE).

Please find below the ORDER of the fields for each CSV file:

  • Add Other Title

    Ida ref. | Title | Subtitle | Language | Country | Society number

  • Add Right Owner

    Ida ref | Internal society ref. for ro | Ipi NN | Role | A right | B right | Distribution basis | Society number

  • Add Society Reference

    Ida ref. | Internal society ref. | Society number

  • Update Main Title

    Ida ref. | Title | Subtitle | Language | Country | Society number

  • Update Other Title

    Ida ref. | Title modified | Subtitle modified | Language modified | Country modified | Title | Subtitle | Language | Country | Society number

  • Update Prex Title

    Ida ref. | Title modified | Subtitle modified | Language modified | Country modified | Title | Subtitle | Language | Country | Society number

  • Update Right Owner

    Ida ref. | Ipi NN of the modified RO | Role of the modified RO Internal society ref. for RO | Ipi NN | Role | A right | B right | Distribution basis | Society number

  • Update Society reference

    Ida ref. | Internal society ref. | Society number

  • Delete Other Title

    Ida ref. | Title | Subtitle | Language | Country | Society number

  • Delete Right Owner

    Ida ref. | Ipi NN | Role | Society number

  • Delete Society reference

    Ida ref. | Ipi NN | Role | Society number

If you want information about the meaning of the fields in IDA, you can download the latest nomenclature file.

3- Save this Excel file in the specific ‘CSV file’ format or create your file in the XML format.

4- Import your file on the TEST platform first, then if the result is good, you can import your file on the PRODUCTION platform.

Exemples field-by-field UPDATE :

Add a right owner : test_csv_fbf_ro.csv

Add a title : test_csv_fbf_add_otitle.csv

Update a other tilte : test_csv_fbf_update_otitle.csv