Author Topic: Seemingly Random Contacts in our DB (Read 2078 times)

FredJones · June 26, 2008, 07:52:02 am

We have noted as of recent that every so often, a contact appears in CiviCRM (2.0.4 on Drupal 5.7) with no data more than the name, like Doe or Canon. No email, no nothing. No staff member admits to having added such a contact, nor do we have significant reason to suspect anyone of doing something silly like that.

Aside from a staff member apparently pointing her MS Exchange at our server (which results in a page not found in Drupal) I have as of yet not detected anything unusual happening. Not that I really know much how to detect that nor really where to look for, but anyway, I don't know what's happening.

Any ideas how I can figure out what's going on?

Thanks.

Dave Greenberg · June 26, 2008, 11:16:18 am

Have you checked the "last changed by" and "view change log" info for these contacts (this info / link should show at the bottom of the page when viewing the contact summary)?

FredJones · June 26, 2008, 11:24:57 am

Ah, right. The contact called "Canon" was last changed by himself. Change log shows one entry--apparently when he created himself.

Something definitely fishy going on.

CousiMo · June 27, 2008, 07:09:39 am

Fred

I did some testing , this is what i found.. when a new individual ( john 1) is added to the database and he/she indicates a company name as their employer ( company 1) , two entries are entered in the db, one for the new individual (john1) and one for the company which gets added as an organization , not sure if this is a bug or intentional.

CousiMo · June 27, 2008, 07:13:49 am

keep in mind the organization even though it creates a sepereate id # for it.. when you delete the organization it will delete the "employer Name in the john1 profile. ok, def a bug ;-)

Dave Greenberg · June 27, 2008, 09:37:59 am

Entering Employer Name for an Individual creates an Organization record for the employer and an employee - employer relationship. This is intentional. In 2.1 you will be choose between "Create new organization" or "Select existing organization" for the employer.

The fact the deleting the organization also clears the employer name for the individual is also "intended behavior" - since the employee/employer relationship can not exist if the employer org is gone.

FredJones · June 29, 2008, 12:38:56 am

Quote from: Dave Greenberg on June 27, 2008, 09:37:59 am

Entering Employer Name for an Individual creates an Organization record for the employer and an employee - employer relationship. This is intentional. In 2.1 you will be choose between "Create new organization" or "Select existing organization" for the employer.

OK, this makes sense. But I would suggest that the 'last changed by' referring to the Organization record is not correct, because in reality the person who created this record (that's the last change) was the person who created the individual record, even if it was inadvertent.

Quote from: Dave Greenberg on June 27, 2008, 09:37:59 am

The fact the deleting the organization also clears the employer name for the individual is also "intended behavior" - since the employee/employer relationship can not exist if the employer org is gone.

Yes, that is clear.

Thank you.

CousiMo · June 29, 2008, 07:26:57 am

Quote from: FredJones on June 29, 2008, 12:38:56 am

OK, this makes sense. But I would suggest that the 'last changed by' referring to the Organization record is not correct, because in reality the person who created this record (that's the last change) was the person who created the individual record, even if it was inadvertent.

that might not be the best idea, since what would happen .. if john 1 and john2 work for companyA after john1 has recorded his employer's information, thus creating the organizations name, the database admin goes in and updates a phone number for the organization. then john2 puts in also that he/she works for companyA, who edited the file john2 , or the db admin? ....

but i would suggest a link (or a tab) on the organization page, that would list all the employee's for that organization, and even in the individual's page, a tab to see who the co-workers are,

Dave Greenberg · June 30, 2008, 10:50:16 am

Quote from: CousiMo on June 29, 2008, 07:26:57 am

but i would suggest a link (or a tab) on the organization page, that would list all the employee's for that organization, and even in the individual's page, a tab to see who the co-workers are,

If you go to the Relationships tab for an Organization that has "employees" - you will see all the employee's for that organization.

CiviCRM Community Forums (archive)

News:

Author Topic: Seemingly Random Contacts in our DB (Read 2078 times)

FredJones

Seemingly Random Contacts in our DB

Dave Greenberg

Re: Seemingly Random Contacts in our DB

FredJones

Re: Seemingly Random Contacts in our DB

CousiMo

Re: Seemingly Random Contacts in our DB

CousiMo

Re: Seemingly Random Contacts in our DB

Dave Greenberg

Re: Seemingly Random Contacts in our DB

FredJones

Re: Seemingly Random Contacts in our DB

CousiMo

Re: Seemingly Random Contacts in our DB

Dave Greenberg

Re: Seemingly Random Contacts in our DB