Dictionary Creator

From Golden Retriever Wiki

Revision as of 20:18, 17 June 2020 by Jeff (talk | contribs) (→‎Classic)

Note: This page is under development and as such is not yet complete.

Dictionary Creator
Collection dictionaries are made by account administrators from the Admin Portal in the Dictionary Creator main menu item. Here you can create, view and edit what data is collected and how it is collected.

When you first navigate to the Dictionary Creator window you will see a drop-down menu which contains all of your collection dictionaries as well as an empty collection dictionary form. You can either start a new dictionary from scratch by typing in a name and adding new fields or modify an existing one by selecting it from the list. When you load an existing dictionary you will have both a Create Dictionary and an Update Dictionary button. The Create Dictionary works like save as and will create a new dictionary with whatever name you have entered in the Dictionary Nam box. Update Dictionary will save your changes to the existing dictionary.


Dictionary Settings

Dictionary Name

Each dictionary needs a name. It is suggested to name each dictionary with the customer name and year. Where multiple dictionaries are used for the same customer those line or circuit names can be used as well.

Sub Folder

Sub Folders are a great way to organize your collection dictionaries in the mobile app. This is optional and if not set here the dictionary will be shown in the main dictionary directory.

Dictionary Order

By default all dictionaries will be shown in the mobile app in alphabetical order. Normally this works but if you wish to specify the order manually the number you enter here will dictate the order shown when selecting a dictionary in the app.

Default Search Field

When searching online records the user has the option of which field to search. Any of the dictionary fields may be set as the default search field. To make things more efficient the most common search field can be set here (i.e. Pole Number).

Field for Device Map

In the [Databases Summary Page] it is possible to view on a map, the most recent record's GPS location for each device. By setting an inspector name instead of the id of the device, any change in phone/tablet will not effect this maps functionality.

Duplicate Records Allowed

By default saving changes as duplicate records is allowed. This is to avoid data loss due to editing mistakes. However, this does create more administration work later on to edit and consolidate these duplicates. By selecting this option no duplicates will be allowed by the mobile app for map markers once they turn from red to green. This is when working from a map of data supplied by the utility as this is location specific (Pole Number, etc makes no difference.

Photo Required

If a photo is required for every inspection record select this check-box to force a photo before the app will save a new record.



Dictionary Fields

Automatic Fields

Golden Retriever uses several fields for every dictionary which are automatically completed by the system. These fields are shown in the Database view. They are:

  • RecordNo - the record number assigned by the database when the record is uploaded
  • Latitude - the latitude of the GPS location
  • Longitude - the longitude of the GPS location
  • Date - An automatic timestamp when the record is saved in the mobile app
  • Device - The unique device id as supplied by the mobile device.

Customizing Dictionary

In addition to the basic fields, you can define as many other fields as you wish. These custom fields will all be placed after the automatic fields.

Add Field

To add a new dictionary field click on the green Add field here button at the location you wish to add the field.

Move Field

The fields will appear on the mobile app collection form according to the order they are in the Dictionary Creator. They can be moved by entering the desired position number in the box to the right of the green field box and clicking the Move button. The Dictionary Creator will automatically adjust all subsequent fields so there is no worry of overwriting a field.

Delete Field

To delete a field click on the red X by the field. You will be asked to confirm before deletion. Once this is done it is final; there is on 'undo' option.

Defining Fields

Field Types

First, select the field type from the drop-down list. The field types are grouped into categories. The available field types are:

Classic Fields
Comment

This is a text field which always defaults to a blank value. Instructions may be added which show up when entering a new record (on the mobile app). This text does not show up in the final data.

Picklist

A drop-down list of values for the user to select. Click the Add Picklist Option and type in the option as many times as necessary. Any unneeded picklist options may be delected by licking the red X to the right of the picklist option.

By default, the mobile app users may only select from the list. If desired you may allow custom entries by specifying a Length of Custom Entries value.

Text

This is one of the most common field types to use and while this is a 'simple text' field, there are several options available and some must be defined before your dictionary can be saved.

  • Default Value - You may set a default value here. As users are entering records, the previous value will be transferred to the new record unless the Force Default checkbox is selected.
  • Max Length - A maximum length must be set. A standard length length for text is 15 but can be shorter or longer. For a numeric field this number is how many characters are left of the decimal - the Number of Decimals Allowed setting will add to the maximum length.
  • Min Length - An optional minimum length may also be set here.
  • Max Value - A maximum value may be specified for numeric fields. For example, you may wish to disallow any pole year greater than the current year to minimize data entry errors.
  • Min Value - A minimum value may be specified for numeric fields. For example, you may wish to disallow any pole year older than 1940.
  • Number of Decimals Allowed - For numeric fields you may set the maximum number of decimals allowed. This is optional and may be left blank.
  • Alphanumeric - You can set this to All Characters (including special characters), Letters and Numbers, Numbers Only or Letters Only.
  • GPS Data - In addition to the default GPS fields which Golden Retriever automatically collects you may specify GPS coordinate fields for navigation. When defining these fields set this option to either longitude or latitude. Without defining this option Golden Retriever will not recognize this field as containing GPS coordinates and will not plot the pole locations on the navigation map.
  • Capitalize - When an Alphanumeric option containing letters has been selected you may choose to have Golden Retriever automatically capitalize either the first letter of each word or all letters. This avoids inconsistent data in the final data. This option is not shown when Numbers Only is the selected Alphanumeric option.
  • Increment - When you have selected Numbers Only as the Alphanumeric option you may set this number to increment up or increment down. This option is not shown when Numbers Only is not the selected Alphanumeric option.
  • Barcode Scanning - Select this option to enable barcode scanning as the input method for this field.
  • Make This A TimeStamp -
  • Always Locked - This prevents this field from being edited by the user.
Modern
Attachment
Date Picker

The Date Picker field will open up a calendar screen where the user can select a date. This is different from the automatic timestamp field for each record.

Picklist - Multiple Selection

A multiple-selection picklist allows for multiple choices. This is used for deficiency fields where you need to record multiple things if they exist. This data is stored in a text field similar to a notes field and can not be used for any show/hide rules.

Signature

The signature field allows for signature collection using the device's touchscreen. This is most useful when customizing a collection dictionary as for Tailgate safety meetings and for other administrative tasks. Due to crews being spread out it can be difficult to distribute forms to the crews and to receive the completed forms back. Golden Retriever can be used as a tool to aid in this by creating specific dictionaries.

Spacer

The spacer is not a data field but a horizontal line which is displayed in the mobile app to visually separate different categories of fields in the collection form. Use of this is completely voluntary.

Weather

When a user taps this field in the mobile app, while conducting the inspection, the current weather conditions will be recorded in the inspection record. Golden Retriever is also often used by vegetation control companies to record their herbicide mixing and application - in which weather plays a large role.

Calculator
RUS Deduction - RUS Tables
Strength Calc - ANSI Tables
Monitoring
Altered Data

This is a hidden field from the mobile app user and will record any changes made to the original utility supplied data (as seen by the app users in the map or online search function).

Custom GPS
Elevation

Elevation is a hidden field (hidden from the mobile app user) and is automatically populated during the inspection. It can be set to Metric (metres) or Imperial (feet).

Utility Pole

For convenience Golden Retriever has some predefined pick lists for common utility pole inspection fields.

Height
Class
Manufacturer
Species


Field Options

Once you have selected the field type, all of it's options will be displayed. Assign a name to it and complete any field options. Most fields have four basic options.

Required Field

If the required checkbox is selected, this field must be completed for the record to save.

Hidden Field

Is the field visible on the mobile app. Sometimes it makes sense to pass data through to the final reports without cluttering up the field user's screen.

Lock From Search

Not every field is very searchable so this can be used to de-clutter the search fields list

Force Default

Text and Single select Picklists can have default values assigned. If the Force Default is selected, whatever is in the default value box (can be left blank) is pre-populated in the collection form . Otherwise whatever has been entered in the previous record will copy to the new record - this is good for fields such as line or circuit number which do not change often.

Show/Hide Field

To keep collection forms easier to navigate hiding certain fields if unneeded can be beneficial. For example, different collection data is required for poles than for meters if both are being inspected. For this to work all possible combinations must be defined - if the picklist you are referencing has five different options then all five must be accounted for. When you are setting this up there is an option everything else which can be used to save time. Once the dictionary is saved this will be filled out long hand and show all combinations.

Note: Failure to account for all options will lead to inconsistent results.


Require Photo

Sometimes a photo is required only when a certain condition is met. This can be set here.

Upload Supplied Data

When asset location and other details are supplied by the utility this information can be uploaded into the collection dictionary to give a map of the assets to be inspected.

Note: the file must be a CSV (comma delimited and enclosed with double quotes), any coordinates must be in WGS84 format (EPSG:4326), and the column names must match the columns in the dictionary for them to be used by the program.

Assign Dictionary

For Administrators working with multiple Golden Retriever accounts you may assign/unassign collection dictionaries as needed. Select the checkbox beside the account(s) you wish to have access to the dictionary - both on mobile app and in the [Dictionary Summary] page of the Admin Portal.