[OGo-Discuss] phone call information to contacts in ogo

[Sebastian Reitenbach]

discuss@opengroupware.org wrote: 
> > > On 13.12.2007, at 10:44, Sebastian Reitenbach wrote:
> > > > Either the asterisk/callweaver is writing the information directly  
> > > > into the ogo database then, or is using an own database, and the  
> > > > info is synced to the ogo database. At least that would be sth. I  
> > > > think I could implement, as I have no idea how to deal with two  
> > > > different databases at the same time, as the telephone numbers have  
> > > > to be compared between these two.
> > > I think there is nothing bad about storing a call log in the OGo  
> > > database. Though you should choose a better (more unique) table name!
> > the table name is hardcoded in Asterisk, at least, when I take a look at 
the 
> > config file, then I don't see a configuration option for the table name.
> 
> If you want CDR data from Asterisk to appear in the OGo database and
> both are using PostgreSQL there are several pretty simple DB magic
> tricks to pull that off.
> 
> The easiest would be to just trigger from the CDR (Call Detail Record)
> table to create a note (or whatever).  It would also allow you to be
> selective about what CDR data you bought over.
Many people use freepbx, that I mentioned earlier in an other thread. This 
is based on mysql. I don't know much about mysql, but afaik trigger should 
work there too. I'm not sure whether I can use such a trigger to pull data 
into an other type of database, running on another host or sth, but 
generally you are right, a custom table in ogo, with only the stuff really 
needed makes sense for me too.
>  
> > > Personally I wouldn't want to have yet another tab in the person  
> > > viewer for just a call log. A generic journal would be nice, but also  
> > > a lot of work.
> > This is too much work for me right now, but what about overlaying the 
> > appointment tab with the phonecalls. After the phone call ended, info is 
> > stored in teh database. Then when the user opens the appointment tab, 
the 
> > call record shows up, Allow the user to click on it, to make notes.
> > Well, I think an own tab, with a plain list, would be easier for me to 
> > implement, but I think that is sth. I could do too.
> 
> We already store calls in the scheduler.  The interface in our CRM just
> adds the call with the caller and callee as participants and type "call"
> and conflicts disabled.  So far it works just fine.
> 
I see, so they are more or less generally showing up in the using an 
appointment would have all the features needed, e.g. allow permissions, 
comments to the phonecall.
But also the other idea, adding notes to contacts seems a great idea for me, 
but where should they show up, in another tab, or maybe at the bottom of the 
attributes tab, or any better place?

Sebastian