Data Model

The Data Model page allows you to import and/or export your data model (i.e., the organization of your data and the relationships between its various entities).

In a single .xlsx file, you can import or export the entire strucure of your Quable PIM content:

• Data Languages - The languages for creating and translating your production information.

• Objects and Attributes - The structure and organization of your product information.

• Attribute Sets - The groupings of information for different document types.

• Link Types - The relationships between Quable PIM objects.

Import

You can upload an .xlsx file of your data model by clicking the Import button. This opens a window to search your computer's file directory and select a file to import.

👍

Once your data model is imported, you can import your data.

Quable PIM without data model

If your Quable PIM does not have a data model defined, a warning is displayed alerting you to the fact that you are about to delete the default data model, objects, and collaboration settings. After entering the required confirmation message, click the Apply button to continue or the Cancel button to abort the import.

Quable PIM then deletes the default settings (this could take a few minutes). Once the deletion is completed, a window is displayed so you can select the file to import.

Checking the Overwrite files with the same name option replaces any existing files that have the same name as the file you want to import. The Cancel button becomes active once the Start button has been clicked. This allows you to stop the process (if necessary).

Click the Start button to import the file, the Remove All button to clear the list, or the Close button to abort the import.

Quable PIM with data model

❗️

IRREVERSIBLE ACTION

Importing a new data model into an existing instance permanently deletes the previous data model and content.

If your Quable PIM already has a data model defined, a warning is displayed alerting you that you're about to delete the existing data model, objects, and collaboration settings.

To ensure that you're aware of the serious implications this action will have, Quable PIM requires that you enter a confirmation message and click the Apply button in order to proceed with the import. You can click the Cancel button to abort the import.

Quable PIM then deletes the existing data model (this could take a few minutes). Once the deletion is completed, a window is displayed so you can select the file to import.

Checking the Overwrite files with the same name option replaces any existing files that have the same name as the file you want to import. The Cancel button becomes active once the Start button has been clicked. This allows you to stop the process (if necessary).

Click the Start button to import the file, the Remove All button to clear the list, or the Close button to abort the import.

Export

You can download your data model by clicking the Export button. This creates an .xlsx file that can be found on the Downloads page in the Data > Content menu.

From here, you can click the Download button to download the .xlsx file to your computer or the Remove button to delete the .xlsx file from your Quable PIM.

File Description

🚧

To import or export your data model, you must use an .xlsx file with column and sheet titles that comply with Quable PIM's standards. The details of these standards are described in the following sections.

Langues (Data Languages)

This sheet lists all of your active data languages. The title must be: LANGUES.

It includes the following columns of information for each language:

Types de Documents (Document Types)

This sheet lists all of your document types.

It includes the following columns of information for each document type:

Jeux de champs (Attribute Sets)

This sheet lists all of your attribute sets.

It includes the following columns of information for each attribute set:

Individual Document Sheets

Each document type has it's own sheet (titled with the document type name) listing all of its attributes.

It includes the following columns of property information for each attribute:

Sku - Champs (Variants)

This sheet lists all variant attributes.

It includes the following columns of information for each attribute:

Classification

This sheet lists all classification attributes.

It includes the following columns of property information for each classification:

XObject Types (Link Types)

This sheet lists all link types.

It includes the following columns of information for each link type:

XObject Types - Champs (Links)

This sheet lists all link attributes.

It includes the following columns of information for each attribute:

Médias (Assets)

This sheet lists all asset attributes.

It includes the following columns of information for each attribute:

Validators

This sheet is used by Quable to to define acceptable values for the specific data elements.

It includes the following columns of information for each data elements: