I have exported the sales budget(tdsst050) from Exchange in BaaN IV C4 and I have copied the new values exactly as the file exported file(old values plus new values) and saved it as a CSV file.
However, when I try to import the CSV file back via exchange, it keeps on accepting all the old values but rejecting the new values.
Can anyone tell me where I am going wrong and if I on theright track?:confused:

Hi Abuibra,
What does the log file say for the rejected records? A log file is created for every run of import and the directory for this file is defined in "Maintain Exchange Schemes".
Usually, the log file logs a mesasge no and the message can be read thru session "Maintain Messages" (ttadv4151m000).

One common problem is that, if the ascii file field length is less than the corresponding field in BaaN, then it has to be padded with blanks either left or right as the domain of the BaaN field applies.

Warm Regards
Manu

Are the new values for existing records? If so, do you have the
box check marked for adds (Maintain Table relations form 2).


In maitain field relations, do you have the field (values) marked
as overwrite yes?

just some suggestion to check out

Take one record that has problem and import it manually through GTM. The old value should bring up an error. You should get a hint from the error message.

Thank you for your quick response,however, I have already done all your suggestions, the prcoess goes through alright but it does not give out any error message. So usually after importing the file, I just checked with the log file and saw that the records have been rejected. Any ideas?

Try exporting and importing without delimiter, ie fixed-width. I really can't explain the logic of this but it worked for me before.

Another thing is, try importing with default instead of field values on suspect field...you should be able to narrow down which field gives you problem.

Good luck.

You can also compile the scheme in debug mode. Hard as heck to understand some of it, because you see all the standard processing, but you should be able to see if it is reading your records properly, etc.