2 Replies Latest reply on Sep 8, 2011 11:53 PM by symbister

    De-duping records



      De-duping records


      Hi - using FMP 11 on Mac OS 10.5.8

      We have a contact database of some 9000 records, in one table 'picacontax'. A number of those records have ticket purchase data attached to them via relational link to a secondary file ('sabosales') which displays in a portal. However occasionally a ticket-purchase record is initiated in the secondary data source without checking if that purchaser already has a record in the secondary data source. I should add that the ticket purchase data is uploaded from an Excel spreadsheet that has been exported from a non-SQL source.

      So I end up with two (or more) duplicate records, with similar address details etc, but with two different Patron ID's which therefore link to two different records in 'sabosales'.

      I'm trying to set up a de-dupe script that, once two records have been found manually, the operator is then prompted to 'retain' one, keeping one Patron ID, merging the purchase data from both Patron ID's into the chosen retained one, and deleting one main record.

      So ideally, once an operator has identified the two records to merge, clicking a 'merge' button pops up a side window, asking the operator to select from a radio button set, which Patron_Id to 'keep'. - but how do I populate that radio button field with only the Patron Id's of the found set? I know it has something to do with TO's but ...

      The script would then replace the 'discard' Patron_Id in 'sabosales' with the 'retain' one, return to the main table and delete the record with the 'discard' Patron ID.

      does any of that make sense - and how do I do it...? any help appreciated



        • 1. Re: De-duping records

          It would be simpler to list the matching records in a portal and then clicking a button in the portal row could perform your script to select that records Patron ID as the ID to use for all the records shown in the portal.

          Portal filtering can use text you enter in a field above the portal to pull up just your records with similar addresses.

          Does that sound like something you could get to work? Are you using FileMaker 11 (required for this kind of portal filtering here.)

          • 2. Re: De-duping records

            Thanks once again Phil

            Unfortunately we have a selection of FMP11, 9 and 8.5 so a 'portal-filtering' solution won't work, but the 'listing matching records in a portal' works fine - now I just need to work through the logic of merging and purging