You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Running cutplace 0.8.8, I'm trying to undertake basic validation of a CSV file.
Upon trying to validate the data, I see only the first error for a broken row the output.
customers_error.csv (R2C5): cannot accept field 'gender': value must not be empty
customers_error.csv (R3C5): cannot accept field 'gender': value must not be empty
customers_error.csv (R4C5): cannot accept field 'gender': value must not be empty
customers_error.csv (R5C3): cannot accept field 'first_name': value must not be empty
customers_error.csv (R6C3): cannot accept field 'first_name': value must not be empty
customers_error.csv (R7C1): cannot accept field 'customer_id': value must not be empty
customers_error.csv (R8C1): cannot accept field 'customer_id': value must not be empty
customers_error.csv (R9C1): cannot accept field 'customer_id': value must not be empty
customers_error.csv (R10C1): cannot accept field 'customer_id': value must not be empty
customers_error.csv (R11C1): cannot accept field 'customer_id': value must not be empty
Customer file has 15+ validation errors but only 10 errors are being displayed in the results and rest of the errors are missed out despite of using parameter on_error='yield'.
Please suggest.
The text was updated successfully, but these errors were encountered:
vishakhabhasin
changed the title
Cutplace not displaying all the errors on validation
Cutplace displaying only the first error in a broken row on validation
Apr 17, 2017
Running cutplace 0.8.8, I'm trying to undertake basic validation of a CSV file.
Upon trying to validate the data, I see only the first error for a broken row the output.
Code
Contents from CID file
,Property ,Value,,,,
D,Format,Delimited,,,,
D,Encoding,UTF-8,,,,
D,Header,1,,,,
D,Line delimiter,LF,,,,
D,Item delimiter,",",,,,
,,,,,,
,,,,,,
,Name,Example,Empty,Length,Type,Rule
F,customer_id,3798,,,Integer,0...99999
F,surname,Miller,,...60,,
F,first_name,John,,...60,,
F,date_of_birth,,,,DateTime,MM/DD/YYYY
F,gender,male,,,Choice,"female, male"
,,,,,,
,,,,,,
,Description,Type,Rule,,,
C,customer must be unique,IsUnique,customer_id,,,
Contents from Customer.csv
customer_id,surname,first_name,born,gender
1,Beck,Tyler,11/15/1995,
2,Gibson,Martin,8/18/1969,
3,Hopkins,Chester,12/19/1982,
4,Lopez,,10/13/1930,
5,123,,8/10/1943,hhhh
,Martin,,9/27/1932,male
,Knight,,5/25/1977,female
,Rose,Tammy,1/12/2004,female
,Gutierrez,,5/18/2010,male
,Phillips,,11/9/1960,female
Errors displayed
The text was updated successfully, but these errors were encountered: