> For the complete documentation index, see [llms.txt](https://community-test.logicnets.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://community-test.logicnets.com/release-9/platform-documentation/data-and-data-tables/import-definition-from-existing-table.md).

# Import Definition from Existing Table

With this option users can import into the Designer a table from an external database, allowing LogicNets database parts to perform read-write operations on these external tables. To import an existing external table, the user must do the following:

1. From within the project/data folder click the 'New table' function. ![](https://2802811211-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FdFhfexCjZ5JMhwGzzywq%2Fuploads%2Fgit-blob-d0f7b45697ad34d120aa4c2b27fd79d421e8a40f%2Fb323c6a8-22ba-4b54-ad37-5d6b84507fa4.png?alt=media)
2. From the data main panel select *Import definition from existing table* from the 'Mode' dropdown menu. ![](https://2802811211-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FdFhfexCjZ5JMhwGzzywq%2Fuploads%2Fgit-blob-d952726a4310c5ee95a92786eba28cfc95ab306b%2F0820655f-a6c1-4447-88a9-6d1a5f99a095.png?alt=media)
3. Enter the name for the table as it will be identified in the Designer in the 'Table name' field.
4. In the 'Table name in external DB' field enter the name of the external table.
5. Click *add* to complete the operation. ![](https://2802811211-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FdFhfexCjZ5JMhwGzzywq%2Fuploads%2Fgit-blob-934b3041d24b17d39c21edf04aaa59ae7c030ec7%2Fb27ecb19-d78e-42e2-b6fa-cd3dc66cd110.png?alt=media)

Note: Users must configure the 'Source' options in the company configuration file. Initial configuration provides for *data*, which is a standard, local SQLite database. System administrators can set up other databases, however, which will then appear in the 'Source' dropdown menu.

To configure additional databases, to to the company settings configuration file (*logicnets/dat/bnt/COMPANYNAME/settings.cfg*) and add the databases in the section called '\_context.LOGICNETS\_TABLES\_IN\_EXTERNAL\_DB'. Each entry must be a key-value pair that includes a caption and the name of the database. Note: For an ODBC-connected database the value must be the ODBC connection string to the database.

![](https://2802811211-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FdFhfexCjZ5JMhwGzzywq%2Fuploads%2Fgit-blob-cc1dfda404e3df85bd9f1d640dfe850a4613b85b%2F8cc25c71-84d2-42b7-a378-45efabfc1d7d.png?alt=media)


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://community-test.logicnets.com/release-9/platform-documentation/data-and-data-tables/import-definition-from-existing-table.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
