File Maintenance Utility | Toshiba Electric Keyboard guide

File Maintenance Utility

177

12 File Maintenance Utility

Symphony Pro File and Database Maintenance Utility

!!WARNING!! The aspects covered by this utility are technical. Given the critical nature of the Symphony Pro system data and because it is possible to seriously damage the information in the database, we suggest you do not attempt any database manipulation unless you are absolutely certain of the results of the operation. Please contact your Authorized TEC Dealer for technical support.

Symphony Pro provides a utility to handle database tables, used to backup and restore information from the tables, or re-index and pack tables. Some of the options controlled by the File maintenance utility can be run from within Symphony Pro as automated "Events". For example, the backup operation. However, the File Maintenance utility is a "Stand alone" program, not linked with the Symphony Pro program or other module. To launch the File Maintenance utility, open the Windows "Start" menu, "Programs", "Symphony Pro", "File maintenance" option.

NOTE: Since the File Maintenance utility accesses the data tables, they must not be in use during operations. To ensure the tables are not being accessed, you should close Symphony Pro before running this utility.

This example shows the Symphony Pro "stand alone" File and Data table Maintenance Utility.

© 2005 TOSHIBA TEC AMERICA AMERICA RETAIL SYSTEMS, INC. R1.0a

Image 179

Toshiba Electric Keyboard owner manual File Maintenance Utility 177, Symphony Pro File and Database Maintenance Utility

Contents

Toshiba TEC America Page Table of Contents 114 106 Part VII View Log Part File Maintenance UtilityPart V Report System Part VI Entry Module 181 Part Phone no 449-3040 FAX 770 Limited WarrantyLimited Warranty Symphony POS Software Security About Symphony Pro applicationOverview Data Storage Printing Help as a Manual Navigating the Symphony Pro Application Using the mouseUsing the keyboard Navigation Polling Process Understanding CommunicationsTo print the entire paper manual Controlling Database Size Data MaintenanceDaily Maintenance Process Monthly Maintenance Process Protecting Your Data Backups Are ImportantSymphony Pro Data Backup Physical Backup Main Menu Symphony Pro Main MenusFile Menu Symphony Pro Main Menus Logging into the System LoginSymphony Pro File Menu Options Logging off the system Setting the LanguageLogout Language Viewer Display View Internal ProcessWhats Happening behind the scenes View internal process Buttons This example shows the Internal Process viewerStatus bar and control buttons Status Bar View menu Files Menu Menu Options View Polling StatusView Polling Process This example shows the Polling Process viewer Viewer Display windows Execute Command FileForcing Commands Sending Information From One Database Table Deploy Individual FileOther Tasks This example shows the Deploy one file table selection tool Configuration PanelBasic Symphony Pro Set Up Information Company Company Tab Settings TO=STORE103 System System Tab Settings This example shows the Configuration panels System tab Toshiba TEC America America Retail SYSTEMS, INC. R1.0a This example shows the Configuration panels Misc tab Misc Misc Tab Settings Host Host Tab Settings Host data communications This example shows the Configuration panels Host tab Toshiba TEC America America Retail SYSTEMS, INC. R1.0a Number of days to keep individual terminal Cleanup Cleanup Tab SettingsThis example shows the Configuration panels Cleanup tab Number of days to keep processed files Load Files Load Files Tab SettingsNumber of days to keep successful log Number of days to keep all log Because it will be overwritten This example shows the Configuration panels Load Files tab Establishing access levels Security Security Tab Settings Security System Overview They can modify, add or delete it This example shows the Configuration panels Security tabTo assign security levels Julian Date Send urgent message to Symphony ProDate Conversion Calendar and Date Conversion Utility Messages Utility Using the Messages UtilityMessages Unix Date Exit the Symphony Pro Application Show TipsExit Show Tips Symphony Pro File menu Option Modules Menu Options Modules Menu Symphony Pro Desktop Icon shortcuts Special Menu Options What is it for?Special Help Version numbers Maintenance ApplicationSymphony Pro Maintenance Application Overview Maintenance Menus and Icons Overview Maintenance Main MenusThis example shows the Maintenance applications Desktop Top Bar Tools Maintenance ApplicationCommon Data Edit Toolbars Common Data Table Toolbar Displaying Data Lists Viewing Data Table Contents Maintenance Application File Menu Overview SQL Command Item Table File Menu Options Item Maintenance UtilitiesItem Options Terminal table help pages in this manual Maintenance Application Other Dynamic File Menu Options Other File Options Edit Menu Item Options Edit MenuEdit Menu Overview Other Dynamic Edit Menu Options Other Edit Options PLU Menu Option s PLU Menu Item Table Tabs and Fields Item Tables This example shows the Item table editor Quick Tab Item PLU Maintenance Quick T ab Moving existing fields within the quick This example shows the Item tables Quick tabEditing the Quick Tab Editing the Quick Tab Object Tab Adding fields to the quick This example shows the Item tables Object tab Item PLU Maintenance Object Tab POS Tab Item PLU Maintenance POS Tab This example shows the Item tables POS tab Maintenance Application Price Tab Item PLU Maintenance Price Tab This example shows the Item tables Price tab Suggested Retail and Sale price Programming Active and Next prices Maintenance Application If you have selected to use Markup Margin vs. Markup Comparison Chart Maintenance Application Margin Markup Toshiba TEC America America Retail SYSTEMS, INC. R1.0a Rental Items Toshiba TEC America America Retail SYSTEMS, INC. R1.0a This example shows the Item tables Cost tab Cost Break Section Regular Cost Section Maintenance Application This example shows the Item tables Inventory tab Sales Tab Item PLU Maintenance Sales Tab Image File Naming Convention This example shows the PLU weekly Sales tab ECL tab Creating Electronic Coupon links Maintenance Application Image Type and Size RestrictionsRequired POS Setup Meal deal or Combo pricing ECL qualifying record Type Kit tab Creating kits Number. not implemented as of JuneCumulative Purchases Method Qualifier Maintenance Application Building the kits Filtering with an Alphanumeric Field Setting a FilterWorking With Items Working with Items Overview Filtering with a Logical Field This example shows the Filter setting toolFiltering with a Currency Field Combining Filters and Global Modifications Options Adding New Items by CopyingThis example shows the item creation options Deploying Modified Items Sending Changes to Targets Removing Items Rental Items Controlling Rental Items Rent Tab Symphony POS Setup module showing the Rent Tab Item Label Setup Linking Items with Labels Sub-department Overview Sub-department Table This example shows a Sub-department table record Sub-department ProgrammingSub-Department Table Settings Maintenance Application This example shows a Department table record Department Programming Department Table SettingsDepartment Table Department Table O verview Maintenance Application Bottle Link Table Bottle Link Programming Other Item Related TablesTable Programming Overview Environmental fee This example shows a Bottle Link table record This example shows a Category table record Tare Table Tare Table ProgrammingThis example shows a Tare table record Category Table Category Table Programming This example shows a Mix & Match table record This example shows a Price Level table recordMix & Match Table Mix & Match Table Programming Scale Table Scalable Item Table Programming Reference field, it does not print on the register receiptVendor Table Vendor Table Programming This example shows a vendor table record Scale Table Fields This example shows a Scale table record 100 Price Modifier Net WeightCreating and Using Batches Batches Adding records items to the batches Maintenance Application 101Adding new Batches Posting Batches Setting the Price102 Changing the Field Order Statistics 104 This example shows the Statistics Data testing panel Maintenance Application 105 Customer Account Related Maintenance This example shows a Customer table record Maintenance Application 107 Contact 108 Associating a Photo with a Customer Maintenance Application 109 Customer Level Table Programming Client Level TableRisk Level Table 110 This example shows a Customer Risk Level table record Maintenance Application 111 112 Account viewDiscount Custom messages Maintenance Application 113 Register Menu Options Register Menu This example shows an Operator table record Maintenance Application 115Operator Table Operator Table Programming Function Table Programming Functions Table116 Information Fields Alpha Parameters Maintenance Application 117This example shows a Function table record Totalizer Link List 118 Maintenance Application 119 120 Totalizer Table Programming Maintenance Application 121Totalizer Table This example shows a Totalizer table record 122 Terminal Table Programming Maintenance Application 123Terminal Table Adding terminals manually 124 Terminals and GroupsAdding terminals automatically Maintenance Application 125 126 Terminal groups at Headquarters Maintenance Application 127Gift Certificates Sample terminal list Memorizing the Item Tables Tab Order Navigation MenuThis example shows a Gift Certificate table record Windows Menu Maintenance Application 129Controlling the Maintenance Desktop Transfer Menu Report Types Default Symphony Pro ReportsList of Default Reports Report System Report System 131 Report Selection Utility Report SelectionControlling Reports Right Click Menu Bottom bar Buttons Report System 133This example shows the Report Selection Utility Selecting a Report This example shows the Report Target Selection utility Using ReportsOpening Reports Reports Without Dates Report Periods Report System 135 Report Viewer Options Report ViewerViewing Reports Report printing Default report printerSetting a default printer for reports Setting a different printer for specific reports Selection prompt window Printing LabelsGenerating Item or Shelf Labels First Label Selection Report System 139This example shows the Label selection box Defining the label printer 140Other Label Printing Options Report Properties Panel Report Properties Report Properties Panel Options 142 Report Sections Report System 143 Report SQL Editor Window Report SQL EditorModifying Symphony Pro Report SQL Code Entry Module Overview Entry ModuleReport System 145 Tool Bar Tools This example shows the Entry applications Desktop 146 This example shows the Purchase Order selection tool Purchase OrdersEntry Module 147 View Menu Options Creating Purchase Orders 148 Automatic Generation of a P/O Entry Module 149 Stock Receiving Without a Purchase Order Receiving Stock This example shows a Manual Receiving screen Entry Module 151 Printing your stock transaction Receiving Stock using a Portable Device152 Receiving Stock from a Purchase Order Counting Inventory Counting and Adjusting StockInventory Adjustments Entry Module 153 Other Entry Options Transfer Working with Cashier Pickups, Loans and Declarations Pickups and LoansEntry Module 155 156 This example shows the System Log viewer View LogEntry Module 157 View Log Utility Viewing Logs and Messages Logs and Messages Viewing Urgent Messages Urgent MessagesUnprocessed Files View Log 159 This example shows the Electronic Journal Basic version Using the Electronic Journal L-TrackerElectronic Journal L-Tracker Electronic Journal Utility Electronic Journal L-Tracker 161 162 Events / Tasks Utility Events / TasksElectronic Journal L-Tracker 163 This example shows the Events / Task utility Navigating Command Directories164 This example shows the Task Editor programming Programming EventsEvents / Tasks 165 Modifying / Adding / Automating Tasks Task Editor Repeating Cycle 166 Changing the Events / Tasks List Order Using Command directoriesEvents / Tasks 167 Adding / Removing Tasks This example shows the stand alone Monitoring utility Monitoring Utility168 Watching the Front End This example shows a sample of Monitor Statistics Form ManagerMonitoring Utility 169 Monitoring Statistics Shelf and Item Labels Template EditorSymphony Pro Report Template Files Symphony POS Form Template Files Template Objects Form Manager 171 Top Bar Tools and Options ToolsObject Right Click Menu Form Manager 173 Form Manager Main Menus File Menu This example shows the Form Managers label page setupMenus Records This example shows the Form Managers page setupConfiguration Form Manager 175 This example shows the Form Managers Object Inspector 176 Symphony Pro File and Database Maintenance Utility File Maintenance UtilityFile Maintenance Utility 177 Creating An Automated Backup 178 About Data Table Backups View File Properties and Contents File Maintenance Utility 179When and How to Use the Data Table Backups To restore a file from a backup Re-Indexing Operation 180Re-indexing Tables Glossary of Terms File Maintenance Utility 181Why and How to use the Pack Command Glossary 182 Glossary 183 Back Cover