Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor

Main

Google search


Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
17%
200 - 500 GB
17%
500 - 800 GB
6%
800 - 1200 GB
6%
1200 - 1500 GB
17%
1500 - 2000 GB
17%
> 2000 GB
22%
Total votes: 18

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 4th July 2002, 17:11
Maxali Maxali is offline
Junior Member
 
Join Date: May 2002
Posts: 8
Maxali is on a distinguished road
Microsoft Excel in Baan

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!
Reply With Quote
Sponsored Links
  #2  
Old 4th July 2002, 22:29
alejandro's Avatar
alejandro alejandro is offline
Senior Member
 
Join Date: Feb 2002
Location: Madrid - Spain
Posts: 144
alejandro is on a distinguished road
Baan: IV c4 - DB: Oracle 8 - OS: Unix
Excel

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.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
BaaN IV ODBC to Microsoft Access 2000 jun lopez Operating Systems & Databases 1 20th September 2004 20:34
Is Invensys really planning to sell Baan? baanassist General Discussion & Chat 10 3rd September 2002 18:29
Question on integrating Excel with BaaN. r_nagu Tools Development 48 15th August 2002 15:06
Baan Report ---- Excel Kai's Forum Users Deutsches Forum 1 8th August 2000 00:00


All times are GMT +2. The time now is 08:37.


©2001-2018 - Baanboard.com - Baanforums.com