Knowledgebase
[QODBC-Online] How to use QODBC with QuickBooks Online Edition
Posted by Juliet (QODBC Support) on 19 April 2010 08:45 AM

This method is Discontinued, Please refer new product QODBC for QuickBooks Online:

How to use QODBC Online with QuickBooks Online Edition (Apps.com)

How to Reconnect QODBC Online with QuickBooks Online Edition (Apps.com)

 

Instructions

     QODBC has the ability to communicate with the Web version of QuickBooks called "QuickBooks Online". This is a version of QuickBooks which is not sold as software, but rather as a service to USA customers and is run live over the Internet in the customer's browser. Please note that not all files and reports documented in QODBC are available in the Online Edition.

Setup of QODBC

 

     Checking the Connect To QuickBooks Online Edition checkbox activates the fields required to connect to the QuickBooks Online Edition. The connection string attribute for this item is IBizOEConnection. The valid values are Yes and No. The default is No.

Connection Key

     The Connection Key is a unique key that can only be created by your Online Edition Administrator. If you have administrator rights to your Online Company file then you can run the following URL: click here to obtain a connection key. Follow the wizard. The “…” after Connection Key: will launch a browser with the above URL. The connection string attribute for this item is IBizOETicketGUID. The default is an empty string.

Connection Key Wizard

     A short summary

     Login to your company file

     Start of Interview

     For Connection Name, use "QODBC Driver"

     Select the access you want QODBC to have to your Online Data

     Select who can access.

    Note: If you choose anything other than No, Anyone can run QODBC Driver on this computer can use the connection you will have to enter your login in every time a QODBC session or a QODBC connection is made. For a user to have access to your data they must have a connection ticket which can only be created by a company file administrator and must be running a copy of QODBC which passes its own private password along to connect.

     If you choose No you will get this warning also. See the note above on who could access the data and if you want to log in every time you connect to QODBC.

Login Key

      The Login Key comes from Intuit by running the following URL: click here and logging in. The “…” after Login Key: will launch a browser with the above URL. The connection string attribute for this item is IBizOELoginGUID. The default is an empty string. This value is only required if the QuickBooks Online Edition company file has user security activated.

      If you chose No security then leave this blank. This Key will expire after a period of non-use. If your application makes several connections each time you access QODBC you might want to return to this screen and press the "..." and log in once, saving the new Login Key. Then you will not be prompted again until the non-use timeout expires.

     Ask to login if invalid can be checked to allow the user to be sent to the Intuit WEB site to login if the Login Key is not valid. After the user has successfully logged in the user must copy the Login Key to the clipboard, close the browser and paste the Login Key into the Popup prompting for a Login Key. If not checked, and the Login Key is invalid, then an error message is returned to the calling program. The connection string attribute for this item is IBizOEPromptForLogin. The valid values are Yes and No. The default value is Yes. This is only useful if the QuickBooks Online Edition company file has user security activated.

 


SQL Operations Supported by QuickBooks Online Edition

Supported Insert,Query and Update Operations

     Using QODBC with the QuickBooks Online Edition (QBOE), Insert, Query and Update operations are supported for the following "list" tables:

     • Account
     • Class
     • Customer
     • Employee
     • ItemService
     • PaymentMethod
     • Terms
     • Vendor

Supported Insert and Query Operations

     Insert and Query operations are only supported by the following "transaction" tables:-

     • Bill, BillExpenseLine
     • Check, CheckExpenseLine
     • CreditCardCharge, CreditCardChargeExpenseLine
     • CreditCardCredit, CreditCardCreditExpenseLine
     • CreditMemo, CreditMemoLine
     • Invoice, InvoiceLine
     • JournalEntry, JournalEntryCreditLine, JournalEntryDebitLine
     • ReceivePayment, ReceivePaymentLine
     • SalesReceipt, SalesReceiptLine
     • TimeTracking
     • VendorCredit, VendorCreditExpenseLine

Note: TxnDeleted is also supported for the transactions that were created by QODBC.

Date Included in QBOE

     QuickBooks will use the default date if no date is specified in transaction inserts, but the Online Edition requires a date! So you must include a transaction date like this :-

      INSERT INTO "InvoiceLine" ("CustomerRefListID", "TxnDate", "RefNumber",
      "InvoiceLineItemRefListID", "InvoiceLineDesc", "InvoiceLineRate",
      "InvoiceLineAmount", "FQSaveToCache")
      VALUES ('2', {d '2006-04-13'} ,'QBOE1', '1', 'test 1',
      100.00000, 100.00, 0)

 

Keywords : connect to on-line quickbooks, setup for on-line

(147 vote(s))
Helpful
Not helpful

Comments (1)
Bruno Cozzi
04 February 2013 06:21 AM
Hi,
When this was written QB Online was not available in Australia. It now is. But will QODBC support the QB Online Australia edition as described in this article? Are there any updates to the article that we should be aware of before attempting this project?

Regards
Bruno
MD Bluegem Software: www.BluegemExplore.com.au
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).