Home
Administrator Guides
Administrator Guide
Introduction to character encodings
This section provides information on character encodings and language-sensitive database considerations, and lists the encodings supported by Unica Campaign.
Date and time formats
Formats for DateOutputFormatString and DateTimeOutputFormatString

Administrator Guides
- Administrator Guide
  - Unica Campaign administration overview
    The Settings menu provides access to most of the tasks that Unica Campaign administrators typically perform.
  - Security in Unica Campaign
    Security policies control user access to the objects and features in Unica Campaign.
  - Database table administration
    Unica Campaign administrators must perform initial one-time tasks and routine administration tasks that pertain to database tables.
  - Customizing campaigns
    Administrators can customize campaigns by using custom campaign attributes, initiatives, and products.
  - Offer template concepts
    Before administrators perform offer template management tasks, there are several important concepts to understand.
  - About audience level administration
    Unica Campaign is delivered with a single audience level called Customer. You can define any additional audience levels that you need. Audience levels let flowchart designers target specific groups, such as Households, in marketing campaigns.
  - Before you begin working with contact history
    Contact history is stored in the Unica Campaign system database in separate tables by audience level. Therefore, you need to set up audience levels before you begin working with contact history.
  - Response history administration
    Before you begin working with response history, you should read the audience level administration topics and set up required audience levels.
  - Monitoring and controlling flowchart runs
    Choose Campaign > Monitoring and use the All monitored runs page to view the status of all active flowcharts and suspend, resume, or stop flowchart runs.
  - Dimension hierarchy concepts
    A dimension hierarchy is a data construct that groups data into bins based on value ranges. Dimension hierarchies are the basis for a variety of reports.
  - Triggers administration
    Unica Campaign allows you to define inbound and outbound triggers that can be used in all flowcharts in a partition.
  - Unica Campaign log files
    Unica Campaign records information in several different log files.
  - JVM Parameters
  - About codes in Unica Campaign
    Each campaign, cell, offer, and treatment in Unica Campaign has an identifying code that is generated by code generators, and conforms to a specified format.
  - Accessing the Advanced settings
    When a flowchart is open for editing, administrators can choose the Advanced settings option on the Admin menu to make administrative changes that affect only the current flowchart.
  - Unica Campaign integration with other products
    Unica Campaign optionally integrates with a number of other products.
  - Unica Campaign listeners
    The listener is a key component of Unica Campaign. It provides an interface between front-end clients and back-end analytical server processes.
  - Unica Campaign utilities
    Administrators use the Unica Campaign utilities to manage listeners, sessions, and flowcharts, and perform other important administrative tasks.
  - Configuring the ACOOptAdmin tool
    Configure the ACOOptAdmin tool to run Unica Optimize sessions from the command line.
  - Non-ASCII data in Unica Campaign
    Unica Campaign supports the use of localized data and non-United States locales, including multiple user-preferred locales within the same installation of the application.
  - Configuration properties for Unica Campaign
    The configuration properties of Unica Campaign are located at SettingsConfiguration. For more details on the configuration properties, see the Campaign Administrator Guide.
  - About special characters
    Some special characters are not supported in any Unica Campaign object names. In addition, some objects have specific naming restrictions.
  - Introduction to character encodings
    This section provides information on character encodings and language-sensitive database considerations, and lists the encodings supported by Unica Campaign.
    - Character encodings in Campaign
      Unica Campaign supports the character encodings that are described in this topic.
    - Date and time formats
      - Formats for DateFormat and DateTimeFormat
        If you are not configuring Unica Campaign for multiple locales, you can set the values for DateFormat and DateTimeFormatconfiguration parameters for any of the formats specified in the DATE macro, as described in this section.
      - Formats for DateOutputFormatString and DateTimeOutputFormatString
  - About Unica Campaign Error Codes
    Unica Campaign notifies users of error events when they occur with error messages that consist of a code number and error text.
  - Troubleshooting
- System Tables

Formats for DateOutputFormatString and DateTimeOutputFormatString

If you are not configuring Unica Campaign for multiple locales, you can set the values for DateOutputFormat and DateTimeOutputFormatconfiguration parameters for any of the formats specified specified for format_str in the DATE_FORMAT macro, as shown in the following table.

However, if you need to configureUnica Campaign for multiple locales (that is, if you have users with various languages and locales), DO NOT use date formats that contain 3-letter months (MMM), %b (abbreviated month name), or %B (full month name). Instead, you should use one of the delimited or fixed formats that have a numeric value for the month. For more details about the multi-locale feature, see About the multi-locale feature.

%a - Abbreviated weekday name

%A - Full weekday name

%b - Abbreviated month name

%B - Full month name

%c - Date and time representation appropriate for locale

%d - Day of month (01 - 31)

%H - Hour in 24-hour format (00 - 23)

%I - Hour in 12-hour format (01 - 12)

%j - Day of year (001 - 366)

%m - Month number (01 - 12)

%M - Minute (00 - 59)

%p - Current locale's AM/PM indicator for 12-hour clock

%S - Second (00 - 59)

%U - Week of year, with Sunday as first day of week (00 - 51)

%w - Weekday (0 - 6; Sunday is 0)

%W - Week of year, with Monday as first day of week (00 - 51)

%x - Date representation for current locale

%X - Time representation for current locale

%y - 2-digit year (00 - 99)

%Y - 4-digit year

%z, %Z - Time zone name or abbreviation; no output if time zone is unknown

%% - Percent sign

Note: Characters that are part of the format and are not preceded by a percent sign (%) are copied unchanged to the output string. The formatted string must fit in 16 bytes or less.Use the # character to eliminate any leading 0. For example, %d produces 2-digit numbers in the range (01 - 31), while %#d produces 1- or 2-digit numbers as appropriate (1 - 31). Similarly, %m gives (01 - 12) while %#m gives (1 - 12).

Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.