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

[Sebastian Reitenbach]

discuss@opengroupware.org 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. 
> 
> Ugh.  Trigger/SPL support in MySQL is really primitive.  But you could
> write some kind of slurp script easy enough to occasionally pull CDR
> records into OGo.
> 
> > 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 
> 
> Not from MySQL.
> 
what a pity, but nevertheless, at least for my first tests, I can use 
postgresql, as the asterisk CDR database, not a big deal.
I just need to figure out,what is needed.


Helge, how is the notes to persons added in the pending schema change you 
mentioned? Maybe I can just use that.

Sebastian