Tempo

Yes, you can control permissions as a group level in Tempo. First create the group in the Groups tab in the User Manager section. Click Add Group and select the user accounts you would like to add to the group. To add a permission to this group, it is the same process as adding a permission to a user account.

Yes, you can control permissions at a user level in Tempo. Once you are in the User Manager tab, navigate to the Permissions tab and click ‘Add Permission’ and click ‘Select User’ and choose the user you want to grant permission to and the table you want the permission to correspond to. Now choose which permissions you want to grant to this user and select Save.

To add a user in Tempo, navigate to the ‘User Manager’ tab on the left sidebar. Here you will see all the users in your instance of Tempo. To add a user using Microsoft Entra ID (Asure AD), click the ‘Add Account (Entra ID)’ button. To add a user with a local Tempo Username, click the ‘Add Account (Tempo ID)’ button.

To export data from Tempo into excel you can click the ‘Export’ button. You can decide to export all the data in the table or just the currently displayed rows. You can also export to an excel workbook or a csv file. Once these details are filled in, the export will be downloaded to your laptop.

There could be a few reasons why your import is failing. Please check the number of columns in your import file matches the number of columns in the table in Tempo. Check the spelling of each of the columns in your file and ensure they are spelt the same in the table in Tempo. Check the datatypes in your file match the correct data types in the table in Tempo

You can import CSV files into Tempo

To Import data into your table, click the ‘Import’ button in the top right corner of the table, click or drag to import your files. You will see the import process take place and once it is finished click ‘Refresh & Close’. Notice your data has been imported into the table.

To filter on a column, click the ‘Filter’ button. Choose which column you would like to filter on and outline the filter type and criteria. Once you decide this, click the ‘Apply Filter’ and you can see the filtering take place on the table.

To delete a row from a table, check the box of the row you want to edit and click the ‘Delete Row’ button in the top right corner of the table. You can also delete multiple rows at once if you check more than box, the process is the same once you click ‘Delete Row’. You will be prompted to confirm the delete action and once you do the selected records will be removed from the table.

To add a row to a table, click the ‘Add Entry’. Fill in the required fields and then click ‘Save & Add Entry’. Your record has now been added to your table.

To edit a row within a table, check the box of the row you want to edit and click the ‘Edit Row(s)’ button in the top right corner of the table. Now choose which column you want to edit and check the ‘Editable’ box. Make your changes and click ‘Save Changes’. You can also edit multiple rows at once if you check more than box, the process is the same once you click ‘Edit Row(s)’.

To set up a reference column in Tempo, click the ‘Table Settings’ button in the top right corner of the table. In the pop-up screen, click the Pencil on the column you would like to be your Reference Column, navigate to the ‘Special Column’ dropdown and select ‘Reference’. Click ‘Select Reference Table', choose your Reference Table, Display Column and Value Column and select ‘Apply Reference’. Now click the ‘Update Column’ button and ‘Save & Close’. Now your table has a reference column.

To add a primary key to a table in Tempo, click the ‘Table Settings’ button in the top right corner of the table. In the pop-up screen, click the Pencil on the column you would like to be your Primary Key, check the box in the ‘Primary Key’ column and select the ‘Update Column’ button. ‘Save & Close’ and now your table has a primary key.

To connect Tempo to your database, click the ‘Tempo Databases’ button on the left sidebar and navigate to ‘Databases List’. Click the ‘+’ icon. Name your database and then supply an ODBC Connection String which will allow Tempo to connect to your database. Verify the Connection and proceed to select the tables you want to have in your Tempo Database and click ‘Save’. Notice the database has been created in Tempo and your selected tables are in it.