Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Use Case:

Some user accidentally created test data and now wants to get rid of the sameIf for some reason, you want to delete many objects (say many Participants, or Specimens, etc), you can do it via CSV import.

Info

Be very careful since deleted objects cannot be reverted back.

Tips to perform large bulk imports

  1. One should perform these Perform such import during nonoff-peak hours or off time i.e when no others users are using the application. User can even . You can enable the  'System Lockdown' feature to keep stop other users from logging into the system.

  2. Delete objects which have many dependent obects can take long time.

  3. The database locks the tables from which the data is being deleted. Run the import in non-atomic mode which means set the Set the pre-validate to a small number 100 or 200 , which will to ensure the locks are not held by any one transaction for a long time. Deleting participants, visits or specimens which have too much dependent data can take time.