Initial imports 2

II- GENERATION OF ENRICHMENTS AND UPDATES FOR IDA WORKS using CSV (excel) files

1- You must check that the works you want to update or enriched are in IDA

2- Create a xls file with the information you want to import in IDA

If you want to make global update, you have to use the same order as if you were making an ADD file.

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

ORDER of the fields for each CSV File :
[ADD]
Right-Owner: IDA ref. | Internal society ref. for ro | IPI NN | Role | A right | B right | Distribution basis | Society number
Other Title: IDA ref. | Title | Sub-title | Lng | Country | Society number
Society Ref: IDA ref. | Internal society ref. | 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
Other Title: IDA ref. | title modified | sub-title modified | lng modified | country modified | title | sub-title | lng | country | society number
Society Ref: IDA ref. | internal society ref. | society number
[DELETE]
Right-Owner: IDA ref. | IPI NN | Role | Society number
Other Title: IDA ref. | Title | Sub-title | Lng | Country | Society number
Society Ref: IDA ref. | Internal society ref. | Society number

If you want information concerning the meaning of the fields in IDA, you can download the lastest nomenclature file in the download section

3- Save this excel file into the specific format “csv file”

4- Generate the IDA XML file using the script available on the IDA communication space

For the global update go here: http://www.ida-net.org/tools.php?id=5, change the list option, use “G_UPDATE” and click on generate.
For the UPDATE field by field go here: http://www.ida-net.org/tools.php?id=6

5- Contact us and do the import into the user test environment