Bug fix – There was a problem with photo handling when refreshing from web. Pictures from Word templates were not properly being removed.
Bug fix – With embedded comp sheets, there were problems when refreshing from web. Picture sizes shrank.
Bug fix – When a user initializes a folder from the Dashboard, the comps cart name was not saved correctly and did not appear in the "Refresh from Web" dialog.
Bug fix – There was an error when merging the photos in a dynamic comp sheet that prevented the operation from completing correctly.
Bug fix – In the Refresh from Web dialog, when dealing with a Subject property, the "border width" setting was not used and so pictures that were inserted did not have a border. This has been corrected so that the border width entered in the Refresh from Web dialog serves as the default border width. The default border width gets overridden when a user has defined in the Insert Manager a border width for a specific picture group.
Bug fix – In Word, when Excel tables were inserted into a Word document they were sometimes incorrectly sized.
Bug fix – In Excel, a problem has been fixed when the <<Leases and Surveys>> tag is included with the <<Comps Every Other>>, <<Comps Every Third>>, and <<Comps Every Fourth>> tags.
Bug Fix – In the Word Insert Manager, inserting Comp fields was not working. A Comp field is a field set up to display comparable (not the Subject) property data for a specific transaction type. For example, the field name “CompField_LS_1_PropertyName” will display the name of the comparable for land sale, and not just any land sale but the one for the first property in the Land Sales portion of the comps cart.
Bug fix – In Word, there were problems with refreshing Excel tables in Word. The problem, which has now been fixed, appeared when a sequence like the following was done: insert an Excel table in Word, edit the same table in Excel, refresh the table from Word.
Bug fix – In Word, the previewing of an Excel table in the Insert Manager was not being handled correctly and sometimes made it difficult to insert that table into Word, or to edit the original table in Excel and then refresh the table in Word. This problem has been fixed.
In Word, preserves photo sizes between multiple refresh
requests (either Refresh from Excel or Refresh from Web).
Adds <<MaxRows n>> tag
as Excel layout tag to allow arbitrarily long worksheets (otherwise, the
maximum number of rows is either 280 for the Subject worksheet or 150 for all
other worksheets).
Enhancements to Insert Manager: (1) tabbed dialog for easier
navigation; (2) enables setting rules for photo sizes for photo group tags; (3)
allow user filter fields by web page group; (4) allow users (in Word) to select
and insert more than one field at a time (Shift + Click for a set of contiguous
fields, Shift + Ctrl for a set of non-contiguous fields) (5) display preview of
Excel tables prior to inserting.
New fields added for multifamily properties: ability to
track property amenities which are unit amenities.
Bug fix to allow <<Use Comps n-m>> tag to be
used with <<Leases and Surveys>> tag.
Bug fix to address rounding of "Taxes Due".
Bug fix in Excel for password-protected VBA macros. When a
workbook with password-protected macros is closed, Excel displays a spurious VBAProject Password dialog box.
Bug fix in Word "Field Values" dialog when saving
a field formatted as percent. Data was correctly saved in database, however it
displayed incorrectly within Word.
Bug fix in the "Field Values" dialog in Word.
Allow changing data for property type-specific fields.
Bug fix for crashing bug when files are in a Sharepoint
folder.
Adds a building name field to multi-family unit mix database.
For multi-building properties, units can be assigned to different buildings. For
example, there can be a 1 BR / 1 BA for "Building 1" and 1 BR / 1 BA
for "Building 2".
Add support for UnitMixTag, RentRollTag, custom UnitMixTag
tables, and custom RentRollTag tables.
Bug fix for a crashing bug in the Insert Manager with
embedded comp sheets.
Bug fix for crashing bug with null pointer.
Bug fix to <<Comps Unit Mix>> tag in Excel
rentals worksheet, so that it works as expected.
Bug fix to crashing bug when refresh a specific table. When
Excel is not currently open, we notify user that a spreadsheet is going to be
opened.
For “Refresh from Web”, add the ability to cancel a merge
from either Word or Excel. This support is also provided in the “Send to Word”
and “Refresh from Excel” commands.
Enhanced the Insert Manager in Word to make it easier to
insert Word documents.
Bug fix in the Document Library that was converting document
names to all lower-case.
Enhance multi-display screen support. When a computer has
two (or more) display screens, eliminates the orphan windows that sometimes
appears when, for example, an Excel worksheet appears in one window and a
dialog box appears on a different display screen.
Enhance the “Refresh from Web” dialog box to display three
additional transaction types to be controlled (enabled or disabled) by the
user: land listings, sale listings, and lease listings.
Enhanced the Dashboard to show the name of the Word and
Excel templates that were used to initialize the appraisal directory.
Enhance support for the <<Comps Unit Mix>> tag
in Excel to allow unit-mix data from all transaction types to be brought into
Excel, including subject, improved listings, improved sales, cap rate, lease,
lease listings, surveys, and expense comps.
Document Library support enhanced so that you can now open
Excel documents from within Word. Prevent users from saving blank documents in
the document library. Enforce rules for the type of files that can be saved in
different Document Library folders, so that – for example – folders holding
Word templates will only accept Word files, and folders holding Excel templates
only accept Excel templates.
Bug fix to refresh the document list after any changes to
the contents of the Document Library.
Bug fix: Fix the “Merge Danger” problem that prevented
multiple Word files – and multiple Excel file—from being opened simultaneously.
Added a cache to speed up opening of Dashboard, Refresh from
Web, and access to the Web Document library.
Bug fix: Previously, long web photo tags has created a
problem. This is now fixed.
Bug fix: “Capture-and-Save” screen shot capturing now works
from Word.
Bug fix: Removed issues that kept unit mix fields being
available for unit mix in mixed use properties, and also in industrial storage,
and shopping center anchors.
Bug fix: Correct problem when formatting Excel tables in Microsoft
Word.
Bug fix: Enable percent sign to appear in various fields,
including OAR Actual.
Add ability for user to speed up Comps Merge by excluding
photographs from data download.
In dynamic files – Word documents that are inserted into a
main appraisal report based on the value of one or more data fields – enabled
smarter handling of property type, property sub-type, and property sub-sub-type.
When a more specialized document is missing, allow seamless replacement by
another document can replace it.
Fixed problems with mismatched photo tag names.
Added
better handling when changing from one user to another.
Performance
enhancements for loading of data into Word and Excel.
Bug
Fix: embedding Excel tables into Word sometimes causes errors.
Security
improvement: Added encryption to credential storage.
Bug
fix: users sometimes see "Error on connect to server" when the server
is available. Made it more reliable by adding built-in retries. Add support for
template testing with an "All Templates" option in the Dashboard.
(Ask Datappraise Support if you need this.)
Fixed a bug for Excel tables in Word. Sometimes the Excel table does not appear; instead the table name (with "emf" at the end of the name) appears in the Word document. This happens because we expect that Excel tables will be Word Bookmarks. In some places, a Word Field appears instead. This bug fix converts the Word Fields into Word Bookmarks, so that Excel tables appear in Word the way that you expect them to. (Say that five times fast!)
Fixed a bug in the [Copy to Word] and [Update from Excel] to make it more run more reliably. Along the way, made it run a little faster as well.
Added a "contains " button to the Datappraise Insert Manager (in Comps Merge).
Fixed a bug that caused a crash when Word and Excel were started at the same time.
Fixed a bug that prevented Excel tables from getting updated in Word. The link between Word and Excel is handled using Word bookmarks. Under some circumstances, extraneous book marks are created with names like OLE_LINK1, OLE_LINK2, etc. To find the correct bookmark, we ignore the extraneous bookmarks.
Added tool tips to the Datappraise Office toolbar menu items to provide a hint about the role of each toolbar button.
Updated handling of Tax Assessment Ratio to show two decimals of precisions with correct rounding of values (97.251 appears as 97.25%).
Fixed crashing bug when web browser not registered properly with the system. Add support for finding Internet Explorer and Chrome to use as browser when a browser cannot otherwise be found.
Fix bug that made it difficult to place photographs within Comp sheets. Photo tags can now appear anywhere in a Word Table. Removed the merging of table columns where there is one photo in a table with multiple columns.
Fix to prevent formatting of PropertyMasterKey, an important value that always needs to appear as an unformatted, numeric value.
Bug fix to correct the count of rental units for a merge.
Fixed a bug that caused some Datappraise Office toolbox window to be sized incorrectly because of Windows DPI Override setting.
Fixed a bug in navigation window in Excel.
Enable OFFLINE mode. This allows the use of Word and Excel when not connected to a network (on an airplane, for example). The basic feature set of Datappraise Office -- steps that do not require network access --remain available.
Add in support for photos in Lease Survey comp sheets.
Fix bug in error handling for ZIP file download error. More explicit error handling when report is not found. All message windows (350+) now display "Datappraise Office" to make it clear where the error message is coming from.
Add Checking for sufficient disk space prior to download of merge data files.
Upgrade Setup: ClickOnce installation tied to version-checking button on Datappraise toolbar. MSI installation also added for situations where ClickOnce does not work well (e.g. with some Citrix remote desktop installations).
Fixed a bug that incorrectly removed merge tags for on-the-fly documents if a specific document was not present.
Enabled use of formatting tags Comps Every Other, Comps Every Third, and Comps Every Fourth to be used with Surveys and Leases (in column mode).
Fixed a bug that prevented the Occupancy% tag from importing Subject and Comp Income/Expense occupancy data.
Datappraise Office installation files are now digitally signed. This measure enhances the security of your system; you can be sure that the installation have not been damaged or tampered.
A Screen Capture tool was added to Datappraise Office in both Word and Excel. This tool allows capturing an image from the screen -- for example, a map --and saving it directly to the subject property. You can then annotate the image to highlight any portion that you wish.
Access the Screen Capture tool from the Screen Cap button on the Datappraise menu bar. A small window appears in the upper right corner of the screen. Bring up the area of the screen you wish to capture, then click on the Camera icon. After you Click-and-drag the portion of the screen to be captured, click the Save icon. You are prompted to save the captured image directly to the subject property.
No changes. Customer install resolution update.
Options added to the Send to Word button in Excel. Can now send just the current worksheet, data only, or tables only.
Added two additional field lists to contribute to the construction of your On-The-Fly Docs. Added State, Land Only Appraisal and Tenancy to the field lists. Also added option to have document come from the community library.
No changes. Customer install resolution update.
Various improvements to the 'Save to Web' and 'Refresh from Web' functions in the Field Options tool.
Building Area Breakdown fields now supported in the Word document. From the Insert Manager, choose Comp Fields. From the comp field list, choose Area Breakdown. Then select the Comp Number in the list, corresponding to Building Number, and select the building field you would like to insert. In this way you can build a table showing any and all building characteristics for up to 9 buildings.
Number of Stories and Number of Copies can now be formatted as words in the Insert Manager in Word.
Switched rent rates in embedded comp sheets from showing 5 decimals to 2.
Fixed issue where lease rates were showing improper number of decimals. Example $13.00/sf was show as $13/sf.
Various minor fixes and performance enhancements.
Fixed bug where the header/footer fields would not refresh the first time Refresh from Web was executed. The headers and footers now update correctly.
Refinements made to Office 365 and Sharepoint server. Datappraise Office now auto-detects that the document is on a Sharepoint server, and automatically utilizes the local folder ("My Documents\ DatappraiseSharePointWorkFolder") to store the temporary data needed for the Refresh from Web process.
To use Sharepoint and Office 365, follow these steps:
1) In the Datappraise Dashboard, set the Master Folder to the local Datappraise default: My Documents/Appraisals/2013.
2) Use the Dashboard to Initialize the Work Folder in the usual way. A work folder will be created under the master folder, My Documents/Appraisals/2013.
3) Manually create a work folder up on the Sharepoint server. This folder can be named anything desired, and be located wherever desired up on the Sharepoint server.
4) Move the Word and Excel documents from the local work folder (just initialized in step 2) up to the folder created up on the Sharepoint server.
5) Delete the documents from the local Work Folder created by Datappraise in step 2. There is no need for these, as the working documents now reside on the Sharepoint server.
6) And you are done. You can now open your Word and Excel documents on the Sharepoint server, and Refresh from Web will work correctly. Your Word and Excel documents will be updated directly on the Sharepoint server during the Refresh from Web step.
Final note: It is imperative that you do not rename the documents that you have placed on the Sharepoint server. Leave the name that Datappraise assigned to them during the Initialize Folder step in the Dashboard. Datappraise names the local folder and the documents exactly the same during this step. Datappraise then assumes the name of the document on the Sharepoint server matches the local folder name created by the Initialize Folder process.
You can now save comp fields with the Field Options tool.