You can both It is possible to import and update items to room templates into dRofus from Excel by going to the Import/Export tab from within the Templates for Rooms Module.
...
This will open a window where you can choose an Excel file from your computer. :
...
The file must contain data to identify existing room templates and existing Items and data to create a new or update an existing occurrence. You can choose to either just import Read more: Create Excel-file for import and update
Import, update or Both
Select to either:
Import equipment which does not already exist
...
. All occurrences which already exist
...
will be ignored
Update existing equipment. All occurrences which do not exist
...
will be ignored.
You have to select the way in which the room templates are to be identified, for example, by specifying their Code. You also have to select the way in which the Item are to be identified, for example, by specifying their Item Number.
Once you have specified the Excel file, dRofus will automatically suggest the first row of data and check if the program recognizes the column name which matches the selected identification type for room template and for Item. This is only intended as a suggestion and must be double checked in the Excel spreadsheet before running the import. You must also check that the correct worksheet has been specified. It does not matter which column the data is entered in. Only the columns specified for import will be read. Even if you have other columns in the spreadsheet, but are not specified for import, they will not be read.
Both import and Update.
Identify for updating:
When updating items in room template a identifier for room and item must be selected. The drop-down menu provide which values that can be used as identifier.
Import/update Items in different Items lists
Tick the checkbox beside the "item list" if you import/update items in different item list, tick "item list" and indicate the column number that defines the item list. If your import/update concerns only one item list you can select it directly for your entire import: