Baanboard.com

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

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 12th May 2017, 20:22
dadwarf dadwarf is offline
Junior Member
 
Join Date: May 2017
Posts: 5
dadwarf is on a distinguished road
Baan: i don't know yet - DB: i don't know yet - OS: i don't know yet
Noobs need help..
Baan: Other/Unknown
C/S: Client

Hi,
i need some help, in my company we use Baan with bw client to view customer's request.. but the client's interface is painfull and i would like to make a simple client (a webui) just to list each requests in a smarter aspect.
But.. i don't know anything about Baan : I tried to make sql queries in vbs but i don't know field's names, i even don't know what kind of database it is ! Where can i find some clue to begin my project ?

Here is my bwc config :

[ApplicationServer]
bse=/toa/baan/bse
bshell=bshell
command=-- -set USER=xxx
[Remote]
protocol=BAAN
hostname=xxx
portnumber=7150
username=visatm
domain=
logindialog=NO
passwordx=xxx
[NLS]
locale=ISO
rtlreading=NO
[Font]
fontName80=Fixedsys
fontWidth80=0
fontHeight80=-12
fontWeight80=normal
fontItalic80=NO
fontName132=Fixedsys
fontWidth132=0
fontHeight132=-12
fontWeight132=normal
fontItalic132=NO
[Automation]
className=Baan.Application.default
classId={DAEE4B91-9165-43A1-B492-F9A4EF0B7D0A}

Thanks a lot..
Reply With Quote
  #2  
Old 12th May 2017, 22:37
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 6,933
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
With only the bw client information I am not sure you can even get started. If you have the tools module you can at least look up tables and maybe see what they have for setup information. In our company that would not give you enough information to connect into the database to even read tables. Now what I could do is get enough information to use to connect into baan with the client (when you configure it there is an automation tab) and run sessions thru something like excel or VB. You can search this forum http://www.baanboard.com/baanboard/f...splay.php?f=59 for OLE and information around that. But that was even more cumbersome to me than the client itself. It might work better for you, but I no longer even look at it.

Also if you log into baan using the client and bring up a session usually you can hit the help button and click on field to see its name. Without the tools module I am not sure how you could look up the tables see what is available and how they all link together. Someone else might have a better idea on how to poke around and see what is out there.
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
  #3  
Old 16th May 2017, 10:25
dadwarf dadwarf is offline
Junior Member
 
Join Date: May 2017
Posts: 5
dadwarf is on a distinguished road
Baan: i don't know yet - DB: i don't know yet - OS: i don't know yet
Thanks for your answers Mark !

So with the help button i grab few things but i miss something :
my session is tssocc511m000 my first field show tssocc511m000dtssoc210.orno, so i guess field's name is dtssoc210.orno but olesql_parse return an error if try a query (but i works with ttaad200.user)..
Reply With Quote
  #4  
Old 16th May 2017, 13:12
bdittmar's Avatar
bdittmar bdittmar is offline
Guru
 
Join Date: Apr 2002
Location: Germany, 50.584097,8.544078
Posts: 1,653
bdittmar will become famous soon enough
Baan: 2.2/3.1/4c4/LN6.1 FP6/FP9/HiDox - DB: tbase, ms-sql7, oracle10gV1, 11g - OS: HP-UX, W2K3, SLES
Biv / Ln Fp????ß

Hello,
without knowing your System:

LN Featurepack a.s.o.
Used Database ?
it will be difficult to give some hints.

Table tssoc210 is Service-Order-Control Workorders
The index of this table is orno, pono

Regards
__________________
//Bernd
Reply With Quote
  #5  
Old 16th May 2017, 19:19
dadwarf dadwarf is offline
Junior Member
 
Join Date: May 2017
Posts: 5
dadwarf is on a distinguished road
Baan: i don't know yet - DB: i don't know yet - OS: i don't know yet
You gave me a big hint Bernd ! I tried query on dtssoc210.orno but you point it it's in fact tssoc210.orno ! So it works but it doesn't qive me all tables.. you know this table's name are they all common ? I don't know what kind of database it is ! I've got no other tools.. just bw.exe and i would like to extract all data from my session tssocc511m000 just to make a webui !
Reply With Quote
Sponsored Links
  #6  
Old 17th May 2017, 07:51
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 6,933
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Not sure - but in 4c4 I know I could query table ttadv420 in company 000 to get the table names - not sure that would help you. Then I could query ttadv422 to get the field for that table, or ttadv421 to get the index columns. I am not sure about LN or if you can even get to tables like that. On our unix systems I can shell out and run like bic_info6.1 on a session to get more information - not sure that is available to you. Once upon a time I had a tool that did something like this from Gfasbender - not sure if another company has tool like that or not.
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
  #7  
Old 17th May 2017, 09:24
bdittmar's Avatar
bdittmar bdittmar is offline
Guru
 
Join Date: Apr 2002
Location: Germany, 50.584097,8.544078
Posts: 1,653
bdittmar will become famous soon enough
Baan: 2.2/3.1/4c4/LN6.1 FP6/FP9/HiDox - DB: tbase, ms-sql7, oracle10gV1, 11g - OS: HP-UX, W2K3, SLES
tssoc-tables for service orders

Hello,

for Service orders These tables are used:
Code:
tssoc200     Service orders                   Index = orno
tssoc210     Service order Services      Index = orno, pono
tssoc220     Service order Material      Index = orno, pono
tssoc230     Service order Wage          Index = orno, pono
tssoc240     Service order Others        Index = orno, pono
Regards
__________________
//Bernd
Reply With Quote
  #8  
Old 17th May 2017, 20:01
GaryEd GaryEd is offline
Senior Member
 
Join Date: Sep 2001
Location: CT, USA
Posts: 135
GaryEd is on a distinguished road
Baan: 4c4 sp 30 - DB: SQL 2008 R2 - OS: Windows 2008 R2
If your company uses baan you must have someone that is the administrator for it. suggest you start by asking them your questions.
__________________
Gary
Reply With Quote
  #9  
Old 22nd May 2017, 09:15
dadwarf dadwarf is offline
Junior Member
 
Join Date: May 2017
Posts: 5
dadwarf is on a distinguished road
Baan: i don't know yet - DB: i don't know yet - OS: i don't know yet
It's a big company and nobody will understand why i'm doing that..
So i tried :
Quote:
Set BaanObj = CreateObject("Baan.Application.default")
Query = "select ttadv420"
B_function = "olesql_parse(" & Chr(34) & Query & Chr(34) & ")"
BaanObj.ParseExecFunction "ottdllsql_query", B_function
query_id = BaanObj.ReturnValue

B_function = "olesql_fetch(" & query_id & ")"
BaanObj.ParseExecFunction "ottdllsql_query", B_function
Wscript.Echo BaanObj.ReturnValue
But olesql_fetch return -1 ??
Reply With Quote
  #10  
Old 22nd May 2017, 09:31
BChary's Avatar
BChary BChary is offline
Junior Member
 
Join Date: Apr 2016
Location: Poland
Posts: 9
BChary is on a distinguished road
Baan: Infor LN 10.4/10.5 - DB: SQL Server - OS: W10
I'm not sure, but i think your query is wrong, try:
Code:
Query = "select ttadv420.* from ttadv420"
Reply With Quote
  #11  
Old 22nd May 2017, 09:47
dadwarf dadwarf is offline
Junior Member
 
Join Date: May 2017
Posts: 5
dadwarf is on a distinguished road
Baan: i don't know yet - DB: i don't know yet - OS: i don't know yet
you're right. but i don't know how to list all fields, this works but "getstring" from what ?
Quote:
Query = "select ttadv422.* from ttadv422 where ttadv422._compnr = 0"
B_function = "olesql_parse(" & Chr(34) & Query & Chr(34) & ")"
BaanObj.ParseExecFunction "ottdllsql_query", B_function
query_id = BaanObj.ReturnValue

B_function = "olesql_fetch(" & query_id & ")"
BaanObj.ParseExecFunction "ottdllsql_query", B_function
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


All times are GMT +2. The time now is 10:09.


©2001-2017 - Baanboard.com - Baanforums.com