Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Goldmine contacts missing

Posted on 2009-05-04
7
Medium Priority
?
800 Views
Last Modified: 2013-11-15
I use Goldmine 6.5. Every month, I make a report of all contacts in our database. However, I recently noticed that some contact that showed up in the previous month's report, did not show up in this month's report. What could be the reason? Is it archiving? Can I retrieve these contacts back? My computer is running on Windows XP.
0
Comment
Question by:bobox00
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 11

Expert Comment

by:stevengraff
ID: 24296370
It sounds like you're using GoldMine on a standalone PC, yes? Or are you on a network, sharing a database with other user?

Could be your database needs maintenance (i.e. File | Maintain Databases or Tools | Maintain Databases).

Or, if your report is actually based on a filter (could be internal to the report, if it's a custom report or modified report) it could be that these contacts no longer meet the criteria of the filter.
0
 

Author Comment

by:bobox00
ID: 24296856
Goldmine is on a network, and only one user updates it. I only do monthly reports - I never add or remove. The user says she never deletes any contact, and I'm sure she wouldn't.
To generate my monthly report, in Goldmine, I go to Tools | Import/Export Wizard | Export Contact Records. Then I select five fields to be in the report, but specify no conditions whatsoever.
I will do the maintenance. This is still quite a mystery.
0
 

Author Comment

by:bobox00
ID: 24298048
Its not a matter of criteria, because when I look up one of such contacts by name, the contact doesn't come up at all.
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

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

 
LVL 11

Expert Comment

by:stevengraff
ID: 24299280
So the report you're generating is not in GoldMine? You mention that you export the data, and then run a report? What's the final report generation program? Crystal Reports? Excel? Access? Something else?

=
Its not a matter of criteria, because when I look up one of such contacts by name, the contact doesn't come up at all.
=

I infer from this that you can see the contact in GoldMine, but not in whatever you're exporting to -- is this right?
0
 

Author Comment

by:bobox00
ID: 24299354
I export all contact records from Goldmine, but specify 5 fields to be displayed in the exported file - no criteria specified. Goldmine exports to a .dbf file, which I then view with Excel. In this month's report, I have narrowed down the missing contact to only one. No I need to find out exactly what happened to that one contact. The contact was in last month's report, but he's not in this month's report. I searched for him in Goldmine, he's not there either.

Are there any logs I could view to find out how this contact was removed?
0
 
LVL 11

Accepted Solution

by:
stevengraff earned 2000 total points
ID: 24301409
If the contact is not in GoldMine, there's no way it could be in your "report." You can't export it if it doesn't exist.

As a "best practice" you should make sure no one has deletion rights, nor merge/purge rights, nor master rights, other than yourself. Make sure your password is secure.

Even so, it's possible for a contact to "disappear" if someone were to simply update all a contact's fields, i.e. contact, company, phones, address, etc. This may be unlikely in your case... we usually see this only where a new, raw, untrained user does this, not realizing that they are overwriting an existing record.

There's no easy way to track down how a record was deleted, so don't get your hopes up. One chance would be to go to View | GoldMine Logs, then drill down to Contact File Logs, then Contact1. You'll see the company name on the right; possibly you can find the deletion record.

And ask your user(s) if they have done any kind of merge/purge operation. This operation deletes records (that's the "purge" part) and you don't need explicit deletion rights in order to do it.
0
 

Author Closing Comment

by:bobox00
ID: 31577528
Thanks. You're very helpful.
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

GoldMine CRM has a fairly open database architecture , however in this case the email distribution list is stored in a quirky way and does not allow easy access for external use. This article will give details of this and provide a method to extr…
Decide what contact details to include in email signatures with these top 10 email signature contact details DOs & DON'Ts.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

722 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question