Skip to main content

Common Questions (FAQ)

I want to run the same import file multiple times. The import should update data if it already exists.​

Configure an identifier attribute on all buckets and bucket content (key value, text, etc.). When the identifier is set, the import process matches existing records by identifier and updates them instead of creating duplicates.

Example: identifier attribute on a bucket:

<mapping sheet="Bucket" id="brand">
    <attribute name="identifier">
        <value type="row_value" column="Brand" />
    </attribute>
    <attribute name="entityBucketId">
        <value type="static" value="brand" />
    </attribute>
    <attribute name="label">
        <value type="row_value" column="Brand" />
    </attribute>
    <keyValue mappingId="brand_identifier" />
</mapping>

Important: identifiers for buckets and bucket content must be unique. If two buckets or content items share an identifier, the import process cannot determine which parent bucket they belong to.

  • If no identifier is configured, the import process generates one automatically.
  • If identifier is configured, make sure each bucket and bucket content item has a unique value.

The import runs for a long time and does not finish, or causes a memory heap error.​

  1. Update the Publishing Server to the latest version.
  2. Check the Excel file. Make sure all cell values are text or numbers only. Cells containing formulas take extra time to calculate. Copy the data to a new Excel file and paste as "values only" to remove formulas.

I cannot upload the file. The import file is not found on the Publishing Server.​

The Publishing Server only allows .zip file uploads by default. Two options:

  1. Zip the Excel or CSV file and upload the zip.
  2. Update the server configuration to allow additional file types or increase the maximum file size, then upload the Excel or CSV file directly.