DataBlox Inc - New OfficeQ6 Download


OfficeQ6  New Release V 22.3.0.1 - 5/16/2012  (with QuickBooks 2012 support)

This page contains information on the latest version of the OfficeQ6 product.  This minor update release supports QB2012 - all flavors - as well as all flavors of QuickBooks 2005 - 2011.  It has been very well tested and is intended for wide distribution.

Released 5/16/2012, this version contains the following improvements:

  • Improved handling of files with large numbers of payroll related transactions
  • Ability to extract data from latest versions of Canadian 2012 QuickBooks
  • Additional field for report sorting in some record types (will be documented soon)
  • Debug mode (internal DataBlox only) changes related to error logging

Download it from the following URL:  http://www.datablox.com/OfficeQ6_Core_22030001.exe  Other details are same as for prior version below.  Alternate ZIP file with same files:  http://www.datablox.com/OfficeQ6_Core_22030001.zip

Any calling program that worked with earlier OfficeQ6 releases should work with this release with no changes.

The help file included with this release has not been updated.  It is the same as the version 21.x.x.x release.  We are currently converting all our help files to HTML and they will be on our web site soon - including updated field listings that will include the feature additions below.

We anticipate another release around June that will add support for multiple inventory locations / serial numbers / lot numbers (available only in QuickBooks Enterprise 2011 / 2012 versions).  There will be an accompanying API change (new typelib) because of these changes.  Meanwhile, we will be updating both our web site and sample applications.

Send questions to scottt@datablox.com.


Prior (version 22.2.0.0) release

The major differences between this and the earlier 2012 versions are in the memory management area.  It can now use more memory by managing larger address spaces (3GB for Windows XP or 4GB with Windows 7 if hardware supported).  There were also a few memory leaks fixed - which affected very large files significantly.  There are also some minor data enhancements / repairs - but nothing that changes the OfficeQ6 API.

This release is intented to be widely distributed.  We currently have no bugs against it - but will update this page immediately if any important bugs are reported.  It has been tested heavily against older large files that have been converted to QuickBooks 2012.

Download it from the following URL:  http://www.datablox.com/OfficeQ6_Core_22020000.exe

This install file contains the following files:

officeq6.exe - viewer, OLE automation interface, and code to extract 2005-2012 data
officeq6.chm - help file - (soon obsolete) with instructions on how to use, data, etc.
officeq6.ini - ini file - holds list of files and a few settings (not required)
officeq6.txt - small readme file - has tips displayed when file is run (not required)
officeq6.idl - ActiveX automation declarations file (not required)
ofcqpro.rtf - license agreement

Alternate ZIP file with same files:  http://www.datablox.com/OfficeQ6_Core_22020000.zip

Note that if you use the ZIP file, you will need to register the Automation Server yourself.  This can be painstaking with Windows 7 or Vista.  It is automatically done if you use the install EXE above.


Logging Addition (first appeared in version 22.2.0.0)

A new feature has been added to aid in troubshooting large QuickBooks files.  Currently, when the .ReadFile function is called with large files, there is a significant delay until the call returns.  If something goes wrong during this time - there is no way to diagnose what happened.

We have added some options to the .ReadFile call to create a log file to communicate both the execution times and memory useage (both physical and virtual) of different phases of the call.  Whenever a call is made from OfficeQ6 to Intuit's API - we log the following:

    current date and time (in same format used by Intuit's error logging files)
    the QBXML query type called
    the amount of physical memory available before the call to API
    the amount of virtual memory available before the call to API
    the elapsed time of the call to API

If any error occurs during the call, this information is very valuable for determining the cause.  The date time for each call can also be compared to Intuit's error logging files to aid diagnosis.

The following options have been added that can be passed using the siOptList argument of the .ReadFile call (see the help file for how these can be mixed with other options):

    logtype=time - Create the log file, but only log the elapsed time of each call, not the memory available.  This can be considerably faster than the 'timemem' option because calculating the memory used takes a significant amount of time.

    logtype=timemem - Create log file - logging both the elapsed time of each call and the available physical and virtual memory available before each call.

    logfile=<full_path_to_log_file> - Normally the file created has the same folder and name as the .QBW (QuickBooks data file) currently being read.  An extension of .qlog is used for the log file.  Using this option, you can place the file wherever you want and name the file and file extension however you want.

The default is that no log file is created.


Data Feature Additions since version 21.0.0.0

These additions were made for QuickBooks 2011 and were previously released, but are not yet in our field listings on the internet.

Data additions to record type TranDoc

   addition to field sFlags - added the following flags (for transaction types) - meaning
      F (CustChrg, CustInvc, VendBill) - all payments paid in full
      H (Journal) - dollar amounts were entered in the home currency
      J (Journal) - journal entry is an adjustment (orig info retained)
      P (many tran types) - document is waiting to be printed
      T (many tran types) - tax is included (non U.S. only)
      U (Journal) - journal entry is a home currency adjustment
      V (Estimate) - estimate is active
      W (many tran types) - transaction pending (has not occurred)
      Z (CustInvc) - invoice contains one or more finance charge items

Data additions to record type TranLine

   new field:  mSumIncome - currency total of all income type account postings (bDocMain only)

   new field:  mSumExpense - currency total of all income type account postings (bDocMain only)

   new field:  mStillOwing - amount of mBalanceDue that's still unpaid

   new field:  dPaidInFull - if document fully paid, date of last transaction that paid it off

   new field:  sBillableStatus - status of line if item is billable back to a customer

   new field:  dService - date entered as to when service was performed (not otherwise significant)

Added message box when .QQT file is being saved

Augmented code for some boolean fields where QuickBooks 2011 changed output format