Quote:
Originally Posted by kiwidude
Your explanation above was sufficient. What confused me was your original explanation,
|
Sorry I wasn't clear
Quote:
|
However your responding post was much clearer and sounds to me the same as what we have been proposing in earlier posts, just with a combobox of automerge suboptions instead of radio buttons. Great stuff.
|
The code is done, except for cleaning up the label text and tooltips and one detail. What do I do for the "New Record" option when I have multiple matching records?
The functionality for multiple matching records hasn't been mentioned here before, but in the existing automerge code (to be the "Ignore" option in the new code) we put a new incoming format into all matching records, if possible, and ignore it, if not.
For "Overwrite" I'm going to overwrite or add the format to all - again that's easy and already done.
The question is: what to do with the "New Record" option for multiple matching records?
Suppose I have 5 book records already in the database, all with the same author/title, but some with the same format as the incoming format and some without. Is this a "create a new record" situation or not?
1) Shall I add the new incoming format to the records that don't have it and create exactly one new record?
2) Or do I
not create the new record because the incoming format was already added to at least one existing book record?
3) Or do I create one new book record every time I find an existing book record I can't add the new format to (but add it to all records where possible) - thereby creating multiple identical new book records.
4) Or do I create one new record and not add it to any existing records?
5) Or do I create one new book record every time I find an existing book record I can't add the new format to (and not add it to any existing records).
I lean towards option 1, but option 3 is how the new code is working now. Option 3 is stateless - as in I don't need to keep track of what I did (or will do) for other matching book records. I just check each matching book entry, compare the new format to the formats in that record and create a new record if I can't stuff the incoming format into the matching book record.
Note that for option 3 you automatically get one independent record for every case where you already had that format in another record. You can then work your way through that list and manually "Merge-Delete Others" each record into the existing record that caused it to be created (where you wanted overwrite) or just delete it (where you wanted ignore) or just manually delete all but one (if you like option 1)
Can I convince anyone option 3 is the best .... it's much easier - because it's already done.
Comments?