Skip to content

Edit a Template

Edit a Template

To edit a template:

  1. Click Templates in the left navigation pane.
  2. Find the template you want to copy:
    • Search by template name or description.
    • Filter templates by partner, RCX process, status, or the user who last updated the template.
  3. Click the Edit icon () in the Actions column, or click the template name and then click Edit in the upper right corner. The Template Configuration pane opens.

  4. Change the Template Properties as needed. Required fields have an asterisk (*).

    Template Field Definitions
    Name *
    The name for the template. Max length: 100 characters.
    RCX Process *

    FeedXChange supports the following types of processing within RCX:

    Process Name Description
    Activity Enables processing of bulk accruals (such as partner accrual feeds) and redemptions (such as point transfers or other expenditures coming from external sources)
    Enrollments Enables processing bulk enrollments of new members with optional duplicate matching by combinations of fields
    Member Segments Enables bulk assignment of segments to members based on external segmentation sources
    Member Preferences Enables bulk setting of member preferences and member-level loyalty feature flags
    LoyaltyID Enables adding the loyalty ID to the members.
    Profile Update Enables updating member profile data

    Note

    Any process based on RCX member activity can autoenroll the member with only their loyalty id and receive profile updates as they become available.

    Partner *
    The partner to which the template belongs.
    Description
    An optional description of the template. Max length: 255 characters.

  5. Click the Input File or Response File tab. The Input File Properties or Response File Properties pane opens. Required fields have an asterisk (*).

    Input File Field Definitions
    Format *

    Fixed or Delimited.

    • Fixed file: Uses a specific width for each field. Every record has the same length, and data is aligned in fixed positions. No delimiters are used.
    • Delimited file: Uses a specific character (like a comma, tab, or pipe) to separate fields. Field lengths can vary, and the delimiter indicates where each field starts and ends.
    Delimiter *

    Character to use as the field delimiter, such as a comma. Required if Format is Delimited.

    Tip

    To specify the tab character as the delimiter, use another application, such as Notepad or Word, to press the Tab key. Then, copy and paste the tab character into the Delimiter field.

    Quote Strings
    The character used to indicated quotes. Options are single quote ('), double quote ("), or none.
    Header *
    Indicates whether the file has a header row. If yes, the Header tab enables you to configure each column of the header row.
    Header Regex
    The optional regular expression used to identify and validate the entire header row to enforce structure, delimiters, and character rules as needed.
    Body *
    Indicates whether the file has one or more body rows. If yes, the Body tab enables you to configure each column of the body rows.
    Body Regex
    The optional regular expression used to identify and validate the body rows to enforce structure, delimiters, and character rules as needed.
    Footer *
    Indicates whether the file has a footer row. If yes, the Footer tab enables you to configure each column of the footer row.
    Footer Regex
    The optional regular expression used to identify and validate the entire footer row to enforce structure, delimiters, and character rules as needed.
    Response File Field Definitions
    Format

    Fixed or Delimited.

    • Fixed file: Uses a consistent width for each field. Every record has the same length, and data is aligned in fixed positions. No delimiters are used.
    • Delimited file: Uses a specific character (like a comma, tab, or pipe) to separate fields. Field lengths can vary, and the delimiter indicates where each field starts and ends.
    Delimiter

    Character to use as the field delimiter, such as a comma. Required if Format is Delimited.

    Tip

    To specify the tab character as the delimiter, use another application, such as Notepad or Word, to press the Tab key. Then, copy and paste the tab character into the Delimiter field.

    Quote Strings
    The character used to indicated quotes.
    Generate Header
    Indicates whether FeedXChange generates the response file with a header row. If yes, the Header tab enables you to specify the format for each column of the header row.
    Generate Body
    Indicates whether FeedXChange generates the response file with one or more body rows, usually Yes. If yes, the Body tab enables you to specify the format for each column of the body rows.
    Generate Footer
    Indicates whether FeedXChange generates the response file with a footer row. If yes, the Footer tab enables you to identify the format for each column of the footer row.

    Template editor showing the example PAWs Resorts Activity configuration. The main section displays fields for template properties including name, RCX process, partner, and description. The left pane highlights Input File and Response File tabs with an orange border. Buttons for Test File, Validate, Save, and Publish are at the top right.

  6. Click the Header, Body, and Footer tabs as needed to change the field values. Required fields have an asterisk (*).

    Header Field Definitions
    Field Name *
    The name of the header column. Must be unique within the Header. Max length: 50 characters.
    Fixed Length *
    For files whose Format is Fixed, the number of characters expected in the field. This value informs FeedXChange where one field ends and the next begins. Refer to Input File Properties.
    Data Type *
    The data type of the header field. For headers, this is often a string. Options are: Boolean, Date, Number, or String.
    Format
    An optional regular expression to validate the header text when the data type is string.
    Date Format *

    The format for a date field.

    Date Format Options
    • YYYY-MM-DD HH:mm:ss.SSS (such as 2025-01-31 08:30:00.250)
    • YYYY-MM-DDTHH:mm:ss.SSS (such as 2025-01-31T08:30:00.250)
    • YYYY-MM-DDTHH:mm:ss.SSS±HH:mm (such as 2025-01-31T08:30:00.250±12:30)
    • YYYY-MM-DDTHH:mm:ss.SSS±HHmm (such as 2025-01-31T08:30:00.250±1230)
    • YYYY-MM-DDTHH:mm:ss.SSSZ (such as 2025-01-31T08:30:00.250Z)
    Date Format Variables

    To see this list of variables in FeedXChange, click the ⓘ icon.

    • DD - Numeric day of the month (ex. 01, 02, 03, 04)
    • dd - Abbreviated day of the week (ex. Mon, Tue, Wed)
    • EEEEE - Day of the week (ex. Monday, Tuesday, Wednesday)
    • HH - Hour, 2 digits in 24 hour clock (ex. 01, 02, 03)
    • hh - Hour, 2 digits in 12 hour clock (ex. 01, 02, 03)
    • MMM - Abbreviated month (ex. Jan, Feb, Mar)
    • MMMMM - Month (ex. January, February, March )
    • MM - Numeric month(ex. 01,02,03,04)
    • mm - Abbreviated minutes (ex. 01, 02, 03)
    • SS - Second, 2 digits in 24 hours (ex. 01, 02, 03)
    • ss - Second, 2 digits in 12 hours (ex. 01, 02, 03)
    • a - Meridiem indicator (ex. AM, PM)
    • YYYY - Week year, or the year the week falls into (ex. 2023,2024,2025)
    • yyyy - Calendar year (ex. 2023, 2024, 2025)
    Number of decimals *
    For number fields, indicate the number of decimal places.
    Required *

    Indicates whether to require the header field in the header row for each file.

    Example

    For a header row in which the Date field is required but other fields aren't:

    A text editor displaying a sample delimited data file for FeedXChange. The file contains a header row with the column name Date followed by several commas, and body rows with date-time values, test IDs, long numeric values, POS, and AddPoints fields. The environment is a dark-themed editor with torn edges at the top and bottom, suggesting a cropped view.
    Figure 1. This test file is OK

    A dark-themed text editor displays a sample delimited data file for FeedXChange. The primary subject is a body row containing date-time values, test IDs, long numeric values, POS, and AddPoints fields. The file lacks the Date field in the header row, which is required for correct configuration.
    Figure 2. This test file results in an error

    Default value
    The optional default value for the header field. For headers, this is often omitted.
    Minimum Length *
    The minimum length (in characters) of the header field.
    Maximum Length *
    The maximum length (in characters) of the header field.
    Comments
    Any comment that might help users working with the template.
    Body Field Definitions
    Field Name *
    The name of the field. Must be unique within the Body. Max length: 50 characters.
    Fixed Length *
    For files whose Format is Fixed, the number of characters expected in the field. This value informs FeedXChange where one field ends and the next begins. Refer to Input File Properties.
    Fixed Array Length *
    The number of elements to be parsed from the file. Refer to Configure Array Fields.
    RCX Field
    The name of the field in ReactorCX that the Field Name maps to. If not provided, the field data isn't imported into RCX.
    Data Type *
    The data type of the field. Options are:
    • Boolean
    • Date
    • Number
    • String
    Format
    An optional regular expression to validate the field value in the file when the data type is string.
    Date Format *

    The format for a date field.

    Date Format Options
    • YYYY-MM-DD HH:mm:ss.SSS (such as 2025-01-31 08:30:00.250)
    • YYYY-MM-DDTHH:mm:ss.SSS (such as 2025-01-31T08:30:00.250)
    • YYYY-MM-DDTHH:mm:ss.SSS±HH:mm (such as 2025-01-31T08:30:00.250±12:30)
    • YYYY-MM-DDTHH:mm:ss.SSS±HHmm (such as 2025-01-31T08:30:00.250±1230)
    • YYYY-MM-DDTHH:mm:ss.SSSZ (such as 2025-01-31T08:30:00.250Z)
    Date Format Variables

    To see this list of variables in FeedXChange, click the ⓘ icon.

    • DD - Numeric day of the month (ex. 01, 02, 03, 04)
    • dd - Abbreviated day of the week (ex. Mon, Tue, Wed)
    • EEEEE - Day of the week (ex. Monday, Tuesday, Wednesday)
    • HH - Hour, 2 digits in 24 hour clock (ex. 01, 02, 03)
    • hh - Hour, 2 digits in 12 hour clock (ex. 01, 02, 03)
    • MMM - Abbreviated month (ex. Jan, Feb, Mar)
    • MMMMM - Month (ex. January, February, March )
    • MM - Numeric month(ex. 01,02,03,04)
    • mm - Abbreviated minutes (ex. 01, 02, 03)
    • SS - Second, 2 digits in 24 hours (ex. 01, 02, 03)
    • ss - Second, 2 digits in 12 hours (ex. 01, 02, 03)
    • a - Meridiem indicator (ex. AM, PM)
    • YYYY - Week year, or the year the week falls into (ex. 2023,2024,2025)
    • yyyy - Calendar year (ex. 2023, 2024, 2025)
    Number of decimals *
    For number fields, indicate the number of decimal places.
    Required *
    Indicates whether the field is required.
    From File *
    Indicates whether the data for a field is coming from the input file.
    Default Value
    The default value for the field, if any. If From File is No, the Default Value can't be empty.
    Minimum Length *
    For strings, the minimum length of the field. This must be less than or equal to the Maximum Length value.
    Maximum Length *

    For strings, the maximum length of the field. This must be greater than or equal to the Minimum Length value. If the input file format is Fixed, this must be less than or equal to the Fixed Length value.

    Note

    For Fixed file formats, after trimming spaces, the value is validated against the configured minimum and maximum length.

    Minimum Value *
    For numbers, the minimum value of the field.
    Maximum Value *
    For numbers, the maximum value of the field.
    Editable *
    Not yet implemented.
    Auto-Fixable *
    Not yet implemented.
    UUID *
    For string fields, indicates whether this item is a Universally Unique Identifier (UUID).
    SysDate
    For date fields left blank in the input file, FeedXChange can use the system date while processing the file. The system date is the current date in UTC.
    Unique Key Flag *
    Not yet implemented.
    Transform
    Optionally specifies a transform function to be used on that field. The options available depend on the selected Data Type. Refer to Configure Transforms.
    Transform Expression
    A custom expression or formula to apply transformations to the field value.
    Comments
    Further description of the field and any additional information.
    Footer Field Definitions
    Field Name *
    The name of the footer column. Must be unique within the footer. Max length: 50 characters.
    Fixed Length *
    For files whose Format is Fixed, the number of characters expected in the field. This value informs FeedXChange where one field ends and the next begins. Refer to Input File Properties.
    Data Type *
    The data type of the footer field. Options are:
    • Boolean
    • Date
    • Number
    • String
    Format
    An optional regular expression to validate the footer text when the data type is string.
    Date Format *

    The format for a date field.

    Date Format Options
    • YYYY-MM-DD HH:mm:ss.SSS (such as 2025-01-31 08:30:00.250)
    • YYYY-MM-DDTHH:mm:ss.SSS (such as 2025-01-31T08:30:00.250)
    • YYYY-MM-DDTHH:mm:ss.SSS±HH:mm (such as 2025-01-31T08:30:00.250±12:30)
    • YYYY-MM-DDTHH:mm:ss.SSS±HHmm (such as 2025-01-31T08:30:00.250±1230)
    • YYYY-MM-DDTHH:mm:ss.SSSZ (such as 2025-01-31T08:30:00.250Z)
    Date Format Variables

    To see this list of variables in FeedXChange, click the ⓘ icon.

    • DD - Numeric day of the month (ex. 01, 02, 03, 04)
    • dd - Abbreviated day of the week (ex. Mon, Tue, Wed)
    • EEEEE - Day of the week (ex. Monday, Tuesday, Wednesday)
    • HH - Hour, 2 digits in 24 hour clock (ex. 01, 02, 03)
    • hh - Hour, 2 digits in 12 hour clock (ex. 01, 02, 03)
    • MMM - Abbreviated month (ex. Jan, Feb, Mar)
    • MMMMM - Month (ex. January, February, March )
    • MM - Numeric month(ex. 01,02,03,04)
    • mm - Abbreviated minutes (ex. 01, 02, 03)
    • SS - Second, 2 digits in 24 hours (ex. 01, 02, 03)
    • ss - Second, 2 digits in 12 hours (ex. 01, 02, 03)
    • a - Meridiem indicator (ex. AM, PM)
    • YYYY - Week year, or the year the week falls into (ex. 2023,2024,2025)
    • yyyy - Calendar year (ex. 2023, 2024, 2025)
    Number of decimals *
    For number fields, indicate the number of decimal places.
    Required *
    Indicates whether the field is required in the footer for each file.
    Default value
    The default value for the footer field.
    Minimum Length *
    The minimum length (in characters) of the footer field.
    Maximum Length *
    The maximum length (in characters) of the footer field.
    Comments
    Any comment that might help users working with the template.
    • To add a field, click + Add at the bottom of the list.
    • To configure a field, click the field to make it active. You can then edit the field properties in the detail pane.
    • To remove a field, click the delete icon ().
    • To copy a field, click the copy icon ().

    • To move a field up or down, drag and drop the field using the gray dot handle ().

      Important

      If the file's Format is Delimited, the order the fields appear in the list must match the order they appear in the input file.

  7. Test the template with a sample input file. Before you publish the template, it's a good practice to test it.

  8. Click Save in the upper right corner.

See also: