2 Replies Latest reply on Jul 18, 2013 8:54 AM by NikSol

    Cleaning database

    NikSol

      Title

      Cleaning database

      Post

           Hello,

           I've got a bit of a problem and thought may be someone can help me out. We have a database of around 15k records and we've been getting some email bounces from around 500 records. So now I'm trying to delete those records.

           I've got a CSV list with the corresponding email addresses and trying (to no avail) to make filemaker search through this list and delete the records. Is there really no other way as to go through each email one by one? May be someone has a script for this?

           Thanks!

           Nik

        • 1. Re: Cleaning database
          philmodjunk

               And how do you get the CSV data into fileMaker so that it can use the data?

               You should be able to import the data into a table and then use either a relationship between that table and your table of emails or a script that loops through these records and uses the data one at a time to find records in your main table to locate the records for possible deletion.

          • 2. Re: Cleaning database
            NikSol

                 Ok. I got it. Through import I was able to solve the problem. Just added an additional column and filled each row with 11111. Then while importing targeted emails to the appropriate field (through matching mapping of course) and the 11111 value to Company name field (import this field mapping).

                 This way company name values were changed only for corresponging email addressing and then through company name field search I was able to track all the entries.

                 Hope it helps someone!