Tips for Importing on Engagement

Importing is one of the important functionalities of Bloomreach Engagement. The topic is comprehensively discussed in the import documentation. However, if you come across some of the following issues while importing, this page will help you figure them out. To find the solution for the top import issues, refer to the article on the Top Import Issues and Solutions.

  • While importing, make sure that you select the right columns for the import. If you miss a column or mark a column extra that is not required, you will have to go back in the import process to rectify it.

  • The corresponding attribute tag should be assigned to import data. Select the attribute checkbox after adding the column and the data type to import the column as an attribute.

  • While importing customers properties or events of some customers, you need to link it to the Customer ID for choosing the right customer profile for import. However, during importing, do not select the checkbox for Customer ID column in the import table. This will import the ID as an attribute and this can cause multiple implications for your project like duplication of information. Duplication can lead to the issue of volume for large volumes of data.

  • Assign the correct data type to the column while importing data. For example, importing a timestamp as an integer might cause issues in the final display. Timestamp must be imported in the Date type format.

  • While importing catalogs, set the right columns searchable. If the columns are not searchable, you might face difficulty while creating recommendations because the data will not be indexed in the backend. Note that searchable columns can be assigned only during creating the imports. Once the catalog structure is created, you cannot change it. You can only add more items to the catalog.

  • When you set a repeated import and it gets stuck, you can edit the repeated import setting and save it again without changing anything. This will kick start the repeated imports.

  • Events with future timestamps will be processed and only be visible after the future time set has passed. Tampering with the event, due to it being not visible, could create duplicates and create unnecessary load on the platform.

  • Imports are processed in first come first served order. Sometimes, there will be a delay between the importing and visibility on the UI. This can happen due to larger imports being queued in the system that might take up more system resources.

  • It is recommended that timestamps be imported in the Unix timestamp format as it is flexible.

  • Make sure that there are no misspelled ID values while importing. Misspelled ID values will create duplicate customer profiles in the system.

  • Most common import source issues take place when the files used for imports have some errors or missing elements in them, it will cause errors in importing. Do a basic check to make sure that everything is in place before the import.

  • If your import exceeds the known import limits, contact the Product team to know if it can be accommodated.

👍

Did this article help you?

Please provide your feedback. We would like to know if our help center is effective in solving your queries. You can also leave comments and suggestions on how we can make our help articles better. You can also suggest topics you’d like us to cover.