Lookup Tables

DCAPP - Others - Lookup Tables

Here you can set an array or matrix of data that contains items that are searched and used in the applications.

It allows, when loading a previous file with valid information, to check whether an article exists or not in the database when reading or introducing it using one of the applications.

• Add - Clicking on the button you can add a lookup table.

In the central part of the screen, you can view a list with the tables that have already been associated for use with the applications.

Edit Table

When you want to add a lookup table to the application, the system asks a set of questions that facilitate the import of the table (file) and its correct use in the system. In addition to adding this option, you can also edit a lookup table already introduced.

Thus, the screen appears divided into three tabs:

Tab - Table

In this tab the options are:

• Table Name - Where you can name the table. This is the name that will appear in the lookup table list on the previous screen.

• Checkbox - Where you can define if the table is active or not to be used with the apps.

It is advisable to give the name of the table equal to the name of the file to be imported.

Tab - Fields

When you click on the screen, as suggested, a small window appears that asks us to enter the name of the field. Then just click on "Accept" and it is entered.

Tab - Parameters

In this tab the options are:

• Field Separator - Choose the type of tab for the application to check when importing the table. These can be: comma, semicolon, vertical bar and TAB.Choose the type of tab for the application to check when importing the table. These can be: comma, semicolon, vertical bar and TAB.

• EOR - End of Record. It is the character or characters used to indicate the end of registration.The available options are:

  • CR – Carriage Return (ASCII code 13)

  • LF – Line Feed (ASCII code 10)

  • CR+LF – Carriage Return and Line Feed

• Ignore fist line - When importing data by choosing this option, the system ignores the first line of the file you are importing from.

• Path to files on server - Indication of the path to the file to be imported.

If this field is not filled in, the application informs (also accessible through the icon on the side):

If empty writes value in the root of the synchronization folder.

• File Name - File name indication to import. If you have already defined the data import method in the synchronization methods (access it better here), then the application will access this method to import the file. If you put the same name in the table for the file (as advised above) then the system quickly identifies the file.

The file type, by default, is .csv. However, you can use a .txt file. To do this, by clicking on the file name, you can change the extension that appears by default.

At the end of the settings, and before leaving this area, it is necessary to click on "Save" which is at the top right of the screen.

Adding

After creating a search table in the application, it will appear on the previous screen, as shown in the image below.

As you can see, it is active and has two icons on the right to access the data in the table and delete it.

To edit the entered lookup table, double-click on its name. If you want to check the data entered, just click on the icon with a table on the right to access the data.

After this task the table is ready to be used.

Using

To use the lookup tables, after it is associated as shown here, you will need to access the application management (see more here) and in the specific fields associate the lookup table.

The fields that can be configured are on the "Field" tab.