The purpose of this article is to explain export tables. The export data feed is an ad-hoc data feed that populates based on information uploaded by planograms to the database. This information can be used for data reports.
Applicable products: DotActiv Free, DotActiv Lite, DotActiv Pro,
DotActiv Enterprise
Export Tables Process
This data feed forms part of the original staging table deployment.
To understand how to populate staging table data, please read the articles under Step 5 of the database integration process article here.
You can download the Generic Staging Table format here. It will also show you which fields to populate with information.
You are required to populate and update this table with data as often as you need it.
The DotActiv application sets up an extraction job (SQL server agent job), which runs automatically. In this way, the data is always readily available whenever you need it.
You can access this data by setting up a data cube and exporting the data to CSV for easy quick access. Learn how to set up a data cube here.
The export data feed provides great insight into your space planning and can and should be used wherever appropriate and possible.