Products
Solutions
Resources
9977 N 90th Street, Suite 250 Scottsdale, AZ 85258 | 1-800-637-7496
© 2024 InEight, Inc. All Rights Reserved | Privacy Statement | Terms of Service | Cookie Policy | Do not sell/share my information

Only a Project Admin can create Generic Tables to import external data and link to a Unique ID Tag in Model.
External information can be accessed in Model but is managed externally using Excel.
The following step-by-step walks you through how to identify the model Unique ID in Excel.
The following steps require the Excel Plugin to be installed and for a Project Admin to be logged into the InEight Excel Plugin.
After you log into Excel, use the first column (cell A1) to match a Tag Category in Model.
Columns B and beyond can contain additional columns of data as needed.
Rename the Tab to the preferred Table Name.
Although this is not a required step, it can provide clarity as you develop the extra data.
Under the InEight tab in the Data section, select Table.
From the drop-down menu, in the New Table section, select Create new Table.
From the Create new Table data box:
Select one item to be the Identifier (i.e. 00 – Asset).
This must be a pre-existing Tag Category in Model.
In the Data Type column, choose the correct Data Type for each Column Name.
All data types are defaulted to Short String.
String: can contain any sequence of characters
Integer: a whole number (not a fractional number) that can be positive, negative, or zero (-5, 1, 5, 8, 97, 3243)
Location: GPS latitude and longitude coordinates
Short String: can contain any sequence of characters limited to 32 characters
If this is chosen, make sure that your data will not extend beyond 32 characters or you will encounter an error when uploading data.
TimeStamp: a seven part value representing a date and time by year, month, day, hour, minute, second
GUID: Global Unique ID
Unsigned Integer: often called units which are zero or positive numbers
Long Integer: longer than an integer
Float: a number that is not an integer, because it includes a fraction in decimal format
Double: can represent a fractional and whole values and can use exponential notation (1.0e6 to represent one million)
You can add or remove any of the column name fields.
After all Column Name fields have the preferred Data Type, select OK to create the Generic Table.
The new tab is then shaded in red to showthat it is now a table available in the Model database.
Three new fields also show: Created By, Created On and Property ID.
The following step-by-step walks you through how to add information to the generic table.
Open Excel and log in.
Under the InEight tab in the Data section, select Table.
Under Existing Table, select the name of your newly created Generic Table, and then select Query All.
In the Identifier column or the Unique ID, fill in the data from the model.
The new information is then highlighted in yellow. This shows that the information has been added or modified but not yet saved to the database table.
Under the InEight tab in the Settings section, click Pending Changes.
Click Publish.
The database table is now updated.
Fill in any additional data throughout the project as needed.
The following step-by-step walks you through how to import information into the generic table.
Open Excel and log in.
In Excel, select the spreadsheet tab containing the preferred data that needs to be uploaded into a table.
Under the InEight tab in the Data section, select Import.
In the Import Records dialog box, select the Table schema that you want to upload data into.
When a warning dialog box appears, select OK.
The Generic table opens with the new data added.
Under the InEight tab in the Settings section, select Pending Changes.
Click Publish.
The database table is now updated.
Throughout the project, data might be updated by another user without notification that an update is happening. You need to refresh your table to see new information.
The following step-by-step walks you through how to refresh existing table data.
The following step-by-step walks you through how to close database tables.
Open Excel and log in.
Right-click the Excel spreadsheet table tab.
Select Delete.
Deleting the table tab only removes the local worksheet from Excel, but it does not remove database tables from your project.
You can also click the x in the top right of Excel. The InEight Excel Plugin dialog box opens showing available options.
Additional Information
9977 N 90th Street, Suite 250 Scottsdale, AZ 85258 | 1-800-637-7496
© 2024 InEight, Inc. All Rights Reserved | Privacy Statement | Terms of Service | Cookie Policy | Do not sell/share my information