Thread: [Asterisk-java-users] Receive Voicemail event
Brought to you by:
srt
From: Daniele R. <dan...@gm...> - 2013-01-15 17:39:41
|
Hi, there is some event that is raised when a new voicemail arrive? Thanks! -- Daniele Renda |
From: Miguel S. <m.s...@gm...> - 2013-01-15 18:09:07
|
I think so. The "VoicemailUserEntryEvent" and "VoicemailUserEntryCompleteEvent" events can allow you to achieve what you need. Take a look at the following links : http://www.asterisk-java.org/development/apidocs/org/asteriskjava/manager/event/VoicemailUserEntryCompleteEvent.html ------------------------------------ http://www.asterisk-java.org/development/apidocs/org/asteriskjava/manager/event/VoicemailUserEntryEvent.html El 15/01/2013 18:40, "Daniele Renda" <dan...@gm...> escribió: > Hi, > there is some event that is raised when a new voicemail arrive? > > Thanks! > -- > Daniele Renda > > > ------------------------------------------------------------------------------ > Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS > and more. Get SQL Server skills now (including 2012) with LearnDevNow - > 200+ hours of step-by-step video tutorials by Microsoft MVPs and experts. > SALE $99.99 this month only - learn more at: > http://p.sf.net/sfu/learnmore_122512 > _______________________________________________ > Asterisk-java-users mailing list > Ast...@li... > https://lists.sourceforge.net/lists/listinfo/asterisk-java-users > > |
From: Daniele R. <dan...@gm...> - 2013-01-15 21:27:10
|
Hi Miguel, thanks for your reply. I have a ManagerEventListener added to my managerConnection and I need to receive a notification when an user leave a voicemail. In your links seems that I've to send a request in order to receive a response about voicemail. Any suggestion? Thanks very much Daniele 2013/1/15 Miguel Santiago <m.s...@gm...> > VoicemailUserEntryEvent -- Daniele Renda |
From: Daniele R. <dan...@gm...> - 2013-01-15 21:32:09
|
Oh sorry, I realize that there is MessageWaitingEvent. This is what I need. Thanks! 2013/1/15 Daniele Renda <dan...@gm...> > Hi Miguel, > thanks for your reply. I have a ManagerEventListener added to my > managerConnection and I need to receive a notification when an user leave a > voicemail. > In your links seems that I've to send a request in order to receive a > response about voicemail. > > Any suggestion? > > Thanks very much > > Daniele > > 2013/1/15 Miguel Santiago <m.s...@gm...> > >> VoicemailUserEntryEvent > > > > > > -- > Daniele Renda > -- Daniele Renda |
From: Daniele R. <dan...@gm...> - 2013-01-15 22:19:21
|
Hi, after some tests I reach this status: -I added a listener to my managerConnection, I catch the MessageWaitingEvent -Where I catch MessageWaitingEvent i run: VoicemailUsersListAction voicemailList = new VoicemailUsersListAction(); managerConnection.sendAction(voicemailList); -Then I catch the VoicemailUserEntryEvent but when I print the informations about the voicemail I can't see any information that can give me the msg_id of the voicemail received. This is the log of the event received: 15/01/2013 23:15:09 DEBUG AsteriskManager:168 - org.asteriskjava.manager.event.VoicemailUserEntryEvent[dateReceived='Tue Jan 15 23:15:09 CET 2013',maxmessagecount='100',sequencenumber=null,oldmessagecount=null,maxmessagelength='0',timestamp=null,actionid=null,timezone='it',attachmentformat=null,newmessagecount='1',volumegain='0.0',imapuser=null,vmcontext='default',fullname='100',voicemailbox='100',pager=null,saydurationminimum='2',calloperator='false',mailcommand='/usr/sbin/sendmail -t',serveremail='asterisk',sayenvelope='true',attachmessage='true',deletemessage='false',canreview='false',uniqueid=null,internalactionid='962420767_21',email=null,dialout=null,exitcontext=null,callback=null,server=null,language=null,saycid='false',systemHashcode=729217986] I cant' see anything that can help me to get the unique id of the message that I need to retrieve from the db where I save that. I can do that with Asterisk Java? Thanks! 2013/1/15 Daniele Renda <dan...@gm...> > Oh sorry, > I realize that there is MessageWaitingEvent. This is what I need. > > Thanks! > > > 2013/1/15 Daniele Renda <dan...@gm...> > >> Hi Miguel, >> thanks for your reply. I have a ManagerEventListener added to my >> managerConnection and I need to receive a notification when an user leave a >> voicemail. >> In your links seems that I've to send a request in order to receive a >> response about voicemail. >> >> Any suggestion? >> >> Thanks very much >> >> Daniele >> >> 2013/1/15 Miguel Santiago <m.s...@gm...> >> >>> VoicemailUserEntryEvent >> >> >> >> >> >> -- >> Daniele Renda >> > > > > -- > Daniele Renda > -- Daniele Renda |
From: Richard L. <lav...@gm...> - 2013-01-15 23:02:46
|
What about the internalactionid ? Otherwise use the timestamp and the user to reteieve it from the db, I honnestly doubt you'll receive 2 calls at the exact same time. On 2013-01-15, at 17:19, Daniele Renda <dan...@gm...> wrote: > Hi, > after some tests I reach this status: > -I added a listener to my managerConnection, I catch the MessageWaitingEvent > -Where I catch MessageWaitingEvent i run: > VoicemailUsersListAction voicemailList = new VoicemailUsersListAction(); > managerConnection.sendAction(voicemailList); > -Then I catch the VoicemailUserEntryEvent but when I print the informations about the voicemail I can't see any information that can give me the msg_id of the voicemail received. > This is the log of the event received: > 15/01/2013 23:15:09 DEBUG AsteriskManager:168 - org.asteriskjava.manager.event.VoicemailUserEntryEvent[dateReceived='Tue Jan 15 23:15:09 CET 2013',maxmessagecount='100',sequencenumber=null,oldmessagecount=null,maxmessagelength='0',timestamp=null,actionid=null,timezone='it',attachmentformat=null,newmessagecount='1',volumegain='0.0',imapuser=null,vmcontext='default',fullname='100',voicemailbox='100',pager=null,saydurationminimum='2',calloperator='false',mailcommand='/usr/sbin/sendmail -t',serveremail='asterisk',sayenvelope='true',attachmessage='true',deletemessage='false',canreview='false',uniqueid=null,internalactionid='962420767_21',email=null,dialout=null,exitcontext=null,callback=null,server=null,language=null,saycid='false',systemHashcode=729217986] > > I cant' see anything that can help me to get the unique id of the message that I need to retrieve from the db where I save that. > > I can do that with Asterisk Java? > > Thanks! > > > 2013/1/15 Daniele Renda <dan...@gm...> >> Oh sorry, >> I realize that there is MessageWaitingEvent. This is what I need. >> >> Thanks! >> >> >> 2013/1/15 Daniele Renda <dan...@gm...> >>> Hi Miguel, >>> thanks for your reply. I have a ManagerEventListener added to my managerConnection and I need to receive a notification when an user leave a voicemail. >>> In your links seems that I've to send a request in order to receive a response about voicemail. >>> >>> Any suggestion? >>> >>> Thanks very much >>> >>> Daniele >>> >>> 2013/1/15 Miguel Santiago <m.s...@gm...> >>>> VoicemailUserEntryEvent >>> >>> >>> >>> >>> -- >>> Daniele Renda >> >> >> >> -- >> Daniele Renda > > > > -- > Daniele Renda > ------------------------------------------------------------------------------ > Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS > and more. Get SQL Server skills now (including 2012) with LearnDevNow - > 200+ hours of step-by-step video tutorials by Microsoft MVPs and experts. > SALE $99.99 this month only - learn more at: > http://p.sf.net/sfu/learnmore_122512 > _______________________________________________ > Asterisk-java-users mailing list > Ast...@li... > https://lists.sourceforge.net/lists/listinfo/asterisk-java-users |
From: Daniele R. <dan...@gm...> - 2013-01-15 23:11:12
|
Unfortunally the internalactionid is not present in the table of mysql :-( See here: http://www.voip-info.org/wiki/view/Asterisk+Voicemail+ODBC+storage I have already see the origtime but unfortunally the time that asterisk java send to me is different from that is store on db. So seems to not be a manner to mach the voicemail. I need the attachment .wav that is stored on the db; there is no way to have it in Java. Thanks 2013/1/16 Richard Lavoie <lav...@gm...> > What about the internalactionid ? > > Otherwise use the timestamp and the user to reteieve it from the db, I > honnestly doubt you'll receive 2 calls at the exact same time. > > > On 2013-01-15, at 17:19, Daniele Renda <dan...@gm...> wrote: > > Hi, > after some tests I reach this status: > -I added a listener to my managerConnection, I catch the > MessageWaitingEvent > -Where I catch MessageWaitingEvent i run: > VoicemailUsersListAction voicemailList = new > VoicemailUsersListAction(); > managerConnection.sendAction(voicemailList); > -Then I catch the VoicemailUserEntryEvent but when I print the > informations about the voicemail I can't see any information that can give > me the msg_id of the voicemail received. > This is the log of the event received: > 15/01/2013 23:15:09 DEBUG AsteriskManager:168 - > org.asteriskjava.manager.event.VoicemailUserEntryEvent[dateReceived='Tue > Jan 15 23:15:09 CET > 2013',maxmessagecount='100',sequencenumber=null,oldmessagecount=null,maxmessagelength='0',timestamp=null,actionid=null,timezone='it',attachmentformat=null,newmessagecount='1',volumegain='0.0',imapuser=null,vmcontext='default',fullname='100',voicemailbox='100',pager=null,saydurationminimum='2',calloperator='false',mailcommand='/usr/sbin/sendmail > -t',serveremail='asterisk',sayenvelope='true',attachmessage='true',deletemessage='false',canreview='false',uniqueid=null,internalactionid='962420767_21',email=null,dialout=null,exitcontext=null,callback=null,server=null,language=null,saycid='false',systemHashcode=729217986] > > I cant' see anything that can help me to get the unique id of the message > that I need to retrieve from the db where I save that. > > I can do that with Asterisk Java? > > Thanks! > > > 2013/1/15 Daniele Renda <dan...@gm...> > >> Oh sorry, >> I realize that there is MessageWaitingEvent. This is what I need. >> >> Thanks! >> >> >> 2013/1/15 Daniele Renda <dan...@gm...> >> >>> Hi Miguel, >>> thanks for your reply. I have a ManagerEventListener added to my >>> managerConnection and I need to receive a notification when an user leave a >>> voicemail. >>> In your links seems that I've to send a request in order to receive a >>> response about voicemail. >>> >>> Any suggestion? >>> >>> Thanks very much >>> >>> Daniele >>> >>> 2013/1/15 Miguel Santiago <m.s...@gm...> >>> >>>> VoicemailUserEntryEvent >>> >>> >>> >>> >>> >>> -- >>> Daniele Renda >>> >> >> >> >> -- >> Daniele Renda >> > > > > -- > Daniele Renda > > > ------------------------------------------------------------------------------ > > Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS > and more. Get SQL Server skills now (including 2012) with LearnDevNow - > 200+ hours of step-by-step video tutorials by Microsoft MVPs and experts. > SALE $99.99 this month only - learn more at: > http://p.sf.net/sfu/learnmore_122512 > > _______________________________________________ > Asterisk-java-users mailing list > Ast...@li... > https://lists.sourceforge.net/lists/listinfo/asterisk-java-users > > > > ------------------------------------------------------------------------------ > Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS > and more. Get SQL Server skills now (including 2012) with LearnDevNow - > 200+ hours of step-by-step video tutorials by Microsoft MVPs and experts. > SALE $99.99 this month only - learn more at: > http://p.sf.net/sfu/learnmore_122512 > _______________________________________________ > Asterisk-java-users mailing list > Ast...@li... > https://lists.sourceforge.net/lists/listinfo/asterisk-java-users > > -- Daniele Renda |
From: Yves A. <yv...@gm...> - 2013-01-15 23:15:13
|
hi, take a look at the classes MailboxCountAction and MailboxCountResponse MailboxCountAction mca= new MailboxCountAction("<your vm box number>"); MailboxCountResponse mcr = (MailboxCountResponse)<yourdefaultmanagerconnection>.sendAction(mca); yves Am 16.01.2013 00:02, schrieb Richard Lavoie: > What about the internalactionid ? > > Otherwise use the timestamp and the user to reteieve it from the db, I > honnestly doubt you'll receive 2 calls at the exact same time. > > On 2013-01-15, at 17:19, Daniele Renda <dan...@gm... > <mailto:dan...@gm...>> wrote: > >> Hi, >> after some tests I reach this status: >> -I added a listener to my managerConnection, I catch the >> MessageWaitingEvent >> -Where I catch MessageWaitingEvent i run: >> VoicemailUsersListAction voicemailList = new >> VoicemailUsersListAction(); >> managerConnection.sendAction(voicemailList); >> -Then I catch the VoicemailUserEntryEvent but when I print the >> informations about the voicemail I can't see any information that can >> give me the msg_id of the voicemail received. >> This is the log of the event received: >> 15/01/2013 23:15:09 DEBUG AsteriskManager:168 - >> org.asteriskjava.manager.event.VoicemailUserEntryEvent[dateReceived='Tue >> Jan 15 23:15:09 CET >> 2013',maxmessagecount='100',sequencenumber=null,oldmessagecount=null,maxmessagelength='0',timestamp=null,actionid=null,timezone='it',attachmentformat=null,newmessagecount='1',volumegain='0.0',imapuser=null,vmcontext='default',fullname='100',voicemailbox='100',pager=null,saydurationminimum='2',calloperator='false',mailcommand='/usr/sbin/sendmail >> -t',serveremail='asterisk',sayenvelope='true',attachmessage='true',deletemessage='false',canreview='false',uniqueid=null,internalactionid='962420767_21',email=null,dialout=null,exitcontext=null,callback=null,server=null,language=null,saycid='false',systemHashcode=729217986] >> >> I cant' see anything that can help me to get the unique id of the >> message that I need to retrieve from the db where I save that. >> >> I can do that with Asterisk Java? >> >> Thanks! >> >> >> 2013/1/15 Daniele Renda <dan...@gm... >> <mailto:dan...@gm...>> >> >> Oh sorry, >> I realize that there is MessageWaitingEvent. This is what I need. >> >> Thanks! >> >> >> 2013/1/15 Daniele Renda <dan...@gm... >> <mailto:dan...@gm...>> >> >> Hi Miguel, >> thanks for your reply. I have a ManagerEventListener added to >> my managerConnection and I need to receive a notification >> when an user leave a voicemail. >> In your links seems that I've to send a request in order to >> receive a response about voicemail. >> >> Any suggestion? >> >> Thanks very much >> >> Daniele >> >> 2013/1/15 Miguel Santiago <m.s...@gm... >> <mailto:m.s...@gm...>> >> >> VoicemailUserEntryEvent >> >> >> >> >> >> -- >> Daniele Renda >> >> >> >> >> -- >> Daniele Renda >> >> >> >> >> -- >> Daniele Renda >> ------------------------------------------------------------------------------ >> Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS >> and more. Get SQL Server skills now (including 2012) with LearnDevNow - >> 200+ hours of step-by-step video tutorials by Microsoft MVPs and experts. >> SALE $99.99 this month only - learn more at: >> http://p.sf.net/sfu/learnmore_122512 >> _______________________________________________ >> Asterisk-java-users mailing list >> Ast...@li... >> <mailto:Ast...@li...> >> https://lists.sourceforge.net/lists/listinfo/asterisk-java-users > > > ------------------------------------------------------------------------------ > Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS > and more. Get SQL Server skills now (including 2012) with LearnDevNow - > 200+ hours of step-by-step video tutorials by Microsoft MVPs and experts. > SALE $99.99 this month only - learn more at: > http://p.sf.net/sfu/learnmore_122512 > > > _______________________________________________ > Asterisk-java-users mailing list > Ast...@li... > https://lists.sourceforge.net/lists/listinfo/asterisk-java-users |
From: Daniele R. <dan...@gm...> - 2013-01-15 23:20:40
|
Thanks yves. >From MailboxCountResponse I can't get the msg_id of my new message. I can only get the number of new messages. I need to get all information that are stored in message table (see here http://www.voip-info.org/wiki/view/Asterisk+Voicemail+ODBC+storage).<http://www.voip-info.org/wiki/view/Asterisk+Voicemail+ODBC+storage> Unfortunally I can't link the event of new message that I receive in Asterisk Java with the message store natively in mysql table from asterisk. Thanks 2013/1/16 Yves A. <yv...@gm...> > MailboxCountAction -- Daniele Renda |
From: Miguel S. <m.s...@gm...> - 2013-01-15 23:34:52
|
I can't run any test in this moment, but I'll try tomorrow at work. If I discover any good strategy, l'll replay this wire again. Hope you'll achieve... El 16/01/2013 00:21, "Daniele Renda" <dan...@gm...> escribió: > Thanks yves. > From MailboxCountResponse I can't get the msg_id of my new message. I can > only get the number of new messages. > I need to get all information that are stored in message table (see here > http://www.voip-info.org/wiki/view/Asterisk+Voicemail+ODBC+storage).<http://www.voip-info.org/wiki/view/Asterisk+Voicemail+ODBC+storage> > Unfortunally I can't link the event of new message that I receive in > Asterisk Java with the message store natively in mysql table from asterisk. > > Thanks > > 2013/1/16 Yves A. <yv...@gm...> > >> MailboxCountAction > > > > > > -- > Daniele Renda > > > ------------------------------------------------------------------------------ > Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS > and more. Get SQL Server skills now (including 2012) with LearnDevNow - > 200+ hours of step-by-step video tutorials by Microsoft MVPs and experts. > SALE $99.99 this month only - learn more at: > http://p.sf.net/sfu/learnmore_122512 > _______________________________________________ > Asterisk-java-users mailing list > Ast...@li... > https://lists.sourceforge.net/lists/listinfo/asterisk-java-users > > |
From: Daniele R. <dan...@gm...> - 2013-01-15 23:36:37
|
Thank you very much Miguel! 2013/1/16 Miguel Santiago <m.s...@gm...> > I can't run any test in this moment, but I'll try tomorrow at work. > If I discover any good strategy, l'll replay this wire again. > Hope you'll achieve... > El 16/01/2013 00:21, "Daniele Renda" <dan...@gm...> escribió: > >> Thanks yves. >> From MailboxCountResponse I can't get the msg_id of my new message. I can >> only get the number of new messages. >> I need to get all information that are stored in message table (see here >> http://www.voip-info.org/wiki/view/Asterisk+Voicemail+ODBC+storage).<http://www.voip-info.org/wiki/view/Asterisk+Voicemail+ODBC+storage> >> Unfortunally I can't link the event of new message that I receive in >> Asterisk Java with the message store natively in mysql table from asterisk. >> >> Thanks >> >> 2013/1/16 Yves A. <yv...@gm...> >> >>> MailboxCountAction >> >> >> >> >> >> -- >> Daniele Renda >> >> >> ------------------------------------------------------------------------------ >> Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS >> and more. Get SQL Server skills now (including 2012) with LearnDevNow - >> 200+ hours of step-by-step video tutorials by Microsoft MVPs and experts. >> SALE $99.99 this month only - learn more at: >> http://p.sf.net/sfu/learnmore_122512 >> _______________________________________________ >> Asterisk-java-users mailing list >> Ast...@li... >> https://lists.sourceforge.net/lists/listinfo/asterisk-java-users >> >> > > ------------------------------------------------------------------------------ > Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS > and more. Get SQL Server skills now (including 2012) with LearnDevNow - > 200+ hours of step-by-step video tutorials by Microsoft MVPs and experts. > SALE $99.99 this month only - learn more at: > http://p.sf.net/sfu/learnmore_122512 > _______________________________________________ > Asterisk-java-users mailing list > Ast...@li... > https://lists.sourceforge.net/lists/listinfo/asterisk-java-users > > -- Daniele Renda |
From: Yves A. <yv...@gm...> - 2013-01-15 23:58:40
|
ah, i see... sorry, but i have no experience in storing vm in db... i always used files and have no problems accessing the files, because i know the directory they are stored, can fetch filedate and so on... maybe you could explain your objective in detail, so i can understand the story behind... there is almost always a solution... yves Am 16.01.2013 00:20, schrieb Daniele Renda: > Thanks yves. > From MailboxCountResponse I can't get the msg_id of my new message. I > can only get the number of new messages. > I need to get all information that are stored in message table (see > here > http://www.voip-info.org/wiki/view/Asterisk+Voicemail+ODBC+storage). > <http://www.voip-info.org/wiki/view/Asterisk+Voicemail+ODBC+storage> > Unfortunally I can't link the event of new message that I receive in > Asterisk Java with the message store natively in mysql table from > asterisk. > > Thanks > > 2013/1/16 Yves A. <yv...@gm... <mailto:yv...@gm...>> > > MailboxCountAction > > > > > > -- > Daniele Renda > > > ------------------------------------------------------------------------------ > Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS > and more. Get SQL Server skills now (including 2012) with LearnDevNow - > 200+ hours of step-by-step video tutorials by Microsoft MVPs and experts. > SALE $99.99 this month only - learn more at: > http://p.sf.net/sfu/learnmore_122512 > > > _______________________________________________ > Asterisk-java-users mailing list > Ast...@li... > https://lists.sourceforge.net/lists/listinfo/asterisk-java-users |
From: Daniele R. <dan...@gm...> - 2013-01-16 08:49:34
|
Hi, thanks for your reply. I need to run some actions when the pbx receive a new vm. I need to get all details of this new vm and then notify the user in several way (alert notifications, email and so on). I know that with voicemail.conf I can manage the sent of vm by email but this is not enought for me. So I was looking for a way to get the notify of a new vm in Java (with MessageWaitingEvent I can do that) and then get the details of the new vm (I can't do that). Thanks! 2013/1/16 Yves A. <yv...@gm...> > ah, > i see... sorry, but i have no experience in storing vm in db... i always > used files and have no problems accessing > the files, because i know the directory they are stored, can fetch > filedate and so on... > maybe you could explain your objective in detail, so i can understand the > story behind... there is almost always > a solution... > > yves > > Am 16.01.2013 00:20, schrieb Daniele Renda: > > Thanks yves. > From MailboxCountResponse I can't get the msg_id of my new message. I > can only get the number of new messages. > I need to get all information that are stored in message table (see here > http://www.voip-info.org/wiki/view/Asterisk+Voicemail+ODBC+storage).<http://www.voip-info.org/wiki/view/Asterisk+Voicemail+ODBC+storage> > Unfortunally I can't link the event of new message that I receive in > Asterisk Java with the message store natively in mysql table from asterisk. > > Thanks > > 2013/1/16 Yves A. <yv...@gm...> > >> MailboxCountAction > > > > > > -- > Daniele Renda > > > ------------------------------------------------------------------------------ > Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS > and more. Get SQL Server skills now (including 2012) with LearnDevNow - > 200+ hours of step-by-step video tutorials by Microsoft MVPs and experts. > SALE $99.99 this month only - learn more at:http://p.sf.net/sfu/learnmore_122512 > > > > _______________________________________________ > Asterisk-java-users mailing lis...@li...https://lists.sourceforge.net/lists/listinfo/asterisk-java-users > > > > > ------------------------------------------------------------------------------ > Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS > and more. Get SQL Server skills now (including 2012) with LearnDevNow - > 200+ hours of step-by-step video tutorials by Microsoft MVPs and experts. > SALE $99.99 this month only - learn more at: > http://p.sf.net/sfu/learnmore_122512 > _______________________________________________ > Asterisk-java-users mailing list > Ast...@li... > https://lists.sourceforge.net/lists/listinfo/asterisk-java-users > > -- Daniele Renda |
From: Miguel S. <m.s...@gm...> - 2013-01-16 10:30:13
|
Hi Daniele, Assuming MessageWaitingEvent is triggered when someone leaves voicemail, maybe you can do this : - First, add a field to voicemessages table (example : `message_status` Integer Default 0) to allow you to manage your own control (the fact that you extend your ODBC Asterisk tables does not causes a wrong behavior, I´ve tried and check extending some other tables, as cdr, on my implementations, and everything works fine) - Get from the event then name of the mailbox using *getMailbox<http://www.asterisk-java.org/development/apidocs/org/asteriskjava/manager/event/MessageWaitingEvent.html#getMailbox()> *() method. - Select all records corresponding to the mailbox obtained from the event, whose message_status let you know that has not been already processed by your java process. Example : "Select * From `voicemessages` Where mailboxuser = [mailbox] and status = 0" - So, you can process each record obtained from the query, setting a new status when all the work is done Example, message_status = 1 (processed) I think you can get all the information you need from the table, including the recording file stored into the blob field `recording` Note you can obtain the email-address as well querying voicemail.conf Hope it helps ! 2013/1/16 Daniele Renda <dan...@gm...> > Hi, > thanks for your reply. > I need to run some actions when the pbx receive a new vm. I need to get > all details of this new vm and then notify the user in several way (alert > notifications, email and so on). > I know that with voicemail.conf I can manage the sent of vm by email but > this is not enought for me. > > So I was looking for a way to get the notify of a new vm in Java (with > MessageWaitingEvent I can do that) and then get the details of the new vm > (I can't do that). > > Thanks! > > > 2013/1/16 Yves A. <yv...@gm...> > >> ah, >> i see... sorry, but i have no experience in storing vm in db... i always >> used files and have no problems accessing >> the files, because i know the directory they are stored, can fetch >> filedate and so on... >> maybe you could explain your objective in detail, so i can understand the >> story behind... there is almost always >> a solution... >> >> yves >> >> Am 16.01.2013 00:20, schrieb Daniele Renda: >> >> Thanks yves. >> From MailboxCountResponse I can't get the msg_id of my new message. I >> can only get the number of new messages. >> I need to get all information that are stored in message table (see >> here http://www.voip-info.org/wiki/view/Asterisk+Voicemail+ODBC+storage).<http://www.voip-info.org/wiki/view/Asterisk+Voicemail+ODBC+storage> >> Unfortunally I can't link the event of new message that I receive in >> Asterisk Java with the message store natively in mysql table from asterisk. >> >> Thanks >> >> 2013/1/16 Yves A. <yv...@gm...> >> >>> MailboxCountAction >> >> >> >> >> >> -- >> Daniele Renda >> >> >> ------------------------------------------------------------------------------ >> Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS >> and more. Get SQL Server skills now (including 2012) with LearnDevNow - >> 200+ hours of step-by-step video tutorials by Microsoft MVPs and experts. >> SALE $99.99 this month only - learn more at:http://p.sf.net/sfu/learnmore_122512 >> >> >> >> _______________________________________________ >> Asterisk-java-users mailing lis...@li...https://lists.sourceforge.net/lists/listinfo/asterisk-java-users >> >> >> >> >> ------------------------------------------------------------------------------ >> Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS >> and more. Get SQL Server skills now (including 2012) with LearnDevNow - >> 200+ hours of step-by-step video tutorials by Microsoft MVPs and experts. >> SALE $99.99 this month only - learn more at: >> http://p.sf.net/sfu/learnmore_122512 >> _______________________________________________ >> Asterisk-java-users mailing list >> Ast...@li... >> https://lists.sourceforge.net/lists/listinfo/asterisk-java-users >> >> > > > -- > Daniele Renda > > > ------------------------------------------------------------------------------ > Master Java SE, Java EE, Eclipse, Spring, Hibernate, JavaScript, jQuery > and much more. Keep your Java skills current with LearnJavaNow - > 200+ hours of step-by-step video tutorials by Java experts. > SALE $49.99 this month only -- learn more at: > http://p.sf.net/sfu/learnmore_122612 > _______________________________________________ > Asterisk-java-users mailing list > Ast...@li... > https://lists.sourceforge.net/lists/listinfo/asterisk-java-users > > -- Miguel Santiago |