Import only entries with new ID

[meerestier]

Hi there,

1. On first Import (its XML but thats not important), fields are matched in the import, creating the entries (all with unique IDs).

2. Now I want to import again, this time the XML contains additional entries BUT also the entries from the first import (additional IDs).

3. How do I import only the additional entries without overwriting any records that are already in the DB?

Just give me some basic idea on how to accomplish this...

Thanks in advance

Lars

[LaRetta]

You can set the ID to validation unique always (field definition Options - Validation tab). Then import and it won't matter if you show all records from your table first. Importing this way will only import IDs which do not already exist in your table. :^)

ADDED: You will receive an import error telling you not all records imported.

Edited May 4, 2012 by LaRetta

[meerestier]

Thank you for the quick reply. But I want to leave the records, that are already imported completely untouched.

In your scenario it would still update all the fields in the records in the DB... But I do not want that...

Any ideas?

[LaRetta]

My apology - you select ADD ONLY and not Update and Add To. Then existing records will not be updated - only new IDs added.

[meerestier]

Thanks again, I understand now...

No matching based on ID necessary, if there is an entry it is skipped.

Sometimes it is easier than anticipated...

Thanks anyways...