Help CenterThis guide is intended to help access the database directory for PCProg in Windows 10 or Windows 11 for purposes of backing up PCProg's database files.
Before you Begin...
Please note that this guide is intended for advanced users only. If you need assistance, please contact Optima Support at 1-888-475-2767 or at possupport@optimagopos.ca .
Instructions
Log onto your PC or laptop running PCProg. Once logged into Windows, open File Explorer.
Once the window is open, near the top, select View, and make sure File name extensions and Hidden items are checked. Below is an example screenshot from Windows 11.
Next, in the navigation pane on the left-hand side, highlight the icon This PC. You may notice an arrow to the left of it, and if it shows pointing right, click on the arrow to expand the list, and the arrow will point down. If the arrow is already pointing down, then scroll down and select your C: drive.
From there, we will attempt to search for the following files in question by using the search bar at the top right of the window, and then enter one of the following:
PCProgDB.db (Main Program Live Database)
PCProgTransData.db (Reports Data, Suppliers, and Stock Database)
Press enter and give Windows a few moments to search the file. If the file appears and is highlighted, you can note the directory shown below the filename. If you hover your mouse cursor over the file name, you will see the full directory of where the file is located on the hard drive. Next right-click on the file, then select Open File Location.
If the file does not show after a few minutes of searching, you will then need to manually navigate to the file itself. Generally, the file directory tree should be similar to the one below.
C:\Users\<USER>\AppData\Local\OptimaSystems
NOTE: The name <USER> is the username you use as your login for Windows. The file should be in the OptimaSystems folder.
If you do not see the OptimaSystems folder, or got lost while you’re in C:\Users\<USER>\AppData\Local folder and don’t see the OptimaSystems folder, it will be in another subdirectory folder called Packages, followed by another folder in a long alphanumeric name. In that folder, there will be the LocalCache folder, and then inside that folder, will be the Local folder, and then the OptimaSystems folder. The following is the full directory of where the database files will be:
C:\Users\<USER>\AppData\Local\Packages\8f8842a3-2e40-4b33-9349-10524cd8acb0_d4v55k16rs4gg\LocalCache\Local\OptimaSystems
NOTE: For PCProg 1.0.19.1 and beyond, the alphanumeric folder has been named differently, with the differences denoted in red. Here is the following path:
C:\Users\<USER>\AppData\Local\Packages\ 8f8842a3-2e40-4b33-9349-10524cd8acb0_e2d40dpq514c6\LocalCache\Local\OptimaSystems
Once you’re in the OptimaSystems folder, you should then see both the PCProgDB.db and PCProgTransData.db files.
These files should only be accessed primarily for the purposes of backing up the database files.
The PCProgDB.db file is the live database file that runs with PCProg and is responsible for loading the last saved project file automatically when starting PCProg. From PCProg version 1.1.0.0 and beyond, you can now save a copy of the live database file or create a brand new database file when using Utility mode in PCProg 1.1.x.x.
The PCProgTransData.db file as mentioned earlier stores the reports data, suppliers, and stock data. In PCProg 1.1.0.0 and beyond, PCProg will ask you if you want to remove this file when creating a new database.
If you need additional assistance relating to Optima APOS hardware, Optima GoPOS software, or Optima PCProg software, please contact Optima Support.
Toll-Free: 1-888-475-2767
Email: possupport@optimagopos.ca