DSXchange

Hello,

I am getting error in reading .csv file through a schema file.

Schema file is :-

record{record_delim_string='\r\n', delim=',', final_delim=end, quote=double}
(
BRANCH_ID:String[10];
CLIENT_ID:String[10];
NOTES:String[200];
PIN_DEVICE:String[3];
CP_ROUTE_NO:String[4];
)


Error :-

Copy_of_SYS,0: Input buffer overrun at field "NOTES", at offset: 292
Copy_of_SYS,0: Import warning at record 0.
Copy_of_SYS,0: Import unsuccessful at record 0.
Copy_of_SYS,0: Input buffer overrun at field "NOTES", at offset: 292
Copy_of_SYS,0: Import warning at record 1.
Copy_of_SYS,0: Import unsuccessful at record 1.
Copy_of_SYS,0: Input buffer overrun at field "NOTES", at offset: 292
Copy_of_SYS,0: Import warning at record 2.

so on.

Can any one plz help m eon this.

Your schema file does not describe your data file contents. You've defined all fixed-width strings. Are you sure you want to do that for a delimited file?

Mike

Thx Mike,

Could you please make changes as past back schema file.

Or here's a crazy thought - you could do it. Add "max=" before the size.

You might also like to check whether the file genuinely has DOS-style line terminators, as mentioned in the schema file.