Using File Lister

File Lister is a listing of all files created using Report and updated with corresponding orders in Track. File Lister provides a quick and easy way to view the order information for appraisal files. File Lister utilizes canned and user-defined View and Search Schemes to organize the displayed list.

Integration Options

Set the Report-to-Track integration options under Environment Options in the Report program. Integration options control updates to the Track database when saving and closing reports.

Setting Integration Options

  1. Open the Report program.
  2. Click Options > Environment > Integration.

Database
Update order database on close
Selecting this option automatically updates the Track database when closing a report. This option is selected by default.
Only if the report file has been modified
Selecting this option updates the Track database only when the report has been modified. This option is selected by default.
Always create an appraiser if one does not exist
Selecting this option automatically creates an appraiser record in Track if the appraiser is not found in the database.

If this option is deselected, the Report program prompts for adding the appraiser to the database when saving and closing reports. 

Always create client if one does not exist
Selecting this option automatically creates a client record in Track if the client is not found in the database.

If this option is deselected, the Report program prompts for adding the client to the database when saving and closing reports.

  1. Click OK to save any changes and exit Environment Options.

 

Using File Lister in Report

  1. Click File > File Lister, or click the File Lister icon, or press CTRL+SHIFT+O on the keyboard.
  2. Use the View and Search Schemes to filter the list (optional). Select a report and double-click it to open the file, or click Close to exit File Lister without opening a report.
Tip: Enter specific criteria, for example, Client File Number, in the Find field to locate a report. The Find criteria changes with the selected View Scheme

 

Opening Orders in Track

  1. Click File > Open Order, or click the Open Order icon, or press CTRL+O on the keyboard.
  2. Use the View and Search Schemes to filter the list (optional).
Tip: Enter specific criteria, for example, Client File Number, in the Find field to locate a report. The Find criteria changes with the selected View Scheme
  1. Double-click an order or click the Open icon.

 

Customizing View Schemes

View Schemes help organize the information in File Lister. Use View Schemes to create custom on-screen displays of fields in a specific order. Creating or modifying a View Scheme sorts the on-screen display without hiding or filtering data. File Lister includes preset View Schemes that can be modified.

  1. Click File > File Lister, or click the File Lister icon, or press CTRL+SHIFT+O on the keyboard.
  2. Click the Setup View Scheme icon to the right of the View menu.
  3. Select a View Scheme. By default, the last selected View Scheme is displayed
  4. Arrange fields in the Grid Field Order section. Select a field and drag it to the preferred location, or click the Up and Down arrows to move the selected field in the list.
  5. Select the Sort By method.

Index – Sorts using a pre-defined indexing method.
Fields – Sorts by selected grid fields.

  1. Click action.

OK – Applies View Scheme settings immediately (one-time view).
Cancel – Returns to the previous screen. Changes are not applied.
Defaults – Restores the default settings for the selected View Scheme.
Delete – Removes the selected View Scheme.
Save – Saves the current settings to the selected View Scheme name.
Save As – Saves the current settings as a new View Scheme.

Using ACI OpenHouse™

What is ACI OpenHouse™

ACI OpenHouse is a data-gathering and inspection tool that allows you to send a property survey questionnaire to the homeowner or other property contact and import their answers into your report. This gives you the freedom to conveniently accept participation from any respondent with internet access and import property facts and photos at will. No inspection app installation is required for you or property contact; simply run ACI WebUpdate once to add the ACI OpenHouse eService, and you’re ready to go. With OpenHouse, ACI will send a short property survey to the property contact’s email address and, when they tap the link on their internet-capable device, their browser will launch them into a simple Inspection interface – no special App required. Once they are done and tap “Submit,” an email with an Access Code will be sent to you, so you can retrieve the data into your report.

Getting Started

  1. Open or create a report that contains a Subject Property address.
  2. Click eServices > ACI OpenHouse > Property Survey Request

The ACI OpenHouse window appears, with two choices:

New Survey Request
Click New Survey Request to send the survey to the recipient’s email address.

Retrieve Survey Responses
Click Retrieve Survey Responses to import the survey information associated with that property.

New Survey Request

  1. When you click New Survey Request, ACI OpenHouse prompts you to confirm or edit the Subject Street Address. Click OK.
  2. Input the Property Contact’s Email (survey recipient) and Your Email. Click OK

Retrieve Survey Responses

When you click Retrieve Survey Responses, copy and paste the Access Code into the ACI OpenHouse dialog and click OK.

Tip: Importing data will overwrite/update fields that already have data or photos.

Managing your surveys and responses

Upon completing a survey, a respondent may continue to add information to their survey (for example, if you contact them to request an additional photo). They may click on the original survey link, or you may send them a new Request.

Workfile PDF
When surveys are submitted, a PDF summary of the questions, answers, and photos will be emailed to you.

Data Persistence
When surveys are created, the respondent has up to seven days to follow the link and Submit inspection data. If they do not perform this action before the seven days have elapsed, a New Survey Request will be required.

Once the survey has been created, no matter how many times it’s been updated and resubmitted, you have 10 days from the origination of the New Survey to import and save the data.

Data Available for Import
ACI OpenHouse provides the homeowner/property contact a series of survey questions, not all of which they may have the answer to. The survey can be submitted without all questions being answered (or photos being provided), so it is important to ensure you review all the responses and coordinate any additional follow-up or conversation directly with the contact. For the data available for input through the survey, the grid (and conditional items) is below.

ACI OpenHouse can be used for any ACI report, however full data mapping is supported in standard GSE/FHA forms. Other forms require some data input through the work file document.

How to Map a CSV File for ACI Analytics

  1. In a report, go to eServices > Import Analysis Data > ACI Analytics. 
  2. At the Subject tab, confirm the Subject’s information and characteristics or click Get Subject Data.
  3. Select File.
  4. Select the dropdown for MLS Provider Map and select Create New Map then New or Edit.
  5. At the New MLS Map window click Browse select your CSV file then click Load.
  6. Under Map Name, enter a name.
  7. After loading your CSV data it will appear under MLS Columns, clicking on each will display the corresponding data under MLS Column Data.
  8. From the MLS Columns list using the left arrow, match the appropriate MLS Column to the Mapped Columns.
  9. Once finished, click Save.

Please note: Not all the headers in the MLS Columns will match that of the ACI Columns. For instance, Sale Date and Sale Price may show as Closed Date and Closed price. Logic will be needed to try to interpret the information correctly. Also, not all of the fields that show in the MLS Columns will be available for use in the Mapped Columns.

Asterisks next to the ACI Column indicate a required field. Excluding required fields may cause discrepancies in your regression and histograms.

The MLS Map will be saved to C:\Program Files (x86)\Common Files\ACI\ESERVICES\Analytics\Maps.

Using ACI Analytics

What is ACI Analytics?

ACI Analytics is an eService for ACI Report™ to help you analyze market conditions, examine property characteristics, select comparables, and perform statistical analysis. The product is designed to be simple and easy to use. Analytics is structured in modules, so you have the flexibility to use only the sections that you feel comfortable with and that apply to your market. Best of all, ACI Analytics is included with an active ACI membership!

ACI Analytics is comprised of five modules:

  • The 1004MC
  • Market Analysis with Graphing
  • Comparable Selection and Map
  • Key Characteristic Histograms
  • Linear Regression Analysis (using individual components of value)

 

Getting Started

ACI Analytics can be launched right from ACI Report and is included with our Appraiser and Company Subscription Plans. To get started, create a new report and populate the subject’s address and basic information.

  1. In a report, go to eServices > Import Analysis Data > ACI Analytics. 
  2. At the Subject tab, confirm the Subject’s information and characteristics or click Get Subject Data.
  3. Select Listing Service or File.

Note: ACI Analytics includes two data source methods to import from. Users can select Listing Service or File.

  • DataTree® powers ACI’s Listing Service. The Listing Service will allow you to adjust your Data Range, Proximity, and GLA range.
  • Users can also import their MLS data via a CSV or txt file from their preferred MLS provider.  After selecting File, load your CSV file and select your MLS Provider Map*. Instructions on creating custom MLS provider map can be found here.
  1. At the Data tab, you’ll be presented with the data table where you can exclude properties from your analysis.
  2. Click Next through each module or navigate using the tabs at the top.
  3. The 1004MC module displays the inventory totals from your MLS data throughout the last two years. Select the Overall Trend dropdown to complete the 1004MC section; this will fill in the appropriate fields in your report.
  4. The Market Graphs module illustrates the items on the 1004MC. These graphs can be excluded by deselecting the checkbox to the upper left of the graph image. Hover over graph elements to see the figures that they represent. You also can edit the graph title and comment areas within this window.
  5. In the Comp Selection module,  hover your cursor over a map marker to display property details. You can also click to jump to the appropriate row in the data table. From the data table, you can filter by sales and listings; you can limit your observations to the most recent by adjusting the date (by default, this is set to the past six months) and set an address to Observation or designate it as a comp.
  6. In the Property Characteristics module, you’ll find histograms of each key characteristic of value. Here you have the same abilities on this graph page as the others, like deselecting the checkbox to exclude a graph, hovering on a point to reveal the values, and the ability to provide additional comments.
  7. In the Regression Analysis module, ACI Analytics provides simple linear regression where each variable is plotted separately on a scatterplot. These graphs will include all the data from your import, except what you chose to exclude from the analysis. The regression graphs display indicated model slope values and the model fit % (r2). Just like in the other charts, you can include whichever ones you’d like and provide comments on the individual components.
  8. When you’re ready to import to ACI Report, click Import into ACI.

 

Custom MLS Service Provider Map

ACI Analytics includes maps from the majority of significant MLS providers, however, there may be instances where users need to create a custom map for importing from their chosen MLS provider. Please follow these instructions to set up your custom map.

 

Using ACI Sky™ Flood

ACI Sky™ Flood is a service provided by ACI that integrates directly with FEMA and allows you to generate flood determination for the subject property and import the property’s census tract information directly into a report. An active Sky Flood license or Appraiser Subscription is required.

 

Setting Default Map Providers

Selecting a default provider for location maps enables the toolbar icon to launch ACI Sky Maps with one click.

  1. Click Options > Environment> Mapping.
  2. Select Sky Flood from the Create Flood Maps Using drop-down list.
  3. Click OK to save the selection.

Setting Default Map Settings

You can set default map settings for flood maps.

  1. Click eServices > Options.
  2. Click on Mapping and select Sky Flood.
  3. Select your default settings and click OK to save the selection.

Generating a Flood Map

  1. You can generate a new location map in three ways
    • Click Tools > Mapping > Sky Flood
    • Click eServices > Flood Maps > Sky Flood
    • Click on the Flood Map icon on the toolbar.
  1. If prompted, enter the Web Product Permission Password (Company Password) and click OK.
  2. At the Flood Map screen, ACI will automatically adjust the map to fit your Subject. Hover your mouse over the Subject to make adjustments.
  3. After making ANY adjustment click Update Flood Determination.
  4. Click Accept Map to save the map to the current report.
  5. At the Import screen, select the Flood Map page and then OK to import the map.