Importing/Exporting
PhreeBooks has several ways to import data into the system.
With the exception of beginning balances, import operation are made through the Tools -> Import/Export menu. Beginning balances are imported through the General Ledger -> General Journal Utilities menu.
General Import Procedure
- From the Tools -> Import/Export menu, select the tab of the type of import you want to perform.
- Scroll down the list and select the template to import from, press the Open icon.
- The criteria tab will display the criteria for which to import data. This will allow filtering the imported data to only include the fields you are interested in.
- Click on the fields tab. The table displayed lists the fields available to import. Column fields are defined as follows:
- Sequence - Indicates the sequence the field appears in the import file format.
- Field Name - This is a textual name for identifying the field to import. It is linked to the actual database field name.
- Processing - Phreebooks allows for processing the data during the import operation. Imported values can be trimmed, formatted, etc. to meet the criteria of the database value ranges.
- Import - Specifies whether the field is available for import. Generally, all fields are importable except the primary index field (usually named id)
- Show - Indicates whether the field will be included in the import list or not. Yes = include, No = don't include
- Arrange the fields to match the sequence of the import data.
- Save the import template for future use (it's best to try a few trial runs to validate the import template before importing the entire data file.
- Press the Options tab and select the delimiter and text qualifier for the import file. Check whether the first row contains header information. The header information is ignored during the import if checked, the import is sequence driven.
- Press the Browse button and select the file to import.
- Press the Import icon to initiate the import. NOTE: It's best to try a smaller file at first on a test system until the import template is validated.
General Export Procedure
Data can be exported using the same template as importing. The data file is downloaded to your browser and can be saved or viewed locally. Another option is to use the reportwriter tool to build the export data and select the csv option when creating the report.
Importing Contacts (Vendors/Customers/Employees)
Contacts can be imported into PhreeBooks through csv or tab delimited format. Up to 5 of each billing and shipping addresses may be imported with each contact.
Importing Inventory
Inventory can be entered into PhreeBooks as a csv or tab separated file. NOTE: make sure all additional inventory fields are set-up in the system before importing inventory. (See Inventory - Tabs and Fields)
Importing Beginning Balances
Importing beginning balances is covered in the following section: Installation - Importing Beginning Balances
The following journals can be imported. Inventory, Purchase Orders, Purchase/receive Inventory, Sales Orders, Sales/Invoices. For inventory, the SKU's must be present in the system prior to importing values. For the rest, the vendors/customers will be created during the import process, if necessary.
Importing Chart of Accounts
Copying Companies
Companies can be copied to a new database along with selected information ranging from tables only to every record stored in the source company. Company operations are found in the Tools -> Company Manager menu.