CiviCRM Community Forums (archive)

i imported a csv file which contain contacts information. some fields went into civicrm_contact table, while a new table was created that have all the fields in my csv file.

My cvs fields are:

First Name:
Last Name:
Phone:
Address:
CityIDNum:
BirthYear:
Sex:

After importing the file,
it added the first name and last name to civicrm_contact table and automatically generated a contact_id for each record.
It then created another database table called "importjob*******" where it stored all the fields and pulls the CityIDNum from.
it added the phone numbers to the civicrm_phone table using the unique contact_id.

Now, I want to update some contacts with phone numbers  but there is no way to link the importjob table to the civicrm_contact table.


my unique identifier in the importjob table is the citiIDnum which isnt in the contact nor phone table.
the unique identifier in the contact table is the contact_id which isnt in the importjob table.

I want to search for contacts using the CityIDNum since this was what I used to uniquely identify them in my csv file, but when i do search from the importjob table, I get the records quite all right, but I cant seem to have any way of relating these records to the actually civicrm_contact table since the unique id on the table is the contact_id.

any idea how the importjob table relates to the civicrm_contact table?

Thanks Kiran,
I think something went wrong with the import because I can still see the importjob table in my database. Has to do with birthyear field. The birthyear field isnt so important so I overlooked that. I got the important fields in the database and see no reason why I should delete and import over 105,000 records all over again.

I added some phone numbers to my csv files, and wanted to update those records in my database. However, since many names are similar, there is no way to check if Name "John" belongs to contact ID 1 or a similar name "John" belongs to the contact ID 1 since I used the "cityIDNum" to uniquely identify the names in my csv file.

I searched the whole of my database to see where else the "cityIDNum" is, aside from the importjob table, nothing came up. Which is why I was making a reference to my importjob table to get the unique cityIDNum, and then relate this to other civicrm tables, since I dont have the automatically generated "contact_ID" in my csv file.

Since "cityIDNum" is a custom field, is there a table this should actually be in ?
Cos when I search for contact using the front end application, I get the full information of the contact. So I thought civicrm was pulling the name from civicrm_contact table, the phone number from civicrm_phone table, and the cityIDNum from the importjob table.