Accounting for WordPress
Bizuno has a powerful import/export tool to transfer data in to/out of the database. Knowledge of the Bizuno database structure and data fields are necessary to accurately import information into the database. Exporting is less complicated but still required some knowledge of the database tables.
Most import/export operations deal solely with a single database table. The exception is the account definitions (customers, vendors, branches). These definitions include the address book fields (currently set at 5) with the main account information.
Other import scripts specialized towards beginning balance initialization can be found here.
NOTE: AS OF THIS WRITING ONLY MAIN AND SHIPPING ADDRESSES CAN BE IMPORTED!
One of the quickest ways to get up and running is to import your existing customer and vendor database records. Bizuno provides a tool to aid in that effort.
HINT: If you are starting with a new business importing data from your old accounting software, it may be wise to start with a small, two to three row, sample until you get a feel of how the process works and what the results look like.
Bizuno uses a master/slave table structure to store all your contacts whether they be Customers, Vendors, Stores, Employees or CRM Contacts. The main or master table is named contacts and contains all the high level information about the contact. The slave table is linked to the master table and contains the address information for the contact. One or more addresses may be linked to a single contact. However, there can be ONLY ONE main address (type = m) linked to a contact record. The remaining records must be either billing (type = b) or shipping (type = s). If no billing or shipping addresses are present, Bizuno defaults to the main address as the billing and shipping address.
The following is a list of required fields as of this writing. Import files that do not contain the required fields will be rejected and the import will not continue.
The following is a sample of a contact import file. Note that ‘proper’ .csv formatting is imperative, Also keep in mind that only one header row should be present and blank rows should be avoided in your import file.
ContactType,ContactContactID,MainAddressPrimaryName,MainAddressAddress1,MainAddressCity,MainAddressState,MainAddressPostalCode,MainAddressCountryISO3,MainAddressTelephone1c,"Customer 1, Inc.",Tom Franks,4343 Main St.,Fort Worth, TX,76090,USA,817-555-1234c,jSmith,John Smith,543 21st St.,Dallas,TX,76020,USA,214-555-5492v,Bix Box,"Big Box, LLC", 3043 Maple Ave,Dallas,TX,76031,USA,214-555-7473
Bizuno uses the ContactContactID as a unique identifier for each contact type. The same identifier can be used for a vendor and customer as these are treated differently in Bizuno. If the same file is imported multiple times, Bizuno will first see if the Contact ID exists in the database and if so, overwrites the information. This can be a helpful feature as small chunks and bulk updates are possible without duplicating contacts.
Data can be exported from PhreeBooks to text files for use in other applications.
The HOW TOs contain samples of export procedures to export customers, vendors, and inventory.
Powered by BetterDocs
Your email address will not be published. Required fields are marked *
Save my name, email, and website in this browser for the next time I comment.