Export profile
Using export profiles, you can export the data fields you need. You can, however, still export data without an export profile when you want to export all the data without filtering out unnecessary fields.
The following example illustrates how to create a new export profile for the M.Content definition. Using this export profile, you can export the selected data by enabling the Export to Excel option on the Selection component of the Search page.
Create an export profile
To create an export profile:
On the menu bar, click Manage .
On the Manage page, click Export profiles.
On the Export profiles page, click + Export profile.
In the Export profile dialog box, define the following settings using the values provided.
Export profile option Description Value Name The name of the export profile. ContentProfile Definition The definition used for the export profile. M.Content Is default Check box to enable the Is default flag. Select Is default check box Settings Choose from Tree, Form, or Text settings. These settings let you specify the properties, relations, and system properties to include in the export. See Tree and Form settings and Text settings. To include public links in an export, see Public links export settings Click Save.
Tree and Form settings
Use the following Tree and Form settings.
object
properties
: (array)Content.Name
(string)Content.Brief
(string)Blog_Title
(string)
relations
: (object)PublicationStatusToContent
(object)exportRelatedEntities
:false
(string)
ContentTypeToContent
(object)exportRelatedEntities
:false
(string)
includeSystemProperties
:true
(string)version
:1.1
(string)
Text settings
Use the following text settings.
{
"properties": [
"Content.Name",
"Content.Brief",
"Blog_Title"
],
"relations": {
"PublicationStatusToContent": {
"exportRelatedEntities": false
},
"ContentTypeToContent": {
"exportRelatedEntities": false
}
},
"includeSystemProperties": "true",
"version": "1.1"
}
Public links export settings
Add the following settings if you want to export public links. This is only supported when exporting M.Asset entities. The asset parameter is a boolean flag that triggers the export of the completed and active public links for assets. The masterfile parameter triggers the export of the completed and active master file public links.
"publicLinks": {
"asset": false,
"masterfile": false
}
Edit the Search page
To edit the Search page:
On the menu bar, click Manage .
On the Manage page, click Pages.
On the Pages page, search for the Content page.
Next to Content, click View child page(s) .
Click the Search page.
On the Search page, for the Selection component, click the switch to make it active and to enable the custom settings.
Click More options and select Edit .
On the Selection component page, on the General settings tab, click the Enable export to Excel switch to make it active.
Click the Export Excel settings tab and click Add definition.
Add the M.Content definition.
Click + Add export profile.
In the Select items dialog box, select the export profile you created (for example, ContentProfile).
Click Select and then click Save and close.
Export
To export content from the Search page:
On the menu bar, click Content and select Search.
On the Search page, in the left CONTENT TYPE page, select the Blog content type filter, and select all.
Click Actions and select Export to Excel.
In the Export to Excel dialog box:
- In the Filename field, enter a name for the downloaded .xlsx file.
- From the Cultures list, select the cultures for the export. This is a multi-select option.
- Click the User-friendly column headers switch to make it active if you want to use labels instead of technical member names for column headers. If you enable it, you cannot reimport the file.
- Click the User-friendly cell values switch to make it active if you want to add extra columns with user-friendly labels for every value.
Click Export.
Open the .xlsx file to see that the properties, relations, and system properties defined in the export profile were successfully exported.
id identifier Content.Name Content.Brief Blog_Title PublicationStatusToContent ContentTypeToContent CreatedBy CreatedOn ModifiedBy ModifiedOn 33240 dtahzyG3WEabV7UxlsCK9w Developing a diet Healthful nutrition helps you develop your diet M.ContentType.Blog demo_user1 2021-04-27T09:35:27.7691239Z Administrator 2021-04-27T10:13:35.9914875Z 32142 Content.PowerFromWithinBE Kracht komt van binnenuit Kracht komt van binnenuit M.ContentType.Blog demo_user2 2021-04-27T04:38:54.7837484Z Administrator 2021-04-27T04:38:57.7459487Z 31974 Content.HealthIsHappiness Health Is Happiness Health Is Happiness M.ContentType.Blog demo_user3 2021-04-27T04:38:10.9706224Z Administrator 2021-04-27T04:38:14.7976202Z 33236 jBV7J2ShiE-Lu7ZRj8Nadg Nutrition tips blog post Nutrition tips blog post M.ContentType.Blog demo_user4 2021-04-27T09:35:25.8271610Z Administrator 2021-04-27T09:35:26.5736823Z 32258 Content.HealthyMimosaBlog Healthy Mimosa blog Who wants a mimosa?! M.ContentType.Blog demo_user5 2021-04-27T04:39:30.7532130Z Administrator 2021-04-27T04:39:30.8687621Z 33234 7v6MO8twxUGtRDLVSZ9bIg Healthy Mimosa blog Who wants a mimosa?! M.ContentType.Blog demo_user6 2021-04-27T09:35:24.7070619Z Administrator 2021-04-27T09:35:25.5447944Z 32119 Content.PowerFromWithin Power comes from within Power comes from within M.ContentType.Blog demo_user7 2021-04-27T04:38:47.6915480Z Administrator 2021-04-27T04:38:52.9834415Z 32256 Content.NutritionTipsBlogPost Nutrition tips blog post Nutrition tips blog post M.ContentType.Blog demo_user8 2021-04-27T04:39:30.3908274Z Administrator 2021-04-27T04:39:30.5252297Z 32100 Content.DevelopingADiet Developing a diet Healthful nutrition helps you develop your diet M.ContentType.Blog demo_user9 2021-04-27T04:38:44.2818256Z Administrator 2021-04-27T04:38:46.5517592Z
Tip
For another example of export profiles, see Exporting users, where we create an export profile to export selected user fields.
Can we improve this article ? Provide feedback