Knowledgebase
[QODBC-Desktop] How to insert data into the TimeTracking table using QODBC
Posted by brad waddell on 12 March 2009 05:21 PM

An Example of Creating a TimeTracking Record

Note: The following INSERT commands work on the QuickBooks 2005 or 2006 USA Edition Sample Rock Castle Construction Company file using QODBC v6.00.00.143 or later. Modify the actual data elements to match your system.

Create a Simple TimeTracking

INSERT INTO "TimeTracking" ("EntityRefListID", "DurationMinutes","TxnDate","CustomerRefFullName","ItemServiceRefFullName",
"PayrollItemWageRefFullName") VALUES ( '370000-933272659', 480, {d'2007-12-18'}, 'Pretell Real Estate:75 Sunset Rd.', 'Removal','Salary')

Create a TimeTracking with Long Notes

     This INSERT statement is a Time/Enter Single Activity entry with a very long "Notes" column/field with QuickBooks 2006 :

INSERT INTO "TimeTracking" ("EntityRefListID", "DurationMinutes","TxnDate","CustomerRefFullName","ItemServiceRefFullName",
"PayrollItemWageRefFullName","Notes") VALUES ( '370000-933272659', 480, {d'2007-12-19'}, 'Pretell Real Estate:75 Sunset Rd.', 'Removal','Salary','QODBC Driver for QuickBooks New Version 6.0 with Optimizer Technology. A fully functional ODBC driver for reading and writing QuickBooks 2006-2002 accounting data files by using standard SQL queries. The new version 6.0 adds Optimizer technology which is 10 times faster than using the QuickBooks SDK directly. Many applications have ODBC support built-in and can automatically use QuickBooks data with wizard ease once this driver has been installed. Applications such as Microsoft Access - Excel - Visual Basic or Crystal Reports will immediately have real-time data access to your critical accounting data.' )

Note: The "Notes" column has a limit of 4095 characters and the text cannot contain any, (commas).

Result in VB Demo

Result in QuickBooks

     The screen dump (below) shows the Time/Enter Single Activity entry with a very long "Notes" column/field as it appears QuickBooks 2006 after executing the SQL statement:


Data Location

EntityRefListID Location

     I used the "EntityRefListID" value of '370000-933272659' because it's the ListID for employee Dan T. Miller. EntityRefListID can be found in the Entity table by doing:

     SELECT ListID, FullName, IsActive, Type FROM Entity

     or, in my case to check that '370000-933272659' is a valid "EntityRefListID":

     SELECT ListID, FullName, IsActive, Type FROM Entity where ListID='370000-933272659'

 

Keywords: Tracking

(168 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).