180, Re-indexing Tables | Toshiba Electric Keyboard specification

180

Symphony Pro User Manual 2.0.2.15

The File Maintenance utility can also display specific information about a table and its associated SIL file. With one table selected, click the right mouse button. A properties panel opens, displaying the table information in the top portion of the panel. If you did not select an associated backup from the "View" menu there is no associated backup file. If you select a backup day from the view menu, then right click a table, the bottom portion of the properties panel displays information about the backup file. You can also click the "View" button below the backup file properties to open the SIL file in an editor to view the actual contents.

This example shows the Data table and backup file properties.

Re-indexing Tables

If you are using the default "Paradox" database type, there are situations that may arise where the data table "indexes" become corrupt. This doesn't mean that the data itself is corrupt, just the internal pointers used by the database to quickly locate records. This can happen during a system "crash". For example: at the moment that Symphony Pro is writing data to a table, there is a power failure, or the computer "freezes" because of low resources. When the system comes back online, and Symphony Pro is re-started, it will open a message box indicating that it was not properly shut down, and that this may have caused damage to the data table indexes. In this case it is suggested that the tables be re- indexed as a precaution.

NOTE: If your installation is using MSSQL rather than a Paradox style database you will probably never need to run the re-index command because the MSSQL program handles this type of situation internally.

Re-Indexing Operation

NOTE: Close all Symphony Pro programs and modules before running the re-index command. If you re-index while there are tables open, the process will stop, indicating that a table is busy. You must close all Symphony Pro programs and re-start the re-index process.

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

Image 182

Toshiba Electric Keyboard owner manual 180, Re-indexing Tables, Re-Indexing Operation

Contents

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