removing imported records with specific values

[madman411]

Hi All

 

I need a bit of help. I've developed a database for a motion picture rental company I work for which allows staff to track the Quality Control progress of filters that come back from gigs. The rental software they use (Oracle) uses a separate system in which we export an excel spreadsheet with the required data once a week, and import the data to the correct table in filemaker. Problem is, sometimes irrelevant records are imported, such as filter trays, filter rings, etc, rather than just the filter itself. Instead of manually removing these stray records from thousands of imported records on a weekly basis, is there a script or command I can run that will search (for example) trays, rings, etc, and remove them from the table? This will save a lot of time!

 

Thanks for any help.

[webko]

Simple manual method - get a layout with the relevant field on it, search for "ring" and should find all records with "ring" in the field. Make sure that really are not required and Delete Found Records...

 

Repeat for variations.

 

If you are *really* sure that you will never want a record with "ring" in it, then you can write a script that does this automatically...

[comment]

You could probably set up some field validation which would prevent importing the unwanted records in the first place.

[Vaughan]

I usually create an "importer" that puts the new records into a temporary table (often a separate file) and processes them. Once checked, then import into the main table.