The Excel import settings define how Sitecore Content Hub™ handles the import of data from Excel.
To configure these settings:
On the menu bar, click Manage , and then select Settings.
On the Settings page, find ExcelImport.
The following settings are configurable:
Number of rows for periodic report
When you import data from Excel, the import job generates periodic reports.
Use the numberOfRowsForPeriodicReport setting to define the number of rows included in each periodic report.
The default value is 20. You can change this value, with a minimum of 1.
Setting the numberOfRowsForPeriodicReport value to 1 provides more specific reporting information. For example, you can use this when your Excel import is slow, and you want to identify the rows taking a long time to process:
We recommend using the value of 1 row for debugging purposes only, not for regular Excel imports.
Maximum of rows per import
Use the maximumOfRowsPerImport setting to define the maximum number of rows in an Excel sheet or workbook that can be processed in an import.
The default is 50000 rows per import.
This setting also defines the size of the batches in the parallel Excel import.
Number of rows to create new target
Use the numberOfRowsToCreateNewTarget setting to define the number of rows imported before a new target is created.
For example, you have an Excel sheet called M.Asset that has 5000 rows to import. If you set the numberOfRowsToCreateNewTarget setting to 1000, a new M.Target is created every 1000 rows. The default value is 1000.
In the completed Excel import, there are 7985 rows. If the numberOfRowsToCreateNewTarget setting is 1000, there would be 8 targets created:
Fail on error
Use the failOnError flag to specify how the Excel import behaves when an error occurs. If you enable the flag, the Excel import stops after the first error.
When you disable the failOnError flag, if an error occurs during import, it is recorded in the periodic report and processing continues.
When the import runs in parallel and an error occurs, with the failOnError flag enabled, the job fails after the batch is completed. This means that instead of fail on first error, it becomes fail on first batch error.
Excel raw import
Use the rawImport flag to speed up the Excel import process. The Excel import can gain as much as 300 ms per row.
When you enable the rawImport flag:
- In process triggers are ignored during the import.
- Conditional members are not validated during the import; a property value is set even if the corresponding check would have failed.
- Required members are validated as normal; a property value is not set if the corresponding check fails.
- When included as a column, the lifecycle status is assigned to the standard relation, instead of going through the security framework.
Can we improve this article ? Provide feedback