backupPhreeBooks provides a backup and restore utility to the database. It is recommended that this utility be used as other web-based applications have shortcomings that my prohibit proper restoration of your data. Specifically, phpMyAdmin has limitations on the upload size of 8 MB. Using a utility such as BigDump has limitation on the size of the sql being executed. The PhreeBooks backup utility creates a backup with limited sql sizes that allow for the restore script (a modified version of the BigDump script) to properly restore a company backup.

Backup & Restore Features:

  • Independent of database tables, the script automatically determines the tables and creates the sql to re-create the tables and populate with data.
  • Automatically compresses the sql file and downloads to your browser to allow off site storage of your company data.
  • Can be used to re-locate your company to a different server.

Backing Up Your Company Data

  1. From the main menu, navigate to Tools -> Company Backup.
  2. Select the backup compression type and whether to include company data files.
  3. If a copy of the backup is to be kept on the server, check the box labeled ”
    Save a local copy in web server (my_files/backups) directory “.
  4. Press the Start Backup button to start the backup. NOTE: This script can take several minutes depending on the size of the database being backed up. If a copy is selected to stay on the server, it will be placed in the /my_files/backups directory.
  5. When complete, the file will be downloaded to the local browser.

Restoring Company Data (database only)

PhreeBooks provides a restoration utility to restore the database tables. Files from the my_files directory must be restored through your ISP control panel or ftp transfer.

  1. From the main menu, navigate to Tools -> Company Backup.
  2. Press the Company Restore button in the toolbar. Acknowledge the warning that all data will be replaced in the database table.
  3. The restore screen will be displayed and a list of files from the /my_files/backups directory will be displayed.
  4. If the file to restore is available (must be in uncompressed format), select the file and press the Start button.
  5. If the restoration file is not in the /my_files/backups directory, it can be uploaded by browsing your local computer for the uncompressed file and uploading to your server using the control panel or ftp protocol to copy the sql file to your server. Once the file has been uploaded, select the file and press the Start button to begin the restore operation.
  6. Once the restore has successfully completed, Press the button at the bottom of the form to log out and back in to the restored company. Logging out is necessary to verify any updates (if necessary) and make sure the system initializes properly.

NOTE:

1. TOOLS > Company Backup > ‘Database Only’:
Includes – CoA, Sales/Purchase Taxes set, GL entries,
Excludes – anything in my_files – your nice Forms (Invoice, PO, Credit Memo), Company details, logo’s, back-ups

i.e. NOT a full back-up

2. TOOLS > Company Backup > ‘Database and Company Data Files’:
Includes – ‘Database only’ as above, contents of my_files (see above), config.php.
Excludes – ?

3. GENERAL LEDGER > Administrative Tools > Purge all Journal Transactions (re-start)
Includes – all GL-entries
Excludes – Customer, Vendor, Inventory details. CoA and Sales/Purchase tax details. Company details.

Please post any comments or suggestions to the Forum.

January 2014 / PhreeBooksR36RC3
Author – Charles
draft    …   under construction

Bar code scanners are simply quick keyboard entry mechanisms (they scan the code and enter it into the field). To work in a web based application, the cursor needs to be in the field you want to enter the code into. If you enable bar code scanners for item entry, place the cursor in the sku field of the first line and scan the product. The quantity will assume 1, the details will be retrieved and a new line will be added and the cursor placed in the sku field of the next line. Successive scans will continue the operation. Items can be added very quickly this way.

barcode

Which Barcode Scanner:

The following USB Barcode Scanner has been used successfully with PhreeBooks:

LS2208GeneralPurpose

Motorola / Symbol LS2208   …   It doesn’t require any drivers, it’s just like a USB keyboard.

It is mentioned here:
http://learn.adafruit.com/barcode-scanner
http://www.liberty-sys.com/pdfs/manuals/sym_ls2208_prg.pdf

I have also seen Wasp barcode scanners recommended elsewhere, but I am unaware of a  PhreeBooks users with one.

Useful Barcode Resources:

http://www.adams1.com/isbn.html
http://www.gs1.org/
http://www.gs1uk.org/Pages/default.aspx
http://www.barcodelib.com/net_barcode_reader/barcodes/upca.html
http://www.barcodeisland.com/upca.phtml
http://www.adafruit.com/blog/2014/04/07/a-short-history-of-the-modern-bar-code-manufacturingmondays/

barcodeTo Enable Barcodes in PhreeBooks:

barcodeicon

barcode icon

COMPANY > Module Administration > PhreeBooks Module > General

  • If set to Yes, this option will enable data entry on order forms for USB and supported bar code readers    …   YES/NO

COMPANY > Module Administration > Inventory Module

  • When enabled, PhreeBooks looks for a SKU length in the order form equal to the Bar Code Length   …   YES/NO
  • Sets the number of characters to expect when reading inventory bar code values   …   12 (default)
  • inventory field called UPC Code: This field needs to have the numeric UPC value in it. This field is what is searched when a bar code is scanned. You can scan-in new inventory – scan the barcodes into the UPC Code field in Inventory.

Printing bar codes on labels:

barcode on invoiceBar codes are basically fonts and can only be added to Forms at this time. Add a data field to the Form and select bar code as the type.
In the popup, select the database field you want to generate a bar code for. Enter the position on the Form, the height of the bar code. I’ve tested this with:

  • invoice numbers,
  • PO numbers
  • postal codes.

Barcodes can also be printed on Work Orders.

Please post any comments of suggestions to the Forum.

admin1February 2014 / PhreeBooksR36RC3
Author – Charles

General Settings:

COMPANY > Module Administration (click on ‘Module Administration’ itself) 

…   is the path to administer PhreeBooks in General Settings  …  (‘Under the Hood’, if you like.)

  • Modules
  • My Company
  • Configuration
  • E-mail Preferences
  • Currency
  • Company Manager
  • Tools
  • Statistics

PhreeBooks Modules:

Under General Settings > Modules are listed all installed PhreeBooks Modules.

  • Assets
  • Audit
  • Bulk Inventory Tool
  • CA / PA
  • Contacts
  • Document Control
  • Import Bank Statement
  • Inventory
  • OpenCart
  • Payment
  • PhreeBooks
  • PhreeForm
  • PhreeHelp
  • PhreePOS
  • Reportico
  • SKU Pricer
  • Shipping
  • Translator
  • Work Order
  • XML Builder
  • ZenCart

Those Modules listed above in bold are core modules and should not be removed!

If a Module listed above does not appear in the General Settings > Modules, it hasn’t been loaded. Take a look in PhreeSoft Store to locate required Modules (at the time of writing, the PhreeBooks Extensions aren’t yet up to date).

To administer these Modules in General Settings > Modules,  click on the ‘Spanner and Screwdriver’ on the far right.

Post any comments to the Forum

cleanslateThe PhreeBooks install script is designed to be run once and then removed (or renamed) from the server. If the install script is run subsequent to an install, most of the installation will be skipped and Caution notifications will be displayed. If you want to re-install with a clean database follow these steps.

  1. Optional: Overwrite/Remove and Replace the PhreeBooks source code. If a newer version is to be installed, it is best to overwrite the current files with those from the newer release. If an older version is to be installed, it is best to remove the files from the installation folder and replace with a fresh copy from the desired zip release.
  2. Make sure the folders /includes and /my_files are writeable by the web server. Typically this means setting the permissions to 777 for those folders.
  3. IMPORTANT: Verify that the /includes/configure.php file is is not present. This file contains the old installation database information and should be removed as it will be re-written during the install.
  4. IMPORTANT: Verify that the database tables are deleted from the database you want to install to. In many cases, the tables will not be touched if they exist on the server, retaining the old information.
  5. Optional: Remove the folders within the /my_files folder. The only file needed is the index.html file, the rest will re-installed during the installation.
  6. Run the install script by navigating to http://PathToServer/PathToPhreeBooks/index.php and you should be redirected to the installation script. Follow the onscreen instructions to complete the installation.
  7. Rename/remove the /install folder.

if Steps 3 and 4 are not followed, the re-installation will not yield the desired results.