dear all
i have baan iv and i try to import data from excel sheet to baan
evry time the baan reject the record and return log file which i attch thim
i need know what is the problem and how can i rpeair it
thanks

It's not always easy to import from excel. First any numeric usually has commas added to it. If it looks like 2000 in excel, chances are it will look like 2,000 in the CSV file. So you have to change numeric columns to text to prevent the additional formatting. You must also look for quotes and commas in string values. Sometimes it is best to change these to some other value that can not be found. Then from a command prompt edit the CSV file, change the commas to pipes, and then the special character you used back to a comma. The exchange scheme needs to have the new seperator character pipe "|" instead of comma.

You can try to use Print Ascii file to see where the formatting is incorrect.

It takes a few times, but you will eventually get rid of the errors.

dear Mr. William K. Prokurat

iwould like to thank you about your interst and i try your proposal but the still problem occur and this samble line from log file
"10,3,606,01-00302,143950.00
10,3,606,01-00473,125050.00
10,3,606,01-040393,35250.00
10,3,606,01-040553,66100.00
10,3,606,01-040602,32900.00
10,3,606,01-040848,49600.00
10,3,606,01-040871,52400.00
10,3,606,01-040886,26400.00
10,3,606,01-040953,40350.00
10,3,606,01-040982,58350.00
10,3,606,01-041001,50650.00
10,3,606,01-050033,25450.00
10,3,606,01-050058,24400.00
10,3,606,01-050071,27250.00
10,3,606,01-050118,19200.00
10,3,606,01-050264,34450.00
10,3,606,01-050268,16700.00
10,3,606,01-050290,40750.00
10,3,606,01-050344,66750.00
10,3,606,01-050535,18750.00
10,3,606,01-050572,66000.00
10,3,606,01-060013,135450.00
10,3,606,01-060051,112150.00


thanks

Is the 606 am import value from your excel file or is it the output of the log file.

Error 606 is reference error, you want to import an value which is not present in the related table.

Please post both, some sample lines of your import file and the log file.

What you can do:

Insert some records in the table and create an export schema.

Compare this exported file with your import file (field order, number of fields, format of values).

Regards,

Kozure

The 3rd column states that this is a reference error. Check the data dictionary to find out what table is being referenced, and review the data in that table. Find out if the information is there, and if it is, are you properly formatting the field. Is it right or left justified?