Excel: Import and Update Systems and Components
NOTE! Works only for databases configured with NS-TFM classifications (Norwegian classification code).
Excel an database structure:
A pre-populated Excel Spreadsheet with the relevant data is required in order to import or update a systems and components. Excel sheet must include Classification number and Item name. Any other fields for import are optional.
TFM:
The TFM numbers in the excel and database structure needs to be set up correspondingly. In particular:
TFM Lokasjonskode has to be the same number (Example: +AA )
TFM System structure has to contain every system code that is going to be imported
Otherwise the user will get an error message: There is no classification system properly configured for this code
Read more: Add Classification to the database and Create Excel-file for import and update
Import/update
![](../../../__attachments/1353156298/image2019-9-9_11-5-46.png?inst-v=0afdfd47-3bc6-4c62-adaf-adf72ef5899e)
Select the Systems module
Select Import/Export tab
Select Import/update systems and components and a window will appear:
![](../../../__attachments/1353156298/image2019-9-9_11-14-1.png?inst-v=0afdfd47-3bc6-4c62-adaf-adf72ef5899e)
Read Introduction: Import/update with Excel-file before moving forward.
Import, update or both
Select to either:
Import new
Update existing
Both Import new and update existing.
![](../../../__attachments/1353156298/image2019-9-9_15-50-34.png?inst-v=0afdfd47-3bc6-4c62-adaf-adf72ef5899e)
Connection
![](../../../__attachments/1353156298/image2019-9-9_13-31-53.png?inst-v=0afdfd47-3bc6-4c62-adaf-adf72ef5899e)
In the Connections group the column that connects Item to the component has to be specified.
Items can be either already existing, or you can create new Items in dRofus if you check Create Items checkbox.
It is also possible to specify connections to Room (by either Room Function # or Room Name), also Item list and also Category.
General
In the General group there are fields connected to occurrence (component) data.
Product
In Product group there are fields connected to product data. (More about Products here.)
Select import:
Next, the item group needs to be selected if the “crate new Item” box has been ticked, for the new items to be imported to.
Then press OK and dRofus will start the import.
![](../../../__attachments/1353156298/image2019-9-9_15-53-25.png?inst-v=0afdfd47-3bc6-4c62-adaf-adf72ef5899e)