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?

This one will be a dialy upload so we do not want to manually delete unused columns every time.

Please advise. I'm really appreciate all answers.

Thank you, Thank you, Thank you~ :D

The input file to an exchange scheme needs to be of the same format everytime. You can only load those fields that are mandatory. Other fields can just be skipped on the exchange scheme. You can also skip columns that have not information not related to the table - just use a dummy field and do not include in the table relations.

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?

Why? IMHO EDI is a better way to do this. With exchange you would need a lot of programming in the conditions because you have to populate many tables for sales orders.

Regards
csecgn

Thank you!!!

I have been reading some posting. I found that it's not easy to use Exchange Scheme for complicated task. Unfortunately, I kinda have no choice. It's not my choice. :(

I'm sorry. I'm really new to all this. What is IMHO EDI?

Have you heard of EXOSTAR? The text file will be exported from this software. The exported file always has the same number of columns. If no information, it's blank. Unfortunately, most of them are blank. For a sales order, there are 5 rows (number of column per rows, range from 2 columns to 89 columns. In one file, it may have multiple sales orders. Therefore, we try not to manual delete anything from the file. We prefer the computer to do most of the work, if possible.

Yes, I know there are a lot of tables to update. I just got a list of possible affected tables from Baan support. It's a long list!!!!!

Please advise. If I really have to do it from Exchange Scheme, is it possible? Also, like I said I'm new...could you explain how to write a script for Exchange scheme? What is 3gl and 4 gl? Do you have any document reference?

THANK YOU SO MUCH!!!!

Best Regards,
bkkland :)

Unfortunately, I kinda have no choice. It's not my choice.
Sorry, but its a bad choice


What is IMHO EDI?
In My Honorable Opinion; EDI is Electronic Data Interchange:

EDI is the Baan standard way to enter sales order electronical. It's similar to exchange (and from another view completely different). EDI uses a standard file format for input, but you can modify this format. You will find EDI at Distribution -> EDI in the menu (and some help about EDI in the online helptexts)..
For my opinion it is very difficult to use exchange for order entry (much too complicate)

Have you heard of EXOSTAR? No, we are using SEEBURGER converter and EDI/OpenWorld (meanwhile nearly only OpenWorld)

We prefer the computer to do most of the work, if possible.
We do also :D

If I really have to do it from Exchange Scheme, is it possible? Also, like I said I'm new...could you explain how to write a script for Exchange scheme? What is 3gl and 4 gl? Do you have any document reference?

Possible: Maybe, but... . For 3gl (third generation language) and 4gl (forth generation language) better took a look at the manual (programmers help) or the wiki at this forum. There you can find a good explanation.

Regards
csesgn

hi All,
can anyone tell me how you creat the sales order using EDI 850 ,and if possible the session for it.

I am trying to combine two string fields from ascii into one Baan table field in the exchange. Can anyone help me out how to do that?

Thanks
Suresh

You will need a condition for this. Define both fields as input values and use a concatenation of both fields as return value.
The conditon needs to be in the field in which you want to have the combined values.

hth

Regards
Christof