Eddy G
19th September 2003, 11:23
We have performance problems while uploading ASCII dumps via Exchange.
Anyone having a suggestion to improve that?
Regards - Eddy
JJ1972
19th September 2003, 13:28
You have an possible problem of conversion ASCII to ANSI.
Verify the file. If is included the character ^M at the end of line you may convert the ANSI file to ASCII file.
NvanBeest
19th September 2003, 13:51
Also, please post the tables involved, and maybe the layout of the ASCII file, and, lastly, any condition script you are using.
baanconsultant
10th September 2004, 11:07
This has always been extremely slow. As a workaround, you can use a condition on the textfield that has the textlines as parameter, puts the textfields in a tmp-file, uses the Baan-Tools functions to generate a baan-text from the tmp-file and return the generated textnumber. In my experience this is faster, however, I have seen text being created double since exchange sometimes runs over the same field twice on importing.
malutz
10th September 2004, 12:38
I cannot share the opinion of baanconsultant. We always had good performance on importing via exchange (also importing texts).
I have some aditional questions:
- Which tables are you updating?
- Are you using the "DAL"?
- How are the texts structured?
- Are you using the multiline function (ASCII File Fields tuxch0503m000)?