DataBlox Inc - New OfficeQ6 Download
OfficeQ6 New Release V 220.127.116.11 - 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:
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 firstname.lastname@example.org.
Prior (version 18.104.22.168) 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.
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
Alternate ZIP file with same files:
Logging Addition (first appeared in version 22.214.171.124)
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)
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 126.96.36.199
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
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