getting import error for date field

deesh · Post by **deesh** » Sun Oct 20, 2013 4:22 am

Hi,
I have getting below two warnings.

1.summary_file,0: Bad trailing quote character at field "Date"; looking for '34' but found 'r', at offset: 11

2.getting import error for the below field, for the field data type is date,size is 10 and using pipe delimeter as field delimeter.

date format :: 20121101

Please could any one help in this case

MYDAS,0: Field "BaseLine_Date" has import error and no default value; data: {2 0 1 2 1 1 0 1 | V}, at offset: 74

chulett · Post by **chulett** » Sun Oct 20, 2013 8:50 am

Post some input records and detail for us the settings you are using in the Sequential File stage.

ray.wurlod · Post by **ray.wurlod** » Sun Oct 20, 2013 11:21 am

Your default date format is ten characters (YYYY-MM-DD) but the dates in your data contain only eight characters (YYYYYMMDD). You need to adjust your metadata, specifically the format for that date column.

deesh · Post by **deesh** » Sun Oct 20, 2013 11:38 pm

Hi,

Input record format in sequencial file

Data type :: Date
Length ::10
record ex :: 20110101, 20120606 YYYYMMDD

field delimeter is ::: pipeline

I need to pass same value into output

pran.praveen · Post by **pran.praveen** » Mon Oct 21, 2013 2:59 am

Why don't you read it as char and transform it later in transformer.

chulett · Post by **chulett** » Mon Oct 21, 2013 7:09 am

deesh wrote:record ex :: 20110101, 20120606 YYYYMMDD

This is a complete and accurate example of a record from your file? It actually includes the "YYYYMMDD" part? You've also said the field delimiter is a 'pipeline' by which I assume you mean pipe or '|' and yet there is not such character in your example and it doesn't match either error.

ray.wurlod · Post by **ray.wurlod** » Mon Oct 21, 2013 3:22 pm

You still have to set the date format string in your metadata to "%yyyy%mm%dd" - you have provided no evidence that you have done so.