How to define the maximum number of data records to be imported or exported in Talend MDM Web UI

EnrichVersion
6.5
EnrichProdName
Talend MDM Platform
Talend Data Fabric
Talend Open Studio for MDM
task
Data Quality and Preparation > Enriching data
EnrichPlatform
Talend MDM Server
Talend MDM Web UI

How to define the maximum number of data records to be imported or exported in Talend MDM Web UI

You can change the maximum number of data records to be exported or imported on the data browser page in Talend MDM Web UI.

In Talend MDM Web UI, you are allowed to import or export data records using the Import and Export button on the data browser page.

By default, an authorized user can import or export a maximum of 1000 records.

This article applies to Talend products with MDM 6.3.0 and above.

How to define the maximum number of data records to be exported

The following describes how to change the maximum number of data records to be exported.

For Excel 2007, the upper limit for the maximum number of data records to be exported is 1M.

Procedure

  1. Go to the directory <$INSTALLDIR>/conf. Here the <$INSTALLDIR> specifies where the MDM server has been installed.
  2. Edit the file mdm.conf and modify the parameter max.export.browserecord as required.

    For example, if you set its value to 2000, when you select more than 2000 data records and export them, only 2000 of them will be exported successfully.

    #Browse Record web ui max export records count
    max.export.browserecord=2000
  3. Save your changes.
  4. Restart the MDM server.
  5. Clear the cache of your browser, and then access Talend MDM Web UI to verify that the changes have taken effect.

How to define the maximum number of data records to be imported

The following describes how to change the maximum number of data records to be imported.

Before you begin

Make sure you have been assigned a role with the appropriate user authorization and access rights.

Pay attention to the following cases:

  • If you have been assigned a role with both write and create access rights, you can import a csv or xlsx file with both new records and records existing on the MDM server.
  • If you have been assigned a role with write and no create access rights, you can import a csv or xlsx file with only records existing on the MDM server.
  • If you have been assigned a role with no write access right, you cannot import a csv or xlsx file.

Procedure

  1. Go to the directory <$INSTALLDIR>/conf. Here the <$INSTALLDIR> specifies where the MDM server has been installed.
  2. Edit the file mdm.conf and modify the parameter max.import.browserecord as required.

    For example, if you set its value to 2000 and want to import a file containing over 2000 data records, only a maximum of 2000 data records will be imported successfully.

  3. Save your changes.
  4. Restart the MDM server.
  5. Clear the cache of your browser, and then access Talend MDM Web UI to verify that the changes have taken effect.

How to hide the Import and Export button

You are allowed to hide the Import and Export button in Talend MDM Web UI.

To import or export a massive number of data records, you are recommended to design a Job in Talend Studio rather than using the Import and Export button in Talend MDM Web UI.

Procedure

  1. Go to the directory <$INSTALLDIR>/conf.
  2. Edit the file mdm.conf and set max.import.browserecord=0 and max.export.browserecord=0.

    You can set only one of them to 0 so that the corresponding Import... or Export option is invisible from the menu list when you click the Import and Export button on the data browser page.

  3. Save your changes.
  4. Restart the MDM server.
  5. Clear the cache of your browser, and then access Talend MDM Web UI to verify that the changes have taken effect.