CiviCRM Community Forums (archive)

Hi, I recently installed 2.0beta5 over Drupal.  It seems the installation script imports all Drupal users into the CiviCRM database and yay for that.  However, following several failed imports of over 6000 individuals and organizations and assorted do-overs, the import of the Drupal users was lost and their records deleted somewhere along the line. 

I want to reimport everyone who has a Drupal account (the staff of our company) so they also have an account in CiviCRM.  I know my SQL, but there are so many damn tables I don't know where to begin.  Can someone please point me in the right direction to a table or SQL statement that I may use to attempt this reimport?

Thank ye kindly,
Stuart

I just tried this.  The web interface said 7 users were imported.  However, none of our staff are showing up as contacts.  I can't find any of them listed in the contacts.  I don't know who was imported (which 7), CiviCRM didn't say.

Any other ideas?

Stuart

Ok thanks, I have looked into the database,  indeed 7 of our Drupal users were imported into the CiviCRM database.  However the other 6 were not.  I cannot find an explanation as to why.  I went ahead and manually added (using PHPMySQLAdmin) the 6 users that were not imported into civicrm_contact , but the hash field

hash  Key for validating requests related to this contact.

Is blank, I didn't know how or what to put there, so will this work?  Should I just truncate the civicrm_contact table and try again with the reimport?

Stuart
 

Well thanks for the advice guys, but still having problems.  Unfortunately prior to posting here I already truncated the contacts table and since that time these 6 drupal users will not import no matter what I seem to do.  So, somewhere in the database there is a record of these 6 drupal users somewhere OTHER than in the contacts table that is causing import to fail.  Where is it so I can remove their records and attempt to re-import?

Thanks yo!

Ok so, when I installed CiviCRM is imported all the 9 Drupal users into CiviCRM.  Shortly thereafter I truncated the 'civicrm_contacts' table.  I know that is not a good I idea but I didn't know better at the time.  So that's what I did. 

Then (after I did the truncate) 7 more Drupal users were added in Drupal.

Then I used the "Synchronize Users to Contacts" function within CiviCRM.  When I did so it told me:

Synchronize Users to Contacts completed. Checked 16 user records. Found 9 matching contact records. Created 7 new contact records.

Then 7 of our Drupal users could use CiviCRM and 9 (the original 9) could not.  When I say "cannot use" I mean that they login to Drupal, and that works.  Then they click "CiviCRM" in the Drupal navigation and the link won't work.  They click it, and nothing happens.  They don't get the CiviCRM main menu, just nothing happens.

Then I went in and deleted the new 7 by deleting their rows from the 'civicrm_contacts' table.  Again, sorry I didn't know this was a bad idea at the time.

So now I tried the "Sychronize Users to Contacts" function again.  When I did so it said:

Synchronize Users to Contacts completed. Checked 16 user records. Found 16 matching contact records. Created 0 new contact records.

Now none of our Drupal users can use CiviCRM.  CiviCRM thinks they are in the database but their rows were deleted and they cannot use CiviCRM.  The Sychronize function won't bring them back.  Is there some other record of their users that I must delete to get the Synchronize to work?  Do I have to delete a record of the Synchronize occuring to make it work?

THANKS for your help!  Please let me know.  I would like to avoid reinstalling the database completely, as I have imported a lot of data and made a lot of custom fields.

Thank you for your help.  Truncating "civicrm_uf_match" seemed to do the trick.  It is a reference table between the Drupal and CiviCRM user tables evidently.

It has reset the Syncronize function.  Thanks!