Re: [Asterisk-java-users] Receive Voicemail event

[Miguel S. <m.s...@gm...>]

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