Hi all,

I need to import data into a Baan table using BaanERP Exchange. The table has a text field. The ASCII file has data in delimited format. The last 3 fields in the ASCII file are for the text data.

example of the ASCII file data delimited with comma (,):

46000037,ALAATAL C 000/031/155,46000037 ALAATAL C 000/031/155,TAL,0,31,155,180A,k001,"c: [material] = ""TAL""",c: [od] < 31,c: [id] > 0

These above mentioned 3 text fields have to be imported into a Baan table text field on 3 separate lines.

example of how the text should look in the text manager:

c: [material] = "TAL"
c: [od] < 31
c: [id] > 0

I have never worked with text fields in BaanERP Exchange. I would like to know how to go about this. Is there any document or procedure to do the same?

Thank you in advance for your inputs.

46000037,ALAATAL C 000/031/155,46000037 ALAATAL C 000/031/155,TAL,0,31,155,180A,k001
{\{txta 2
c: [material] = "TAL"
c: [od] < 31
c: [id] > 0
}\}



set the text field in the exchange scheme on the table that is being imported to multiline text and enclose the text as shown above, the 2 sets the language

I assume this is the same in baanERP as baan4c4 ?

Hi again,

My ASCII file has more than 10,000 records data in it. So using the enclosing string

{\{txta 2

...

}\}

would be very cumbersome. Is this the only possible option?

Thanks

This will probably need to be done using a condition script. You could create an exchange scheme that reads each field in individually, then in the script it would combine the fields as you need it and store it in a variable that is then loaded to the table instead of the individual fields.

Alternately, an OS level script could be created to reformat the data as required, but I believe the condition script would be best, especially if you are familiar with 4GL already.