Data Management Process

Use import to add or update database rows, and export to remove or extract them.

Import process overview

When importing a file, Transtream first looks for an existing row to update. If not found, a new row is created; otherwise, an existing row is updated. If a row cannot be identified, you'll be notified with an error. As part of the import process database mappings are created automatically for you. They can be then amended or removed, if necessary. If you want to cancel a mapping you are currently editing, press your Esc button.

Export process overview

When exporting a file, Transtream tries to locate the file based on its location, entity name and any filters applied during the export process to help identify the data.

How rows are identified

Rows are identified through Keys. Each Transtream entity (database table) includes ID columns identified as primary keys, which are not generally exposed. This is the first key type that import/export process uses for identification. If no Primary Key is identified, the process will then look for an alternative primary key - other rows from the table that can be used to identify it. If none are found, a foreign key will be used for identification. Foreign keys are related database table rows. See Database to view the entities and their keys.

Options

As part of the import/export process, specify:

• Whether to save the import/export as a template.
• Whether to enable email notifications.
• The type of delimiter you wish to use in your file.