Hello everybody,

Is there someone who knows abouth a solution to access a BISAM- and TBASE database (Baan Triton) with an ODBC solution????
Or perhaps the possibility to establish a table connection in msAccess to the tables in BISAM- and TBASE DATABASE.

If you do, please let me know.

With kind regards,
Marius Keulers

there is no odbc for bisam do a search on the board for croker this tool may do what you want.

I think Darren is talking about the "Croko Reporter" - indeed this product is a nice solution for linking Baan to Microsoft-Technology based reporting (ODBC, Excel Pivots...). It might be a solution for you, since it's working with TBase, too. It is offered by the dutch company Quadriceps: www.quadriceps.nl

You can also get Croko Reporter in Germany through SPETEC Deutschland.

Their Web site is www.spetec-it.de


- Bader

Hi,

I'm new here and am facing a similar problem. Thanks for the links to the croko reporter program, it looks to be exactly what I need. However, I don't speak German and can't seem to get ahold of any of the German sites you listed. Do you know of any English sites?

Thanks,

Don Becker

Don,

Have a look at this member's profile (http://www.baanboard.com/baanboard/member.php?s=&action=getinfo&userid=79). He works for Quadriceps and has made some posts on Croko Reporter on the board. I am sure he can you get more info iif you email him. You can do this through the board using the link in his profile.

Patrick,

Thanks for the reply.

His email via profile option is turned off, however, I emailed him through his website and also sent him a PM.

I feel very fortunate to have found such an active board.

I am basically starting to document our company processes, a big part of which is Baan. We don't have alot of documentation, so my job has become a difficult one.

If you get a chance, please take a look at my post here. (http://www.baanboard.com/baanboard/showthread.php?s=&threadid=12954)

Thanks again Patrick,

Don Becker

Hi Don,

I am afraid I wouldn't be much help for the topics of your post but but I am sure there are members who can and will. With 30000+ posts on this board, there is a vast knowledge repository already available for you to go through :)

Hello

I've tried Croko reporter - doesn't seem to fit our business needs - are there any other ideas or recommendations for accessing the bisam flat files from outside of baan?

Thanks.

From what I've been able to gather, not only is it a problem connecting to Baan Triton, but also the problem lies in the non-existent documentation of it's structure (which tables hold which data).

From another thread, someone posted that there were somewhere around 1,800 tables in Baan Triton. Yes, 1,800.

All the tables have weird names, and it's seems to be hit or miss on what's in them.

I believe I looked at Croko reporter, it looked great, but I couldn't swallow the price (small company). Now that brings the question of why the company I work for of about 50 employees ever ended up with Baan in the first place. Overkill.

There has to be some way to read the Baan tables into another db format.

I'm sure the new versions of Baan work great, but I'm dealing with Triton and all I get is pain due to a severe lack of documentation and setup.

If anyone has a line on some way to just do a massive dump of data out of Baan into another db, I'm all for it.

Also, if anyone has any documentation, I'm up for it.

Starting with nothing, I might be forced to start documenting one by one, and it looks like it won't be fun.

DonBecker

In our environment we have around 1900 table files. the filename structure actually makes sense -

for example

ttiitm001100.bdt/bid
Break it down:

[t] = "table"
[ti] = package
[itm] = module
[001] = item master data
[100] = company number
[bdt / bid] BDT is the table file, BID is the index file...

It's actually set up very logically - for example, all tables in the package/module ti/itm are typically located in a directory ttiitm.

You can look at pretty much any table and correspond these files to the table number in GTM.

I agree, Croko is too expensive for what we'd like to do - extract data on a realtime basis from an external application. Right now we're batching it.

I must agree on the lack of documentation - let me know if you find something.

Thanks!

Wow!

Can't believe I missed that one! :)

I would REALLY be interested if you had the info to decode those numbers..

Do you have any books you could point me to?

My searches at Ebay and Amazon have turned up nothing.

As for my company's documentation, we have 18 little gray 'triton' binders, I looked through them and can't seem to find much help.

I've just started some linux stuff in my spare time, and some of the unix things in Baan are starting to make sense.

If anyone would like to start a cooperative effort to put together information on Baan Triton, I will be more than willing to help.

Wow!

Can't believe I missed that one! :)

I would REALLY be interested if you had the info to decode those numbers..

Do you have any books you could point me to?

My searches at Ebay and Amazon have turned up nothing.

As for my company's documentation, we have 18 little gray 'triton' binders, I looked through them and can't seem to find much help.

I've just started some linux stuff in my spare time, and some of the unix things in Baan are starting to make sense.

If anyone would like to start a cooperative effort to put together information on Baan Triton, I will be more than willing to help.

DonBecker,

If you use the session ttadv4420m000, Print Table Definitions, it will provide you a list of tables with thier names, broken down in groups of "packages".

We have the grey binders as well. I've found that since BaanIV is pretty similar in structure that you can get the Baan IV document on something and use it as a starting point while creating your own version.

Sometimes the built in help text that Baan has on a subject is actually quite usefull as well.

Let me know if you need help with the table listing.

Cool, that worked.

45 pages later..... :)

Here's a question...

All of the listings are seperated by package.


But not all the packages say Triton.

For example:

:tc Common Baan IV b
:td Distribution Baan IV b
:tf Finance Baan IV b

I thought I had Baan Triton?

At least that's what the main menu says.
Sheesh, after all the windows programming I've done, doing something in unix sure makes me feel like a newbie.

Don

Baan is broken down into packages & modules. Baan is very structured or modular in this way.

For example, the TC package is "common" or all of the common data (ie customers, suppliers, etc). or Distribution is where you would keep track of all your incoming and outgoing supplies, if for example, you purchase/sell stock.

Each of those packages is what makes up Baan. You need to have a license for each package you use - so things that you don't use (for example, we don't use the transportation package), you don't need a license for (and it won't work).

Looking at what you posted though, you said

"tc Common Baan IV b."

Are you actually on IVb? or or 3.1?

Triton is the interface that Baan employs to layout and access the packages (common, finance, etc) and modules (itm, pcs, etc).
<someone correct me if that's an incorrect statement>

Okay, I'm not sure, here's what I do know....

We use a terminal emulator program called Smarterm Essential, made by a company called Persoft.

This lets us interface with our Baan Unix server from our Windows 2000 PC's.

When I login to Baan, I see a main menu.

At the top it says: "Triton General menu"

Then I have a number of options, most have 3.1 after them, except for Organizer and enterprise (1.3) and Tools and Exchange (6.1).

Again the others (Common, finance, mfg, distribution, transportation and service) all have a 3.1 after them.

But when I did the tables by package printout, at the top it says this:

Package : tc Common Baan IV b

So is that Baan IV?

I had a thread earlier this month on my version and some people walked me through it and told me I had Triton, but then this IV comes up. click here for the thread (http://www.baanboard.com/baanboard/showthread.php?s=&threadid=12954)

What do you think? Can you show me a way to determine which version?

BTW, I have access to an ftp connected to the Unix server, so if there's a file there that could tell me (or a structure, etc.) let me know and I'll look.

In all probability the version is 3.1. However u can be sure of that by printing a session info for any session (ttstpsessinfo). The highest pvrc for tt package will indicate ur Baan version.

U can use P (assuming English language) in the ascii menu to start the session directly without going through normal menu channel.

Originally posted by DonBecker
If anyone would like to start a cooperative effort to put together information on Baan Triton, I will be more than willing to help.

We will give you the opportunity to do just that. Stay tuned next week :)

Don - in repsonse to:

What do you think? Can you show me a way to determine which version
in the thread you connect to lbencic said
You are indeed on Triton 3.1. You can check the exact specifics when you log in. Assuming you type the ba6.1, type ba6.1 -V, which will display your version, porting set, etc
The last porting set version that baan has released for 3.1 is 6.1c.06.07.

You are probably on 3.1 - if it *IS* Baan IV, I would have to agree that it would indeed have been a very poor conversion (as per the thread (http://www.baanboard.com/baanboard/showthread.php?s=&threadid=12954) )

Looking forward to the Triton / 3.1 forum "opportunity next week"

regards....

Ok,

Where exactly do I type the ba6.1-v at?

I tried printing session information, and at the top, under package information, this is what I have:

Package
------------------------
tt Tools BAAN IV
pa TRITON Akko Customizations
tc Common Baan IV b
td Distribution Baan IV b
tf Finance Baan IV b
tg Organizer Baan IV b
ti Industry Baan IV b
tp Project Baan IV b
tr Transport Baan IV b
ts Service Baan IV b
tu Utilities Baan IV b

Don

do the ba6.1 -v from the shell prompt.

Drop to the shell by using the "<" symbol from the choice prompt.

I would suggest using that at the menu choice prompt since it will open a new shell instance instead of locking up the current session you are in when you shell out.

Here's what I got, I guess I don't have IV.


bshell6.1>
bshell6.1> ba6.1 -v
-------------------------------------------------------
Porting set : 6.1c.04.01

Port no. : PA.1069
Date : Wed Aug 25 11:08:21 DFT 1999
Uname : AIX jerom 1 4 002051894C00
Machine-id : IBM_RS6000
OS-release : AIX4.1.5
CFLAGS : -O2 -qro -qtocdata -qinlglue -qunroll=1 -qnoansialias -I/port.6.1c
.04.01/vobs/tt/headers -I/port.6.1c.04.01/vobs/tt/ba/cu_4 -I/port.6.1c.04.01/vob
s/tt/lib/ds_1 -I/port.6.1c.04.01/vobs/tt/lib/mb -I/port.6.1c.04.01/vobs/tt/lib/a
l_1 -DIBM_RS6000 -DAIX4_1 -DREL6_1 -DRIOS6000 -D_POSIX_SOURCE -D_ALL_SOURCE -DIN
CLSTDLIB -D_TSS -DSYSTIME -DSOCKET -DLOCAL_SOCKET -DPIPE -DMQ -DSHM -DUNIQUE -DD
IRENT -DCUSERIDBUG -DVOID_PTR -DSCANF_OK -DSYSMEMFUN -DSLOTIO -DMEMMAP -DWRITEV
-DHIGH_LOW -DGETCLOCK -DSIGINTERRUPT -DWAITPID -DWAIT3 -DSIGNAL_TYPE=void -DSEM_
LOCK
LOADFLAGS : -bimport:/port.6.1c.04.01/vobs/tt/Util/imake/ibm_aix_41.exp
-------------------------------------------------------
Copyright © Baan Company NV, 1990-1999
bshell6.1>

Your's is confusing. I don't like those references to IVb - if it is pure Triton that would never even come up.

To check the derivation of each of your packages, that ttstpsessinfo would help. Or just open up 'Display Package VRC's' - (Tools / Application Customization / Packages and Modules / Inquiry / Display Package VRC's).

This session will show the derivation for each package you have. The lowest level will be the standard - it will say if it is B40b or c or 3.1 something...Maybe post a screen print of the derivation for your question packages like tc for us to review.

You can't run that for package tt, but running that ttstpsessinfo would help there - from the main menu type 'P' for running a process (if your user is allowed, it will prompt you to type in a process to run). Type 'ttstpsessinfo', this will hopefully bring up that tools session. Leave your VRC, and put in a popular session, like tdsls4101m000, choose continue. If it's the same in Triton as what I see, the first breakdown it gives you is your derivation structure for all packages, including tools. Maybe post that first derivation breakdown for us to see (not the whole sessinfo). If that's what you used to get the Baan IVb derivation you submitted above, it looks different from my ttstpsessinfo results, but still seems to say you are on Baan IVb.

Also, this could easily happen if an upgrade was done without paying attention to that menu. Maybe the main menu (Triton 3.1) was customized, and copied over during the upgrade to Baan IVb and not changed. I think that is likely considering all your printouts of derivation say you are on IVb.

'Display Package VRC's' results:

ttadv1511m000 multi/view (3) Form 1-1
[------------------------------------------------------------------------------]
| Display Package VRC's |
}------------------------------------------------------------------------------{
| |
| Package : pa TRITON Akko Customizations |
| |
| VRC Description Status Derived from Package |
| VRC Combin. |
| |
| 3.1C a akk0 Developing 31Caakk0 |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| Choice: . |
[------------------------------------------------------------------------------]


'ttstpsessinfo' and 'tdsls4101m000' results in:

ttstpdisplay Page 1 W: 80 H: 22


Date : 09-30-03 [08:08] SESSION INFORMATION Page : 1
Data_Dictionary_General Company : 000

--------------------------------------------------------------------------------
Package Combination : 31Caakk0 Customized_31_a
------------------------------------T-------------------------------------------
Package | VRC
------------------------------------+-------------------------------------------
tt Tools BAAN IV | 6.1 a Tools 6.1
pa TRITON Akko Customizations | 3.1Ca akk0
tc Common Baan IV b | 3.1Ca akk0
td Distribution Baan IV b | 3.1Ca akk0
tf Finance Baan IV b | 3.1Ca akk0
tg Organizer Baan IV b | 1.3Ca akk0
ti Industry Baan IV b | 3.1Ca akk0
tp Project Baan IV b | 3.1Ca akk0
tr Transport Baan IV b | 3.1Ca akk0
ts Service Baan IV b | 3.1Ca akk0


>
--------------------------------------------------------------------------------


So as I understand your last post, we could be running Baan IV and still be using the menu from Triton, giving us the impression we're running Baan 3.1?

Thank you SO much for your time, it is greatly appreciated. I'm looking forward to the ability to collaborate on Baan documentation.