Start an import

The Start an Import page allows you to define and manage the settings for importing your Quable PIM content.

The page is divided into four sections::

Profile - Use with or without an import profile
Import File Format - The format of the import file
File Source - Location of the import file
Mapping - Instructions to match your import file content to your Quable PIM content

When you've completed the sections, click the Import Data button to start the import.

👍
Quable's powerful import functionality allows you to start imports from:

the Import Profiles page (via More actions), and

from the Start an import page (with or without an import profile)

There are two main scenarios for importing content into Quable PIM:

No Profile	With Profile
Typically used for one-time imports.	For recurring imports.

These scenarios are described in detail in the following sections.

No Profile

To start an import without an import profile, select Start an Import from the Data Flow sidebar menu and complete the following sections:

Import Identity

This section allows you to define the import and its settings.

Enter the following information:

Information	Description	Mandatory
Select a profile	Select No profile.	Yes
Object Type	The type of content the profile will import. Possible values: Assets Classification Document - when selected, a mandatory option to specify the type of document appears. Links - when selected, a mandatory option to specify the type of document appears. List of values Variants	Yes
Languages	The data language to import. Note: Only content for the translatable attributes in the designated language(s) will be imported, however attributes that can't be translated are taken into consideration (e.g., numbers). Example Your designated language is French and your import file includes translations in both French and another language. Only the French translations are imported, as well as any attributes that can't be translated (e.g., a price attribute with an number value).	Yes
Empty cell action	Defines the action to take if empty cells are encountered during the import operation. By default, empty cells are considered = 0. Possible values: Ignore - Empty cells in the import file are disregarded and any existing content (if updating objects) remains unchanged. Replace - Empty cells in the import file overwrites any existing content (if updating objects). Note: It's recommended to complete the columns with the correct values in order to avoid unintended consequences (e.g., set "active" to "1", so it isn't replaced by "0" and setting your content inactive.)	Yes
Save as profile	Import settings are not saved by default. Click the slide button to save the settings as a profile. When enabled, an entry area for the profile's name appears.	No

File Import Formats

🚧
Important Note

Files can only be imported one at a time.

Large files (more than 100 columns) may impact performance during import.

This section is used to specify the format and settings (if applicable) of your import file. Two options are available:

XLSX

Maximum File Size: 10MB
Maximum Number of Rows: None

🚧
Important Note
Mapping is required for .xlsx imports.

For .xlsx file imports, standard settings are used. You do not need to specify additional parameters.

CSV (Default)

Maximum File Size: None
Maximum Number of Rows: 200,000

👍
Good to Know
Mapping is optional for .csv imports.

For .csv file imports, you have two parameter options:

Standard: Standard settings are used. You do not need to specify parameters.
Custom: You must specify the following parameters (you can click on the link Fill with default values to automatically select default settings):
- Character Encoding (UTF-8)
- Column Separator (Comma, Semicolon (default), Tab)
- Date Separator (Space (default))
- String Identifier (Quotes (default), Apostrophe)
- Line Break Identifier (\n (default))
- Date Format (yyyy/mm/dd, dd/mm/yyyy (default))
- Time Format (hh:mm.ss (default))
- Multiple Values Separator (Vertical bar (default))
- Number Format (00.00 (default), 00,00)

File Import Source

This section allows you to specify the source (current location) of your import file.

You can click on the drag button to choose between the following options:

Local: The import file is on the computer you are using. You can drag and drop the file directly into the drop zone or click the Browse button to locate the file directory on your computer and select a file for import.
Remote: The import file is on a remote server.

Enter the following information for remote sources:

Information	Description	Required
Protocol	The protocol to use for the import. Possible values: http:// https:// ftp:// sftp:// Note: Media can only come from HTTP or HTTPS sources.	Yes
Folder Path	The full address of the import file directory.	Yes
Login ID	ID for connecting to the source containing the import file.	Yes
Password	Password to connect to the source containing the import file.	Yes

Once an import file is selected, immediate validation is performed to ensure the file is readable and matches the specified parameters.

👍
Once validation is complete, you can:

Analyze your file via the Analyze My File link (CSV files only), or

Immediately start your import. Column headers in the import file are assumed to correspond to the content in your Quable PIM. If not, you need to enable Mapping (see below).

Mapping

The section allows you to specify which columns of your import file correspond to the content in your Quable PIM.

❗️
When mapping is enabled, only the mapped columns are taken into account and imported.

Enabling the mapping option expands the section:

The expanded section is divided into three columns:

File Columns - This column is used to identify columns in your import file.
PIM Attributes - This column is used to designate the PIM attribute that corresponds to the file column.
Please note that only 500 attributes are displayed in this list. You can perform a search to find an attribute from this list or another attribute that is not displayed.
Object Attributes - The column contains all of the available properties for the selected object type.

To map your import file to your Quable PIM content, select attributes from the Object Attributes column and drag / drop them into the area below File Columns -> PIM Attributes.

🚧

Object Attributes outlined in orange are mandatory. An import can't be started if they're not selected.

All of the columns in your import file must be mapped to PIM attributes.

The columns of your import file should include correct values to avoid unintended consequences (e.g., set "Active" to "1", so it isn't replaced by "0" and setting your content inactive.)

You can modify the titles of the attributes under File Columns so that they correspond to the titles of the columns of your import file.