FaxChange news Content User documentation Administrator documentation Index of terms Technical Support Search on-line
Archivation tools

Tools described here are intended for fax database maintenance - its archivation and deletion.

Archivation tool

Tool allows to copy/move faxes and information about them from fax database into MS Access database for archiving purposes and saving disk space by moving records from fax archive. Access database created by tool can be burn to the CD and data can be viewed using fxArch program without importing data back to FaxChange working database.

fxArchTool is unusable for je operational database backup, because:

Use standard tools of your database server for operational database backup. For MS SQL server backup FaxChange_Fax (information about faxes), FaxChange_File (fax image data) and FaxChange_Info (users, CSID, PABX etc) databases.

Tool is started from Start menu - Faxchange - Tools - Database Archivation Tool and uses GUI interface.

Enter path to MDB file, where data will be archived to. Records can be moved or copied. Utility alow time selection of records for copy/move. If you move records to external database, you can next time to add another records to the same database by specifying the same path and filename.

But you CAN'T add duplicity records - program report an error message about possible reasons and exit -- in this case data in FaxChange database left without any change, destination database contain only records which has been processed until program exited due to duplicity. This is valid for both copying and moving records.
For example you can not first copy some data to external database and then to try move the same data to the same database.

We recommend for each data move use different destination database file.

back to top of page

Fxarchtool

Command line utility for archiving FaxChange faxes. Located in \utils directory of the installed FaxChange. 
fxArchTool.exe [-h] [-d yyyy[mm[dd]]] [-o number] [-l log] [-r] archive
Arguments:
-h  help
-d  archive faxes as specified by date "yyyy[mm[dd]]":
     yyyy - archive faxes processed in year "yyyy"
     yyyymm - archive faxes processed in year and month "yyyymm"
     yyyymmdd - archive faxes processed till the day "yyyymmdd"
     (default is current date as "yyyymmdd" with second precision)
-o  archive faxes older than "number":
     days if -d is not specified or is specified as "yyyymmdd"
     months if -d is specified as "yyyymm"
     years if -d is specified as "yyyy"
     (default is 0)
-l  redirect output to file "log"
-r  remove archived faxes from FaxChange database
archive  MDB file where the faxes are going to be archived. Path should be enclosed in quotations and can contain environment
variables like %date%.
Examples of usage:
Archive faxes older than 2 month:
fxArchTool -d %date:~10,4%%date:~4,2% -o 2 d:\faxarch\faxes.fx.mdb
(Current year and month in cmd is "%date:~10,4%%date:~4,2%". This expression is dependent on %date% environment variable format. Mentioned format is valid for English regional settings)

Archive faxes older than year
fxArchTool -d %date:~10,4% -o 1 backup.mdb

Archive faxes older than 30 days
fxArchTool -d %date:~10,4%%date:~4,2%%date:~7,2% -o 30 d:\faxarch\faxes.fx.mdb

Archive faxes older than one day
fxArchTool -o 1 d:\faxarch\faxy%date:~10,4%%date:~4,2%%date:~7,2%.fx.mdb

back to top of page

FxarchErase

The FxArchErase program helps you with the fax database maintenance. It can delete faxes older than specified number of days from the database. It is located in \utils directory of the installed FaxChange subtree. You don't need run it directly on the server where database to be modified resides.

Usage:
FxArchErase <num_days> <server>
num_days - faxes older than specified number of days will be deleted
server - name of Faxchange server, which database will be cleaned

Attention:
FxArchErase only deletes faxes from database, but doesn't get the database smaller! For example: database has 100MB, you will delete all faxes - but the database is still 100 MB large. For decreasing the amount of occupied spaceyou have to compact the database. You may use utility (for Access database) - Faxchange/setup/bin/_compact_db.cmd - for this purposes.

back to top of page