Imports
Click here to see this page in full context

 Imports

Overview

The Engagement Data Platform allows you to import data into any table in your database. From the Import screen, you can configure various properties about the import process, such as what database fields to populate, and what business rules to apply upon import. These import properties can then be saved as a reusable asset called an Import Definition.

The Imports screen displays a list of Import Definitions in your account. For each Import Definition, the screen displays information about the last execution of this import, such as the number of records imported, failed, and skipped, the import file name, and the current status. For imports that are scheduled to run on a recurring basis, the screen also shows the next scheduled execution.

The Cheetah Learning portal provides access to a wide range of training videos on how to use Cheetah Digital's products. Click here to view a training video on how to use Imports. Please note that you must have a free Cheetah Learning user account in order to access this video.  

Access

To access the Imports screen, select Integrations from the Main Navigation Menu, then select Imports from the Sub-Category menu.

Additional Resources

Features

The Imports screen provides the following features related to managing your Import Definitions:

 Searching and Sorting

Click hereClick here

Search

The search feature allows you to search for a specified text string anywhere within Import Definition's resource (i.e., the destination table), display name, or internal name.

  1. Optionally, in the search field near the top of Imports screen, enter the desired text string.

  2. Press Enter, or click the search button (magnifying glass icon).

  3. The Import screen is refreshed to show only the Import Definitions that meet your search criteria.

  4. To remove all search criteria, click the remove button ("X" icon).

Sort

The "Sort" drop-down menu allows you to sort the Import Definitions on a variety of different fields. To sort the list of Import Definitions, select the desired sort option from this menu.

  • Created Date (default)

  • Updated Date

Navigation

Once you've found the desired Import Definition, you can navigate to the following other screens:

  • Click the name of the desired Import Definition to navigate to the Import Definition Details screen.

  • Click the user name in the "Updated By" column to navigate to the Admins screen for that user.

 

 Create a New Import Definition

Click hereClick here

To create a new Import Definition:

  1. Optionally, from the "Select Business Unit," select a Business Unit to which this Import Definition applies. 

  2. From the "Select Table" drop-down menu, select the table into which this Import Definition will write or update data.

  3. Based on what you selected above in step 2, you may see an additional drop-down menu:

  • Activity: Select an Activity Type.

  • Custom Object: Select a Custom Object table. 

  1. Enter the Display Name value for the new Import Definition.

  2. Click create to display the Import Definition Details screen, where you can configure the Import Definition properties.

 

 View or Edit an Import Definition

Click hereClick here

To view or edit the details of an Import Definition:

  1. Search, sort, or filter the Imports screen as described above.

  2. Click on the desired Import Definition name. Or optionally, click the Edit icon within the Action column.

  3. The Import Definition Details screen is displayed and populated with all of the information about this Import Definition.

 

 Execute an Import Definition

Click hereClick here

Import Definitions can be scheduled to run on a one-time or recurring basis. You can also manually execute an Import Definition as follows:

  1. Search, sort, or filter the Imports screen as described above.

  2. Within the "Action" column click the Upload and Import File icon. A confirmation dialog box is displayed.

  3. Click confirm.

 

 

 Delete an Import Definition

Click hereClick here

To delete an Import Definition:

  1. Search, sort, or filter the Imports screen as described above.

  2. Within the "Action" column, click the Delete icon. A confirmation dialog box is displayed.

  3. Click confirm.

 

 

 Copy an Import Definition

Click hereClick here

The platform allows you to copy an Import Definition to use as the basis for a new Import Definition. To copy an Import Definition:

  1. Search, sort, or filter the Imports screen as described above.

  2. Within the "Action" column, click the Copy icon.

  3. The system creates a new Import Definition and displays the Import Definition Details screen. The default name of the new Import Definition is the name of the original Import Definition, followed by an incremental counter, such as "(1)."  

 

 

 Download Log Files

Click hereClick here

The import process generates various log files, which can be downloaded from the Imports screen:

  1. Search, sort, or filter the Imports screen as described above.

  2. Within the "Action" column, click the Download icon for the desired log file:

  • EDP Log

  • Transofrmation Errors

  • Skipped Records

 

 

 Back to Integrations Overview

Last Updated: April 2022

 

© Cheetah Digital    Engagement Data Platform Online Help 22.0  April 2022