«Proximity Promoter 24x7» - Database

It’s a distinctive feature of the application that all files meant for the distribution are stored in a database, in a single file BTPBASE.BS. In other words, right as you have added a file from disk to «Proximity Promoter 24x7», the entire file is saved in the database, and you no longer need to keep it on disk at the same location, as well as you don’t need to care of maintaining the file structure during the distribution process. Storing all data in a single file ensures the convenience when transferring the data to a different computer and the convenience when backing up the entire database. You can format your campaign on one computer and then simply copy the BTPBASE.BS file to a dozen of other ones to avoid repeating the same routine ten times. Also, the database file stores information on the composition of campaigns, scheduler records, MAC address exception list and the history of all distributions ever run.

Where is the database file located?

The BTPBASE.BS file is located in the Documents folder, common for all users.
In Windows XP, that folder is located at:
C:\Documents and Settings\All Users\Documents\Proximity Promoter 24x7\DB\
In Windows Vista, that folder is located at
C:\Users\Public\Documents\Proximity Promoter 24x7\DB\

See dialog "About" - "System Information":

btp-db-path-en.png

Moving database file to another computer

Use the main menu to save the BTPBASE.BS file to any temporary folder:

btp-db-save-as-en.png

Copy the file to the necessary computers, placing it to the folder mentioned above.

Backing up database file

Use the main menu to save the file with any name:

btp-db-save-as-en.png

To restore the backup file, close the «Proximity Promoter 24x7» application, rename your backup file to BTPBASE.BS and then re-write it to the folder specified above.

Deleting information from database

Some data entry and deletion operations have been grouped in a separate menu:

btp-db-delete-en.png

Packing database file

As the application keeps running, "bubbles" from deleted data may occur in the database file. That is a normal process, since the data doesn’t get physically removed right off, first it gets marked as deleted. The packing routine straightens database file, removing such "bubbles" and cutting the file size. The packing routine doesn’t affect the performance application of the; you can run it whenever you wish to. Make sure you have stopped the distribution of your files before launching the packing routine.

btp-db-pack-en.png