Dubplicate caseids in mysql

Discussions about syncing data via Bluetooth, Dropbox, FTP, and using CSWeb
Forum rules
New release: CSPro 8.0
Post Reply
ntliem
Posts: 5
Joined: April 21st, 2018, 12:03 am

Dubplicate caseids in mysql

Post by ntliem »

Hello,
I have a situation: some cases are duplicate in mysql because they were put from two or more devices.
Can I only keep the newest case in mysql?
Thanks,
josh
Posts: 2399
Joined: May 5th, 2014, 12:49 pm
Location: Washington DC

Re: Dubplicate caseids in mysql

Post by josh »

There is no automated way to do this in mysql. You should download the data using DataViewer and then remove the duplicates in the downloaded cspro data file.

We recommend designing your application in such a way that you avoid creating duplicate cases in the first place.
Post Reply