TMS TDBPlanner component - anyone used it?

[lespaul]

I am looking for someone who has used this component in the past. It seems to be one of the better third-party components, but I'm having problems "getting it". Thanks for responding!


Leslie
landrews@metrocourt.state.nm.us

There are 10 types of people in the world -
those who understand binary
and
those who don't!

 

[LucieLastic]

'getting it' - you mean understanding how to use it or can't find where to get it from?

On the TMSSoftware web site they appear to have example applications using this component - have you looked there?

lou

 

[lespaul]

the only example applications I could find involved purchasing something someone had built with TDBPlanner. I couldn't find any code examples! I have dropped a TDBPlanner on my form, but the times go from 12:00 am - 12:00 pm and I want to limit it to the hours of operation and I can't find out where to do that; I am going to be developing a scheduler for a massage therapy school/clinic and want to set up the scheduler to show each day's therapist across the top of the grid and their appointments in each column, but I can't see where you assign anything!! So I'm basically looking for some examples, that I can open in the IDE, that show some of the ways to use this component. Thanks for helping!

Les

 

[LucieLastic]

If you're registered with TMSSoftware then they are extremely helpful with support. They will actually send you an example of how to do something if you ask them. They are based in Belgium (I think) so your day times will be a bit out of sync. though.

lou

 

[LucieLastic]

hi

Did you scroll to the bottom of the TDBPlanner page on their web site, it has

'- All sample applications for Delphi ...' (download)

I was unable to download on my network pc because of WatchGuard - I have to go on a standalone to download anything. If this is the download you were referring to, then ignore this message.

lou

 

[GeppoDarkson]

Hi,

I'm using TMS TDBPlanner and I'm pretty happy.
I have had some difficulties because of the huge quantity of properties, but after some days everithig was clear.

My procedure does more or less what you need (plus multiple eMail management system), so if you need something specific, maybe i'll can send you some pices of code.

I dont' know if it's legal to promote software on this forum, but i'm finishing it right now, so, if someone wants a demo...

Meanwhile,
that's how to set Start and End time:

DBPlanner1.Display.DisplayStart:=0;
DBPlanner1.Display.Displayunit := 30; //30 min each row
B:=DBPlanner1.AbsTimeToCell(DalleOre.Time);
E:=DBPlanner1.AbsTimeToCell(AlleOre.Time);
DBPlanner1.Display.DisplayStart:=B;
DBPlanner1.Display.DisplayEnd :=E;
DBPlanner1.Display.ActiveStart:=0;
DBPlanner1.Display.ActiveEnd:=DBPlanner1.Display.DisplayEnd+1;

On the TMS Site you'll find many examples, plus a PDF specific to Planner/DbPlanner

Let me know if you can't find it or if you need something else.

Ciao,
Geppo Darkson.

 

[lespaul]

Thanks Geppo! I looked around for a component and this seemed to be one of the more developed and doesn't cost a few hundred dollars! Thanks for the tips and the PDF information. I'll go look around the site again!

Leslie

 

[lespaul]

So I found the Demos file (thanks weez), but I'm really interested in the PDF file. Any clues on where I might find that on the TMS Site? Thanks!

 

[lespaul]

Geppo, I have run into a slight problem with the samples. I am designing the database in Access and the Access demoplanner causes my delphi to crash. So any pointers you can give me regarding this component will be greatly appreciated. I am still looking for the PDF. FYI - I am a relatively new Delphi programmer, I have about 1 year experience working on a jury tracking system. I have learned alot about Delphi, but I am still relatively inexperienced, so please don't feel that you can give me too much detail or instruction. Thanks for your help. If you could email me samples of your code/application, it would also help me alot in learning how this component works.



Leslie
landrews@metrocourt.state.nm.us

There are 10 types of people in the world -
those who understand binary
and
those who don't!

 

[GeppoDarkson]

Hi,
after you login with email & pwd on

http://www.tmssoftware.com/asp/reg_input.asp

, after the promotions you'll find the TMS Component pack : help files
with "TMS TPlanner/TDBPlanner Developers guide (12/16/2002 5:14:27 PM)".

I'm using the dbPlanner with D7 and Access via ADO + JetEngine, and I have had no problems.

This works:



AdoConnection1.Connected:=False;

//Database parameters
AdoConnection1.ConnectionString:='Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;'+
'Data Source='+ExtractFilePath(Application.ExeName)+'Agenda.mdb;'+
'Mode=Share Deny None;Extended Properties="";Persist Security Info=False;'+
'Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDBatabase Password="";Jet OLEDB:Engine Type=5;Jet OLEDBatabase Locking Mode=1;'+
'Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;'+
'Jet OLEDB:Encrypt Database=False;Jet OLEDBon''t Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False';
ADOConnection1.Provider:='Microsoft.Jet.OLEDB.4.0';
ADOConnection1.Connected:=True;


//Query for data
QApp.Active:=True;


//"ItemSource" for the planner with DataSource linked to the TQuery QApp (via a TDataset QAppSrc)
DBDaySource1.Day := QApp.FieldByName('FromDate').AsDateTime; //Start at the first appointment


DBPlanner1.Realign;


Hope this helps.
Ciao,
Geppo Darkson.

 

[origineforever]

hi all,

i am searching for the help/pdf files for the AdvStringGrid but i'am not registred with TMS software could you give any idea on how to get these files!
really need them.