sections in the article
This article gives you an overview of the Excel export feature.
About excel exports and imports
inriver uses Microsoft Excel as a tool for mass updating entities where you can export data to and import data from Excel. You export all or selected entities in a work area to Excel and you can later import the same Excel document after changing the content.
Since Excel is a widely known and used tool to sort, structure, analyze, and manipulate large amounts of data, entities can easily be mass updated in Excel.
The Excel export and import features have basically the same functionality in the Rich Client and in the Web Portal, but there are some minor differences. Here we only show where you find the export and import features.
When working with Excel documents, there are some restrictions on which changes you can make and still be able to import the content of the file back into inriver. To get the right format, we recommend that you start by exporting an Excel file, make any changes or additions to that file before reimporting the file.
Read more about Excel imports in this article.
Excel export: web portal
The Excel export feature is found in the top-row navigation menu in Enrich. There are two places where you can do an Excel export, from a Work area or by using a Search result.
Exporting a work area
You can search for data in several ways, use saved searches or use saved entities from work area folders. Once you have populated a work area, you find the Excel export option in the navigation menu in the upper right corner of the work area.
Exporting a search result
Search results are also listed in the left-side frame in Enrich. The Excel export option is in the navigation menu above the list of entities in the search result, see screenshot below.
Excel export capabilities
When exporting to Excel you can choose to save your export settings by clicking Save as. Your settings will then be saved in a template that can be accessed through the Open saved setting drop-down menu. This is especially useful if you export the same type of data regularly.
You can edit one of these templates at any time by choosing the template in Open saved setting, making the changes and clicking Save.
In general, the Excel export with related entities only include the entities that are directly linked. The export works with either one level up, down, or both ways in the hierarchy. For example Product -> Item, Product <- Item, or Product <- Item -> Resource.
When including an entity type that is higher up in the hierarchy, only the entities with that relation will be included. For example, if you export Product <- Resource, only Resources with a direct link to a channel will be included in the export.
You also have the option to select multiple entity types for the second level, e.g. Product -> Item and Product -> Resource.
Note that the sorting order differs depending on what inriver functionality you are using. For instance, in Content Store the field order is sorted alphabetically while in Enrich the field order follows the same order as in the model.
Excel export: rich client
In the Rich Client, the Excel export is found in the work area navigation menu. You can access the navigation menu by right-clicking any of the entities in the work area. Before you open the navigation menu, you can select any number of entities from the work area. You can either export all entities in the work area, or just the selected entities.
Good to know
Keep the below advice in mind when importing a modified Excel file back into inriver:
- Don't remove or rename the column headers in the first row, they are used for mapping columns to FieldTypes when importing.
- Don't remove the first column called sys_id, it is used for identifying the entity that should be updated when importing.
- Don't hide columns or rows.
- When removing columns or rows, remove them completely by selecting the entire column or row, then clicking Remove in the navigation menu.
- Don't add rows or columns that are not part of the information you are editing.
- Don't add other sheets to the Excel file (linked cell is not supported).
- When entering data into CVL fields, make sure you use the CVL Key (not the Value), and that the Key exists in the CVL.
- Excel export date format is based on browser's setting for language