I'm very new to BaanIV so please I need a lot of help!!! :o

How can we use Baan Exchange Scheme to populate sale order data from a text file, which has several columns that data is not used for upload?

Is it possible to use Exchange Scheme to read and populate only the required columns from a text file? How? Additional Script required?

Please advise. I'm really appreciate all answers.

Thank you, Thank you, Thank you~

It is posible to load data from an ascii file that contains more info that what you need.

in session tuxch0103m000 Maintain ASCII File Formats, by default the format created is Identical to the table; however you can change the start position of the fields like:

10 cuno Customer Code Alphanumeric 1 6
20 namb Name 2 Alphanumeric 9 30
30 nama Name Alphanumeric 47 35

I don't think that loading sales order (header/Details/text) using exchange will be your best bet. However is doable.

The loading of sale order is possible ... but you need to update all required tables thru Exchange scheme .... other way is to use AFS to populate sales order from flat file

It is posible to load data from an ascii file that contains more info that what you need.

in session tuxch0103m000 Maintain ASCII File Formats, by default the format created is Identical to the table; however you can change the start position of the fields like:

10 cuno Customer Code Alphanumeric 1 6
20 namb Name 2 Alphanumeric 9 30
30 nama Name Alphanumeric 47 35

I don't think that loading sales order (header/Details/text) using exchange will be your best bet. However is doable.

Thank you!!! :D

I know that loading sales order usin Exchange is not the best way;however, I have no choice and it's not my choice.

The file contain multiple lines for a sales oders, will that be a problem?

By specifying the starting position, can the file contain "," as a separator? Also, some column is blank, " ". How do count the start position when it's blank? Start from the first code? Total 3?

Please advise...Thank you!!! :)

Thank you!!! :D

I know that loading sales order usin Exchange is not the best way;however, I have no choice and it's not my choice.

The file contain multiple lines for a sales oders, will that be a problem?

By specifying the starting position, can the file contain "," as a separator? Also, some column is blank, " ". How do count the start position when it's blank? Start from the first code? Total 3?

Please advise...Thank you!!! :)

Since you have no choice, I will suggest that you parce your files first and try to create the files from there.
I mean the ASCII exchange file to populate sales order header and sales order lines.
Normally files will be fix lenght, therefore you can still use the starting position and end position of the field, the character fields should be alligned according with the domain of the field that you are populating.
You can create manualy a sales order and sales order lines, then use exchange and export the values so you will see which fileds you will require to populate from your import.

Good luck

Felipe Saavedra