146 - Inepro Back Office Suite
Advanced Tasks
Remove a User (User data) from the System
Prerequisites:
§
Undesired User(s)
Where
§
Main Menu\Basic\Users
§
Main Menu\Tools\Import Users and Related Details via CSV
§
Main Menu\Tools\Clean Database...
Removing User (Data) from the System
Users can not easily be deleted from the Inepro system once they have made a transaction. This is because a User has a
Card and or an Account-Tag with transactions, these transactions cannot be deleted as they would cause a financial
unbalance in the system.
Manual
As Users can be deleted as long they did not made a transaction, if they did, they cannot be deleted manually. The User can
be detached from the card and the card or account can be deleted, but the card or account will not be removed from the
database, only from the view. Furthermore, the aggregated data will still be visible in the reports.
*.csv
Users can be deleted by using a *.csv file, but with the same restrictions as a manual removal.
Clean Database
With the clean database the database can be purged up through a certain date. At that moment all User and transaction
dating from before that date will be eliminated, and cannot be retrieved ever again.
So before using this procedure, make a backup from the database and verify it's a correct functioning backup.
Prerequisites:
Undesired User(s)
A *.bak backup from the IBOS database.
Where
Main Menu\Advanced\Site Types
The user data and their transactions are stored in the database. This will accumulate to a large amount of data over the
years. Sometimes the old data and old user transactions are no longer needed. This data can be purged using the Cleanup
Inepro Back Office Suite database tool.