Before you begin
The MDM server is already launched.
The data records have been already copied from the server to a local copy on your computer. For further information, see Exporting data records.
Make sure you have selected the data container that holds the master data you want to manage and the data model against which the master data will be validated. For further information, see Accessing data containers and data models.
About this task
- Open the Master Data Browser page in Talend MDM Web UI.
Select the entity in which you want to import the data records,
and then click the Search button to
list all the records in the selected entity.
- Click Import and Export on the menu bar to open a list.
Select Import... to open the
Upload data dialog box.
Click the Browse... button and follow
the instruction in the opened dialog box to upload the file
that holds the data records you want to import.
Pay attention to the following:
When importing a record with an element of date type, you must specify the element in the format of yyyy-MM-dd.
Make sure you have defined a multi-value separator. Otherwise, unexpected errors will occur.
If you want to include a foreign key element in the data records to be imported, you can specify it in the following formats:
Warning: The id values of a composite foreign key element must always be wrapped by brackets separately, for example, [FKid1][FKid2], [FKid1][FKid2]|[FKid3], or [FKid11][FKid12]|[FKid21][FKid22].
one foreign key id (with or without brackets) only, for example, FKid1, or [FKid1];
one foreign key id (with or without brackets) and foreign key information, for example, FKid1|FKinfo1, [FKid1]|FKinfo1, or [FKid1]|FKinfo1|FKinfo2;
multiple foreign key ids (with or without brackets) only, for example, FKid1|FKid2, or [FKid1]|[FKid2];
multiple foreign key ids with brackets and foreign key information, for example, [FKid11][FKid12]|FKinfo1, [FKid1]|FKinfo1|[FKid2]|FKinfo2, or [FKid11]|[FKid12]|FKinfo1|[FKid21][FKid22]|FKinfo2.
If needed, select the Use Partial Update
check box to update partially the fields of the existing
data records instead of updating all fields.
The ID field in the uploaded file will be validated first to identify the existing data records.
Click Submit. A progress information bar
is displayed followed by a confirmation message.
Make sure the uploaded file contains valid field values. If any error occurs during the import, for example, the uploaded file contains invalid field value, an error message pops up and none of the data records in the uploaded file will be imported.Note: The import operation may take some time depending on how many records you have in the local file.
- Click OK to close the confirmation message. All data records in the local file are imported on the MDM server.