How to Delete Database Data

You have the ability to delete data through a configuration package. There are several ways to delete database data:

Delete database data using the package data
Delete database data when importing an Excel spreadsheet
Delete database data with no validation

Note: You can only delete data from tables that you are licensed to access.

To delete database data using package data

These steps allow you to delete data from the database by updating package data, and then applying the package data to the database. To be able to do this, data needs to exist in the package. If required, you can copy database data to a package. This can be done for a company with any status. The deletion is validated to ensure that other data will not be affected.

Choose the Search icon, enter configuration packages, and select Configuration Packages.
Open the package that contains the tables that you want to delete data from.
In the Tables FastTab, select the table that has records that you want to delete.
On the Table tab, choose Package Data.
Select the Delete in Database check box for the records that you want to delete. If you want to delete all of the records, choose the Set Delete in Database action on the Home tab, which will select the Delete in Database check box for all of the records.
On the Home tab, choose Apply Data. JustFood will validate that the record can be deleted, and then will delete the selected records from the database.

To delete database via the Excel spreadsheet

These steps allow you to define which records to delete from an Excel spreadsheet. When the Excel spreadsheet is imported, the records marked as Delete are deleted from the database when applying the data. In order to mark records for deletion, you need to add the Import Type column to the spreadsheet, which is done via the Configuration Worksheet or the Config. Package Card.

These steps show how to add the Import Type column to the spreadsheet using the Config. Package Card window.

Choose the Search icon, enter configuration packages, and select Configuration Packages.
Open the package that contains the tables that you want to delete data from.
On the Tables FastTab, select the Import Type as Column check box for the tables that you want to delete data from. This adds a column at the end of the Excel spreadsheet, which allows you to define if the record should be deleted.
Modify the fields to display in the Excel spreadsheet:
1. On the Table tab, choose Fields. The Config. Package Fields window opens.
2. Clear the Include Field for any fields that you don't want to be displayed in the Excel spreadsheet.
  
  Important: Make sure that Include Field is selected for the Import Type line. If you filter on Import Type=Yes, you can find the line quickly, and make sure that the Include Field check box is selected. If Include Field isn't selected for the Import Type line, then it won't be in the Excel spreadsheet.
3. Click Close.
On the Excel tab, choose Export to Excel.
Click Yes to export the data to the Excel spreadsheet.
Enter a name for the spreadsheet and click Save. The Excel spreadsheet opens.
In the Excel spreadsheet, for all of the records that you want to delete, change the value in the Import Type column to Delete.
Save and close the spreadsheet.
Return to the Config. Package Card window.
Select the table that you are deleting data from, and on the Excel tab, choose Export to Excel.
Navigate to the spreadsheet.
On the Functions, choose Apply Data.
Click Yes to apply the data. The records marked as Delete have been deleted from the database.

To delete database data with no validation

These steps allow you to delete database data with no validation. This can only be done for companies that have a status of Testing or Development on the Companies window.

You would typically delete data this way when you want to create a clean company.

Warning: This function does NOT run data deletion integrity checks. Data will be deleted regardless of whether other data will be impacted.

Choose the Search icon, enter configuration packages, and select Configuration Packages.
Open the configuration package that contains the tables that you want to delete data from.
To delete the data from all of tables listed in the package,
1. On the Home tab, in the Process group, choose Delete Database Data.
2. Click Yes at the confirmation message. The data is deleted. This may take a while depending on the number of records.
To delete data from selected tables,
1. In the Tables FastTab, select the tables that you want to delete data from. Tip: Use <Ctrl+click> to select more than one table.
2. On the Functions tab, choose Delete Database Data.
3. Click Yes at the confirmation message. The data is deleted. This may take a while depending on the number of records.

How to Delete Database Data

To delete database data using package data

To delete database via the Excel spreadsheet

To delete database data with no validation

See Also