Many entities in EasyRoyalties have lists or collections associated entities, such as:
- a title may have multiple editions
- a title may have multiple authors
- a company may have multiple contact persons
and so on.
However the source files are “flat”, so only one subordinate item can be shown on each row. For example, if you are importing titles and you want to include information about the title’s different editions, you can only provide information on one edition per row.
Therefore in order to create more than one subordinate item, add as many additional rows in the spreadsheet as necessary, where each row has the code for the main item and then provides the new subordinate item information.
The following example illustrates how to import titles with multiple editions:
|T00001||Twelfth Night||William Shakespeare||978-1-9999-001-1||Hardcover|
|T00002||A Tale of Two Cities||Charles Dickens||978-1-9999-009-7||Hardcover|
In the example above, the first row creates the title (intellectual property) for Twelfth Night, and adds one edition (the hardcover); the following two rows simply add two more editions of Twelfth Night to the database. The title code (“T00001”) is used to identify which title these editions belong to (the title and author cells are left blank, though if the information were repeated it would not make a difference).
The following example illustrates how to assign multiple authors to the same title:
|T00001||A Call to Duty||David Weber||978-1476736846||Hardcover|
|T00001||A Call to Duty||Timothy Zahn|
In the example above, the first row creates the title for A Call to Duty and adds one edition (the hardcover). The second row adds a second author to the same title.