Data Archiving

In the Data Archiving section, you can define two types of tasks: archiving and cleanup.

Archiving

Archiving is handy for maintenance of data in tables. A typical scenario is when your tables grow too big and contain data you never use (i.e., old data). With the archive task you remove the data from tables but still keep a backup of it. Archiving moves the selected data out from the tables into an archive (ZIP).

Archiving is available for these tables: Customer, Product, Product Competition, Product Extension, Customer Extension, Price List.

 When you archive Product/Customer Extensions, their meta data is still kept in the database.

Cleanup

The cleanup task helps you get rid of unused or stale data (e.g., when you delete a customer, but in other tables there are still references to this customer).

This task currently cleans:

  • Stale Customer Extension / Product Extension records, i.e., rows with the "name" field set to a value that is not in the configuration anymore. (The task does not check Product Competition (PCOMP) data.)

  • Orphaned records (i.e., records of PX/CX where sku/customerId references a row that does not exist in the master data).

Create a Cleanup / Archive task

To set up an archive/cleanup task:

  1. Go to Administration > Configuration > Import / Export / Archiving > Data Archiving.

  2. Click the New Archive button and fill in the task label.

  3. In the Type field select one of the options:

    • Archive – The data will be removed from the tables and put in a ZIP file.

    • Cleanup – The removed data is put in a ZIP file.

  4. For an archive task, click the Configure button and select the data source to be archived.

  5. Click the Start button to run the task.

  6. When finished, the task status changes to Ready and you can download the ZIP file using the Download button.
    If the ZIP file is empty for the clean up task, there were no data to be removed.

Found an issue in documentation? Write to us.

 
Pricefx version 13.1