fileCollectorAttribute

Forms: File Columns

The data columns present in the import file are defined here.

Form: File Column Details

FieldDescription
NameThe name of the column. The attribute will be referred by this name elsewhere in CenterView. This can contain any combination of letters and numbers, and the characters: '_'.
TypeThis can be one of:
LengthFor a String, the maximum length of the String. For an Integer, the maximum number of digits. Note that for a comma-separated file it is not necessary to set field sizes; only the field sizes of the fields in the stream that this collector will write to are important. Of course, for a file with fixed length records it is crucial to set the fields lengths correctly.
OrderThe order in which the attributes are placed. This must match the order of the fields in the files that will be read by this file collector.
DescriptionDescription of the file column.

Supported Date/Datetime Format Patterns

The following formats are available for use in Date and Datetime type fields:

Valid Date FormatsValid Datetime Formats
dd/MM/yy dd/MMM/yy dd/MM/yyyy dd/MMM/yyyy dd-MM-yy dd-MMM-yy dd-MM-yyyy dd-MMM-yyyy MM/dd/yy MMM/dd/yy MM/dd/yyyy MMM/dd/yyyy MM-dd-yy MMM-dd-yy MM-dd-yyyy MMM-dd-yyyy yyyyMMdddd/MM/yy HH:mm:ss dd/MMM/yy HH:mm:ss dd/MM/yyyy HH:mm:ss dd/MMM/yyyy HH:mm:ss dd-MM-yy HH:mm:ss dd-MMM-yy HH:mm:ss dd-MM-yyyy HH:mm:ss dd-MMM-yyyy HH:mm:ss MM/dd/yy HH:mm:ss MMM/dd/yy HH:mm:ss MM/dd/yyyy HH:mm:ss MMM/dd/yyyy HH:mm:ss MM-dd-yy HH:mm:ss MMM-dd-yy HH:mm:ss MM-dd-yyyy HH:mm:ss MMM-dd-yyyy HH:mm:ss yyyyMMdd.HHmmss

The symbols used in these formats are explained in the following table

SymbolMeaningPresentationExamples
yyearyear1996
Mmonth of yearmonthJul; 07
dday of monthnumber10
Hhour of day (0~23)number0
mminute of hournumber30
ssecond of minutenumber55

The number of letters used in the pattern determines the format.

  • Number: The minimum number of digits. Shorter numbers are zero-padded to this amount.
  • Year: Numeric presentation for the year field are handled specially. For example, if the count of 'y' is 2, the year should be displayed as the zero-based year of the century, which is two digits.
  • Month: 3 or over, use text, otherwise use number.

Supported TrueFalse Values

The following values are available in upper, lower and mixed cases for use in the TrueFalse type field:

Valid True ValuesValid False Values
true,yes,T,Y,1false,no,F,N,0

Form Icons

The form provides the standard form icons.

See Also