Import and update of Room Templates from MS-Excel

It is possible to both import and update room templates, room template properties information, groups, and Room Data into dRofus from Excel by using the Import/Export tab from within the Template for Rooms module. 

This will open a window where you can choose an Excel file from your computer. Once you have done this, dRofus will automatically suggest the first row of data and check whether the program recognizes the column name which matches either with Room Properties fields, Group Names, or Room Data fields in dRofus. This is only intended as a suggestion and must be double-checked in the Excel spreadsheet before running the import. It is important to also check that the correct worksheet has been specified. It does not matter which columns contain the data, however, it must be specified in the import dialog window. Only the columns specified for import will be read.

You can choose to either only import a room template that does not already exist, only update existing room templates or both. When using Import no identifier is needed, but for update Template ID, Room Template Code or Room Template Name is needed. If you only import new room templates, all room templates which match existing room templates in dRofus will return an error message that will detail the issue to resolve. The same will occur if you only want to update room templates but one or more room templates do not match the existing room templates in dRofus.

Click the Room Data button to import Room Data fields. This will open a dialogue box with all defined Room Data fields and you can choose which fields you want to import. The program tries automatically to match column names to Room Data fields. This will succeed if the column name is written in the same way as in the column 'Excel label' in the dialogue window.