Error when import csv file

klum
klum Member Posts: 102
edited 2008-03-12 in NAV/Navision Classic Client
Hi All,

Anybody have seen this error before "The length of the source exceeds the size of destination buffer"

I am working on NAV5.0 W1 and I use dataport from sales price table with customzied option field called "Hotel Cust. Price". There are 7 options ( ,Agent,Wholesales,Wholesales Plus,Wholesales extra plus,Walk in,Wholesales Plus for AWD)

I would like to import csv file with some fields including "Hotel Cust. Price" Field which have only one option is "Wholesales Plus for AWD" in this file.

Can anybody explain that why this error appear when import? and how i can fix this error?

Thanks in advance

Wanwisa

Comments

  • kriki
    kriki Member, Moderator Posts: 9,121
    In means you have some text or code field in the file that is larger than the field in the dataport.
    You can also get the error when there is something wrong in the file. Eg. if you use comma-separated, you have some field with a comma in it and the Navision dataport considers it as a field-divider. The best is to use TAB-separated fields. With in the dataport properties
    FieldStartDelimiter,FieldEndDelimiter = <None>
    FieldSeparator = <TAB>
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Categories