If you have duplicate records in the bottom sheet of PS Data Manager, you can remove them easily by following the steps below.


1. In the top sheet of your database select the records with duplicate items.


2. From the main menu in choose PROCESS > REMOVE DUPLICATE ITEMS.


3. The above step will mark the bottom sheet records as deleted, and you will see a red cross will appear next to the deleted records.


4. To remove the deleted items from the database completely, choose DATA > DATABASE OPERATIONS > PURGE DELETED RECORDS


Duplicate bottom sheet records can happen for several reasons such as:


  • Data is sent twice from the mobile device due to a poor internet connection and a previously failed transfer.


  • You are doing re-surveys, and you are NOT importing the data into the database with the IMPORT > OVERWRITE option.