Excel Add In Manager (Export from DataLog to Excel)

  1. Home
  2. Knowledge Base
  3. DataLog
  4. Excel Add In Manager (Export from DataLog to Excel)

To access the Add-In Manager, click on Edit then on Manage Add-ins.

add

The Add-In Manager allows the user to enable three available add-ins: MS Excel Add-In, ODBC Access, and Template Designer.

*Note:
In DataLog versions prior to 5.0.4, the Excel Add-In Manager is only compatible with the 32 bit version of Excel.

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

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

add3

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.

add4

The third Excel add-in sample file is the Land Mix; an empty version is seen below.

add6

To import sale data, use a “d” or “i” number.

add7

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.

add8

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.

add9               add10

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.

add11

Select UAAR DataLog Excel Integration and click Browse.

add12

 

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

add13

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:

add14add15

Last is the 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.

add in manager n

 

Was this article helpful?

Related Articles