Field Types

User Fields

User fields are the fields that record values supplied by users or by data import from other sources. In a data entry form, a quick way to identify user fields is to look for boxes with a white background showing that they allow user data entry.

The following user field types are available:

Coordinate

You can add fields to entity types or link types to store coordinate data so that the geographic location of an entity or link can be plotted on a map using a GIS package or i2 Analyst's Notebook.

When you add a coordinate type field with two real number fields to make the combination for automatic conversion, the field order is important. The coordinate field must be followed by the latitude field and then the longitude field. The two Real Number fields are used to store the converted coordinate values.

When the user enters geographic data into the Coordinate field, a Coordinate Conversion utility converts the coordinates into decimal degrees, using the WGS 1984 datum (a global standard for plotting geographic locations).

Counting Number

Counting Number fields are used for whole numbers. For example, 656 and -100001 are valid entries.

Note: If a number has a fractional element, use Real Number or Currency field types.

Currency

A Currency field is used for financial values. A Currency field accepts either numbers or numbers with the Currency symbol from the current Regional Settings. The number can include a fractional part, expressed as decimals. This type of field stores numbers in a way that minimizes any errors during calculation and storage. If you analyze records that have different currencies, do one of the following:

• Include the currency in the field name, such as Amount in $, Amount in £ and do not enter the symbol when entering a currency amount.

• Hold currency information in two fields. A Currency field, called Amount to hold the number and a Text field called Currency to hold the currency symbol.

Note:

• You can set the currency symbol to one that is not the default for your current regional settings, for example, to Yen if you are using US English. When you do this, iBase no longer accepts any other currency symbols (including the default for your Regional Settings).

• There is no link to the currency in use when the data was entered. If you have users that work in different locales, you might want to convert all monetary values to a single currency before you enter them into the database record.

A Currency field can be up to 19 digits in length, 15 digits before the decimal point and 4 digits after it.

Note: Analyst's Notebook does not support values in decimal formats. When currency values are added to Analyst's Notebook charts, values will be converted to doubles, that is 15 digits in total, which may result in lower precision for your values.

Date

Date fields are used when entering dates.

You can specify a default value, or use a special value 'Today' which is the creation date of the record.

There are special field types for the system fields Create Date and Update Date.

Document

Document fields are used to embed documents in a record, such as charts, and files with extensions of: .doc, .docx, .xls, .xlsx, .ppt, .pptx, .txt, and .htm. The advantage of embedding a document is that users are no longer dependent on an external file system or a web server. An embedded document cannot be updated by any changes made to the external file, or by editing in iBase.

Embedded documents can be:

• Viewed in the Show or data entry dialogs

• Searched if Search 360 is available. (Searching documents is optional and requires that the appropriate iFilters are installed on the server.)

• Edited, provided that users have a suitable application for the file type. Users edit a temporary copy of the file; they cannot edit the document embedded in the record. To update the embedded document, users need to reload the edited document into the record.

Hyperlink (including owner hyperlinks)

Hyperlink fields are used to specify one or more locations to link to. A Hyperlink field consists of a series of text strings, with a maximum length of 65000 characters. Hyperlink fields cannot be indexed.

A special type of hyperlink field displays the name of the user who owns the record, and clicking on this type of field displays their contact details.

Hyperlink fields can contain:

A file

For example C:\My Documents\Person Report.doc, for a file on your computer or \\server/Shared/Person Report.doc for a file on a network.

A URL to the Internet or an intranet

The user can enter any valid URL and double-click on it to display it in their Web browser.

An entity or link record

This can be another entity or link record in the database. Each record is identified by a # character and the record identifier which is displayed in the Properties dialog of the other record.

For example, the record #PER156\GEN. This is record 156 of a PERSON entity type that has a database identifier of GEN. The user clicks the Browse button to display the Select dialog.

A user name

This is the name of the user who owns the record: either the user who created the record (their name is automatically inserted when the record is saved) or the user selected as the owner. To define the hyperlink field as an owner field rather than a general hyperlink field, use the dollar symbol ($) as the default value. Unformatted text, suitable for notes that require editing

Multi-Line Text

Multi-line Text fields are used for unformatted text, such as long unstructured notes that might require subsequent editing. These fields are displayed over several lines; the limit is 65535 characters (in English, this is typically between 10000 and 12000 words).

Note:

• Do not use Multi-line Text fields for information that you might want to sort in record lists.

• If you want to protect fields such that users cannot edit or delete them, use Multi-Line Text (Append only) fields.

• If users need to use large amounts of text, tables or graphics, or character formatting such as bold or italic, use Document or Hyperlink fields.

Multi-Line Text (Append Only)

Multi-line (Append Only) Text fields are used for unformatted text. They are similar to Multi-line Text fields except that users cannot edit or delete existing text; they can only append to it. This is useful if you need to store notes as an investigation progresses and you do not want to lose any of the existing information.

If you define a default value for this field, it always precedes any text that a user enters.

OLE Object

OLE Object fields are similar to Picture fields. This is a legacy type; they typically appear in iBase 3 databases that have been converted to a newer version of iBase. OLE Object fields are not supported in iBase 4 or later. They are read-only fields which you need to convert to appropriate field types.

To convert to appropriate field types:

1. Export all the data in the OLE fields that you want to keep.

2. Delete the OLE field type.

3. Import the data back in to fields that use either the Document or Picture types.

Picture

Picture fields are used for pictures in a record. If a Picture file contains a graphics file, this is displayed on Analyst's Notebook charts instead of the icon.

Note:

• There can be more than one picture field in a record, however only the first one that is defined can be displayed on an Analyst's Notebook chart instead of the icon.

• Picture fields cannot be indexed for searching in Full-Text search.

Real Number

Real Number fields are used for numbers that can include a fractional part, expressed as decimals. For example, 1234.56 and 0.005.

A Real Number field can hold a larger range of values than a Counting Number or Currency field. Currency fields offer greater accuracy within a smaller range.

Selected from Code list

Selected from Code List fields make a user select a value from a code list (drop-down list). For example, a grading system might use grades A to E, the code list therefore, would contain only the values A, B, C, D and E from which the user can select.

When editing a field, you can change a Selected from Code List field to a Suggested from Code List field and vice versa. This does not affect any existing records.

Note: This field type is only suitable for use with complete code lists. If you have an incomplete code list, you should consider using a Suggested from Code List field.

Strength

A Strength field defines the line style to be used for event frames in Analyst's Notebook charts.

When defining a Strength field, for a record in iBase you can choose one of the following strengths:

• Confirmed - solid line

• Unconfirmed - dashed line

• Tentative - dotted line

Note: You cannot add a Strength field to a link type, or as a standard field.

Suggested from Code List

Suggested from Code List fields allows a user to select a value, either suggested from a code list (drop-down list) or to enter any value. For example, you might supply a list of common car models, but allow the user to type in other models.

When editing a field, you can change a Selected from Code List field to a Suggested from Code List field and vice versa. This does not affect any existing records.

Note: Use this field type when the code list is not complete or definitive.

Text

Text fields are used for small amounts of plain text; these fields are limited to 255 characters. The default field size is 50 characters. You do not save space in a database by using a small field length, however the layout of the fields in dialogs or datasheets is best if limited to 100 characters.

Time

Time fields are used when entering times. You can specify a default value, or use a special value 'Now' which is the creation time of the record.

Time Zone

Time Zone fields can be used to specify the time zone of a record. They are used to provide a reference to dates and times when working with iBase data in Analyst's Notebook.

Note: If you want to import records containing time zones from external data sources, then you need to represent each time zone by the appropriate code. For example, in the import file, the time zone (GMT+00:00) Greenwich Mean Time: Edinburgh, London must be represented by 32. Also, when exporting data that contains time zones, the time zone will also be represented by a code.

The time zones and their codes are listed in Time zones in import and export.

Yes or No (Boolean)

Any data with two values: Yes or No, True or False. For example, if the Field Name is Glasses Worn, then the Field Type is Yes/No. The default value in iBase Designer is usually set to No. If users report that Yes/No fields are not populating correctly when importing data, they should check that the import file uses values that iBase recognizes as Yes or No. See Yes or No fields for more information.