Discussions

Expand all | Collapse all

Mass deleting records using info from a spreadsheet

  • 1.  Mass deleting records using info from a spreadsheet

    Posted 02-11-2020 19:31
    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
    ------------------------------


  • 2.  RE: Mass deleting records using info from a spreadsheet

    Posted 02-11-2020 21:16
    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
    ------------------------------