Data Manager

Systems->Data Manager Menu: n/a Action: none The Data Manager is a special utility used to correct problems with your data that may stop ProfitSystem® from operating correctly. There is normally no reason to be in the Data Manager unless you are having data problems. No one can be using ProfitSystem® when you are using the Data Manager. Please review the General Question topic, ProfitSystem will Not Start of Having operation trouble for detail information on how to utilize the Data Manager when ProfitSystem© is having issues..

Available Functions Reindex Tables...Re-creates special “index” files used by ProfitSystem®. You cannot harm your data by reindexing. Update Data...Checks all your data files to make sure they have the correct structure. This option will also reindex your files. This option is performed automatically when you update to a new version of ProfitSystem®. You will be prompted for the location of the data files to update. They are normally located in \TPSWINS\LIVEDATA. See 'Update data technical details' below. Backup Data...Makes a backup of all your ProfitSystem® data files. It creates a file called BACKUP20010112.ZIP (BACKUP + year + month + date.ZIP) It is not meant to be used as your daily backup. It is it be used to make a quick backup before using Data Manager to work on your data files. Repair Headers...This option is used to fix damaged data files. It does a quick repair. You should have a data backup before attempting to use this utility, in case it makes the problem worse. You will be prompted for the location of the data files to update. They are normally located in \TPSWINS\LIVEDATA. You will then be prompted for the files to repair. Reset Security to Default...This option is used to set the security settings back to their defaults, allowing everyone access to all parts of the program. It would be used if the security was incorrectly configured, locking users out of ProfitSystem. You will be prompted for the location of the data files to update. They are normally located in \TPSWINS\LIVEDATA. Validate Actions/Transfer...This option checks the Transfer/Actions list to make sure no entries are missing. This option would be used if ProfitSystem is displaying a message such as 'No entry in the Actions/Transfer table for' You will be prompted for the location of the data files to update. They are normally located in \TPSWINS\LIVEDATA. Validate Query Data Dictionary...This option checks the query data dictionary tables to make sure no entries are missing. This does not remove any queries. It is used if tables or fields are missing from the Querymaker. You will be prompted for the location of the data files to update. They are normally located in \TPSWINS\LIVEDATA. Validate Ship Options...This option checks a table that contains the various shipping carriers, shipping options, etc. has all the correct entries. You will be prompted for the location of the data files to update. They are normally located in \TPSWINS\LIVEDATA.

Is ProfitSystem in Use?...Displays a message indicating if the data files are in use. The data files cannot be in use for these utilities to be run. You will be prompted for the location of the data files to update. They are normally located in \TPSWINS\LIVEDATA. Force ProfitSystem exit...Prompts you for the data directory and sends a message to the registers using the data in that directory telling ProfitSystem® to shut down. Note that this does not close the register, it only shuts down ProfitSystem®. This will only work if the register is at the main menu. Lock out users...Creates a text file called LOCKOUT.TXT in the \TPSWINW program folder, which stops ProfitSystem from starting. Note that this only works on a terminal server, where there is one program folder shared by all users. Remove lock out...Removes the LOCKOUT.TXT in the \TPSWINW program folder, which stops ProfitSystem from starting. Note that this only works on a terminal server, where there is one program folder shared by all users. Get database version...Displays the database version stored in the database, along with the current program version. The database version is updates automatically to the program version when the databases are updated by the program.

Integrity Check...Checks the contents of your data files to make sure data needed by the system is present. Data Utilities...Contains a number of specialized data update utilities. These should only be used under the direction of BBL Customer Service. Create Blank Data...Prompts you for a directory and creates a blank set of ProfitSystem® data. This should not be done in the \TPSWINS\LIVEDATA folder because the existing data will be overwritten and lost. Share Data Folder... Will automatically set the permissions on the data folder (location of ProfitSystem data files) to share read/write for all users. This would be done via a logged in Windows user with Admin privileges.

Database repair...Attempts an automated data repair. See 'Database repair technical details' below Enable data repair...Removes flag file NOREPAIR.TXT. If the file is present, database repair will not automatically start. Disable data repair...Creates flag file NOREPAIR.TXT. If this file is present the database repair will not automatically start. Remove DB repair flag...Removes the FLAG file, which indicates that data problems were detected and the database repair will start automatically.

Update Data Technical Details Update data actually performs a series of operations.

Make a backup of the
data files.  The backup file is named YYMMDD.ZIP and is placed
in the parent folder of the Livedata folder.


Install the new database
meta data.


Update the existing
data tables to match the structure of the new database meta data.


Reindex all data tables.


Make sure all records
in the Users table have a valid primary key.


Add the WALK-IN customer
if missing.


Make sure all wholesale
rental orders have a valid customer name and event name.


Add any missing system
defined style codes.


Make sure all registers
belong to at least one store.


Make sure all inventory
records have a store id.


Make sure every style
code has an OTHER size record.


Make sure every size/color/width
has a valid quantity record for each store.


Make sure every size/color/width
has at least one receive history record.


Make sure all OTHER
records have a QOH of zero.


Make sure all taxes
records are logically consistent.


Clear any existing saved
credit cards.


Make sure all accounting
class names are uppercase.


Move old actions from
prospect to new todo table.


Clear any logged credit
card entries.


Remove any letters from
extra charge size ranges.


Make sure every owned
store has a Store record.


Delete orphaned size,
store QOH, and receive history records.


Extract all inventory
images from the database storage and move to livedata\InventoryImages.
 Move customer/prospect images to livedata\CustomerImages


Move web store settings
to style level for BigCommerce.

Database Repair Technical Details

Make a backup of the
data files.  The backup file is named YYMMDD.ZIP and is placed
in the parent folder of the Livedata folder.


Validate the database,
removing bad tables.


Check Tickitem for duplicate
records and remove them.


Check Sinvstor for duplicate
records and remove them.


Delete all the index
files.


Update the database
structures.


Repair headers on all
the files.

Database repair creates a log called FIXLOG.TXT in the livedata folder.