Maxali
4th July 2002, 18:11
Hi all
we use Baan IV and Unix IBM Aix
i want to get data in online with winNT it works
but Unix I do not how if sombody can helpe me
i will appriciate it.
Thanks
Maxali!
alejandro
4th July 2002, 23:29
What do you mean exactly with online data?
There are some ways to put data from BaaN-Unix to Excel.
In the forum you can find many threads and some code about how to do it.
In our system we use three different procedures:
1.- You can customize one existing report and put out page headers and footers, change separator to |, for example and put in the first line field names. Then select device Excel (how to create is is also explained in the forum) and excel will launch with this data.
2.- Use seq functions to create the output, then client2server and then app_start (functions from ttdllbw BaaN's dll) to execute excel passing text file created to be opened with excel.
3.- Use AFS from vba Excel and use ttstpsql_query function dll to get data in BaaN. See examples in your PC BaaN folder.
There are some other ways but I think you should better explain your requirements.
Hope this helps.