Importing/Updating Rooms
You can import Import/Update rooms, room data structures, Room Properties, Groups, and Room Data into dRofus from Excel by going to the Rooms Module → Import/Export and choosing Import/Update Rooms.
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, Group Names or Room Data fields in dRofus. This is only intended as a suggestion and must be double checked with the Excel spreadsheet before running the import. You must also check that the correct worksheet has been specified.
The Excel spreadsheet must have a specific structure to allow import. It is important that the number and name of functions and sub-functions are entered in different columns, although they do not have to be in a sorted sequence - if a level is repeated later in the document, dRofus will see if it is found and then make use of the existing one. It does not matter which columns contain 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 can specify which rooms to import in two ways: If you have more than one room per row, you have to specify this in a separate column and cross off number of rooms. dRofus will then only import the rooms which have a number greater than or equal to 1. Rows with blank numbers of numbers less than 1 will be ignored. If you cross off for number of rooms, the import function will check the entry in the name column and then import the rows which do not have a blank/empty name.
An example of how this process works is provided in the illustration below.
The end result in dRofus:
The fields for Function level illustrated in his example in the Import room window may vary from project to project, depending on how many function levels are defined for the project and their names.
The same standards for Excel Sheets that apply the Import and Updating of rooms also apply to the Importing/Updating of Rooms. In the example below, new rooms are being imported and an update is being performed by adding Room Name Descriptions and updating the Programed Area (fields in red) to the Rooms that we imported and then updated above.
Note: The only rows that we have included the Department (Number) and Department (Name) are those new rooms that are being imported. The rooms that are being updated, the Room Function # as Identifier Room to indicate which rooms in the project should be updated.
Upon selecting the file that will be the source of the import/update, you will need to select the Identifier for the Room. In this case, the Room Function # as Identifier Room to indicate which rooms in the project should be updated (see highlight from the image below). At this point in the process, it is important to check to confirm that the program recognizes the column names and check to make sure that the Import/Update dropdown is set to Update Existing (included in highlight).
After clicking Import and the bottom of the window, The import/update process will run and if successful, you will get a message indicating how many rooms have been imported and updated (see below). If the import or update fails, you will receive an error message along with an error log.
The end results in dRofus:
| Info |
|---|
| 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 name to Room Data fields. This will succeed if the column name is written in the following format: <tab name> - <group name> - <group element name> - <field name>. It is important here to check the Room Data tabs in dRofus to make sure that the text is entered correctly. For example, the column name "Description - Personal load - Persons, maximum" is mapped to the Description tab, the Personal load group and the Persons, maximum group element. |
...