Exporting and Importing Data
Importing and Exporting Data: Overview
Sharing facilities data others who do not have Archibus is accomplished with these features:
- Data Transfer
- Supports import and export.
- Supports CSV format and Excel XML format.
- Available on some Web Central views.
- Available in Smart Client as the Transfer command.
- Export to XLS
- Export data directly to an Excel file.
- Available on some Web Central views.
- Available in Smart Client as the Export command.
As shown above, there are two methods for exporting data from Archibus. The following tables summarizes the two export actions.
Data Transfer | Export to XLS | |
---|---|---|
How accessed | DATA button, Transfer Out action | XLS or Export button |
Format | Exports to a format that is intended to be read by machine. Enumeration lists, dates, and numbers are in a format that can be reliably parsed and read back in. | Exports to the XLS file in a form that is intended to be read by people – enumeration lists, dates, numbers use the translated values; that is, string values for enumeration lists and localized value for dates are clear to people reading the Excel file. |
Include fields from a standards table? |
No In order to support data transfer round tripping, only the main table fields are exported. This means that if a field defined in the data source of the view is from the standards table, that field will not be exported. |
Yes, if these fields are visible |
Fields must be visible in the view? |
Yes, with the following exceptions:
|
Yes |
Obeys the view's restriction? | No. Exports all records. |
Yes. The export includes all records meeting the restriction, even if the record limit for the view prevents some of these records from being displayed. A restriction can be set with the Smart Search console or a filter. |