I have created an exchange scheme for employees, but when I import data, all the records are rejected and I get an error message in the log file saying

"Incorrect record: number of fields or field contents doesn't correspond with ascii file format".

I have checkec the number of fields and they match, but I am not sure what it means by field contents doesn't correspond.

Any help would be appreciated.

Jenny

Are you sure that each field is the correct data type? For example, the emno field in Baan IV is a long integer; are you sure you don't have it set to alphanumeric in your exchange scheme?

Vince

I have attached a screen shot of the field type that I have - I think they are correct.

Jenny

Hi Jenny,

You have defined 21 fields. That means that in each line in the file ther should be 20 field separators. (I'm assuming that you did define field separtors for files in exchange scheme). Also the field separator should be the same as the one defined for the scheme ";" or "|" or,...

I have 20 "|" and I defined the separator but it still doesn't work??

I think the emno field should be numeric, not alphanumeric. That is what I have it set to on my exchange scheme for employees.

Vince

Please go to specific in ASCII fields and "recalculate start positions" after you define the ASCII fields.
As per your screenshot all start positions are "0" which is incorrect. They need to be recalculated.
Hope it works for you.
Thanks.

Hi,

define all the fields as alphanumeric. The problem shoud go away. Now you can set each field one by one to the desired type and test. By the way when you define field separators the beginning and end lenghts are ignored and need not be entered.

After you set up you ASCII file you can use it to print out your datafile and see if the data looks correct. Use Print ASCII files under the misc. menu and don't supply any field numbers to get them all.

I have 20 "|" and I defined the separator but it still doesn't work??

I only see 20 fields.....:rolleyes:

Hello Jenny,

Easiest thing to do with this is to set up an Export identical to the Import and see what data it spits out. This should give you a feel for what is wrong with your import data.

Cheers
Neal

Jenny,

Use the Print ASCII File Session tuxch0202m000 to display all your fields. This will let you know if you have incorrect fields.

Date fields are nasty in exchange schemes. They can't be empty or Baan will complain when you run the import and give you just the error message that you are getting. Try putting a zero in if the birthdate field is empty.