3.12.2 Loading Files From Other Data Sources
In order to load file definitions, you must search existing data sources and select the file name from the list of files located. Your search will include:
Connect to Database
Mandatory.
Select the database from the list provided.
Note: Some data sources can only be searched once you have supplied a valid User ID and Password in a Connect to Database dialog.
If the MS Access Database data source is selected, a Select Database dialog will be displayed. It is similar to a standard Windows File Open dialog.
Full or partial table name
Specify the full name or part of the file name to be found. Note that this edit box is case-sensitive, and that no results will be found if the case entered does not match the case of your table names.
If no full or partial physical file name has been specified all files in the data source will be listed in the search results. If the data source contains many files, the search results may take some time to be displayed.
Search Results
Once the search criteria have been specified, and the Find button has been pressed, a list of matching tables will be displayed.
Each table displayed in the search results list includes:
- A check box. Select the check box to load the table definition. The Select All, Deselect All and Invert Selection buttons at the bottom of the form can be used for managing multiple selections.
- A green tick or red cross, indicating whether or not its definition has been previously loaded into the repository.
Selected tables are loaded by clicking the 
Load button on the toolbar. Prior to the load being performed, the Load Options dialog will be displayed. Refer to 3.12.4 Other Data Sources Load Options for more information.
If warning or error messages are generated by the load process, a warning or error triangle will be displayed adjacent to the table's check box. Click on the triangle to view the messages.
Note that warning and error messages for all selected tables, as well as those messages that may not be specific to a particular table, are accessible by clicking the inverted triangle that appears adjacent to the Search results text, above the list of tables.
Load messages can also be displayed by clicking the 
Messages button on the toolbar. From the resultant dialog, the text can be copied and then pasted elsewhere. This can be useful if you need to contact LANSA Support about a loading issue.
Once a table definition has been loaded, its repository definitions can be previewed by selecting the table and clicking the 
Preview button.
If no error messages have been generated by the validation process, the 
Save button will be enabled. Click it to save the selected table definitions to the LANSA repository.
Note that, by changing the selection of tables in the Search results, the Save button will be disabled and the load must be performed again.
Also See
Load Other Files in the