Multiple Duplicate E-mails in Contact Records? 1

[bmiller3s]

Several days ago, one of our salesmen started getting mulitple copies of some older e-mails under the "Pending" tab of the Contact Record. (GoldMine 4.0 with dBase IV) Synchs with the Server database now take extremely long for all salesmen and dozens of dups for hundreds of contacts get compounded.

A re-index/rebuild of MAILBOX fails with "Insufficient disk space - BDE Err Cat Code [37:3]" There are 12gig of freespace on the Server while MAILBOX .DBF, .DBT and .MDX take up 26MB, 610MB and 16MB respectively (DBT file seems inordinately large?). Same error happens whether rebuild done from workstation or Server console. Examining MAILBOX.DBF by linking through Access97 shows only valid records (no dups).

Any insight or suggestions would be greatly appreciated!

 

[ddeegan]

Hello

If you have records under the pending tab, I would look into rebuilding your Cal file. I'm not sure how your rep is entering e-mails, but I know the pending tab means Cal.dbf.

"MAILBOX .DBF, .DBT and .MDX take up 26MB, 610MB and 16MB "

The DBF part is the records, the MDX are the index files. .DBT contains the data in a memo file. The memo file contains the text of the e-mail as well as address info. You probably have a large amount of e-mail text in MAILBOX.DBT. To view the data, open MAILBOX.DBF and look for your memo field.


HTH
Dave

 

[Goldinrod]

We had a similar problem with old emails, calls, appts etc...
I don't know how often your Sales Rep's synch, but we found that synching daily has stopped the duplications.
What transpires is: when someone goes back to edit any of the activities, it puts a new timestamp on the record or field. The Synch process will take the latest timestamp and add it as new to the (in this case) Pending" folder.
From time to time people will edit existing emails, calls, appts etc... I do it myself. The longer the duration between shychronizations the more possibilities exist for duplications. I hope this helps.

Goldinrod