Manuals / Toshiba / Musical Instruments & Equipment / Electronic Keyboard

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

Models: Electric Keyboard

1 186

Download 186 pages 28.52 Kb

Page 182

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 114Part VI Entry Module Part File Maintenance UtilityPart V Report System Part VII View LogPart 181Symphony POS Software Limited WarrantyLimited Warranty Phone no 449-3040 FAX 770Data Storage About Symphony Pro applicationOverview SecurityNavigation Navigating the Symphony Pro Application Using the mouseUsing the keyboard Printing Help as a ManualPolling Process Understanding CommunicationsTo print the entire paper manual Monthly Maintenance Process Data MaintenanceDaily Maintenance Process Controlling Database SizePhysical Backup Backups Are ImportantSymphony Pro Data Backup Protecting Your DataSymphony Pro Main Menus Symphony Pro Main MenusFile Menu Main MenuLogging into the System LoginSymphony Pro File Menu Options Language Setting the LanguageLogout Logging off the systemView internal process View Internal ProcessWhats Happening behind the scenes Viewer DisplayStatus Bar This example shows the Internal Process viewerStatus bar and control buttons ButtonsFiles Menu View menuThis example shows the Polling Process viewer View Polling StatusView Polling Process Menu OptionsViewer 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=STORE103This 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 tabHost 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 filesThis example shows the Configuration panels Load Files tab Because it will be overwrittenSecurity Security Tab Settings Security System Overview Establishing access levelsThey 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 DateUnix Date Using the Messages UtilityMessages Messages UtilityShow Tips Symphony Pro File menu Option Show TipsExit Exit the Symphony Pro ApplicationModules Menu Modules Menu OptionsHelp Special Menu Options What is it for?Special Symphony Pro Desktop Icon shortcutsVersion 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 ToolsViewing Data Table Contents Displaying Data ListsMaintenance Application SQL Command File Menu OverviewItem Table File Menu Options Item Maintenance UtilitiesItem Options Terminal table help pages in this manual Maintenance Application Other File Options Other Dynamic File Menu OptionsEdit Menu Item Options Edit MenuEdit Menu Overview Other Edit Options Other Dynamic Edit Menu OptionsPLU Menu PLU Menu Option sItem Tables Item Table Tabs and FieldsQuick Tab Item PLU Maintenance Quick T ab This example shows the Item table editorMoving 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 TabItem PLU Maintenance Object Tab This example shows the Item tables Object tabPOS 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 ProgrammingMaintenance Application Margin vs. Markup Comparison Chart If you have selected to use MarkupMaintenance 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 SectionMaintenance 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 ConventionECL 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 kitsMaintenance Application Building the kits Working with Items Overview Setting a FilterWorking With Items Filtering with an Alphanumeric FieldFiltering 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 TargetsRental Items Controlling Rental Items Symphony POS Setup module showing the Rent Tab Rent TabItem Label Setup Linking Items with Labels Sub-department Table Sub-department OverviewSub-department ProgrammingSub-Department Table Settings This example shows a Sub-department table recordMaintenance Application Department Table O verview Department Programming Department Table SettingsDepartment Table This example shows a Department table recordMaintenance Application Bottle Link Table Bottle Link Programming Other Item Related TablesTable Programming Overview This example shows a Bottle Link table record Environmental feeCategory Table Category Table Programming Tare Table Tare Table ProgrammingThis example shows a Tare table record This example shows a Category table recordThis 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 ProgrammingThis example shows a Scale table record Scale Table FieldsBatches Price Modifier Net WeightCreating and Using Batches 100Adding records items to the batches Maintenance Application 101Adding new Batches Changing the Field Order Setting the Price102 Posting BatchesStatistics This example shows the Statistics Data testing panel 104Maintenance Application 105 Account Related Maintenance CustomerMaintenance Application 107 This example shows a Customer table record108 ContactMaintenance Application 109 Associating a Photo with a Customer110 Client Level TableRisk Level Table Customer Level Table ProgrammingMaintenance Application 111 This example shows a Customer Risk Level table record112 Account viewDiscount Maintenance Application 113 Custom messagesRegister Menu Register Menu OptionsOperator Table Programming Maintenance Application 115Operator Table This example shows an Operator table recordInformation Fields Functions Table116 Function Table ProgrammingAlpha Parameters Maintenance Application 117This example shows a Function table record 118 Totalizer Link ListMaintenance Application 119 120 Totalizer Table Programming Maintenance Application 121Totalizer Table 122 This example shows a Totalizer table recordTerminal 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 HeadquartersMemorizing the Item Tables Tab Order Navigation MenuThis example shows a Gift Certificate table record Transfer Menu Maintenance Application 129Controlling the Maintenance Desktop Windows MenuReport System Default Symphony Pro ReportsList of Default Reports Report TypesReport System 131 Right Click Menu Report SelectionControlling Reports Report Selection UtilitySelecting a Report Report System 133This example shows the Report Selection Utility Bottom bar ButtonsReports Without Dates Using ReportsOpening Reports This example shows the Report Target Selection utilityReport System 135 Report PeriodsReport Viewer Options Report ViewerViewing Reports Setting a different printer for specific reports Default report printerSetting a default printer for reports Report printingSelection 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 Panel142 Report Properties Panel OptionsReport System 143 Report SectionsReport SQL Editor Window Report SQL EditorModifying Symphony Pro Report SQL Code Tool Bar Tools Entry ModuleReport System 145 Entry Module Overview146 This example shows the Entry applications DesktopCreating Purchase Orders Purchase OrdersEntry Module 147 View Menu Options This example shows the Purchase Order selection tool148 Entry Module 149 Automatic Generation of a P/OReceiving Stock Stock Receiving Without a Purchase OrderEntry Module 151 This example shows a Manual Receiving screenReceiving Stock from a Purchase Order Receiving Stock using a Portable Device152 Printing your stock transactionEntry Module 153 Counting and Adjusting StockInventory Adjustments Counting InventoryTransfer Other Entry OptionsWorking 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 viewerLogs and Messages Viewing Logs and MessagesView Log 159 Urgent MessagesUnprocessed Files Viewing Urgent MessagesElectronic Journal Utility Using the Electronic Journal L-TrackerElectronic Journal L-Tracker This example shows the Electronic Journal Basic versionElectronic 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 programming166 Repeating CycleAdding / Removing Tasks Using Command directoriesEvents / Tasks 167 Changing the Events / Tasks List OrderWatching the Front End Monitoring Utility168 This example shows the stand alone Monitoring utilityMonitoring Statistics Form ManagerMonitoring Utility 169 This example shows a sample of Monitor StatisticsSymphony POS Form Template Files Template EditorSymphony Pro Report Template Files Shelf and Item LabelsForm Manager 171 Template ObjectsTop 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 Records176 This example shows the Form Managers Object InspectorSymphony Pro File and Database Maintenance Utility File Maintenance UtilityFile Maintenance Utility 177 178 About Data Table Backups Creating An Automated BackupTo restore a file from a backup File Maintenance Utility 179When and How to Use the Data Table Backups View File Properties and ContentsRe-Indexing Operation 180Re-indexing Tables Glossary File Maintenance Utility 181Why and How to use the Pack Command Glossary of Terms182 Glossary 183 Back Cover