Forum Discussion

ChrisSwirtz2's avatar
ChrisSwirtz2
Qrew Cadet
6 years ago

Mass deleting records using info from a spreadsheet

I have a spreadsheet with 2400 or so Workstation names that represent records in the Workstation table that need to be deleted. Is there a better way to go about deleting these records than finding them one by one in the table? My initial thought was uploading the spreadsheet matching the field and it would potentially just update those fields and I could then search by last modified perhaps. But not sure if that will work like I am thinking, specifically because the upload won't actually change any info.

------------------------------
Chris Swirtz
------------------------------
Data import and export
  • DonLarson's avatar
    DonLarson
    Qrew Elite
    6 years ago
    Chris,

    Yes you want to upload the spreadsheet matching the current Record ID#.   The trick here is to add a column of data with the value of "1".   When you import create a new field as a Check Box.   Call it Temp Delete or some other variant on that.

    After the import you can run a custom report where you set the filter:

    [Temp Delete]=True

    Then delete all the records in the report.

    Poof.  They are gone.

    I suggest going back into the table and getting rid of the new field so that it will not cause confusion in the future.


     


    ------------------------------
    Don Larson
    Paasporter
    Westlake OH
    ------------------------------