--- title: "Adding File Import Replications" slug: "adding-file-import-replications" updated: 2026-11-16T14:33:51Z published: 2026-11-16T14:33:51Z canonical: "skthelp.syniti.com/adding-file-import-replications" --- > ## Documentation Index > Fetch the complete documentation index at: https://skthelp.syniti.com/llms.txt > Use this file to discover all available pages before exploring further. # Adding File Import Replications You can import data from flat files using Syniti Drive as the source datastore and an SKP Catalog System as the target datastore. In File Import replications, you can also perform field mappings, similar to the way you would map fields when customizing the target table configuration based on the file. To create file import replications: 1. In the Targets panel, select the required SKP Catalog System as the target datastore. 2. In the Sources panel, select the required Syniti Drive as the source datastore. 3. In the Replications panel, click the **Add Replication** (**+**) button. The New Replication dialog box is displayed. 4. In the Sources section, select the required file available from the Files list. > [!NOTE] > Note > > - To see which file formats are supported for import operations, refer to the [File Replications](/v1/docs/sources-and-targets#file-replications) section. > - A maximum of 10,000 files can be searched when selecting files for replication. > - Upon selecting a file, the interface displays format-specific fields tailored to parse data from that file type. For example, to parse a .csv file, enter the following details: | Field Name | Description | | --- | --- | | Delimiter | Defines the character used to separate values in the file. Default is comma (`,`). See [Supported Delimiters](/docs/adding-file-import-replications#supported-delimiters). | | Encoding | Specifies the text encoding used in the file to ensure special characters are read properly. Default encoding format is UTF-8. | | Header Row | Indicates which row (by index) in the file contains the column names. For example, set to 0 if the first row contains the headers. | | Column Names | Specify the column names that match the destination columns using the following format: `["Column1", "Column2", "Column3"]`. New columns will be created if the specified columns do not exist. | 5. In the Target section, the selected target datastore is displayed. Complete the following steps: 1. In the Target Name field, enter the table name corresponding to the source table name. 2. To replicate by dropping and recreating the table instead of truncating the data, turn on the **Drop Target Table** toggle. > [!NOTE] > Note > > Ensure that the Append Mode toggle is disabled when using Drop Target Table during replication. Replication will fail if both toggles are enabled. 6. In the Additional Properties section, complete the following steps: 1. To specify higher preference for this replication over others, enter a priority value in the Priority field. Note The replications will be ordered and executed using the Priority value. By default, the value for each replication is set at 1000, which provides equal preferences for all replications, but ordered using the creation time of a replication. 2. To replicate data without truncating data in the target table, turn on the **Append Mode** toggle button to append new data from the source table. 3. Select **Pre-Execution** and **Post-Execution Workflows** to run if this replication is integrated with other module’s tasks in an Orchestrate workflow. 7. Click **Save**. #### Importing a Multi-Worksheet Spreadsheet When importing an Excel spreadsheet with multiple worksheets, Replicate Preview lets you choose to import either all worksheets or only the ones you need. A separate replication is created for each worksheet using this naming format: `SpreadsheetName_WorksheetName`. After the replications are created, you can edit each one to adjust the Header Row and Column Names field properties to ensure the data imports correctly. #### Supported Delimiters | Delimiter Type | Supported Value | Common use | | --- | --- | --- | | Comma | `,` | Standard CSV format (default) | | Semicolon | `;` | CSV in European locales | | Tab | `\t` | Tab-separated values (TSV) files | | Pipe | `\|` | Flat-file and EDI exports | | Tilde | `~` | EDI and legacy mainframe data | | Caret | `^` | Fixed-width or structured exports | | Multi-character | `\|\|` | Any multi-character printable non-whitespace string | The following delimiters are not supported: - Space ` ` - Carriage return `\r` - Newline `\n`