Actions

Assets - Tables

From VersaVision Support


Tables-Button-No.png

OVERVIEW

Tables is an area where users can create customized tables to store data. These tables can be used for a number of different options. Examples would be Part Numbers, Materials, Employee Names, etc.
The Advantages to this repository is to allow the user to easily update existing images in one place. Any updates made to the files here will automatically reflect in any application that is using/accessing the files.


NAVIGATION

Access Tables by selecting the Assets icon from the Applications Quick Menu or by selecting the Menu icon from the Home Page. Once Assets is selected, click on the Tables option.
Assets-Tables-Home.png


TABLES                                                                                                      

      Add        |       Edit        |       Copy        |       Delete       

DATA                                                                                                         

   Add     |    Export     |    Import     |    Return to Assets   


ADD A TABLE

To Add a New Table select the Add New button at the top right of the page next to the Search field.
Asset-Tables-2.png

A New Table properties section will show on top of the Tables list.
Asset-Tables-3.png

A Table Name will need to be setup first. Click in the Name field and enter a Name for the table.
Asset-Tables-4.png

The SQL Name field will automatically populate based on the Table Name entry.
Asset-Tables-5.png

Click on the Description field and enter a description for the Table if needed. This description will show on the Tables List.
Asset-Tables-6.png

The Next step in the process is to setup the columns needed for the Table. By default, there is a Key field already added. The data in this cell is what will be used when a command is created to look up data from the table. This field is setup as a Primary Key.
An example of this would be Employee ID is the Key (Primary Key) the second column would be added for Employee Name. The system would look for the Employee ID then return the Employee Name.
The Primary Key cannot have the duplicate data, each one must be unique.
Click in the Column Name field and enter a Name for the column in the table. Leave the Primary Key switch toggled. Our example will show the Employee ID/Name table used above.
Asset-Tables-7.png

The SQL Name field will automatically populate based on the Column Name entry.
Asset-Tables-8.png

Click on the Description field and enter a description for the Column if needed. This description will show when editing the Setup/Definition of a Table.
Asset-Tables-9.png

The Type field is used to define what type of data will be stored in the Column. There are multiple options available when the down arrow is selected. Select the appropriate Type - the example here will be Integer.
Asset-Tables-10.png
Text - any combination of characters/text can be entered into this cell.
Integer - only a number can be entered into this cell.
Boolean - the cell can only be on or off.
Decimal - the cell can accept a number with decimal places.
Date/Time - only a date and time combination can be entered into this cell.
Date - only a date can be entered into this cell.
Time - only a time can be entered into this cell.
Identity - this is a number that will be automatically entered when new data is added to the table.

The Allow Nulls toggle will not be accessible on a Primary Key. A Primary Key must have a value.
Asset-Tables-11.png

Click on the Add Column button at the top of the New Table window. Generally, a table will need more that 1 Column.
Asset-Tables-12.png

The New Column properties will appear below any other Columns. Click in the Name field and enter a name for the column.
Asset-Tables-13.png

The SQL Name field will automatically populate based on the Column Name entry.
Asset-Tables-14.png

For this example, the Primary Key toggle is in the Off position. This table will use the Employee ID as the primary key.
Asset-Tables-15.png

Click on the Description field and enter a description for the Column if needed. This description will show when editing the Setup/Definition of a Table.
Asset-Tables-16.png

The Type field is used to define what type of data will be stored in the Column. There are multiple options available when the down arrow is selected. In this example the Text option is being used.
Asset-Tables-17.png
Text - any combination of characters/text can be entered into this cell.
Integer - only a number can be entered into this cell.
Boolean - the cell can only be on or off.
Decimal - the cell can accept a number with decimal places.
Date/Time - only a date and time combination can be entered into this cell.
Date - only a date can be entered into this cell.
Time - only a time can be entered into this cell.
Identity - this is a number that will be automatically entered when new data is added to the table.

Toggle the Allow Nulls switch to On (Allow) or Off (Not Allow). If there is a need for the cell to be blank, contain no data, turn the switch On. In this example, the switch is Off as there will always be a Employee Name associated with an Employee ID.
Asset-Tables-18.png

If additional Columns are required, click on the Add Column button.
Asset-Tables-19.png

Once all of the Columns have been created, click on the Save button next to the Add Column button.
Asset-Tables-20.png

Select the "X" next to the Save button to close the Table properties window and return to the Tables list.
Asset-Tables-21.png

The Table that was setup will now show in the Tables List.
Asset-Tables-22.png


TABLES                                                                                                      

      Add        |       Edit        |       Copy        |       Delete       

DATA                                                                                                         

   Add     |    Export     |    Import     |    Return to Assets   


EDIT A TABLE

To Edit the setup of a Table (Name, Columns, Description, Type or Nulls) click on the 3 dot menu to the right side inline with the Table name.
Asset-Tables-23.png

On the pop-up menu select the Edit Definition option.
Asset-Tables-24.png

Click in the Table Name field to change the name.
Asset-Tables-25.png

Click in the Description field to change the description of the table.
Asset-Tables-26.png

Click on the Column Name to change the name.
Asset-Tables-27.png

Click in the Column Description to change the description of the column.
Asset-Tables-28.png

Click on the Type down arrow to change the column type.
Asset-Tables-29.png

Click on the Primary Key toggle to turn it On or Off. We suggest that you do not turn off an field that is already set as the primary if you have entered data into the table.
Asset-Tables-30.png

Click on the Allow Nulls toggle to turn it On or Off for columns that are not primary key's.
Asset-Tables-31.png

Click on the Add Column button to add additional Columns to the table.
Asset-Tables-32.png

To Remove an existing Column from the table, click on the 3 dot icon on the right side of the Column cell.
Asset-Tables-33.png

Select the Delete option from the pop-up menu. Then will NOT be any warning message, the column will automatically be removed.
Asset-Tables-34.png

Once all changes have been made to the Table, click on the Save button next to the Add Column button.
Asset-Tables-35.png

Close the Edit Table window by clicking on the "X".
Asset-Tables-36.png


TABLES                                                                                                      

      Add        |       Edit        |       Copy        |       Delete       

DATA                                                                                                         

   Add     |    Export     |    Import     |    Return to Assets   


COPY A TABLE

To create a Duplicate/Copy of an existing Table, click on the 3 dot menu to the right side inline with the Table name.
Asset-Tables-45.png

A pop-up menu will appear - select the Duplicate option.
Asset-Tables-46.png

A Copy Table window will pop-up. The Table Name will show the Table you copied plus COPY. We suggest you change the Name of the table.
Asset-Tables-47.png

Edit any of the Column fields required. Once all of the changes have been made, click on the Save button.
Asset-Tables-48.png

Close the Copy Table window by clicking on the "X".
Asset-Tables-49.png

Then Duplicated/New Table will show in your Tables List.
Asset-Tables-50.png


TABLES                                                                                                      

      Add        |       Edit        |       Copy        |       Delete       

DATA                                                                                                         

   Add     |    Export     |    Import     |    Return to Assets   


DELETE A TABLE

To Delete/Remove an existing Table, click on the 3 dot menu to the right side inline with the Table name.
Asset-Tables-51.png

Select Delete from the menu.
Asset-Tables-52.png

A warning message will appear on the screen. Select Delete to remove the Table or select Cancel to keep the Table.
Asset-Tables-53.png

If you have selected to Delete the Table, it will no longer show on your Tables list.
Asset-Tables-54.png


TABLES                                                                                                      

      Add        |       Edit        |       Copy        |       Delete       

DATA                                                                                                         

   Add     |    Export     |    Import     |    Return to Assets   


ADD DATA TO A TABLE

Click on the Open button found on the right side of the Table Name in the Table list.
Asset-Tables-37.png

A new page will load showing the layout of the table. Click on the Add Row button in the top right corner of the page.
File:Asset-Tables-38.png|link=Assets - Tables

A New Record menu will pop-up. All Columns setup in the Table will show as fields. Click in the 1st field and enter the required information.
Asset-Tables-39.png

Select the next field and enter the required information.
Asset-Tables-40.png

Repeat the process to enter information into all required fields. Once all required fields are filled out, click on the Save button to save the record/data to the Table.
Asset-Tables-41.png

Close the New Record window by clicking on the "X".
Asset-Tables-42.png

The information that you entered will now appear in the Table.
Asset-Tables-43.png

Repeat the process to add additional information to the table. Once all information has been entered and saved, click on the "X" at the top right of the page to close the window and return to the Table list page.
Asset-Tables-44.png


TABLES                                                                                                      

      Add        |       Edit        |       Copy        |       Delete       

DATA                                                                                                         

   Add     |    Export     |    Import     |    Return to Assets   


EXPORT TABLE DATA

To Export the Table and Data, click on the 3 dot menu to the right side inline with the Table name.
Asset-Tables-55.png

Select Export Data from the menu.
Asset-Tables-56.png

Select the format or document type required. Options are a "CSV" file or "Excel" file.
Asset-Tables-57.png

The file will download automatically to your default web browser download location. At the bottom left side of the page you will see a file status icon.
Asset-Tables-58.png


TABLES                                                                                                      

      Add        |       Edit        |       Copy        |       Delete       

DATA                                                                                                         

   Add     |    Export     |    Import     |    Return to Assets   


IMPORT TABLE DATA

To Import data to an existing Table, click on the 3 dot menu to the right side inline with the Table name.
Asset-Tables-59.png

Select Import Data from the menu.
Asset-Tables-60.png

A File Explorer window will automatically open. Navigate to the CSV or Excel file containing the Table Data - double click on the file.
Asset-Tables-61.png

The Import Data window will show the file selected under the Change File button.
Asset-Tables-62.png

If the wrong file was selected, select the Change File button to reopen the File Explorer.
Asset-Tables-63.png

There are 2 Import Options available - "Delete Existing Records" or "Update Existing Records". Select the appropriate option.
Asset-Tables-64.png
Delete Existing Records - selecting this option will remove all current data in the table and replace it with the data in the file selected.
Asset-Tables-65.png
Update Existing Records - selecting this option will keep all current data and add the data in the file selected.

Select Import to Delete or Update the data in the table. Select Cancel to not make any changes to the Table data.
Asset-Tables-66.png

A green message window will appear on the screen when the data has been uploaded.
Asset-Tables-67.png


TABLES                                                                                                      

      Add        |       Edit        |       Copy        |       Delete       

DATA                                                                                                         

   Add     |    Export     |    Import     |    Return to Assets   


VC Footer.png
Follow Us On LinkedIn View our Blog