Jump to content

Rodolphe

Members
  • Posts

    13
  • Joined

  • Last visited

Everything posted by Rodolphe

  1. exactly after more tests, the best request i found was : SELECT * FROM `cdr` WHERE trunkid > 0 and extension = '' and i have to look after "remoteparty" field to know for Outbound Call the callee and for Inbound Call the caller If during the call, there was a lot of : hold, transfer, *52 for cellphone, etc... the results will be the summary of the call but the "from" and "to" field will be not correct afterall, so i check the "remoteparty". In case of call in huntgroup or ivr node, with this request, il will not know which extension pick up the phone. In these cases, i have to do another request to have more detail. What do you think about all this ??? i'll continue my tests and let you know if i'm good Thx for your answers Rudwolf
  2. Indeed, the result seems correct but all call to cellphone when you have your cellphone in "Accounts / Redirection / Cell Phone Number" and "Include the cell phone in calls to extension" is set to "Immediatly" are recorded. I have to find a better request Thx for your help
  3. thx il will do some tests
  4. or SELECT * FROM `cdr` WHERE trunkname <> '' and keep only entries with "ipadr" field not empty what do you think ? thx in advance rudwolf
  5. if i select entries like this : SELECT * FROM `cdr` WHERE trunkname <> '' and when i have two entries with same "primarycallid" i only keep the entrie where "primarycallid" = "callid" (in case of cellphone call) should i be good ?
  6. thx for your reply so what the difference between "primarycallid" and "callid" ? because for one call, there are 3 entries with the same "primarycallid" but 3 different "callid", and sometimes primarycallid = callid. If i check where trunk is not empty i could have 2 entries, one with type O and one with type I but i think it will be when snomONE call cellphone extension (type O) hard to do script in this condition
  7. Hello, I just tested the implementation of CDRs in a MySQL database via PHP script available here: http://wiki.pbxnsip.com/index.php?title=JSON_CDR and everything works well. Each call is recorded in the database. But I have trouble reading the data and understand them. Indeed, for one call there may be three entries and the type is both O and I My goal is to make a script statistics (number of incoming calls, number of outgoing calls, average length, etc ...), can you help me to understand these values ​​and how to use them. Thank you. Rudwolf
  8. Hi, i've just installed a snomONE v5.0.9 on a linux debian 32bits and i follow this link to configure the fax2mail option http://wiki.snomone.com/index.php?title=Fax#Fax2Email_Setup but first, i never see the FAX option as indicated in the wiki on the mailbox extension, there is just Enabled or Disabled. Any idea ??? It's now auto in v5.0.9 ? Thx Rudwolf
  9. Hi, i have same problem on version 1.0.0.132. When an extension is unregistered, it still online on UC Client. (nothing in log) Any idea ? Rodolphe
  10. Hi, FYI, by dint of searching and reinstall my snomONE I found why the callback function was not proposed in the Personal Virtual Assistant. Indeed, for this option to be proposed in the Personal Virtual Assistant, it is essential that a "Calling Card" account is present in the system (leave the default options). If this service does not exist then it will only offer 3 choices (outbound call, mailbox, Auto Attendant). More, to change the Personal Virtual Assistant language in French, you have to select language French in the "Web Language" and not the "IVR Language" (I do not know why ) for the extension parameters (or domain default parameters). No logic in it but hey it works! Tested on version 4 and 5 Sorry for my english (google translate) cause i'm french Bye Rudwolf
  11. Hi, FYI, by dint of searching and reinstall my snomONE I found why the callback function was not proposed in the Personal Virtual Assistant. Indeed, for this option to be proposed in the Personal Virtual Assistant, it is essential that a "Calling Card" account is present in the system (leave the default options). If this service does not exist then it will only offer 3 choices (outbound call, mailbox, Auto Attendant). More, to change the Personal Virtual Assistant language in French, you have to select language French in the "Web Language" and not the "IVR Language" (I do not know why ) for the extension parameters (or domain default parameters). No logic in it but hey it works! Tested on version 4 and 5 Sorry for my english (google translate) cause i'm french Bye Rudwolf
  12. Rodolphe

    CallBack

    Salut, pour info, à force de chercher et de réinstaller mon snomONE j'ai trouvé pourquoi la fonction Callback n'était plus proposée dans le Personal Virtual Assistant. Pour rappel le Personal Virtual Assistant est le menu proposé lorsque l'on appelle un Auto Attendant (Standard Automatique) de l'extérieur avec son GSM qui lui est référencé dans l'onglet "Redirection" de l'extension. En effet, pour que cette option soit proposée dans le Personal Virtual Assistant, il faut absolument qu'un service (account) "Calling Card" soit présent dans le système (laisser les options par défaut), si ce service n'existe pas alors il ne proposera que 3 choix (outbound call, mailbox, auto attendant). De plus pour avoir le Personal Virtual Assistant en français il faut sélectionner pour l'extension concernée la langue FR dans le champ "Web Language" et non pas dans le champ "IVR Language" (pourquoi je ne sais pas ). Rien de logique dans tout cela mais bon ça marche ! Ce problème et par conséquent cette solution concerne autant les versions en v4 et v5 (testé sur les deux). A+ Rudwolf
  13. Rodolphe

    CallBack

    Salut, moi aussi j'ai le même problème, je suis en version Free en v4.5.0.1075 sur une Debian. J'ai un snomONE Office sur la même version et sur celui-ci ça marche. J'ai mis à jour en version v4.5.0.1090 mais toujours pas le choix du Callback en 2. J'ai même désinstallé complètement mon snomONE de ma Debian et réinstallé en laissant tout par défaut et rien y fait. Pourtant sur une version 5.03 cela marche bien. Et je suis pourtant sûr que cela marchait avant. A+ Rudwolf
×
×
  • Create New...