Import Finishes to Rooms from MS Excel

Finishes data can be imported to room templates and rooms by:

1. Opening Rooms module -

2. Select Import/Export tab

3. Select Import/update items to rooms 

   Open

   

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 with room core fields in dRofus. 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 columns contain the data, but you have to specify this yourself in the import dialogue box. Only the columns specified for import will be read. Even if you have other information in the spreadsheet, it will not be read.

You also have to choose how to identify the rooms/room templates for example via their code or room function number.

Select Item list: Finishes to import Finishes data. Indicate the Column name to identify the Category of Finish you are importing ( eg Walls, Ceilings ..)

in the column 'Excel label' in the dialogue window.