Share
 
 

Data type information

This page describes the various data types used by InfoWorks WS Pro.

This information is particularly useful when you are importing or exporting CSV data.

Data Type Code Description

Text

This is a fixed length text field. The absolute maximum length is 255 characters. However, most fields will have a shorter maximum length. For example, object names are usually 30 or 32 characters. Descriptions are usually 80 characters.

To find the maximum size for a specific field, look in the Size column in the table on the appropriate Data Fields page.

Single or Double

All floating point numbers have this type. Every floating point number will have a precision assigned to it. Look in the Precision column in the table on the appropriate Data Fields page.

Boolean

Usually seen in the interface as a check box, but could be some other either/or combination such as True/False or Yes/No.
  • when exporting to CSV, True is exported as 1, False as 0
  • when importing from CSV, 1 y or Y will be interpreted as True, anything else is interpreted as False

(Short) Integer

Stores whole numbers, positive or negative

Memo

This is a variable length text field that can hold up to a maximum of approximately 64,000 characters. It is used for Notes and some other fields

Array

This can contain an array of values, or the data for a sub-object. The label in the user interface will display the type of array. The possible types are:
  • Value - contains an array of values of the specified data type
  • Structure or Structure Blob - contains an array of defining elements of a complex type. These are usually repeating doublet or triplet values. Common examples are rating curves, where paired flow and head values repeat, or demands where paired time and flow values repeat. On the appropriate Data Fields page you will see a sub-table listing the contents of the structure.

See the CSV File Formats topic for more information on how this data appears in a CSV file.

Date / Time

Dates and times are exported to CSV as a text string with the information in the format specified by the locale set on your computer.

Long Integer

Can hold larger numbers than the integer type.

GUID

This is a 16-byte binary number, which may be represented as a 32-byte hexadecimal character string, with or without hyphens and curly brackets.

Size Format Example

32

Standard

3F2504E04F8911D39A0C0305E82C3301

36

With hyphens

3F2504E0-4F89-11D3-9A0C-0305E82C3301

38

With hyphens and curly brackets

{3F2504E0-4F89-11D3-9A0C-0305E82C3301}

By default a GUID field will be exported as a Standard 32-byte hexadecimal character string.

Fake Indicates a virtual field in the user interface. This is used for complex data types, inferred values, or used to show a dialog. A field with this type cannot be set directly.
Parent topic: About networks

Related Information

Was this information helpful?