Importing Relationships

Overview

Relationships between items can be imported into SharpCloud via the Data Grid. This allows you to quickly establish connections between items using structured data from Excel.

Preparing Data in Excel

To import relationships, structure your Excel data with the following columns:

• Item 1 – Name of the first item (must match an existing item)

• Item 2 – Name of the second item (must match an existing item)

• Comment (optional) – Description of the relationship

• Direction (optional) – Defines arrow direction:

  • Both

  • None

  • Item 1 to Item 2

  • Item 2 to Item 1

Note: If no direction is specified, it defaults to None.

Importing into SharpCloud

To import the relationships:

1. Open the Data Grid

2. Navigate to the Relationships tab

3. Click Paste

4. Paste your Excel data into the dialog

5. Confirm to import

Once imported, the relationships will be created between the matched items.

 

Additional Data

You can also include:

• Relationship attributes

• Relationship tags

These can be added as additional columns in your Excel file.

Notes

• Item names must match existing items exactly

• Ensure item names are unique to avoid incorrect linking

• Importing is fast and ideal for bulk relationship creation