Downloading a New Table

!Prerequisites:
1. Connecting TAD to the Server

In order to use any of the Table Actions on the ribbon, first you need to download the Table that you want to work with.

1. Start by clicking the Add Table button on the ribbon.

2. That will open the TAD Query Editor form starting on the From view showing the available tables.

3. In the Search Tables box, type “TAD Sandbox” to filter the list.

4. Select the table and the Save Changes and Cancel Changes buttons will appear. Click the Save Changes button.

*Other ways to select the table:
1. Double-clicking on the table will save it and take you to the Query view bypassing the Save Changes button.
2. Selecting the table and pressing your Enter key will save the table to the TAD Tab and start the Download action.

5. You will now be on the Query view where you will see the Tab Name and basic SQL Statement.

6. Change the Tab Name to “My Sandbox” and click the Download Changes button to download the Table.

7. The TAD Parameters form should now appear showing your Tab Name and the (Companies) parameter.

*Parameters surrounded by parentheses, such as (Companies), can accept multiple values separated by commas. For example, entering “1,2,3” for (Companies) would download data for all three.

8. Most parameters have an associated lookup. To access the lookup either double-click in the parameter field or click in the field and press your F4 key.

9. The TAD Lookup form appears providing a list of Companies.

*Month and Date parameters will display the TAD Calendar form instead of TAD Lookup form.

10. You can filter the list by using the Column and Search fields. Entering “0” into the Search field filters the lookup list.

11. Select Company 0 for the TAD Sandbox Company and click the Save button. You can also double-cliick on values to select them.

*You can also use your Ctrl key to select multiple values for any parameters that are surrounded by parentheses, such as (Companies).

12. That will populate the (Companies) parameter with the value of 0.

13. Click the Download button to download the Table.

14. The TAD Progress form should now appear showing you the status of the Download action. When the download finishes the form will show you if it was successful or failed.

15. You should now be on the My Sandbox tab and it should be green.

*When an Action finishes the tab will be green if successful and red if it failed.

16. The My Sandbox tab should look like the image below.

The main parts of the download are:

17. There are also Groups on the sheet that allow you to collapse/expand certain rows/columns.

The three group options are:

• Columns A – B are part of the Saved Parameters group
• Columns D – G are part of the TAD Columns group
• Rows 1 – 8 are part of the Column Properties Table group

*Each group has an option that will collapse the group automatically when downloading.

18. To download the table again, you have two options:

Option 1 – Using Download Button on Ribbon

Option 2 – Using Download Action Button

When you use this button you will be prompted with the message below. Click Yes to download the Table again with the same parameters or No to enter them again.