System operation
StockSAVER manual - Software version 2.1
58
Field ID
Data type
Description
SensorCount
[int]
Number of sensors in this Location.
MinimumBoxCount
[int]
Safety Stock Level (eg value = 2; safety stock is
breached if < 2 bins are present).
If no safety stock is defined for the Location, an
empty string will be exported.
ReorderBoxCount
[int]
Reorder level (eg value = 2; reorder level has
been reached if ≤ 2 bins are present).
If no reorder level is defined for the Location,
an empty string will be exported.
AboveMaximumBoxCount [int]
Excess stock (eg value = 3; excess stock has
been reached if ≥ 3 bins are present).
If no excess stock is defined for the Location,
an empty string will be exported.
Resync
[bit]
Permissible values:
0 = The entry is not a resync entry
1 = The entry is a resync entry: Bins have been
withdrawn or replenished while the system was
offline. Deposits and withdrawals that took
place can’t be individually tracked. The new
stock level is saved in this data set.
DeltaBoxCount
[int]
Bin difference from the previous log entry for
this Location/material.
Negative = withdrawal
Positive = replenishment
DeltaAmount
[int]
Quantity difference to the previous log entry
for this Location/material.
Negative = withdrawal
Positive = replenishment
Configuration and Import process
The CSV export is performed by the WERMA StockSAVER Server Service, i.e. the export file is
created on the server.
The following is recommended for optimum availability of the CSV interface:
−
The export file must be saved on a local data carrier (not on a network drive).
−
An exception for the export file must be configured in the virus scanner to ensure that the
file is not fully scanned during every export.
−
The WERMA StockSAVER Server Service requires write permission for the directory. The
Server Service is executed under the Windows user account 'network service'.
Access to the CSV export file by an interface program must run as follows:
1.
Wait until the export file has been created.
2.
Rename the export file. If a file access error occurs, repeat this attempt. A file access error
will always occur if the Server Service has just opened the export file to add other entries.
3.
The renamed export file can be edited and deleted or archived as required. If the file is
archived, this must be done in another directory or a subdirectory to prevent too many
files being created in the actual export directory.