logo
logo

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:

  1. On the menu bar, click Manage .

  2. On the Manage page, click Export profiles.

  3. On the Export profiles page, click + Export profile.

  4. In the Export profile dialog box, define the following settings using the values provided.

    Export profile optionDescriptionValue
    NameThe name of the export profile.ContentProfile
    DefinitionThe definition used for the export profile.M.Content
    Is defaultCheck box to enable the Is default flag.Select Is default check box
    SettingsChoose 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
  5. 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:

  1. On the menu bar, click Manage .

  2. On the Manage page, click Pages.

  3. On the Pages page, search for the Content page.

  4. Next to Content, click View child page(s) .

  5. Click the Search page.

  6. On the Search page, for the Selection component, click the switch to make it active and to enable the custom settings.

  7. Click More options and select Edit .

  8. On the Selection component page, on the General settings tab, click the Enable export to Excel switch to make it active.

  9. Click the Export Excel settings tab and click Add definition.

  10. Add the M.Content definition.

  11. Click + Add export profile.

  12. In the Select items dialog box, select the export profile you created (for example, ContentProfile).

  13. Click Select and then click Save and close.

Export

To export content from the Search page:

  1. On the menu bar, click Content and select Search.

  2. On the Search page, in the left CONTENT TYPE page, select the Blog content type filter, and select all.

  3. Click Actions and select Export to Excel.

  4. 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.

  5. Click Export.

  6. Open the .xlsx file to see that the properties, relations, and system properties defined in the export profile were successfully exported.

    ididentifierContent.NameContent.BriefBlog_TitlePublicationStatusToContentContentTypeToContentCreatedByCreatedOnModifiedByModifiedOn
    33240dtahzyG3WEabV7UxlsCK9wDeveloping a dietHealthful nutrition helps you develop your dietM.ContentType.Blogdemo_user12021-04-27T09:35:27.7691239ZAdministrator2021-04-27T10:13:35.9914875Z
    32142Content.PowerFromWithinBEKracht komt van binnenuitKracht komt van binnenuitM.ContentType.Blogdemo_user22021-04-27T04:38:54.7837484ZAdministrator2021-04-27T04:38:57.7459487Z
    31974Content.HealthIsHappinessHealth Is HappinessHealth Is HappinessM.ContentType.Blogdemo_user32021-04-27T04:38:10.9706224ZAdministrator2021-04-27T04:38:14.7976202Z
    33236jBV7J2ShiE-Lu7ZRj8NadgNutrition tips blog postNutrition tips blog postM.ContentType.Blogdemo_user42021-04-27T09:35:25.8271610ZAdministrator2021-04-27T09:35:26.5736823Z
    32258Content.HealthyMimosaBlogHealthy Mimosa blogWho wants a mimosa?!M.ContentType.Blogdemo_user52021-04-27T04:39:30.7532130ZAdministrator2021-04-27T04:39:30.8687621Z
    332347v6MO8twxUGtRDLVSZ9bIgHealthy Mimosa blogWho wants a mimosa?!M.ContentType.Blogdemo_user62021-04-27T09:35:24.7070619ZAdministrator2021-04-27T09:35:25.5447944Z
    32119Content.PowerFromWithinPower comes from withinPower comes from withinM.ContentType.Blogdemo_user72021-04-27T04:38:47.6915480ZAdministrator2021-04-27T04:38:52.9834415Z
    32256Content.NutritionTipsBlogPostNutrition tips blog postNutrition tips blog postM.ContentType.Blogdemo_user82021-04-27T04:39:30.3908274ZAdministrator2021-04-27T04:39:30.5252297Z
    32100Content.DevelopingADietDeveloping a dietHealthful nutrition helps you develop your dietM.ContentType.Blogdemo_user92021-04-27T04:38:44.2818256ZAdministrator2021-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