A spreadsheet is used for Relations import. Data columns represent the data entry fields while each row is a new record. Each Relations row has columns to enter one contact along with the Relations information. To ensure the correct format is used, first export any existing Relations to Excel, and then use the same sheet as a template to (re-)import Relations.
Please see the section above for the list of data columns.
Note: The export structure is similar to Counterparties but has additional columns in a different order.
| • | To begin a Relations import, select Relations on the Home screen. |
| • | On the Relations screen select the Import button on the App bar at the top right of the screen. |
| • | Select Import. The Import Relations screen appears. |
| • | Select the Select button. A dialog to select a file will open. |
| • | Select a spreadsheet for import. Any name may be used for the file, but it must be a spreadsheet in Excel 2007 format or higher (i.e. XLSX). |
| • | Once selected, the file name will appear on the screen. |
| • | Only one spreadsheet may be imported at a time. |
| • | To delete the spreadsheet select the red X next to the spreadsheet name. |
| • | Select the Import button to begin the import process. |
Note: Error messages will appear if there is a problem with any of the data. This may include omission of required information, duplicate data or incorrect data entered in a field matched against Master data values. Relations import follows the “all or nothing” rule. If an error is found, the import process is stopped, no records are imported. Check the file, correct the error and try the import again. When the import is completed, the message “Import successfully completed” will appear.