foxycart_installation_windows

2010-02-25T07:02:22-04:00

If you encounter any problems or have any questions, please feel free to contact us and we'll be glad to help. First, you need to configure QuickBooks: * Place an order (if you haven't already) for the Foxycart QuickBooks service here: * You will be provided with a .QWC configuration file, data feed URL, data feed key, and password by e-mail. Please download and save this .QWC file. * Download and install the Web Connector from Intuit's website:

freebsd

2009-11-06T09:31:01-04:00

IPSwitch WS_FTP Pro and FreeBSD SFTP Connection Problems If you have trouble connecting from WS_FTP Pro to a FreeBSD host, you probably need to tweak an SSH setting on the FreeBSD server. WS_FTP Pro has a strange bug or something that causes error messages like this to appear in /var/log/auth.log:

freebsd_postfix

2008-10-20T10:53:52-04:00

This is incomplete, I havn't added instructions on what else to do to get this working yet... The /usr/local/etc/postfix/main.cf file: [consolibyte@www /usr/local/etc/postfix]$ postconf -n body_checks = pcre:/usr/local/etc/postfix/checks/mime_body_checks.regexp command_directory = /usr/local/sbin config_directory = /usr/local/etc/postfix daemon_directory = /usr/local/libexec/postfix data_directory = /var/db/postfix debug_peer_level = 2 header_checks = pcre:/usr/local/etc/postfix/checks/head…

getaccountbyid

2008-12-05T16:13:54-04:00

Usage Examples $Account = $QB->getAccountByID("80000081-1221752087"); echo $Account->FullName; Parameters * ID -- The desired account's ListID. Must be exact match. Returns * FALSE if account wasn't found. * Otherwise returns first row found in database as Database Object.

getaccountbyname

2008-12-05T16:16:01-04:00

Usage Examples $Account = $QB->getAccountByName("Accounts Payable"); echo $Account->Balance; Parameters * $name -- The desired account's Name. Must be exact match. Returns * FALSE if account wasn't found. * Otherwise returns first row found in database as Database Object.

getaccountfullname

2008-12-05T16:12:08-04:00

Usage Examples $Account = $QB->getAccountByFullName("Expense Account"); echo $Account->TotalBalance; Parameters * $name -- The desired account's FullName. Must be exact match. Returns * FALSE if account wasn't found. * Otherwise returns first row found in database as Database Object.

getaccounts

2008-12-05T16:35:22-04:00

Usage Prototype getAccounts($filters = array(), $or = false, $fields = array(), $start = 0, $max = -1, $order = array()) Examples //-------------------------------------------------------------------------------------------------- //Get 15 accounts, sorted by name, starting at result 500 $Accounts = $QB->getAccounts(array(), QUICKBOOKS_SQL_API_AND, array(), 500, 15, array( array("Name", "ASC") )); foreach($Accounts as $Account) echo " ".$Account->Name."
"; //---…

getaccountsbytype

2008-12-05T16:24:30-04:00

Usage Examples $Accounts = $QB->getAccountsByType("OtherCurrentAsset"); foreach($Accounts as $Account) echo $Account->TotalBalance."
"; Parameters * $type -- The type of accounts to retrieve. Must be exact match. Returns * FALSE if no accounts were found.

getcustomerbyemail

2008-12-05T14:53:59-04:00

Usage Examples $Customer = $QB->getCustomerByEmail("email@gmail.com"); echo $Customer->Contact; Parameters * Email -- The desired customer's email. Must be exact match. Returns * FALSE if customer wasn't found. * Otherwise returns first row found in database as Database Object.

getcustomerbyfullname

2008-12-05T14:54:41-04:00

Usage Examples $Customer = $QB->getCustomerByFullName("A J Enterprises"); echo $Customer->FirstName." ".$Customer->LastName; Parameters * $name -- The desired customer's FullName. Must be exact match. Returns * FALSE if customer wasn't found.

getcustomerbyid

2008-12-05T14:54:30-04:00

Usage Examples $Customer = $QB->getCustomerByID("80004EB9-1199278616"); echo $Customer->FullName; Parameters * ID -- The desired customer's ListID. Must be exact match. Returns * FALSE if customer wasn't found. * Otherwise returns first row found in database as Database Object.

getcustomerbyname

2008-12-05T14:54:59-04:00

Usage Examples $Customer = $QB->getCustomerByName("A J Enterprises"); echo $Customer->FirstName." ".$Customer->LastName; Parameters * $name -- The desired customer's Name. Must be exact match. Returns * FALSE if customer wasn't found. * Otherwise returns first row found in database as Database Object.

getcustomers

2008-12-05T15:41:48-04:00

Usage Prototype getCustomers($filters = array(), $or = false, $fields = array(), $start = 0, $max = -1, $order = array()) Examples //-------------------------------------------------------------------------------------------------- //Get 15 customers, sorted by name, starting at result 500 $Customers = $QB->getCustomers(array(), QUICKBOOKS_SQL_API_AND, array(), 500, 15, array( array("Name", "ASC") )); foreach($Customers as $Customer) echo " ".$Customer->Name."
"…

getestimatebyid

2008-12-05T16:36:32-04:00

Usage Examples $Estimate = $QB->getEstimateByID("80000081-1221752087"); echo $Estimate->FullName; Parameters * ID -- The desired estimate's ListID. Must be exact match. Returns * FALSE if estimate wasn't found. * Otherwise returns first row found in database as Database Object.

getestimates

2008-12-05T16:34:38-04:00

Usage Prototype getEstimates($filters = array(), $or = false, $fields = array(), $start = 0, $max = -1, $order = array()) Examples //-------------------------------------------------------------------------------------------------- //Get 15 estimates, sorted by TotalAmount, starting at result 500 $Estimates = $QB->getEstimates(array(), QUICKBOOKS_SQL_API_AND, array(), 500, 15, array( array("TotalAmount", "ASC") )); foreach($Estimates as $Estimate) echo " ".$Estimate-…

infusionsoft

2010-06-23T09:22:10-04:00

Configuration Infusionsoft You will need to generate an API key within Infusionsoft. Follow these instructions here: *

opencart

2010-03-29T07:02:07-04:00

We are running an open beta test for an OpenCart + QuickBooks Integration. The integration aims to move OpenCart customers, orders, order data, and items from OpenCart to QuickBooks automatically. You are encouraged to test out the code, and provide feedback to support@ConsoliBYTE.com so we can fix errors and continue to improve the integration.

php

2010-03-08T15:59:07-04:00

* Fixing include_once and require_once problems when using PHP, APC, and Subversion to deploy websites

php_apc_and_subversion

2010-03-08T16:07:52-04:00

If your files are getting included or required more than once in PHP scripts and you're using APC and Subversion, you need to make sure you set this configuration variable to avoid problems: apc.stat_ctime=1 Quote from the PHP developers: SVN (like rsync and other applications) actually creates new files, replaces the old ones, and back dates the files. This causes the inodes to change, but not the mtime and apc will execute the incorrect file. Turning on ctime verification will avoid …

polycom_ringtones

2008-11-19T10:53:57-04:00

Polycom VoIP phones can use standard .WAV files as ring tones. Choose your .WAV file of choice and make sure it's in the correct format: Check if it's in the right format: # file rington.wav ringtone.wav: RIFF (little-endian) data, WAVE audio, ITU G.711 mu-law, mono 8000 Hz

quickbooks

2010-07-30T07:18:46-04:00

Welcome to the QuickBooks Integration Wiki This wiki is about integrating the Intuit QuickBooks accounting software packages with websites, desktop applications, and other third-party applications. We're just getting started putting integration information up here, so feel free to register and add your own content and/or make your own changes. If you need a help with QuickBooks integration or this wiki, you can e-mail us at .

quickbooks_bugs

2009-10-09T07:26:32-04:00

quickbooks_desktop_integration

2009-11-03T10:59:24-04:00

See also: --- **WARNING** Before you even **think** about doing this, you should see if your application can instead run as a Windows Scheduled Task, scheduled to run at system start-up. Many times, this is an infinitely better solution than getting a QuickBooks application to run as a Windows Service.

quickbooks_error_codes

2010-03-10T08:32:36-04:00

0 The QuickBooks server processed the request successfully. Status OK. 1 No match. The filters used in the query request did not return any matching objects from QuickBooks. * You'll get this error message if you issue a query of any type, but the result set is empty. Instead of just returning an empty list of objects, QuickBooks returns this error message. This is similar to error code 500, so see that error code for more details.

quickbooks_example_qbxml

2010-01-15T09:47:30-04:00

General notes about qbXML requests * If the value of the tag is empty, then do not send that tag. i.e. rather than send an empty tag like: just don't send that tag at all. * If you're issuing a *Mod request, you must send the ListID/TxnID and EditSequence of the record you're trying to modify.

quickbooks_for_foxycart

2010-02-25T07:01:31-04:00

Hosted Foxycart QuickBooks Integration Hosted Foxycart QuickBooks Integration is available for a low monthly fee at:

quickbooks_for_oscommerce

2009-09-23T16:03:13-04:00

Installation * Download and install the QuickBooks Web Connector from here: * Open QuickBooks and go to your 'Customers' panel within QuickBooks * Open the QuickBooks Web Connector (there should be an entry under Start > Programs > QuickBooks > Web Connector) * Visit: . You will be asked to save or open a file. Save this file to your 'Desktop' or your 'Documents' folder.…

quickbooks_frameworks

2008-11-12T08:30:57-04:00

ColdFusion * QuickBooks Web Connector Starter Kit for ColdFusion: Perl * [Perl Example] * [Perl Example #2] PHP * QuickBooks Web Connector and PHP framework * QuickBooks RDS and PHP: (old, I'm not sure if this works anymore...?)

quickbooks_integration_csharp

2009-08-26T09:45:36-04:00

C# Sample Code for QuickBooks Desktop Editions // Use this if you're just using the regular SDK stuff //using QBXMLRP2Lib; //using Interop.QBXMLRP2; // Use this if you're using QBXMLRP2E.exe using QBXMLRP2ELib; RequestProcessor2 rp = null; string ticket = null; string response = null; try { rp = new RequestProcessor2(); rp.OpenConnection("", "IDN CustomerAdd C# sample"); ticket = rp.BeginSession("C:\\path\\to\\file.QBW", QBFileModeE.qbFileOpenDoNotCare); //ticket = rp.BeginSession("C:…

quickbooks_integration_java

2010-07-30T07:19:34-04:00

QuickBooks Online Edition NOTE: WARNING! This is *super* sloppy code. You'll want to clean it up a bit before you use it! import java.net.*; import java.io.*; import javax.net.ssl.*; public class Test { protected static String _appID = "134476472"; protected static String _appLogin = "test.www.academickeys.com"; protected static String _connTicket = "TGT-47-1sRm2nXMVfm$n8hb2MZfVQ"; protected static String _appURL = "https://webapps.quickbooks.com/j/AppGateway"; /** * @param…

quickbooks_integration_methods

2010-04-20T23:11:04-04:00

Integration Options There are a number of different ways to accomplish QuickBooks integration with websites. The common ones are: * IIF files * CSV/Excel import/export * The QuickBooks Web Connector * COM/DCOM * RDS * HTTP Connector * Rubygem

quickbooks_integration_php

2009-09-02T21:00:10-04:00

* ConsoliBYTE / Keith Palmer's QuickBooks PHP Integration Framework * Mirroring to an SQL database * Coding Standards for Contributors * Also: * Also:

quickbooks_integration_php_consolibyte

2010-07-27T21:20:45-04:00

Where can I get it? See: Who Develops It? * Keith Palmer keith { at } ConsoliBYTE {dot} com How can I contribute? Contributions towards open-source projects are *always* appreciated! You can contribute by:

quickbooks_integration_php_consolibyte_api

2010-03-29T18:42:49-04:00

The API is experimental right now, and many of the API methods do not work yet. That said, if you want to try it out, have at it, and if you have problems post them on the forums () and we'll do our best to get them fixed in a timely manner.

quickbooks_integration_php_consolibyte_codingstandards

2009-07-16T07:49:14-04:00

Subversion / SVN Access The preferred contribution method is via checking in subversion updates. Please contact me for svn access. Coding Standards brackets: GOOD: if (something) { // do something } BAD: if (something) { // do something }

quickbooks_integration_php_consolibyte_constants

2009-10-27T22:40:21-04:00

QUICKBOOKS_OBJECT_* Constants QUICKBOOKS_OBJECT_ACCOUNT => Account QUICKBOOKS_OBJECT_BILL => Bill QUICKBOOKS_OBJECT_BILLINGRATE => BillingRate QUICKBOOKS_OBJECT_BILLPAYMENTCHECK => BillPaymentCheck QUICKBOOKS_OBJECT_BILLPAYMENTCREDITCARD => BillPaymentCreditCard QUICKBOOKS_OBJECT_BILLTOPAY => BillToPay QUICKBOOKS_OBJECT_CHARGE => Charge QUICKBOOK…

quickbooks_integration_php_consolibyte_dbstructure

2010-07-21T10:38:43-04:00

quickbooks_user The user table stores authentication information for each Web Connector user/application. -- -- Table structure for table 'quickbooks_user' -- -- Stores usernames and passwords the Web Connector authenticates against CREATE TABLE quickbooks_user ( qb_username varchar(40) NOT NULL, // The username used by the Web Connector to authenticate qb_password varchar(40) NOT NULL, // The password used by the Web Connector to authenticate (stored…

quickbooks_integration_php_consolibyte_docs

2009-07-20T13:55:34-04:00

See Also: ConsoliBYTE QuickBooks PHP Framework

quickbooks_integration_php_consolibyte_hooks

2010-03-29T19:05:27-04:00

Since version 1.4, user-defined hooks may be attached to the QuickBooks_Server and QuickBooks_Server_* SOAP servers to enable developers to further integrate their custom web applications with QuickBooks. Hooks are simply functions or static methods which are registered with the server component to be called when certain events occur within the QuickBooks PHP Framework. Some of the base available hooks are documented below. Other Driver subclasses or SOAP server subclasses may offer addit…

quickbooks_integration_php_consolibyte_merchantservice

2009-09-02T21:02:32-04:00

Starting with nightly builds after 2009-09-01 and release v1.5.3, the ConsoliBYTE QuickBooks PHP Framework includes QuickBooks Merchant Service support. Download it here: * QuickBooks Merchant Service PHP Framework See also: * * QuickBooks Merchant Service documentation

quickbooks_integration_php_consolibyte_oopapi

2009-08-24T10:44:35-04:00

See also: QuickBooks PHP Framework The QuickBooks PHP Framework now supports a purely OOP way of communicating with QuickBooks via the Web Connector. Some of the methods are documented below. You should download the latest release (or nightly build, if you're adventurous) and see the included documentation for more complete examples. The files you should look at in the downloaded package are:

quickbooks_integration_php_consolibyte_sqlmirror

2010-04-09T16:04:55-04:00

The purpose of the QuickBooks SQL Mirror is to facilitate easier access to QuickBooks desktop editions data by extracting the data and making it available in normal SQL tables. The data can then be manipulated within the SQL database and, if desired, written back to QuickBooks automatically.

quickbooks_integration_php_consolibyte_sqlmirror_table_customer

2009-09-23T21:17:30-04:00

qbsql_id ListID (You can make this up if adding a new record. Do not update it. It will be updated when the record is transferred to QuickBooks.) TimeCreated (Read-only.) TimeModified (Read-only.) EditSequence (Read-only. Do not update, this is needed to sync changes back to QuickBooks.) Name (Required.) FullName IsActive Parent_ListID Parent_FullName Sublevel CompanyName Salutation FirstName MiddleName LastName BillAddress_Addr1 BillAddress_Addr2 BillAddress_Addr3 BillAddress_Addr4 (You …

quickbooks_integration_php_consolibyte_sqlmirror_table_customertype

2009-10-14T06:29:47-04:00

* IMPORTANT NOTE: The QuickBooks SDK does not allow UPDATEs to this record. Changes beyond the initial add of the record to QuickBooks will not be propagated back to QuickBooks. qbsql_id ListID (You can make this up if adding a new CustomerType. Do not update it. It will be updated once synced to QuickBooks.) TimeCreated (Changes to this field will be overwritten when synced to QuickBooks.) TimeModified (Changes to this field will be overwritten when synced to QuickBooks.) EditSequence…

quickbooks_integration_php_consolibyte_sqlmirror_table_datedriventerms

2009-10-14T06:39:16-04:00

* IMPORTANT NOTE: There are two types of terms in QuickBooks: Standard and Date-Driven. To get the full list of Terms, you must UNION this table with the 'standardterms' table. * IMPORTANT NOTE: The QuickBooks SDK does not allow UPDATEs of this type of record. Any changes to these records will not be propagated back to QuickBooks.

quickbooks_integration_php_consolibyte_sqlmirror_table_invoice

2009-09-30T13:35:32-04:00

qbsql_id (Auto-increment. Do not update.) TxnID (Required. If adding a new Invoice, you can make this up and QuickBooks will replace it when it's added to QuickBooks. Do not update.) TimeCreated (This field will be overwritten by QuickBooks when the object is added to QuickBooks.) TimeModified (This field will be overwritten by QuickBooks when the object is added to QuickBooks.) EditSequence (Do not update.) TxnNumber Customer_ListID Customer_FullName (Either this or Customer_L…

quickbooks_integration_php_consolibyte_sqlmirror_table_invoice_invoiceline

2009-11-17T09:42:56-04:00

qbsql_id (Auto-increment. Do not update.) Invoice_TxnID (This field refers to the TxnID field of the 'invoice' table.) SortOrder (This field indicates the order of the line items on the invoice, lower sort order numbers appear first on the invoice.) TxnLineID (To cause this line item to be added to the invoice, set this to -1. To cause this line item to be updated on the invoice, leave it as the generated TxnLineID value from QuickBooks. Note that any existing line items on the invoi…

quickbooks_integration_php_consolibyte_sqlmirror_table_invoiceline

2009-10-15T14:13:53-04:00

qbsql_id Invoice_TxnID TxnLineID Item_ListID Item_FullName Descrip Quantity UnitOfMeasure OverrideUOMSet_ListID OverrideUOMSet_FullName Rate RatePercent Class_ListID Class_FullName Amount ServiceDate SalesTaxCode_ListID SalesTaxCode_FullName Other1 Other2

quickbooks_integration_php_consolibyte_sqlmirror_table_iteminventory

2009-09-23T14:18:25-04:00

qbsql_id (Auto-increment. Do not update.) ListID (Required. If adding a new Item, you can make this up and QuickBooks will replace it when it's added to QuickBooks. Do not update.) TimeCreated (This field will be overwritten by QuickBooks when the object is added to QuickBooks.) TimeModified (This field will be overwritten by QuickBooks when the object is modified in QuickBooks.) EditSequence (Do not update.) Name (Required) FullName (If this is a sub-Item of something else, QuickBooks …

quickbooks_integration_php_consolibyte_sqlmirror_table_itemservice

2009-10-28T09:25:05-04:00

ListID (You can make this up if adding a new record to QuickBooks, it will be updated when the record is transferred to QuickBooks. Do not update.) TimeCreated (Read-only.) TimeModified (Read-only.) EditSequence (Read-only. Do not update.) Name (Required.) FullName (If this service item has a parent item, the FullName is formatted as "Parent Name:Child Name" IsActive Parent_ListID Parent_FullName Sublevel UnitOfMeasureSet_ListID UnitOfMeasureSet_FullName SalesTaxCode_List…

quickbooks_integration_php_consolibyte_sqlmirror_table_purchaseorder

2009-09-30T13:11:02-04:00

qbsql_id TxnID (Read-only. You may make this up if you're inserting a new value, it will be updated when it syncs to QuickBooks.) TimeCreated (Read-only.) TimeModified (Read-only.) EditSequence (Read-only. Do not change this!) TxnNumber (Read-only.) Vendor_ListID Vendor_FullName (Either this or Vendor_ListID is required.) Class_ListID Class_FullName ShipToEntity_ListID ShipToEntity_FullName (This can be a reference to either a Customer, a Vendor, or an Employee.) Templat…

quickbooks_integration_php_consolibyte_sqlmirror_table_receivepayment

2009-10-28T09:32:40-04:00

TxnID (Required. If adding a new Receive Payment, you can make this up and QuickBooks will replace it when it's added to QuickBooks. Do not update.) TimeCreated (This field will be overwritten by QuickBooks when the object is added to QuickBooks.) TimeModified (This field will be overwritten by QuickBooks when the object is modified in QuickBooks.) EditSequence (Read-only. Do not update.) TxnNumber (Read-only.) Customer_ListID (Either this field or the Customer_FullName field are re…

quickbooks_integration_php_consolibyte_sqlmirror_table_standardterms

2009-10-14T06:37:44-04:00

* IMPORTANT NOTE: There are two types of terms in QuickBooks: Standard and Date-Driven. To get the full list of Terms, you must UNION this table with the 'datedriventerms' table. * IMPORTANT NOTE: The QuickBooks SDK does not allow UPDATEs of this type of record. Any changes to these records will not be propagated back to QuickBooks.

quickbooks_integration_php_consolibyte_sqlmirror_table_vendor

2009-10-28T09:21:14-04:00

qbsql_id ListID (You can make this up if adding a new record to QuickBooks, it will be updated when the record is transferred to QuickBooks. Do not update.) TimeCreated (Read-only.) TimeModified (Read-only.) EditSequence (Read-only. Do not update.) Name (Required.) IsActive CompanyName Salutation FirstName MiddleName LastName VendorAddress_Addr1 VendorAddress_Addr2 VendorAddress_Addr3 VendorAddress_Addr4 (You can only use this field if you do *not* use the City, State, PostalCode, or Cou…

quickbooks_integration_php_consolibyte_sqlmirror_table_vendortype

2009-09-30T13:13:59-04:00

qbsql_id ListID (Required. If adding a new Vendor Type, you can make this up and QuickBooks will replace it when it's added to QuickBooks. Do not update.) TimeCreated (This field will be overwritten by QuickBooks when the object is added to QuickBooks.) TimeModified (This field will be overwritten by QuickBooks when the object is added to QuickBooks.) EditSequence (Do not update.) Name (Required) FullName IsActive (1 for YES, 0 for NO.) Parent_ListID Parent_FullName Sublevel (Thi…

quickbooks_integration_php_consolibyte_webconnector

2010-04-01T08:52:00-04:00

See also: ConsoliBYTE QuickBooks PHP Integration Framework You may also want to see the new OOP API method of integrating with the Web Connector Quick Start See here: Quick Start for the QuickBooks Web Connector Request and Response Functions for "Traditional" Integrations Your request and response functions are called by the framework to generate requests and handle responses from QuickBooks. So, you'll queue up some requests (i.e. add customer #15) and then when the Web Connector conne…

quickbooks_integration_php_consolibyte_webconnector_quickstart

2010-04-12T05:17:54-04:00

I'm going to try to quickly describe here what you need to do to get QuickBooks up and running and interacting correctly with the Web Connector and your web application. This assumes your doing an integration using the basic features of this framework. You'll need to look at these files for examples:

quickbooks_integration_vbdotnet

2008-11-12T08:29:26-04:00

See: QuickBooks Visual Basic .NET Framework

quickbooks_integration_vbdotnet_consolibyte

2010-03-29T10:15:13-04:00

See: Download: Installation Guides * Installation Guides Frequently Asked Questions What do I have to modify in the Web.config file? You have to at least modify your databaseDSN setting to point to the SQL Server database you'll be using.

quickbooks_integration_vbdotnet_consolibyte_installation

2008-12-12T14:53:09-04:00

Below are some people's solutions to common installation problems / problems getting started. Installation Guide by Mike Satkevich mike AT sysgbs DOT com I set up a virtual directory off my main web site, and called it “QBWC”. Then I copied your project files from inside

quickbooks_ipp

2010-09-07T13:47:32-04:00

Quick-Start for Federated Applications * Quick-Start Guide for the Federated Applications on the Intuit Partner Platform Example HTTP Requests and Responses IPP Requests and Responses * API_Authenticate * API_GetUserInfo IDS Requests and Responses * IDS AccountQuery

quickbooks_ipp_http_accountquery

2010-07-08T22:44:36-04:00

HTTP Request POST https://services.intuit.com/sb/account/v2/173642438 HTTP/1.1 Content-Type: text/xml Authorization: INTUITAUTH intuit-app-token="tex3r7hwifx6cci3zk43ibmnd",intuit-token="5_bfg54n3j2_bxae7r_b_cddabr2cvpkv7r2vqds7crspikg_p7jncwyuufv3r64is7ughxcbj299ymnkpf5fuat7x8gfu74skx7b" Cookie: scache=Jul 8 2010 13:24:01_3; ptest=1278643222343; stest=1278643222343; luid=55579567; TICKET=5_bfg54n3j2_bxae7r_b_cddabr2cvpkv7r2vqds7crspikg_p7jncwyuufv3r64is7ughxcbj299ymnkpf5fuat7x8gfu74skx7b; qb…

quickbooks_ipp_http_authenticate

2010-07-09T16:25:18-04:00

Example Request POST https://workplace.intuit.com/db/main?act=API_Authenticate Content-Type: application/xml QUICKBASE-ACTION: API_Authenticate Content-Length: 198 keith@consolibyte.com password42 tex3r7hwifx6cci3zk43ibmnd

quickbooks_ipp_http_getuserinfo

2010-06-17T14:03:38-04:00

This request gets information about a specific user by e-mail address, or gets the currently logged in users information if you don't specify an [email] node. Example Request POST https://workplace.intuit.com/db/main Content-Type: application/xml QUICKBASE-ACTION: API_GetUserInfo Content-Length: 237 5_bffe4fdvy_bxae7r_b_8qukaybpnsp2qcvkznnwcbm64xt_cnn8ps3u4knjmbfp86ybbaeqrznswtrd6vuzsmk7j4w83a74pqmb tex3r7hwifx6cci3zk43ibmnd keith@cons…

quickbooks_ipp_quickstart

2010-09-07T14:36:49-04:00

Creating the Application * Log in to Workplace.Intuit.com * Choose 'Create New' to create a new application * Choose 'Customize' > 'Application' from the menu * Choose 'Advanced Settings' * Click 'App uses Intuit Data Services' * Check 'Application is Hosted Externally' * Put the URL of your application (i.e. where you want to send the user after they've logged in) in the 'Application Destination URL' box * Click 'Save Changes'

quickbooks_links

2008-09-27T19:36:32-04:00

* QuickBooks Web Connector: * QuickBooks SDK (requires registration): * QuickBooks OSR (On-Screen Reference):

quickbooks_multiuser_multilocation

2008-09-28T10:39:42-04:00

Sometimes, you need to have access to QuickBooks for more than one user, and from more than one location. For instance, your company might have more than one office with more than one accountant/person who accesses QuickBooks. You can do this by:

quickbooks_online_edition

2010-08-01T10:05:34-04:00

Additional documentation is provided in the QuickBooks SDK. Chapter 7, Page 87 of QBSDK_ProGuide.pdf Open-source Frameworks with QuickBooks Online Edition Support * ConsoliBYTE QuickBooks PHP Framework Sample Code * ConsoliBYTE QuickBooks PHP Framework (see code in docs/example_online_edition.php)

quickbooks_osr

2008-09-30T10:42:07-04:00

Choose the qbXML version you're targetting from the slide bar on the left labeled 'Max SDK Version'. If you don't know what version to use, consult this list: * QuickBooks versions supporting various qbXML Versions Choose the action you want to perform from the select box in the top-middle labeled “Select Message:”. When you choose it, it will then show you the qbXML request schema.

quickbooks_qbms_integration

2009-12-09T21:59:03-04:00

Getting Started * Start by getting a test account here: * And registering for a developer account here: * Then, go to the application registration page here:

quickbooks_qbms_integration_vbdotnet

2009-08-03T06:23:41-04:00

Protected Function getSession(ByVal Site As String) Dim req As WebRequest = WebRequest.Create(Site) Dim xmldom As New XmlDocument Dim request_xml As String Dim myWriter As StreamWriter xmldom.Load("~\XML\GetSessionTicket.xml") request_xml = xmldom.InnerXml req.Method = "POST" req.ContentLength = request_xml.Length req.ContentType = "application/x-qbmsxml" myWriter = New StreamWriter(req.GetRequestStream) m…

quickbooks_qbxml

2010-07-21T15:52:04-04:00

Where can I find what tags/nodes/requests are available? Use the QuickBooks OSR (choose the command type from the 'Select Message' dropdown box): * Where can I find a schema definition / .XSD file for qbXML? You can find the .XSD schema files in the QuickBooks SDK. You should:

quickbooks_qbxml_accountquery

2008-10-12T13:59:26-04:00

Example qbXML Request Example qbXML Response 80000020-1209525941 2008-04-29T23:25:41-05:00 <…

quickbooks_qbxml_customeradd

2009-01-13T14:35:35-04:00

* * * WARNING: If you're using Keith's / Consolibyte Solutions PHP framework, you must change the requestID=”...” attribute before using this examples! You need to embed the $requestID parameter passed to your handler function as requestID=“xyz” * * *

quickbooks_qbxml_customerquery

2008-10-07T12:20:46-04:00

Fetching All Customers This query will fetch all customers in QuickBooks. If you have a lot of customers in QuickBooks, there's a good chance that this will take a very long time and might even return so much data that your Web Server (Apache, IIS, etc.) will close the connection or die. If that occurs, you'll need to think about using iterators or limiting the amount of data returned with the IncludeRetElement tag.

quickbooks_qbxml_customerquery_by_name

2008-10-07T12:18:07-04:00

Example Request Keith Palmer

quickbooks_qbxml_customerquery_with_iterators

2009-02-20T08:07:06-04:00

You might find that when querying for large result sets, you get HTTP time-out errors, Web Connector time-out errors, web server time-out errors, or web server data-overflow errors. This is because the resulting XML from some queries can get so large (imagine sending 15,000 customer XML records over the network, it's usually a several megabyte XML document) that the SOAP server/web server/Web Connector rejects the response or refuses to wait for that much data to transfer.

quickbooks_qbxml_dataextmod

2009-01-12T07:39:06-04:00

You have to add the custom field either via the QuickBooks UI, or with a DataExtDefAdd request before you can add or modify the data contained within it. 0 MyCustomerNumber Customer Keith Palmer

quickbooks_qbxml_editions_simplestart

2009-02-18T15:51:38-04:00

QuickBooks Simple Start only supports some of the SDK commands. Here's a list: ARRefundCreditCardAdd (5.0) Yes ARRefundCreditCardQuery (5.0) Yes AccountAdd Yes AccountQuery Yes AgingReportQuery (2.0) Yes BillAdd No BillMod (3.0) Yes BillPaymentCheckAdd (2.0) No

quickbooks_qbxml_element_includeretelement

2009-01-13T16:23:33-04:00

The ... tag in qbXML can be used in qbXML queries to tell QuickBooks what data to return in the response. By default, all data for the given object is returned. For example, if you issue a CustomerQuery, you'll get back the entire customer record(s).

quickbooks_qbxml_idtype

2008-10-14T16:08:42-04:00

Primary Keys ListID * Customer * Account * Class * Employee * ItemDiscount * ItemOtherCharge * ItemStandardTerms * ItemSubtotal * StandardTerms * Vehicle * Vendor TxnID * Bill * BillPaymentCheck * BillingRate * BuildAssembly * Charge * Check * Company * Deposit * Estimate * InventoryAdjustment * Invoice * LinkedTxn * PurchaseOrder * TimeTracking * VehicleMileage

quickbooks_qbxml_inaccuracies

2008-12-05T15:15:00-04:00

Undocumented Required Fields ItemInventoryAdd Undocumented required fields include: * IncomeAccountRef * AssetAccountRef * COGSAccountRef ItemNonInventoryAdd Undocumented required fields include: * AccountRef stopOnError is misspelled as stopOnErrror (too many "r"s) The ENUM stopOnError is misspelled in many places in the QuickBooks SDK/OSR v7.0

quickbooks_qbxml_invoiceadd

2008-12-03T09:20:39-04:00

Example qbXML to Add an Invoice F560000-1197683156 2007-12-14 9668 56 Cowles Road Willington CT 06279 United State…

quickbooks_qbxml_invoiceadd_2

2010-01-15T09:51:08-04:00

Invoice Add Request 90001-1263558758 Testy McTesterson 2010-01-15 21011 ConsoliBYTE, LLC 134 Stonemill Road …

quickbooks_qbxml_invoiceadd_with_discount

2008-09-26T16:35:32-04:00

Example qbXML for Adding an Invoice with a Discount 50001-1213155398 19 Karli Palmer USA Line Item Name …

quickbooks_qbxml_invoicemod

2009-02-13T14:04:37-04:00

Important Notes: If you specify ANY line items on the invoice mod, it replaces all the line items with those you specified. If you are trying to just add a line to the end, you have to reference all the lines in the invoice (you don't have to resend all the info, just set the TxnLineID to the one from the original invoice), and set it to -1 for all the new line items...

quickbooks_qbxml_iteminventoryadd

2009-01-12T13:32:32-04:00

Example qbXML Request product name here your sales description here 85.00 Sales Cost of Goods Sold

quickbooks_qbxml_iteminventoryquery

2009-09-22T14:28:19-04:00

Example qbXML Request This fetches a list of items, starts an iterator, and only returns the item names. Name

quickbooks_qbxml_itemnoninventoryadd

2008-12-05T15:18:06-04:00

Example ItemNonInventoryAdd Request My Item Name My description here... 1.00 Sales

quickbooks_qbxml_itemquery

2009-01-12T13:26:46-04:00

Example qbXML Request your item name

quickbooks_qbxml_itemreceiptadd

2009-11-02T12:50:47-04:00

Linking your Item Receipt to a Purchase Order If you want to link the Item Receipt to an existing Purchase Order, there are two ways you can accomplish this: * If you want to link the entire PO to the Item Receipt then you can use the LinkToTxnID tag. This will bring in all item information from the Purchase Order, regardless of what items or quantities you specify in any ItemLineAdd nodes.

quickbooks_qbxml_itemserviceadd

2008-12-05T08:43:07-04:00

ItemServiceAdd Request Tubes Tubes are excellent for all ages. These are Guaranteed fun for everyone 110 Other Income

quickbooks_qbxml_pointofsale

2009-10-30T13:27:27-04:00

... CompanyName Young Yuk

quickbooks_qbxml_questions

2010-07-22T11:14:31-04:00

General qbXML Questions How much of the QuickBooks API is exposed via qbXML? Almost all of it. Certain functions are not supported: * Payroll requests * Querying for voided transactions How does qbXML handle special characters (accents, non-US/non-ASCII characters, etc.)? This does not work: (it fails with a “QuickBooks found an error with the XML” error)

quickbooks_qbxml_receivepaymentadd

2010-07-23T06:50:17-04:00

Example qbXML for adding a Received Payment F230000-1196864585 2007-12-14 00612361 195.00

quickbooks_qbxml_salesreceiptadd

2009-01-12T13:48:14-04:00

Sales receipts are generally used to record purchases that are paid for right away (point of sale orders). So with Invoices, you'd send an invoice, and then receive a payment another day. With sales receipts, the invoice and payment are sort of bundled together as one.

quickbooks_qbxml_versions

2009-12-15T09:15:30-04:00

What versions of qbXML to various versions of QuickBooks support? QuickBooks 2009 and Enterprise 9.0 * 7.0 * 6.0 * 5.0 * 4.1 * 4.0 * 3.0 * 2.1 * 2.0 * 1.1 * 1.0 QuickBooks 2008 Canadian Note from the QB SDK 7.0: While the currently available CA QB 2003-2007 supports qbXML CA3.0 & CA2.0 and the currently available UK QB 2003-2006 supports qbXML UK 3.0 & UK2.0, these qbXML specs will NOT be supported by any future CA or UK QB release. Instead those future releases will s…

quickbooks_sceenshots

2009-12-02T07:36:49-04:00

Items and Services * The 'Account' that the item 'Generic Invoice Item' is assigned to is: Services * The 'Item Type' of the item 'Generic Invoice Item' is: Service (use: ServiceItemAdd, ServiceItemMod, ServiceItemQuery, ListDel) * The 'Account' that the item 'Boots With The Fur' is assigned to is: Sales * The 'Item Type' of the item 'Boots With The Fur' is: Non-inventory Item (use: ItemNonInventoryAdd, ItemNonInventoryMod, ItemNonInventoryQuery, ListDel)

quickbooks_sql_api_manual

2008-12-05T14:33:04-04:00

Retrieving Data * Accounts * Customers * Estimates * Invoices

quickbooks_ssl_selfsigned

2009-08-17T16:54:33-04:00

To get self-signed SSL certificates to work with the QuickBooks Web Connector, you must import the certificate (and possibly the CA certificate) into Windows/Internet Explorer. To test if your self-signed certificate is working correctly and will play nice with the Web Connector, visit the https:// URL you're using in *Internet Explorer*. Firefox or another browser *will not help you test*, you must use Internet Explorer.

quickbooks_testing

2008-12-05T11:15:15-04:00

* [Test file for QuickBooks Enterprise Solutions 9.0 (Manufacturing and Wholesale Edition 9.0)]

quickbooks_web_connector

2010-06-02T14:18:09-04:00

The QuickBooks Web Connector is a software application that runs on Microsoft Windows that enables specially designed web-based applications to exchange data with QuickBooks products. The Web Connector offers and automated way to transfer data between web applications (shopping carts, CMS, etc.) and QuickBooks. It supports two-way communication (i.e. moving data from the web to QuickBooks, and moving data from QuickBooks to the web) and is the recommended way to connect websites to QuickBooks (…

quickbooks_web_connector_soap_authenticate

2009-05-02T13:47:28-04:00

authenticate() method Request:

userna…

quickbooks_web_connector_soap_closeconnection

2009-04-15T11:27:20-04:00

Incoming SOAP Request 9d525ece56dc622522abdd28aaa0a13c

quickbooks_web_connector_soap_receiveresponsexml

2009-05-08T08:43:47-04:00

Example SOAP Request Example SOAP request indicating the last request was successful It is important that you still check the statusCode and statusAttribute of the qbXML request as well! You need to be able to handle both Web Connector protocol-level errors *and* qbXML errors.

quickbooks_web_connector_soap_sendrequestxml

2009-05-08T08:28:03-04:00

Example SOAP Request First Request The very first call top sendRequestXML() for each session will send you a strHCPResponse from QuickBooks. It will look like this: a05fd1b411f6e22adbb5717f96876b5b

quickbooks_web_connector_supports

2008-09-27T19:35:27-04:00

The Web Connector is not supported on any Apple OS X platform. It only works for Windows Desktop editions of the software. The Web Connector officially supports these QuickBooks versions: * U.S. editions of QuickBooks Financial Software products * QuickBooks Enterprise Solutions * QuickBooks Premier (2002 or later) * QuickBooks Pro (2002 or later) * QuickBooks Simple Start (2006 or later) * QuickBooks Point of Sale (v.4.0 or later) * Canadian editions of QuickBooks (2003 or lat…

start

2010-06-04T10:45:41-04:00

Welcome to the Consolibyte Solutions Wiki QuickBooks Integration Wiki Foxycart + QuickBooks Wiki InfusionSoft + QuickBooks Wiki WHMCS + QuickBooks Wiki OpenCart + QuickBooks Wiki Asterisk Integration/Scripting Wiki XBox Media Center Wiki PHP Programming Wiki

sysadmin

2010-03-26T08:59:11-04:00

------ Miscellaneous Systems Administration Tips ------ Rsnapshot for Backups Password-less SSH Logins Testing SMTP-AUTH Logins Testing IMAP Logins Testing POP3 Logins Securing your Apache 2.x Server Moving Subversion Repositories to another server

sysadmin_apache2

2010-03-26T09:14:05-04:00

SSL and PCI Compliance Your SSL configuration should have the following options: # This disables old, vulnerable SSL versions (SSLv2): SSLProtocol -ALL +SSLv3 +TLSv1 # This disables WEAK and MEDIUM strength ciphers: SSLCipherSuite ALL:!ADH:RC4+RSA:+HIGH:!MEDIUM:!LOW:!SSLv2:!EXPORT

sysadmin_imap

2009-05-19T09:39:02-04:00

# telnet consolibyte.com 143 Trying 208.81.124.11... Connected to consolibyte.com. Escape character is '^]'. * OK [CAPABILITY IMAP4rev1 SASL-IR SORT THREAD=REFERENCES MULTIAPPEND UNSELECT LITERAL+ IDLE CHILDREN NAMESPACE LOGIN-REFERRALS UIDPLUS LIST-EXTENDED I18NLEVEL=1 AUTH=PLAIN AUTH=LOGIN AUTH=DIGEST-MD5 AUTH=CRAM-MD5] Dovecot ready. 1 login keith@consolibyte.com your-password-here 1 OK Logged in. 2 list "" "*" * LIST (\HasChildren) "." "INBOX" * LIST (\HasNoChildren) "." "INBOX.Sent"…

sysadmin_mailapp_remove_messages_after

2009-03-14T12:11:11-04:00

By default, Apple's Mail.app sets POP accounts to removing messages from the server after one week. To change this, open Mail.app and then go: * Mail > Preferences * Choose the 'Accounts' panel * Click the account you want to change * Choose the 'Advanced' tab * To stop it from deleting messages, uncheck the 'Remove copy from server after retrieving message after' checkbox, otherwise, adjust the time period to suite your needs

sysadmin_movingsubversionrepositories

2009-06-02T11:04:48-04:00

First, dump the repository: # svnadmin dump /path/to/your-repository-name > your-repository-name.repo Create your new repository (if you haven't already): svnadmin create your-new-repository-name Then, load it into the new repository: svnadmin load your-new-repository-name < your-repository-name.repo

sysadmin_passwordlessssh

2009-05-14T13:39:06-04:00

On the machine that will be starting the SSH session (the client machine): # ssh-keygen -t rsa * Note: Do not enter a password when prompted. Now, copy the .ssh/id_rsa.pub file this generates so the remote machine, to the remote user's .ssh/authorized_keys file.

sysadmin_pop3

2009-11-03T19:35:48-04:00

From a command prompt: keithpalmerjr$ telnet domain-name.org 110 Trying 208.81.124.14... Connected to domain-name.org. Escape character is '^]'. +OK Dovecot ready. user your-username-here +OK pass your-password-here +OK Logged in. list +OK 31 messages: 1 543 2 1095 3 1085 4 14591 5 3431 6 116763 7 6608 8 7819 9 12350 10 2939 11 3838 12 5251 13 8477 14 9330 15 1945 16 30652 17 105489 18 105864 19 85070 20 106379 21 107810 22 19840 23 11055 24 20394 25 16601 26 108297 27 107015 28 20400 29 11…

sysadmin_smtpauth

2009-07-16T12:03:32-04:00

------ Testing SMTP-AUTH Logins ------ First, you'll need the encoded version of the username and password auth string. Assuming your login username is someone@somewhere.com and your login password is my-password, at the command prompt: % perl -MMIME::Base64 -e 'print encode_base64("\000someone\@somewhere.com\000my-password")' AHNvbWVvbmVAc29tZXdoZXJlLmNvbQBteS1wYXNzd29yZA==

sysadmin_thunderbird_default_printer

2009-02-05T13:38:10-04:00

Mozilla Thunderbird has a bad habit of remembering the default printer, rather than pulling the default printer from your Windows (OS X? Linux?) preferences every time. Thus, if you set up Thunderbird when you have one printer as the default, and then change the default printer, Thunderbird will still try to print to the old default printer.

sysadmin_thunderbird_remove_messages_after

2009-03-14T12:13:50-04:00

By default, Thunderbird removes downloaded messages over POP3 immediately from the server. * Open Thunderbird * Go to Tools > Account Settings * Click the account you want to change settings for * Choose the 'Server Settings' option set * The 'Leave messages on server' checkbox should be checked to leave messages on the server

whmcs

2010-03-23T11:19:02-04:00

Frequently Asked Questions QuickBooks UK Editions and "Unable to cast COM object of type 'Interop.QBXMLRP2.RequestProcessor2Class' to interface type 'Interop.QBXMLRP2.IRequestProcessor4'" Question: I'm getting this error when trying to connect the Web Connector to QuickBooks UK: ”

Consolibyte Solutions Wiki

accounts

asterisk

cms

customers

estimates

foxycart

foxycart_installation_onlineedition