Point of Success Roundtable Home
Home Search search Menu menu Not logged in - Login | Register
Point of Success Roundtable > All Forums > Knowledge Base > Networking and Database Server > Remove orders before starting to use the system in live production. Clearing database.

Remove orders before starting to use the system in live production. Clearing database.
 Moderated by: garyt
 New Topic   Reply   Printer Friendly 
 Rating:  Rating
AuthorPost
 Posted: Tue Jan 17th, 2012 03:52 pm
   PM  Quote  Reply 
1st Post
Jeff Ward
Administrator


Joined: Mon May 21st, 2007
Location: Mesa, Arizona USA
Posts: 2874
Status: 
Offline

  back to top

Warning: There is a danger of irretrievable data loss in following these instructions. If you do not fully understand the entire process, do not attempt these tasks. Contact your dealer or Point of Success support for assistance.

Point of Success Version 2.5 or above
  1. Exit all Point of Success programs on all workstations
  2. Make a backup of your Point of Success data. This is most easily accomplished with the Database Administrator program included with Point of Success.
  3. Open Windows Explorer on the computer where the database resides. If running on a network, this is the database server computer.
  4. Browse to the C:\Point of Success\Data folder
  5. Delete the following data tables (remove all tables starting with these names no matter what the file name extension) DeliveryRunItems, DeliveryRuns, Order, OrderItems, Till, and TillItems.
  6. Browse to the Point of Success program folder (C:\Program Files\Point of Success\)
  7. Run the CreatePOSData program to recreate the deleted database tables.
The next order entered in Point of Success will be order number one.

Point of Success Version 2
  1. Exit all Point of Success programs on all workstations
  2. Make a backup of your Point of Success data. This is most easily accomplished with the Data Utilities program included with Point of Success.
  3. Open Windows Explorer on the computer where the database resides. If running on a network, this is the database server computer.
  4. Browse to the C:\Point of Success\Data folder
  5. Delete the following data tables (remove all tables starting with these names no matter what the file name extension) DeliveryRunItems, DeliveryRuns, Order, OrderItems, Till, and TillItems.
  6. Browse to the Point of Success program folder (C:\Program Files\Point of Success Programs\)
  7. Run the CreatePOSData program to recreate the deleted database tables.
The next order entered in Point of Success will be order number one.

Point of Success Version 1
  1. Exit all Point of Success programs on all workstations
  2. Make a backup of your Point of Success data. This is most easily accomplished with the Data Utilities program included with Point of Success.
  3. Open Windows Explorer on the computer where the database resides. If running on a network, this is the database server computer.
  4. Browse to the C:\Point of Success Pizzeria\Data folder
  5. Delete the following data tables (remove all tables starting with these names no matter what the file name extension) DeliveryRunItems, DeliveryRuns, Order, OrderItems, Till, and TillItems.
  6. Browse to the Point of Success program folder (C:\Program Files\Point of Success Programs\Pizzeria\)
  7. Run the CreatePOSData program to recreate the deleted database tables.
The next order entered in Point of Success will be order number one.



 Current time is 07:28 am
Point of Success Roundtable > All Forums > Knowledge Base > Networking and Database Server > Remove orders before starting to use the system in live production. Clearing database.
Top




UltraBB 1.172 Copyright © 2007-2011 Data 1 Systems