1.0 - 4.0 Territory Data Extraction
In this section we describe how to manually extract Territory Data from EAutomate for upload into PIVOT
Steps for E-Automate Users
Exporting your device data from e-Automate will require a working understanding of e-Views. This document will guide you through the basic steps to getting your data ready for importing into PIVOT. All screen captures were created with e-View version 8.x thru 17.x, instructions may vary slightly based on your version.***
Prior to downloading files from e-Automate you will want to create a sub-folder in your My Document folder labeled Territories. This is where you will deposit all files downloaded from e-Automate
2.0 Creating Eview
From the e-Automate main application, launch e-Views by clicking on Tools – e-Views.
2. Click on MyViews or Favorites
3. Click on New to start a new view.
4. Create a Name for your new view. Example: “PIVOT Territory Export”
5. Create a Description for your new view. Example: “PIVOT Territory Export”
6. In the window named Based on: Select “Service Equipment Meters”
7. Using the column selection arrows circled below, select the following mandatory fields:
a. Active Equipment
b. Make
c. Model
d. Serial Number
e. Equipment Number
f. Street Address
g. City
h. State
i. Zip
j. Technician Number
k. Customer Name
l. Territory
m. Mo. Avg. (12mo.)
n. Meter Type
8. Save Template then reopen Template and select “Import New Column” icon
9. From the Import column screen select the magnifying glass in the Linked Views Window.
10. Scroll down and select "Service Equipment (Equipment)"
11. From the Service Equipment window, add the following fields to your e-View Un-Selected window. Once complete hit the Apply button then OK
a. Model Category
b. Model Category Desc.
c. Last Call Date
d. Last Meter Date
e. Contract Count Current - Note that once "Contract Count Current" is added to the Unselected columns window, the name will change to "Equipment Contract Count (Current)
12. Once you have added the 4 new columns to your Un-selected Columns field, use the arrow indicated below to add your new columns to the Selected Columns field (Left Window)
13. Using the up and down arrows, arrange the mandatory fields in the order previously listed on page 3 of this manual.
14. Select the Filters tab
15. Select the Sync with Columns button at the bottom of the e-View window.
16. Prior to completion of the Eview, verify that all the columns listed below are present in your Eview Export. All columns not listed below should be deleted from Eview.
17. Click OK to compete the e-View creation.
3.0 Report Filtering
From the primary e-View screen, Double-click the e-View titled “Pivot Territory Export”
17. Using the QuickSearch dropdown window, select Active Equipment
a. In the pop out window select equals
b. Click the Yes radio button
c. In the right drop down window select And
d. Select contains from the second drop down box
e. Beginning with the second row of your filter in the QuickSearch header select Meter type
f. In the description window type B\W and hit the Go button
4.0 Completed View
18. Save your search for future use, click the drop down arrow, click Save as.
19. Type the name of your new filter, this name will need to denote this filter is for black and white device meters.
a. This file will be saved in your Territory folder created earlier in section 1
20. Create the same filters for exporting of your color meters.
21. Using the QuickSearch dropdown window, select Active Equipment
a. In the pop out window select equals
b. Click the Yes radio button
c. In the right dropdown window select And
d. Select contains from the second drop down box
e. Beginning with the second row of your filter
in the QuickSearch header select Meter type
f. In the description window type Color and hit the Go button
22. Save your search for future use, click the drop down arrow, click Save as.
23. Type the name of your new filter, this name will need to denote this filter is for color device meters.
a. This file will be saved in your Territory folder created earlier in section 1
