You Users can both import and update equipment occurrences in rooms in room into dRofus from using Excel by going to Rooms → Import/Export → Import/update Items to roomsOccurrences . This will open a window where you can choose an Excel file from your computer. The file must contain data to identify existing rooms already in dRofus and existing Items already in dRofus and item data occurrence fields to create a new or update an existing occurrence.You can . Note that only one items list can be imported with new occurrences or updated each time this is task is run.
Users choose to either just import equipment which does only 'import new' occurrences that do not already existoccur, only 'update existing equipment' occurrences, or both import and update at the same time.
When you only using 'import new equipment' occurrences, all occurrences which that already exist are ignored.
When you only update equipmentusing 'update existing', all occurrences which that do not exist already occur are ignored.
You have to must select the way in which to identify the rooms are to know where the occurrences will be identifiedlocated, for example, by specifying their Room Function Number.
You also have to must select the way in which the Item are to be identifiedto identify the items to know which items represent the occurrences, for example, by specifying their Item Number.
Once you have specified browed and selected the Excel file via 'Choose file', dRofus will read the column headers and attempt to automatically suggest the first row of data and check if the program recognizes the column name which that matches the selected identification type for room and for Itemunique identifiers for the rooms and items. This is only intended as a suggestion and must be users are advised to double checked within the Excel spreadsheet before running the import . You must also check or update. Users are advised to also confirm that the correct worksheet has been specified. It does not matter which column the data is entered in. Only in the excel file matches the sheet discovered in the automation check. The order of the columns is not required to match the sequence of the fields in dRofus. there can also be data in other columns that are not mapped, 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.If you import/update items If the automation does not correctly map the fields intended to import or update, users can manually map the columns to the available fields that are associated to the excel file by putting the letter of the column in the box next to the field that matches the excel column header.
When import/update occurrences 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:
and choose the Item list from the drop down. Note only one items list can be updated or imported per excel task.
