Delete Database Data
JustFood provides the capability for you to delete data through a configuration package. There are several methods that you can perform to delete database data:
Delete database data using the package data. In this method, you delete data from the database by updating package data, and then applying the package data to the database. For this method, data must exist in the package. If required, you can copy database data to a package. Copying database data to a package can be performed for a company with any status. The deletion is validated to ensure that other data will not be affected.
Delete database data when importing an Excel spreadsheet. In this method, you 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. To mark records for deletion, you must add the Import Type column to the spreadsheet, which is performed via the Configuration Worksheet page or the Config. Package Card page.
Delete database data with no validation. In this method, you delete database data with no validation. This can only be performed for companies that have on the Companies page, a status of Testing or Development.
Typically, when you want to create a clean company, you delete data with this method.
Warning
This method does not run data deletion integrity checks. Data will be deleted regardless of whether other data will be affected.
Note
You can only delete data from tables that you are licensed to access.
To delete database data using package data
Choose
, enter configuration packages, and then choose the related link.The Configuration Packages page opens.
Select the package that includes the tables from which you want to delete data, and then on the action bar, choose Manage > View.
The Config. Package Card page opens.
In the Tables section, select the table that has records that you want to delete.
On the Tables section action bar, choose Table > Package Data.
The Config. Package Records page opens.
For the records that you want to delete, select the Delete in Database check box. If you want to delete all the records, on the action bar, choose Process > Set Delete in Database, which will select the Delete in Database check boxes for all the records.
On the action bar, choose Process > Apply Data.
JustFood validates that the record can be deleted, and then deletes the selected records from the database.
To delete database via the Excel spreadsheet
Choose
, enter configuration packages, and then choose the related link.The Configuration Packages page opens.
Select the package that includes the tables from which you want to delete data, and then on the action bar, choose Manage > View.
The Config. Package Card page opens.
In the Tables section, for the tables from which you want to delete data, select the Import Type as Column check box.
This action adds a column at the end of the Excel spreadsheet, which allows you to define whether the record is to be deleted.
To modify the fields to display in the Excel spreadsheet, perform the following steps:
On the Tables section action bar, choose Fields.
The Config. Package Fields page opens.
For any fields that you don't want to be displayed in the Excel spreadsheet, clear the Include Field.
Important: For the Import Type line, ensure that the Include Field check box is selected. If you filter on Import Type=Yes, you can find the line, and ensure that the Include Field check box is selected. If the Include Field check box is clear for the Import Type line, the field is not included in the Excel spreadsheet.
Choose Close.
On the Tables section action bar, choose Excel > Export to Excel.
A dialog box appears.
To export the data to the Excel spreadsheet, choose Yes.
Enter a name for the spreadsheet, and then choose Save.
The Excel spreadsheet opens.
In the Excel spreadsheet, for all 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 page.
Select the table from which you are deleting data, and on the Tables section action bar, choose Excel > Export to Excel.
Navigate to the spreadsheet.
On the Functions, choose Apply Data.
A dialog box appears.
To apply the data, choose Yes.
The records marked as Delete have been deleted from the database.
To delete database data with no validation
Choose
, enter configuration packages, and then choose the related link.The Configuration Packages page opens.
Select the package that includes the tables from which you want to delete data, and then on the action bar, choose Manage > View.
The Config. Package Card page opens.
To delete the data from all tables listed in the package, perform the following steps:
On the action bar, choose Process > Delete Database Data.
A dialog box appears.
To confirm that you want to delete the database data, choose Yes.
The data is deleted.
To delete data from selected tables, perform the following steps:
In the Tables section, select the tables from which you want to delete data.
On the Tables section action bar, choose Functions > Delete Database Data.
A dialog box appears.
To confirm that you want to delete the database data, choose Yes.
The data is deleted.