• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 609
  • Last Modified:

Database Cleansing

Hi,

We are looking to reduce our database size by removing all our duplicate records of which there are quite a few.

Im going to use mobile phone number to identify the duplicates so Im after a way of first identifying the duplicates and then either moving to a 2nd database or just simply removing them.

Is this something which can be done within Goldmine or will this be a backend process?

Thanks
dw
0
daiwhyte
Asked:
daiwhyte
  • 4
  • 2
1 Solution
 
GMGeniusCommented:
Goldmine has a de-duplication process built in, you could create a filter to pick up all contacts with a mobile number then using the de-dupe process you can merge duplicates together.

Alternativly you could find the duplicates another way (by hand or using SQL) - mark these records by putting something in a field. Then using a filter to find these you could move them to another database (you would need to create this Database first), you can then use the tools >  copy - move records.
0
 
daiwhyteAuthor Commented:
Sounds interesting, how does the merge work, does it delete the orphaned record - will the process utlimately reduce the database size or just hide the duplicate entries?

Im doing this process to improve the performance of our DB so Im guess the smaller the database the better it runs - hence the request to remove the duplicates.

0
 
GMGeniusCommented:
The merge does just that, it merges the records together

History/pending/linked/detail records are linked to the new "surviving" record fields are merged based on how recent they changed then the old record is either marked for deletion tor actually deleted.

I suggest you read the help file on dedupe/merge purge to better understand it.
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
daiwhyteAuthor Commented:
Thanks GMG, I will read and get back to the thread this Thursday
0
 
daiwhyteAuthor Commented:
Ive had a read of the help file and like what Im reading, Im going to perform the process after last day of the month (just in case!)

Thanks GMG.;
0
 
daiwhyteAuthor Commented:
Thank you.
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now