CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Developer Discussion (Moderator: Donald Lobo) »
  • CiviVoice
Pages: [1]

Author Topic: CiviVoice  (Read 1059 times)

bpmccain

  • I post frequently
  • ***
  • Posts: 255
  • Karma: 5
  • CiviCRM version: 4.1
  • CMS version: Drupal 7.12
  • MySQL version: 5.2
  • PHP version: 5.2
CiviVoice
September 11, 2013, 08:04:58 pm
I'm working on a Voice feature similar to CiviMail and CiviSMS. Basically allowing a user to upload an mp3 or wav file and have it call a mailing list using a service such as Twilio. The workflow will be very similar to CiviSMS.

I've obviously disabled the compose message section and just left the Upload file part, which I have configured for a wav or mp3 file.

Where I am now is that I want the uploaded file to be stored in a directory, renamed with a unique filename, and have that filename stored in civicrm_mailing table in the body_text column.

So my question at the moment is what happens to the uploaded files for CiviMail and CiviSMS? Does Civi simply read through, take out the text and save it to the database and delete the file itself? Or are they saved somewhere?

Brian

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: CiviVoice
September 11, 2013, 08:37:32 pm

hopefully you will be releasing the code as open source, right?

check the civicrm_file and civicrm_entity_file table. the files are stored there and attached to the mailing object

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

bpmccain

  • I post frequently
  • ***
  • Posts: 255
  • Karma: 5
  • CiviCRM version: 4.1
  • CMS version: Drupal 7.12
  • MySQL version: 5.2
  • PHP version: 5.2
Re: CiviVoice
September 12, 2013, 05:44:06 am
Absolutely  ;D Although the first version may need a little work to make it a more general solution.

I've got a Click2Call Voip solution working as well at the moment, that I would like to make a part of the release. Again, may need some help to make it more general.

Thanks Lobo.

Brian

bpmccain

  • I post frequently
  • ***
  • Posts: 255
  • Karma: 5
  • CiviCRM version: 4.1
  • CMS version: Drupal 7.12
  • MySQL version: 5.2
  • PHP version: 5.2
Re: CiviVoice
September 12, 2013, 07:41:57 am
Hi Lobo,

I looked into this and I assume this is how it is done for mailing attachments, but does not appear to be the case for when you upload a txt file with the content of the SMS for example.

Anyway, I'll just have to move some code around and I should be able to achieve this in a similar way to which attachments are dealt with. Thanks.

Brian

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: CiviVoice
September 12, 2013, 09:02:10 am

I think for non-text stuff, keeping them in files might be easier to debug / ship around etc and hence attachments might be a wee bit better

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

bpmccain

  • I post frequently
  • ***
  • Posts: 255
  • Karma: 5
  • CiviCRM version: 4.1
  • CMS version: Drupal 7.12
  • MySQL version: 5.2
  • PHP version: 5.2
Re: CiviVoice
September 28, 2013, 06:05:18 am
I wrote a Wiki on the work I've been doing. I'd appreciate thoughts and feedback.

http://wiki.civicrm.org/confluence/display/CRMDOC/CiviVoice

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: CiviVoice
September 28, 2013, 09:13:59 am

very very cool indeed :) thanx a lot for sharing. A couple of thoughts and comments:

a. Would be great if you can package and hence distribute this as an extension

b. Should be fairly easy to add the twilio connect data and caller ID functionality as civi forms / pages. civix can give u a running start for this and we can help out on irc

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

Owen

  • I post occasionally
  • **
  • Posts: 83
  • Karma: 2
    • Leukaemia & Lymphoma Research
  • CiviCRM version: 4.3.4
  • CMS version: Drupal 7
  • MySQL version: -
  • PHP version: -
Re: CiviVoice
September 28, 2013, 12:47:28 pm
On incoming calls, we've written hacky code that hooks up our Acatel PBX so that on putting the phone down the user is asked if they want to log the call and presents them a form with the contact already selected (if we have their phone number in Civi) they can then fill out the details of the call for the activity.

  • On putting the phone down the user is presented with a popup asking if they want to log the call to Civi.
  • If they do it redirects to a php script which searches Civi for the phone number via the api.
  • It then redirects to a webform-civi Drupal page with the contact id of the caller so that the user can fill in the subject of the call and the details, the webform then creates the activity between the logged in user and the contact.
  • If it finds more than one contact with the phone number or no contact with the phone number it redirects to the same form but the user then has to search for the contact to log the activity to. They are also presented with the option of adding the phone number to the contact.

So far it's only on my machine and not with any users, but I intend to start testing it with a few next week. The code we've written wouldn't really work without PIMphony the Acatel software and requires a VB file so wouldn't be easily shareable, however I think the process flow works well.   

Making interactions with our supporters easily loggable to Civi by users is something I'm quite interested in (I'll be talking about it at CiviCon).
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Developer Discussion (Moderator: Donald Lobo) »
  • CiviVoice

This forum was archived on 2017-11-26.