Deleting data records in bulk
To remove data records more quickly, make your changes in bulk by importing a .csv file.
-
Upload the file.
- In the navigation panel of App Studio, click Data.
- Click Data types and integrations.
- Click a data type.
- On the Records tab, click Import.
- In the Purpose list, select Delete.
- Click Choose File.
- Navigate to your .csv file, and then click Open.
- Click Next.
-
Map a column in your file to the key field in the data type.
For example, your file may identify employees by Staff ID but your data type stores this information in the Employee ID field. If your data type has multiple key fields, repeat the following steps for each field.
- In the Match existing records by field, press the Down Arrow key, and then select the column in your file that uniquely identifies each data record.
-
Click Select, and then double-click the field in the
data type that corresponds to the column.
Tip: To narrow the list of fields, enter text in the Search field, and then click outside the field.
- Click Next.
- Click Import.
-
If there are failures displayed in the Current import
statistics section, resolve them.
- Click Download.
- Follow the instructions in the .csv file to fix the rows that have errors.
- Close the Import progress dialog box, and then retry the import process with your updated file.
- Click Finish.