Export Sale Data to Excel
To access the Add-In Manager, click on Edit then on Manage Add-ins.
The Add-In Manager allows the user to enable three available add-ins: MS Excel Add-In, ODBC Access, and Template Designer.
In DataLog versions prior to 5.0.4, the Excel Add-In Manager is only compatible with the 32 bit version of Excel.
The first enables transfer of a specific sale’s DataLog sale sheet into MS Excel, while maintaining the DataLog layout.
To implement the Excel option from within DataLog, click the enable button as shown below.
They are pre-loaded with formulas and other information.
Users can edit and then save the sample files with their preferred layouts to be used as custom templates.
Here is an example of a formula that is used:
=DataLogLookup(“database or index number”, “FieldName”)
You can download Excel sample files HERE
The first of the three files is the ALL Fields example.
It simply imports every possible field from the sale; they are displayed in the first column.
This provides an easy reference of all of the field names used in the formulas.
Enter a “d” or “i” number in the Sale # field to import DataLog Data.
To display a DataLog-style sale sheet in Excel, open the One Page Sales Sheet sample file.
(It could be used as a springboard for creating a customized sale sheet in Excel.)
The red arrow points to the cell where either a “d” or an “i” number for a specific sale in DataLog is entered to import that sale’s data.
In the test example below, a “d” number was used to import the data for the Costello to Abbott sale.
The third Excel add-in sample file is the Land Mix; an empty version is seen below.
To import sale data, use a “d” or “i” number.
If a match for both sale and field is not found, an error code will be displayed for the cell value.
#NoSale# if the sale cannot be located based on the entered database id or index
#UnknownField# if a sale is found but the field name is not recognized
“0” (zero) if the sale number parameter is blank
“0” (zero) if the sale and field are both found and the field is empty
The second option in the Manager window is for ODBC Access.
Enabling it allows the user to create an ODBC entry for the DataLog cache database.
It can be linked to other databases such as Arc GIS or set up to use Mail Merge functions with MS Word.
Excel Add-In (Previous Version – Archived Instructions)
The Excel Add-In for DataLog allows the user to retrieve DataLog sales data from within Excel.
This feature must be installed in Excel.
To do this, open Excel and click the File tab in the upper left corner of the window.
Next, click the Excel Options button at the bottom left of the window.
A dialog box opens to show numerous options.
1. Click on Add-Ins from the list to the left.
2. Locate the Manage section at the bottom of the box; ensure that Excel Add-ins is displayed.
3. Click Go.
Select UAAR DataLog Excel Integration and click Browse.
(NOTE: If the UAAR option is not listed, click the Automation… button and select it there first.)
Excel will assign an ID to the file; if one already exists, there will be an option to replace it
Once a DataLog template has been created in Excel, sale data can be transferred into the Excel spreadsheet using “d” or “i” numbers.
Here are two examples:
Template Designer Add-In. This option remains “under construction” and is currently undergoing evaluation.
User instructions will not be available until the tool has passed all preliminary testing.