Symptom
Receiving a 'Data quality' error, 'xx% of data doesn't match format' when entering a custom timestamp while importing data into Signavio Process Intelligence.
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Resolution
Please hover over the icon to get more information on supported timestamps and check the time format is correct for your data.
Additional information, we currently only support a subset of the moment.js pattern
REF: https://momentjs.com/docs/#/parsing/
Token | Output | |
---|---|---|
Month | M | 1 2 ... 11 12 |
MM | 01 02 ... 11 12 | |
Day of Month | D | 1 2 ... 30 31 |
DD | 01 02 ... 30 31 | |
Year | YY | 70 71 ... 29 30 |
YYYY | 1970 1971 ... 2029 2030 | |
Hour | H | 0 1 ... 22 23 |
HH | 00 01 ... 22 23 | |
h | 1 2 ... 11 12 | |
hh | 01 02 ... 11 12 | |
Minute | m | 0 1 ... 58 59 |
mm | 00 01 ... 58 59 | |
Second | s | 0 1 ... 58 59 |
ss | 00 01 ... 58 59 | |
Fractional Second | S | 0 1 ... 8 9 |
SS | 00 01 ... 98 99 | |
SSS | 000 001 ... 998 999 | |
SSSS ... SSSSSSSSS | 000[0..] 001[0..] ... 998[0..] 999[0..] | |
Time Zone | Z | -07:00 -06:00 ... +06:00 +07:00 |
ZZ | -0700 -0600 ... +0600 +0700 |
* Additionally all characters, matched by the following regex are allowed: [^a-zA-Z\[\]]
Keywords
KBA , BPI-SIG-PI-DI , Data Import for SAP Signavio Process Intelligence , How To
Product
Attachments
image2020-8-6_16-36-31.png |
image2020-8-6_16-37-37.png |
image2020-8-6_17-10-0.png |
image2020-8-6_17-8-38.png |