Date Formatting Options - XML Index Document Import Processor - Foundation 23.1 - Foundation 23.1 - Ready - OnBase - Essential - Premier - Standard - external - Essential - Standard - Premier

XML Index Document Import Processor

Platform
OnBase
Product
XML Index Document Import Processor
Release
Foundation 23.1
License
Essential
Standard
Premier

Set the date format options by specifying how the dates are displayed in the documents to be imported.

To set the date formatting options for a date Keyword Type:

  1. Select the date Keyword Type to format from the list of configured Keyword Types from the document field order.
  2. Click Format. The Date Format dialog box is displayed.
  3. Specify the following options in the Date Format dialog box:

    Option

    Description

    Order

    Specifies the order that the month, day, and year are displayed in the date value. M represents Month, D represents Day, and Y represents Year. The following are the available options:

    • MDY

    • DMY

    • YMD

    • M D, Y

    Note:

    The M D, Y order option is not supported for the Numeric month format option.

    Select the Locale Specific Date option to use your the locale of your operating system if your index file contains date values that cannot be described by any of the MDY options listed in the Order section.

    To use this option correctly, you must select the language from the Language drop-down list in the Language Settings section that correctly matches the language selected in the Regional Settings of your workstation.

    Note:

    When using the Locale Specific Date option with the Arabic Hijri calendar, you cannot use dates prior to the Gregorian date of 01/01/1902.

    Month Settings

    Specifies the format of the month displayed in the date value. The following are the available options:

    • Numeric: Select this option if the month is represented by a number (for example, January = 1). Select the Month Leading Zero option if the month value is always represented by two digits (for example, January = 01).

    • Three Letter Months: Select this option if the month is represented as an uppercase, three-letter abbreviation (for example, JAN, FEB, MAR).

    • Full Month: Select this option if the month is spelled out in its entirety (for example, January, February, March).

    General Settings

    Specifies format of the day, year, and how the date is separated in the date value. The following are the available options:

    • Separator: Enter the value used to separate Month, Day, and Year values. A forward slash (/) is commonly used as a date separator (for example, 01/01/2018). A space ( ) is also a valid separator value (for example, 01 01 2018).

    • Day Leading Zero: Select this option if days are represented by two digits where the digits 1 through 9 are preceded by zeros (for example, 01 = first day of the month).

    • Century: Select this option if the year value indicates the century. Dates that indicate a century are represented by four digits rather than two (for example, 1990 vs. 90).

    Language Settings

    Select the language from the Language drop-down list to select the language in which the date is written. When the correct language is selected, the processor can translate the value into a value it is able to recognize.

    Note:

    For some Japanese dates, a preprocessor must be used to translate the dates into OnBase-supported characters.

    If you are using the Locale Specific Date option in the Order section, the language selected must match the language selected in the Regional Settings of your workstation.

  4. Click Make Default to save your preferences as the default date format when adding additional date Keyword Types, if needed. The Confirmation Message dialog box is displayed.
    1. Click Yes to confirm your selected preferences as default.
      Note:

      The Language option is not saved as part of the default date format.

  5. Click Save.