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 2022 USA Edition Sample Company file using QODBC v22.00.00.345 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 ( '60001-1039046236', 480, {d'2021-12-15'}, 'Kim Garland', 'Installation Labor','Sick -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 2022 :

INSERT INTO "TimeTracking" ("EntityRefListID", "DurationMinutes","TxnDate","CustomerRefFullName","ItemServiceRefFullName",
"PayrollItemWageRefFullName","Notes") VALUES ( '60001-1039046236', 480, {d'2021-12-15'}, 'Kim Garland', 'Installation Labor','Sick -Salary','QODBC is a fully functional ODBC driver for reading and writing QuickBooks 2022-2002 accounting data files by using standard SQL queries. It requires an ODBC compliant front-end application such as Microsoft Word, Microsoft Excel, Microsoft Access, Visual Basic, PowerBuilder, Delphi, Python, C#, .NET, ASP, ASP.NET, PHP, Crystal Reports, Jitterbit, QlikView, Power BI, and many popular report writers and tools. Once installed, it will allow these applications to read and write QuickBooks Accounting files in the same fashion as other file formats installed on your computer. Using the official QuickBooks SDK interface, we are able to offer our customers total compatibility with all QuickBooks file formats.' )

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

Result in QODBC Test Tool


Note: 
 QODBC Support Wizard is used to test QODBC SQL queries only and is not a development tool.

 

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 2022 after executing the SQL statement:


Data Location

EntityRefListID Location

     I used the "EntityRefListID" value of '60001-1039046236' 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 '60001-1039046236' is a valid "EntityRefListID":

     SELECT ListID, FullName, IsActive, Type FROM Entity where ListID='60001-1039046236'

 

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).