0

Is it possible to merge two records in same db?

I have a contact db and wanted to update the records that originate in Google Contacts. I created a csv and mapped the fields, then mapped the fields with identical labels, e.g. First Name, Surname. Then I selected  'only update fields if blank'.

After import I had expected new info in the csv eg 'Address' would sppear in thr blank field created in the db 'Address'. Instead I have got two versions of the same record, e.g.

John Doe with an address field and John Doe without an address field.

Hoping I can merge the records somehow using the First Name and Surname.

Would like to know what I got wrong too. Was it not using the 'Key' option?

4 replies

null
    • Fred
    • 4 mths ago
    • Reported - view
     said:
    Would like to know what I got wrong too. Was it not using the 'Key' option?

    That would be my guess. If you don't tell Ninox what field to "key" on then it can't tell what is new or old.

      • Robert_Fitzmaurice
      • 4 mths ago
      • Reported - view

       Thanks. Right, so if a field is marked as key it is treated as existing record to retain (not overwrite)?

      • Fred
      • 4 mths ago
      • Reported - view

      more like the key is used to check to see if an existing record already exist and will either skip or update. so using First Name and Surname may not be the best key as you can have duplicate names. I'm not sure but I don't think you can have two fields be keys so you will have to use another key or make a new field that is a combo of the two.

      • Robert_Fitzmaurice
      • 4 mths ago
      • Reported - view

       OK this helps to clarify. Thanks Fred

Login to reply

Content aside

  • Status Answered
  • 4 mths agoLast active
  • 4Replies
  • 26Views
  • 2 Following