About Data Table Backups | Toshiba Electric Keyboard manual

178

Symphony Pro User Manual 2.0.2.15

About Data Table Backups

The Symphony Pro utility can extract all data from the tables and store the information in text type "SIL" (Standard Interchange Language ) files. The backup files contain information about each table, along with the data to re-populate the tables. It can completely re-build the database from these files. When set as an automated task, the backup utility works as a "cyclical" backup; it creates a series of folders named for each day of the week. After the first week, the process replaces each day's existing backup from the week before. There is always at least one week of data, going back day by day.

Creating An Automated Backup

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.

If your installation does not already include an automated backup "Event" you can create one by following several simple steps. First, open the "Events / Tasks" utility using the Symphony Pro desktop icon.

·Click the "Add" button at the bottom of the Automated Tasks utility to open the "Task Editor". ·Enter a description for the task, such as "Daily Backup".

·Place the cursor in the "Command" entry line, then click the "..." button to the right of the Command box.

·A file browser opens. From the "Files of type" option at the bottom of the file browser, select "Programs".

·By default, the file browser shows the "Office" folder. Navigate to the \LBOSS folder. ·Find and select the "FileMaint.exe" file.

·The Task Editor will automatically fill in the Command with the backup option. ·Place a check mark beside both the "Allow manual" and "Allow scheduled" options. ·Set the time for the backup operation.

·In the "Repeating cycle" box, enter 1 "days" to have the backup performed every day.

·Press the check mark icon on the Task Editor top bar to save the new task and close the editor.

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

Image 180

Toshiba Electric Keyboard owner manual About Data Table Backups, Creating An Automated Backup

Contents

Toshiba TEC America Page Table of Contents 106 114 Part File Maintenance Utility Part V Report SystemPart VI Entry Module Part VII View Log Part 181 Limited Warranty Limited WarrantySymphony POS Software Phone no 449-3040 FAX 770 About Symphony Pro application OverviewData Storage Security Navigating the Symphony Pro Application Using the mouse Using the keyboardNavigation Printing Help as a Manual Understanding Communications To print the entire paper manualPolling Process Data Maintenance Daily Maintenance ProcessMonthly Maintenance Process Controlling Database Size Backups Are Important Symphony Pro Data BackupPhysical Backup Protecting Your Data Symphony Pro Main Menus File MenuSymphony Pro Main Menus Main Menu Login Symphony Pro File Menu OptionsLogging into the System Setting the Language LogoutLanguage Logging off the system View Internal Process Whats Happening behind the scenesView internal process Viewer Display This example shows the Internal Process viewer Status bar and control buttonsStatus Bar Buttons Files Menu View menu View Polling Status View Polling ProcessThis example shows the Polling Process viewer Menu Options Execute Command File Forcing CommandsViewer Display windows Deploy Individual File Other TasksSending Information From One Database Table Configuration Panel Basic Symphony Pro Set Up InformationThis example shows the Deploy one file table selection tool 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 Cleanup Cleanup Tab Settings This example shows the Configuration panels Cleanup tabNumber of days to keep individual terminal Load Files Load Files Tab Settings Number of days to keep successful logNumber of days to keep all 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 This example shows the Configuration panels Security tab To assign security levelsThey can modify, add or delete it Send urgent message to Symphony Pro Date ConversionCalendar and Date Conversion Utility Julian Date Using the Messages Utility MessagesUnix Date Messages Utility Show Tips ExitShow Tips Symphony Pro File menu Option Exit the Symphony Pro Application Modules Menu Modules Menu Options Special Menu Options What is it for? SpecialHelp Symphony Pro Desktop Icon shortcuts Maintenance Application Symphony Pro Maintenance Application OverviewVersion numbers Maintenance Main Menus This example shows the Maintenance applications DesktopMaintenance Menus and Icons Overview Maintenance Application Common Data Edit ToolbarsCommon Data Table Toolbar Top Bar Tools Viewing Data Table Contents Displaying Data Lists Maintenance Application SQL Command File Menu Overview Item Maintenance Utilities Item OptionsItem Table File Menu Options Terminal table help pages in this manual Maintenance Application Other File Options Other Dynamic File Menu Options Edit Menu Edit Menu OverviewEdit Menu Item Options 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 This example shows the Item tables Quick tab Editing the Quick Tab Editing the Quick TabMoving existing fields within the quick 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 Maintenance Application Image Type and Size Restrictions Required POS SetupECL tab Creating Electronic Coupon links Meal deal or Combo pricing ECL qualifying record Type Number. not implemented as of June Cumulative PurchasesMethod Qualifier Kit tab Creating kits Maintenance Application Building the kits Setting a Filter Working With ItemsWorking with Items Overview Filtering with an Alphanumeric Field This example shows the Filter setting tool Filtering with a Currency FieldFiltering with a Logical Field Combining Filters and Global Modifications Adding New Items by Copying This example shows the item creation optionsOptions 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 Programming Department Table Settings Department TableDepartment Table O verview This example shows a Department table record Maintenance Application Other Item Related Tables Table Programming OverviewBottle Link Table Bottle Link Programming This example shows a Bottle Link table record Environmental fee Tare Table Tare Table Programming This example shows a Tare table recordCategory Table Category Table Programming This example shows a Category table record This example shows a Price Level table record Mix & Match Table Mix & Match Table ProgrammingThis example shows a Mix & Match table record Reference field, it does not print on the register receipt Vendor Table Vendor Table ProgrammingThis example shows a vendor table record Scale Table Scalable Item Table Programming This example shows a Scale table record Scale Table Fields Price Modifier Net Weight Creating and Using BatchesBatches 100 Maintenance Application 101 Adding new BatchesAdding records items to the batches Setting the Price 102Changing the Field Order 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 Client Level Table Risk Level Table110 Customer Level Table Programming Maintenance Application 111 This example shows a Customer Risk Level table record Account view Discount112 Maintenance Application 113 Custom messages Register Menu Register Menu Options Maintenance Application 115 Operator TableOperator Table Programming This example shows an Operator table record Functions Table 116Information Fields Function Table Programming Maintenance Application 117 This example shows a Function table recordAlpha Parameters 118 Totalizer Link List Maintenance Application 119 120 Maintenance Application 121 Totalizer TableTotalizer Table Programming 122 This example shows a Totalizer table record Maintenance Application 123 Terminal TableTerminal Table Programming 124 Terminals and Groups Adding terminals automaticallyAdding terminals manually Maintenance Application 125 126 Maintenance Application 127 Gift CertificatesSample terminal list Terminal groups at Headquarters Navigation Menu This example shows a Gift Certificate table recordMemorizing the Item Tables Tab Order Maintenance Application 129 Controlling the Maintenance DesktopTransfer Menu Windows Menu Default Symphony Pro Reports List of Default ReportsReport System Report Types Report System 131 Report Selection Controlling ReportsRight Click Menu Report Selection Utility Report System 133 This example shows the Report Selection UtilitySelecting a Report Bottom bar Buttons Using Reports Opening ReportsReports Without Dates This example shows the Report Target Selection utility Report System 135 Report Periods Report Viewer Viewing ReportsReport Viewer Options Default report printer Setting a default printer for reportsSetting a different printer for specific reports Report printing Printing Labels Generating Item or Shelf LabelsSelection prompt window Report System 139 This example shows the Label selection boxFirst Label Selection 140 Other Label Printing OptionsDefining the label printer Report Properties Report Properties Panel 142 Report Properties Panel Options Report System 143 Report Sections Report SQL Editor Modifying Symphony Pro Report SQL CodeReport SQL Editor Window Entry Module Report System 145Tool Bar Tools Entry Module Overview 146 This example shows the Entry applications Desktop Purchase Orders Entry Module 147 View Menu OptionsCreating Purchase Orders 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 using a Portable Device 152Receiving Stock from a Purchase Order Printing your stock transaction Counting and Adjusting Stock Inventory AdjustmentsEntry Module 153 Counting Inventory Transfer Other Entry Options Pickups and Loans Entry Module 155Working with Cashier Pickups, Loans and Declarations 156 View Log Entry Module 157View Log Utility This example shows the System Log viewer Logs and Messages Viewing Logs and Messages Urgent Messages Unprocessed FilesView Log 159 Viewing Urgent Messages Using the Electronic Journal L-Tracker Electronic Journal L-TrackerElectronic Journal Utility This example shows the Electronic Journal Basic version Electronic Journal L-Tracker 161 162 Events / Tasks Electronic Journal L-Tracker 163Events / Tasks Utility Navigating Command Directories 164This example shows the Events / Task utility Programming Events Events / Tasks 165Modifying / Adding / Automating Tasks Task Editor This example shows the Task Editor programming 166 Repeating Cycle Using Command directories Events / Tasks 167Adding / Removing Tasks Changing the Events / Tasks List Order Monitoring Utility 168Watching the Front End This example shows the stand alone Monitoring utility Form Manager Monitoring Utility 169Monitoring Statistics This example shows a sample of Monitor Statistics Template Editor Symphony Pro Report Template FilesSymphony POS Form Template Files Shelf and Item Labels Form Manager 171 Template Objects Tools Object Right Click MenuTop Bar Tools and Options Form Manager 173 This example shows the Form Managers label page setup MenusForm Manager Main Menus File Menu This example shows the Form Managers page setup ConfigurationForm Manager 175 Records 176 This example shows the Form Managers Object Inspector File Maintenance Utility File Maintenance Utility 177Symphony Pro File and Database Maintenance Utility 178 About Data Table Backups Creating An Automated Backup File Maintenance Utility 179 When and How to Use the Data Table BackupsTo restore a file from a backup View File Properties and Contents 180 Re-indexing TablesRe-Indexing Operation File Maintenance Utility 181 Why and How to use the Pack CommandGlossary Glossary of Terms 182 Glossary 183 Back Cover