SAP Knowledge Base Article - Public

3242433 - Receiving a 'Data quality' error, 'xx% of data doesn't match format' when entering a custom timestamp while importing data into Signavio Process Intelligence.

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/



TokenOutput
MonthM1 2 ... 11 12

MM01 02 ... 11 12
Day of MonthD1 2 ... 30 31

DD01 02 ... 30 31
YearYY70 71 ... 29 30

YYYY1970 1971 ... 2029 2030
HourH0 1 ... 22 23

HH00 01 ... 22 23

h1 2 ... 11 12

hh01 02 ... 11 12
Minutem0 1 ... 58 59

mm00 01 ... 58 59
Seconds0 1 ... 58 59

ss00 01 ... 58 59
Fractional SecondS0 1 ... 8 9

SS00 01 ... 98 99

SSS000 001 ... 998 999

SSSS ... SSSSSSSSS000[0..] 001[0..] ... 998[0..] 999[0..]
Time ZoneZ-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

SAP Signavio Process Intelligence all versions

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