iVend POS - Purge Data to Reduce iVend Store database size

iVend POS - Purge Data to Reduce iVend Store database size

Introduction

The Data Purging feature in iVend helps the Administrator to control the size of the iVend database at each store. Data purging at stores is controlled centrally and is managed from the iVend Enterprise at Head Office. The Administrator can also view the status of the data purge that is carried out at the store. Once data purge activity is scheduled and triggered from the iVend Enterprise the actual data purging occurs at the store when the Store Manager runs the End of Day routine.

Purpose

To help the Administrator to control the size of the iVend database at each store.

Purging Data

In the following article, we will see how to setup and use the Purge Data functionality in iVend retail.
Figure – Data Purge Search
1. Log into the iVend Management Console and go to Administration > IT Administration > Purge Data.
 This option is only available at the iVend Enterprise Level.

2. By default, the list of created Data Purges that are scheduled are displayed. The user can search from existing Data Purges that are scheduled by entering the Schedule Date and pressing the [F1 Search] button.
3. To create a new Scheduled Data Purge for a store, press the [F3 New] button.
Figure – Data Purge Screen
4. This feature enables the Administrator to start the data purge activity at the stores. Using this, the System Administrator can generate an event for performing a data purge at the store.
5. This feature is generally used in the scenarios where the stores are using the SQL Server Express Edition. Due to size limitations of the SQL Server Express Edition database, the Administrator should keep the store database size in check and therefore this activity is recommended to be performed at regular intervals.
This menu option is only available at the iVend Enterprise. Using this option would delete the transactional information from the store database.

Field

Description

Purge Transaction Before

Enter the date for which the data needs to be purged. The earlier transaction data will be purged from the date defined.

Clear Audit Log

Audit log data will be purged when this checkbox is checked.

[Add Store]

Use this button to choose an individual store for which the data purge needs to be run.

[Add All Stores]

Selecting this button will add all the stores in the network and the data purge will be run for all of them.

[Delete Store]

Choose this button to remove a selected store from the data purge screen. Any store not showing on the data purge screen will not have a data purge performed on it.

StoreID

Displays the Store Id for which the purge will be run.

Run Date

Shows the date on which the purge will be run.

[Start]

Clicking this button will start the data purging process for the selected stores.

[Cancel]

Clicking this button will Cancel the changes made, the data purge will not be performed and the window will close.


7. Once the information has been entered, click the [Start] button. Please remember that once this is done, the information entered here in the Purge Data window cannot be edited or deleted.
8. The Purge Data Schedule will be replicated to all the retail stores that are included in the run. The Data Purge process will automatically run when Store Manager runs the End of Day process
9. Once the Data Purge run has been successful at the stores, the transactional data will no longer be available.
10. The Administrator can view the last successful Data Purge Run Date at the Enterprise Management Console.


    • Related Articles

    • iVend Offline POS - Purge Data for Offline POS Database

      Product Query Is there any process to purge Offline POS Database? From HO Server only is possible to purge the store database but not offline pos. Environment iVend 6.6 Solution As per current iVend functionality Data purging (from iVend Management ...

    • Addon information was not updated for newly created store

      Environment: iVend 6.6 integrated with SAPB1 Problem Statement: Addon information was not updated for newly created store Symptoms: Not Applicable Resolution/Work Around: Issue is already fixed in the latest iVend patch (8567). As a workaround we ...

    • Require to make the inventory as Zero for particular store

      Environment: iVend 6.6 with SAP B1 10 Problem statement: Require to make the inventory as Zero for particular store. Symptoms: products Inventory show in negative and some are in positive numbers. Resolution/Work Around: There is need to check if SAP ...

    • SQL Queries : iVend Enterprise /HO database Purge

      ****************INTERNAL TO SUPPORT TEAM ( Not for Customers) ************************* Note:-This article is created only for Support team and will be done along with product expert. Environment: iVend 6.6 integrated with SAPB1 Problem Statement: ...

    • Data not purging on store server properly

      *********** For Internal CitiXsys Use only *********** Environment : iVend 6.6 Problem Description : Data is not purging on for a single store at the time of EOD. Scenario : On a store data not purging properly and the database growing larger by the ...