ODBC text setup: Difference between revisions
No edit summary |
m (Add missing words) |
||
| Line 4: | Line 4: | ||
In this window we need to set several items: | In this window we need to set several items: | ||
{{ScreenElementDescription|Data Source Name|This just a name for the setup you are making, name this Radimation, or another descriptive name for the used database}} | {{ScreenElementDescription|Data Source Name|This is just a name for the setup you are making, name this Radimation, or another descriptive name for the used database}} | ||
{{ScreenElementDescription|Select Directory...|Allows to select the directory in which the text based database files are stored}} | {{ScreenElementDescription|Select Directory...|Allows to select the directory in which the text based database files are stored}} | ||
{{ScreenElementDescription|Use Current Directory|Overrules the selected directory to use the current directory. It is best to turn this checkbox off, and select a specific directory by using the {{ScreenElement|Select Directory...}} button}} | {{ScreenElementDescription|Use Current Directory|Overrules the selected directory to use the current directory. It is best to turn this checkbox off, and select a specific directory by using the {{ScreenElement|Select Directory...}} button}} | ||
| Line 13: | Line 13: | ||
Select the file you want to use, check the {{ScreenElement|Column Name Header}} checkbox and select the format. | Select the file you want to use, check the {{ScreenElement|Column Name Header}} checkbox and select the format. | ||
Press {{ScreenElement|Guess}} button to see if the column headers from your database are set correctly. | Press the {{ScreenElement|Guess}} button to see if the column headers from your database are set correctly. | ||
In the screenshot above the columns are not set correctly. The .csv file format is different, to solve this press the {{ScreenElement|Format}} combobox and select {{ScreenElement|Custom Delimited}}. Insert ';' in the delimiter textbox and press {{ScreenElement|Guess}} again. | In the screenshot above the columns are not set correctly. The .csv file format is different, to solve this press the {{ScreenElement|Format}} combobox and select {{ScreenElement|Custom Delimited}}. Insert ';' in the delimiter textbox and press {{ScreenElement|Guess}} again. | ||
Latest revision as of 12:54, 10 February 2025
The ODBC text setup dialog is used to configure the ODBC driver for a text based database.
In this window we need to set several items:
 Data Source Name
|
This is just a name for the setup you are making, name this Radimation, or another descriptive name for the used database |
| Select Directory...
|
Allows to select the directory in which the text based database files are stored |
| Use Current Directory
|
Overrules the selected directory to use the current directory. It is best to turn this checkbox off, and select a specific directory by using the Select Directory... button |
| Extensions List
|
Shows a list of filename extensions which will be used to determine the correct text files. Remove *.asc and *.tab from the extentions list |
| Define Format...
|
Will show the Define Text Format dialog, which can be used to define the format of the database as it is maintained in the text file |
Select the file you want to use, check the Column Name Header checkbox and select the format. Press the Guess button to see if the column headers from your database are set correctly. In the screenshot above the columns are not set correctly. The .csv file format is different, to solve this press the Format combobox and select Custom Delimited. Insert ';' in the delimiter textbox and press Guess again.
Now everything is set correctly, close all windows by pressing the Ok button on every window. Once the ODBC Data Source connection is correctly configured, the configuration of the customer database in RadiMation® can be performed.