In some cases when importing, the date or date/time format in the source is not compatible with the target. The add-on allows administrators to create custom formats for CSV import and export to overcome the compatibility issue.
To create a custom pattern:
Navigate to Administration > TIBCO EBX® Data Exchange Add-on (New) > Reference data > Date time pattern.
Create a new record.
Choose the application type.
Enter the pattern.
See Date pattern reference for date pattern definitions and output information. See Time pattern reference for time pattern definitions and output information.
The table will not accept duplicates.
Select the pattern type.
Save and close.
A date pattern must adhere to the following:
It can only include the following characters: G, y, M, w, W, D, d, F, E, u
It can only include the following special characters surrounded with double quotes: space, /, -, |, :, ;
Any other characters must be surrounded with single quotes. For example: '#'
It cannot begin with the space character.
A date/time pattern can utilize the allowed characters for both the date and time patterns.
The following table provides a description of the date pattern parameters:
Symbol | Definition | Pattern/Output |
|---|---|---|
G | Era designator | GG/AD |
y | Year | yy/96 yyyy/1996 |
M | Month in year | MM/07 MMM/Jul MMMM/July |
W | Week in year | W/27 |
D | Day number in year | D/189 |
d | Day number in month | d/9 dd/09 |
F | Day of week in month | F/2 (2nd Wednesday in July) |
E | Day of week (name) | E, EE, or EEE/Tue EEEE/Tuesday EEEEE/T EEEEEE/Tu |
u | Day number in week | 1/Monday 2/Tuesday |
A date pattern must adhere to the following:
It can only include the following characters: a, H, k, K, h, m, s, S, z, Z, X
It can only include the following special characters surrounded with double quotes: space, /, -, |, :, ;
Any other characters must be surrounded with single quotes. For example: '#'
It cannot begin with the space character.
A date/time pattern can utilize the allowed characters for both the date and time patterns.
The following table provides a description of the time pattern parameters:
Symbol | Definition | Pattern/Output |
|---|---|---|
a | AM/PM designation | a/PM |
H | Hour in the day Hour in the day (0-23) | H/0 HH/00 |
k | Hour in the day (1-24) | k/24 kk/24 |
K | Hour in am/pm for 12 hour format (0-11) | K/0 KK/00 |
h | Hour in am/pm for 12 hour format (1-12) | h/7 hh/07 |
m | Hour in am/pm for 12 hour format (1-12) | m/4 mm/04 |
s | Second in the minute | s/3 ss/03 |
S | Second in the minute | S/2 SS/22 SSS/225 SSSS/2250 |
z | Timezone | z, zz, zzz/PST zzzz/Pacific Standard Time |
Z | Timezone offset in hours (RFC pattern) | -0800 |
X | Timezone offset in ISO format | -08; -0800; -08:00 |