Bulk Delete

The Bulk Delete feature is used to remove either a set of records or relationships from the Fulfillment Catalog system.

You can delete individual records by accessing them and using the delete operation. You can also delete relationships between the records by accessing them and deleting them. Additionally you can delete all the records and relationships using the feature provided by MDM. But deleting a particular set of records or relationships was not possible.

The Bulk Delete feature is introduced for deleting a particular collection of records or a list of relationships maintained between the records.

The valid data file types that can be zipped are CSV or TXT files. The samples of the data files are available in the BulkDeleteImportSample.zip file, which is placed within the $AC_HOME/samples/ location. The ZIP file contains the following files:

  • RemoveRecords.csv – to remove specific records from the repositories.
  • RemoveRelationshipRecords.csv – to remove specific relationships between records of the selected repositories.

The ZIP file can contain multiple CSV files for the bulk removal of data. You can add multiple CSV files as per your requirement of bulk deletion.

The delimiter configuration for the data is as follows:

  • The default delimiter is a comma ( , )
  • The delimiter can only be a single character, for example ( , ) or ( # )
  • You can configure the delimiter in the PrepareForDelete activity of the file wfin26bulkdatadeletev1.xml available in the $MQ_COMMON_DIR/<ENT_NAME>/worflow/ location.