Import and update of Items to Room Templates from Excel-file

You can import and update items to room templates into dRofus from Excel by going to the Import/Export tab within the Templates for Rooms Module and selecting Import/update Items in Room Templates.

This will open a window:

The file must contain data to identify room templates and items in the database and data to create a new or updated occurrence. Read more: Create Excel-file for import and update

Import, update, or Both

Select to either:

• Import New occurrences that do not already exist. All occurrences that already exist will be ignored.

• Update existing equipment. All occurrences which do not exist will be ignored.

• Import new and update existing will attempt to do both import and update.

Identify for updating:

When updating items in the room template, an identifier for the room and item must be selected. The ID is also required when updating occurrences in the Room Template. Be sure to export the Template Occurrence ID to update existing occurrences.

Import/update Items in different Items lists

When working with more than one item list, it is important to identify which column will be associated with a given list of item lists. If only one item list is being populated, pick the list from the drop-down menu. If the item list uses Categories, populate the column with the item list categories.