User Tools

Site Tools


jobmatix_jobtracking:maintaining_jobmatix

This is an old revision of the document!


Maintaining JobMatix

RetailManager Reference Database

The RetailManager database is maintained only via the MYOB Retail Manager application system. This includes Backup and Restore which must be done through RetailManager in the usual way. JobMatix does not write to, nor does it backup, this database.

JobMatix Reference Tables

All JobTracking reference tables are accessible to the user for updating and modification.
(Main Menu-> Reference->Edit Ref.Tables).

JobMatix Settings: To get to the Settings screen: Main menu->Admin->Setup->JobMatix Settings.

JobMatix Database- Backup and Restore

<html> <p>These functions are built on top of the basic SQL-Server <em>Backup/Restore </em> functionality. <strong><br /> The JobTracking database is hosted by the the SQL-Server service, and the database files should <em>not</em> be accessed directly by the user in the normal course of events.</strong></p> <p><em><strong>Important:</strong></em><br /> It is essential that SQL Server users (in fact everyone) have an appropriate disaster recovery plan for critical systems to ensure that important data can be recovered in the event of the loss of a server.. SQL Server databases are <strong><em>not</em></strong> normally recovered by simply reloading Windows data file backups.. When a server is re-built, SQL Server must be re-installed,and all databases RESTORED from their backup files using the SQL Server RESTORE function. The Microsoft MSDN website is a good source of Backup/Restore information:</p> <p><em>Introduction to Backup and Restore Strategies in SQL Server:</em><br /> <a href=“http://msdn.microsoft.com/en-US/library/ms191239(v=SQL.90).aspx”><br /> http://msdn.microsoft.com/en-US/library/ms191239(v=SQL.90).aspx</a></p> <p>Access to Backup and Restore SQL functionality is built into <em>JobMatix</em>, and is simple to access and execute.</p> <p><em>Backup</em> calls<br /> the SQL-Server &#8220;BACKUP DATABASE <em>databasename</em> TO DISK &#8230; &#8221; command to produce a <em>full</em> backup of the JobTracking database onto a backup file <em>(&#8212;JobTracking&#8211;.bak</em>) representing the complete database at that moment in time. The backup command is available in JobMatix whether it is running on the server or on a client system.</p> <p><em>Restore</em> calls the SQL Server &#8220;RESTORE DATABASE <em>databasename</em> FROM DISK &#8230; &#8221; command which will restore or re-create the database on the server. Restore can only be executed from JobMatix running on the server machine..</p> <p>&nbsp;</p> <p><strong>Notes on JobMatix Settings:</strong></p> <p>1. A sample text is provided for the <em>Terms and Conditions</em> printed at the bottom of the New Service Agreement form. It will be installed automatically in the Jobmatix SystemInfo table (item is <em>TermsAndConditions</em>) when the program is first run. This text can be edited by the user as required, by going the Setting screen. However, the overall size of the text should not be increased, due to the space restrictions on the printout.</p> <p>2. As part of the job completion process, <em>JobMatix</em> will print out the service record form ready for Job delivery. Additionally, if an appropriate barcode font is installed, the program will print out all the barcodes for the product codes and serial numbers for all stock items chargeable to the Job. This is to enable them to be easily scanned into the RetailManager sale transaction when the job is being invoiced out. The Barcode font must be provided by and installed by the business user on each user machine if needed.. The name of the font has to be entered into the JobTracking database through the JobMatix Settings screen..</p> <p><a href=“https://i2.wp.com/jobmatix.com.au/wp-content/uploads/2012/11/JobMatix-Barcode-Setup.png”><img class=“alignleft size-medium wp-image-229” alt=“JobMatix-Barcode-Setup” src=“https://i1.wp.com/jobmatix.com.au/wp-content/uploads/2012/11/JobMatix-Barcode-Setup-294x300.png?resize=294%2C300” data-recalc-dims=“1” /></a></p> <p>&nbsp;</p> <p>The default FontSize is 9pt. This can be changed by changing the value of the size setting (in <em>points</em>).</p> <p>&nbsp;</p> <p>&nbsp;</p> <p>&nbsp;</p> <p>&nbsp;</p> <p>&nbsp;</p> <p>&nbsp;</p> <p>&nbsp;</p> <p>&nbsp;</p> <p style=“font-size: 0.7em;”>&#8212; Page updated: 20-June-2012 10:40am. JobMatix Team</p>

jobmatix_jobtracking/maintaining_jobmatix.1481022226.txt.gz · Last modified: 2016/12/06 11:03 by azmin