### VideoLinkWithStartTimeAndThumbnail Template Syntax

Source: https://wiki.exocad.com/wiki/index.php/Template%3AVideoLinkWithStartTimeAndThumbnail

The template uses four parameters to define the link text, video ID, start time, and thumbnail image.

```wikitext
[[Image:{{{4}}}|272px|Tip|link=https://www.youtube.com/embed/{{{2}}}?start={{{3}}}&autoplay=1]]| {{{1}}}
```

--------------------------------

### Configure SQLSettings XML

Source: https://wiki.exocad.com/wiki/index.php?diff=14648&oldid=14141&title=DentalDB_Migrating_SQLite

Example of the SQLSettings XML structure required for DentalDB database configuration.

```xml
<DriverClass>NHibernate.Driver.SqlClientDriver</DriverClass>
</SQLSettings>
```

--------------------------------

### Convert DentalDB tables to utf8mb4

Source: https://wiki.exocad.com/wiki/index.php?action=edit&oldid=14647&title=DentalDB_Migrating_SQLite

Use these ALTER TABLE statements to convert existing tables to the utf8mb4 character set if it was not set correctly during initial setup.

```sql
ALTER TABLE dentaldb.CustomWorkDefinition CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE dentaldb.DependentOnNumericToothWorkParameters CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE dentaldb.DependentToothWorkParameters CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE dentaldb.NumericToothWorkParameter CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE dentaldb.TextualToothWorkParameter CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE dentaldb.ToothWork CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE dentaldb.ToothWorkParameters CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE dentaldb.Treatment CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE dentaldb.TreatmentValuedCustomInfo CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE dentaldb.TreatmentValuedParameters CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE dentaldb.ValuedMaterialParameters CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE dentaldb.WorkParamsInfoDentalShare CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE dentaldb.WorkParamsInfoLocal CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE dentaldb.WorkParamsInfoLocalImport CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE dentaldb.client_allowedImportedIds CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE dentaldb.clients CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE dentaldb.databaseInformation CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE dentaldb.laboratories CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE dentaldb.patients CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE dentaldb.technicians CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
```

--------------------------------

### MyiTero Connection Prompt

Source: https://wiki.exocad.com/wiki/index.php?diff=14367&oldid=14366&title=Setting_up_integration_between_iTero_Element_and_exocad

Initial prompt displayed when setting up the iTero integration.

```text
If you have a lab account, click **Connect to MyiTero as lab user**. Both options will redirect you to a login screen, where you can enter your MyiTero credentials:
```

--------------------------------

### Configure SQL Settings XML

Source: https://wiki.exocad.com/wiki/index.php?diff=14648&oldid=14637&title=DentalDB_Migrating_SQLite

Add the SQLSettings tag to the configuration file if it is missing.

```xml
<SQLSettings>
  ...
</SQLSettings>
```

--------------------------------

### Material Mapping Prompt

Source: https://wiki.exocad.com/wiki/index.php?diff=9650&oldid=9649&title=Setting_up_integration_between_MyiTero_and_exocad

Displays the prompt encountered when material mapping is ambiguous during case import.

```text
There is also an option (enabled by default) to make this choice the default for future imports of cases with the same material. In addition to the material, you can also chose the production method (e.g. 4-axis milling vs 5-axis milling), and save a default for this as well.
```

--------------------------------

### Configure MySQL/MariaDB in settings-db.xml

Source: https://wiki.exocad.com/wiki/index.php/DentalDB_Migrating_SQLite

Use this XML configuration block within settings-db.xml to define the connection string and driver settings for MySQL or MariaDB.

```xml
<SQLSettings>
     <ConnectionString>Server=localhost;Database=dentaldb;User ID=test;Password=somepass</ConnectionString>
     <SQLDialect>NHibernate.Dialect.MySQLDialect</SQLDialect>
     <DriverClass>NHibernate.Driver.MySqlDataDriver</DriverClass>
     </SQLSettings>
```

--------------------------------

### Configure auto-import watch directory mode

Source: https://wiki.exocad.com/wiki/index.php?diff=17960&oldid=14355&title=Setting_up_integration_between_iTero_Element_and_exocad

Sets the import mode to watch the directory for new cases.

```xml
<ScanImport01WatchDirImportMode>Default</ScanImport01WatchDirImportMode>
```

--------------------------------

### Configure auto-import watch directory and delay

Source: https://wiki.exocad.com/wiki/index.php?action=edit&oldid=15254&title=Setting_up_integration_between_iTero_Element_and_exocad

These settings define the import mode and the sleep duration in milliseconds before the system attempts to import files from the watch directory.

```xml
<ScanImport01WatchDirImportMode>Default</ScanImport01WatchDirImportMode>
```

```xml
<ScanImport01SleepForMsBeforeImport>2000</ScanImport01SleepForMsBeforeImport>
```

--------------------------------

### Configure Windows Authentication

Source: https://wiki.exocad.com/wiki/index.php?diff=14638&oldid=14637&title=DentalDB_Migrating_SQLite

Use this XML configuration for connecting to SQL Server using integrated Windows security.

```xml
<SQLSettings>     <ConnectionString>server=MY_DENTAL_SERVER_PC_NAME\SQLEXPRESS01; database=dentaldb;Integrated Security=SSPI;</ConnectionString>     <SQLDialect>NHibernate.Dialect.MsSql2008Dialect</SQLDialect>     <DriverClass>NHibernate.Driver.SqlClientDriver</DriverClass>     </SQLSettings>
```

--------------------------------

### Configure SQL Server Authentication

Source: https://wiki.exocad.com/wiki/index.php?diff=14638&oldid=14637&title=DentalDB_Migrating_SQLite

Use this XML configuration for connecting to SQL Server using a specific username and password.

```xml
<SQLSettings>     <ConnectionString>server=MY_DENTAL_SERVER_PC_NAME\SQLEXPRESS01; database=dentaldb;user=test;pwd=somepass</ConnectionString>     <SQLDialect>NHibernate.Dialect.MsSql2008Dialect</SQLDialect>     <DriverClass>NHibernate.Driver.SqlClientDriver</DriverClass>     </SQLSettings>
```

--------------------------------

### Configure iTero Import Settings in XML

Source: https://wiki.exocad.com/wiki/index.php?diff=11502&oldid=11501&title=Setting_up_integration_between_iTero_Element_and_exocad

Required XML configuration settings for the settings-db.xml file to enable and manage the iTero auto-import feature.

```xml
<ScanImport01Enabled>1</ScanImport01Enabled>
```

```xml
<ScanImport01WatchDirImportMode>Default</ScanImport01WatchDirImportMode>
<ScanImport01SleepForMsBeforeImport>2000</ScanImport01SleepForMsBeforeImport>
```

--------------------------------

### Configure SQL Server Connection

Source: https://wiki.exocad.com/wiki/index.php/DentalDB_Migrating_SQLite

XML configuration blocks for connecting to SQL Server using either SQL Server Authentication or Windows Authentication.

```xml
<SQLSettings>     <ConnectionString>server=MY_DENTAL_SERVER_PC_NAME\SQLEXPRESS01; database=dentaldb;user=test;pwd=somepass</ConnectionString>     <SQLDialect>NHibernate.Dialect.MsSql2008Dialect</SQLDialect>     <DriverClass>NHibernate.Driver.SqlClientDriver</DriverClass>     </SQLSettings>
```

```xml
<SQLSettings>     <ConnectionString>server=MY_DENTAL_SERVER_PC_NAME\SQLEXPRESS01; database=dentaldb;Integrated Security=SSPI;</ConnectionString>     <SQLDialect>NHibernate.Dialect.MsSql2008Dialect</SQLDialect>     <DriverClass>NHibernate.Driver.SqlClientDriver</DriverClass>     </SQLSettings>
```

--------------------------------

### Configure SQL Server settings-db.xml

Source: https://wiki.exocad.com/wiki/index.php?action=edit&oldid=14647&title=DentalDB_Migrating_SQLite

Use these configuration blocks within settings-db.xml to connect DentalDB to a SQL Server instance using either SQL Server Authentication or Windows Authentication.

```xml
<SQLSettings>
<ConnectionString>server=MY_DENTAL_SERVER_PC_NAME\SQLEXPRESS01; database=dentaldb;user=test;pwd=somepass</ConnectionString>
<SQLDialect>NHibernate.Dialect.MsSql2008Dialect</SQLDialect>
<DriverClass>NHibernate.Driver.SqlClientDriver</DriverClass>
</SQLSettings>
```

```xml
<SQLSettings>
<ConnectionString>server=MY_DENTAL_SERVER_PC_NAME\SQLEXPRESS01; database=dentaldb;Integrated Security=SSPI;</ConnectionString>
<SQLDialect>NHibernate.Dialect.MsSql2008Dialect</SQLDialect>
<DriverClass>NHibernate.Driver.SqlClientDriver</DriverClass>
</SQLSettings>
```

--------------------------------

### SQL Server Connection Configuration

Source: https://wiki.exocad.com/wiki/index.php?diff=14648&oldid=8512&title=DentalDB_Migrating_SQLite

XML configuration block for connecting to a SQL Server instance using SQL Server Authentication.

```xml
<SQLSettings>
<ConnectionString>server=MY_DENTAL_SERVER_PC_NAME\SQLEXPRESS01; database=dentaldb;user=test;pwd=somepass</ConnectionString>
<DriverClass>NHibernate.Driver.SqlClientDriver</DriverClass>
</SQLSettings>
```

--------------------------------

### Configure MySQL/MariaDB settings-db.xml

Source: https://wiki.exocad.com/wiki/index.php?action=edit&oldid=14647&title=DentalDB_Migrating_SQLite

Use this configuration block within settings-db.xml to connect DentalDB to a MySQL or MariaDB database.

```xml
<SQLSettings>
<ConnectionString>Server=localhost;Database=dentaldb;User ID=test;Password=somepass</ConnectionString>
<SQLDialect>NHibernate.Dialect.MySQLDialect</SQLDialect>
<DriverClass>NHibernate.Driver.MySqlDataDriver</DriverClass>
</SQLSettings>
```

--------------------------------

### Create a Major Connector with a hole

Source: https://wiki.exocad.com/wiki/index.php/Partial_Framework_-_Major_Connector

Instructions for generating a connector featuring an internal void by selecting the outer and inner curves.

```text
For a Major connector with a hole in the middle, first click on the outline curve, then the inner curve where the hole should be, then click "Apply".
```

--------------------------------

### Configure SQL Server Authentication settings-db.xml

Source: https://wiki.exocad.com/wiki/index.php?diff=8515&oldid=8514&title=DentalDB_Migrating_SQLite

Use this XML configuration to connect DentalDB to SQL Server using standard database credentials.

```xml
<SQLSettings>
    <ConnectionString>server=MY_DENTAL_SERVER_PC_NAME\SQLEXPRESS01; database=dentaldb;user=test;pwd=somepass</ConnectionString>
    <SQLDialect>NHibernate.Dialect.MsSql2008Dialect</SQLDialect>
    <DriverClass>NHibernate.Driver.SqlClientDriver</DriverClass>
    </SQLSettings>
```

--------------------------------

### VideoLinkWithThumbnail Template Code

Source: https://wiki.exocad.com/wiki/index.php?action=edit&title=Template%3AVideoLinkWithThumbnail

This template creates a table layout containing a video thumbnail and a link to the YouTube embed URL.

```MediaWiki
<div style="border: 0px solid #000; background-color: #EEE; padding: 0px 0px 0px 0px; margin: 10px;" class="noprint"><table style="background-color: transparent;margin-bottom:0;"><tr><td style="border:none;width: 165px;">[[Image:{{{5}}}|140px|{{{2}}}|link=https://www.youtube.com/embed/{{{3}}}?start={{{4}}}&autoplay=1&cc_load_policy=1]]</td><td style="padding-left: 10px;border:none;vertical-align: middle;">{{{1}}} [https://www.youtube.com/embed/{{{3}}}?start={{{4}}}&autoplay=1&cc_load_policy=1 {{{2}}}]</td></tr></table></div><div style="clear: left"></div><noinclude>[[Category:Formatting Box]]</noinclude><br>
```

--------------------------------

### Set import delay in milliseconds

Source: https://wiki.exocad.com/wiki/index.php?diff=17960&oldid=14355&title=Setting_up_integration_between_iTero_Element_and_exocad

Defines the sleep duration in milliseconds before the system triggers an import.

```xml
<ScanImport01SleepForMsBeforeImport>2000</ScanImport01SleepForMsBeforeImport>
```

--------------------------------

### Enable iTero import feature

Source: https://wiki.exocad.com/wiki/index.php?action=edit&oldid=15254&title=Setting_up_integration_between_iTero_Element_and_exocad

Set this XML tag to 1 to enable the iTero import functionality within the DentalDB configuration.

```xml
<ScanImport01Enabled>1</ScanImport01Enabled>
```

--------------------------------

### Configure Windows Authentication settings-db.xml

Source: https://wiki.exocad.com/wiki/index.php?diff=8515&oldid=8514&title=DentalDB_Migrating_SQLite

Use this XML configuration to connect DentalDB to SQL Server using Windows Integrated Security.

```xml
<SQLSettings>
    <ConnectionString>server=MY_DENTAL_SERVER_PC_NAME\SQLEXPRESS01; database=dentaldb;Integrated Security=SSPI;</ConnectionString>
    <SQLDialect>NHibernate.Dialect.MsSql2008Dialect</SQLDialect>
    <DriverClass>NHibernate.Driver.SqlClientDriver</DriverClass>
    </SQLSettings>
```

--------------------------------

### Convert Existing Tables to utf8mb4

Source: https://wiki.exocad.com/wiki/index.php/DentalDB_Migrating_SQLite

SQL commands to retroactively convert existing database tables to utf8mb4 if the character set was not set correctly initially.

```sql
ALTER TABLE dentaldb.CustomWorkDefinition CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;     ALTER TABLE dentaldb.DependentOnNumericToothWorkParameters CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;     ALTER TABLE dentaldb.DependentToothWorkParameters CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;     ALTER TABLE dentaldb.NumericToothWorkParameter CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;     ALTER TABLE dentaldb.TextualToothWorkParameter CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;     ALTER TABLE dentaldb.ToothWork CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;     ALTER TABLE dentaldb.ToothWorkParameters CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;     ALTER TABLE dentaldb.Treatment CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;     ALTER TABLE dentaldb.TreatmentValuedCustomInfo CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;     ALTER TABLE dentaldb.TreatmentValuedParameters CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;     ALTER TABLE dentaldb.ValuedMaterialParameters CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;     ALTER TABLE dentaldb.WorkParamsInfoDentalShare CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;     ALTER TABLE dentaldb.WorkParamsInfoLocal CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;     ALTER TABLE dentaldb.WorkParamsInfoLocalImport CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;     ALTER TABLE dentaldb.client_allowedImportedIds CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;     ALTER TABLE dentaldb.clients CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;     ALTER TABLE dentaldb.databaseInformation CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;     ALTER TABLE dentaldb.laboratories CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;     ALTER TABLE dentaldb.patients CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;     ALTER TABLE dentaldb.technicians CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
```

--------------------------------

### Material Mapping Deletion

Source: https://wiki.exocad.com/wiki/index.php?diff=9650&oldid=9649&title=Setting_up_integration_between_MyiTero_and_exocad

Describes the behavior when deleting undesired material mappings in the settings menu.

```text
Undesired mappings can be deleted - you will be prompted for your preference again the next time you import a case with the respective material choice.
```

--------------------------------

### Set MariaDB/MySQL Character Encoding

Source: https://wiki.exocad.com/wiki/index.php?diff=14635&oldid=14141&title=DentalDB_Migrating_SQLite

Execute this SQL command to set the database character set to utf8mb4, ensuring special characters in fields like Notes are saved correctly.

```sql
ALTER DATABASE YourDatabaseName CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
```

--------------------------------

### MariaDB/MySQL Character Encoding Configuration

Source: https://wiki.exocad.com/wiki/index.php?diff=14648&oldid=8512&title=DentalDB_Migrating_SQLite

SQL commands to set or convert database character sets to utf8mb4 to support special characters.

```sql
ALTER DATABASE dentaldb CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
```

```sql
ALTER TABLE dentaldb.CustomWorkDefinition CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE dentaldb.DependentOnNumericToothWorkParameters CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE dentaldb.DependentToothWorkParameters CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE dentaldb.NumericToothWorkParameter CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE dentaldb.TextualToothWorkParameter CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE dentaldb.ToothWork CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE dentaldb.ToothWorkParameters CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE dentaldb.Treatment CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE dentaldb.TreatmentValuedCustomInfo CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE dentaldb.TreatmentValuedParameters CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE dentaldb.ValuedMaterialParameters CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE dentaldb.WorkParamsInfoDentalShare CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE dentaldb.WorkParamsInfoLocal CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE dentaldb.WorkParamsInfoLocalImport CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE dentaldb.client_allowedImportedIds CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE dentaldb.clients CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE dentaldb.databaseInformation CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE dentaldb.laboratories CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE dentaldb.patients CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE dentaldb.technicians CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
```

--------------------------------

### Set Database Character Encoding

Source: https://wiki.exocad.com/wiki/index.php/DentalDB_Migrating_SQLite

SQL command to set the database character set to utf8mb4, which is required to support special characters.

```sql
ALTER DATABASE dentaldb CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
```

=== COMPLETE CONTENT === This response contains all available snippets from this library. No additional content exists. Do not make further requests.