Ben Vlaeminck

Members
  • Content Count

    27
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Ben Vlaeminck

  • Rank
    Member

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Ben Vlaeminck

    UnconditionalForwarding other user

    Hi Jorn, if you don't have a solution yet, please look here: Article from Tom Wellige about this issue Good luck Ben
  2. Hi all, We use Persistent Variables in ECR scripts for IVR functions for a customer. after update to v11.20.0.2 (from 11.10.0) the IVR functionality broke. more in detail, the information from a Persistent Variable was not passed on to the next level ECR script. Looking in IpPbxSrv log, we found Swyxware was not able to logon to the IpPbxExtensions DB on the local SQL server. Where as immediately befor the update, this was not a problem! So, we're stuck now for this customer, he can't use his ECR scripts for the moment. Anyone experienced this? Any solution? How to troubleshoot? No need to point out this is urgent for the customer... best regards Ben
  3. Ben Vlaeminck

    Trunk SIP problem

    Hi Kevin, We use SIP trunks for a couple of years now, and I can tell this issue normally has nothing to do with SIP trunks vs ISDN lines. Unless there's something in the Failover config of the SIP trunk (Provider side). First of all, can you tell a little more about the setup? version Swyxware, call routing setings for the receiving user, client system of the call receiver, where are you calling from? is the call to a mobile number or Swyx client on the smartphone? etc... look forward to helping you out... regards Ben
  4. Hi all, We use Persistent Variables in ECR scripts for IVR functions for a customer. aftr update to v11.20.0.2 (from 11.10.0) the IVR functionality broke. more in detail, the ionformation from a Persistent Variable was not passed on to the next lever ECR script. looking in IpPbxSrv log, we found Swyxware was not able to logon to the Extensions DB on the local SQL server. Where as immediately befor the update, this was not a problem! So, we're stuck now for this customer, he can't use his ECR scripts for the moment. Anyone experienced this? Any solution? How to troubleshoot? No need to point out this is urgent for the customer... best regards Ben
  5. My local SQL server is a Standard server, v 2014, instance = MSSQLSERVER. I'm getting errors (in IpPbxSrv) like this: quote 30 19:52:55.558 0017a4 Info SrvScript 05F93660 00000015 SPBXScript::OutputTrace () ---------> PersistentVariable.Retrieve 30 19:52:55.558 0017a4 Info SrvScript 05F93660 00000015 SPBXScript::OutputTrace () ---------> PersistentVariable.OpenDatabase 30 19:52:55.558 0017a4 Info SrvScript 05F93660 00000015 SPBXScript::OutputTrace () ---------> PersistentVariable.CalcConnectString 30 19:52:55.558 0017a4 Info SrvScript 05F93660 00000015 SPBXScript::OutputTrace () g_sPersistentVariableServerName: cs-swyx\MSSQLSERVER 30 19:52:55.558 0017a4 Info SrvScript 05F93660 00000015 SPBXScript::OutputTrace () g_sPersistentVariableDatabaseName: 30 19:52:55.558 0017a4 Info SrvScript 05F93660 00000015 SPBXScript::OutputTrace () g_sPersistentVariableConnectString: 30 19:52:55.558 0017a4 Info SrvScript 05F93660 00000015 SPBXScript::OutputTrace () sServerName: cs-swyx\MSSQLSERVER 30 19:52:55.558 0017a4 Info SrvScript 05F93660 00000015 SPBXScript::OutputTrace () sDatabaseName: IpPbxExtensions 30 19:52:55.558 0017a4 Info SrvScript 05F93660 00000015 SPBXScript::OutputTrace () ConnectString: Provider=sqloledb;Data Source=cs-swyx\MSSQLSERVER;Initial Catalog=IpPbxExtensions;Integrated Security=SSPI 30 19:52:55.559 0017a4 Info SrvScript 05F93660 00000015 SPBXScript::OutputTrace () ConnectStringExpress: Provider=sqloledb;Data Source=cs-swyx\MSSQLSERVER\SQLEXPRESS;Initial Catalog=IpPbxExtensions;Integrated Security=SSPI 30 19:52:55.559 0017a4 Info SrvScript 05F93660 00000015 SPBXScript::OutputTrace () <--------- PersistentVariable.CalcConnectString 30 19:52:55.559 0017a4 Info SrvScript 05F93660 00000015 SPBXScript::OutputTrace () Using none local SQL Express connect string. 30 19:52:55.559 0017a4 Info SrvScript 05F93660 00000015 SPBXScript::OutputTrace () Opening database... 30 19:52:55.559 0017a4 Info SrvScript 05F93660 00000015 SPBXScript::OutputTrace () Error opening database! (-2147467259) 30 19:52:55.559 0017a4 Info SrvScript 05F93660 00000015 SPBXScript::OutputTrace () [DBNETLIB][ConnectionOpen (ParseConnectParams()).]Invalid connection. 30 19:52:55.559 0017a4 Info SrvScript 05F93660 00000015 SPBXScript::OutputTrace () bReturn = False 30 19:52:55.559 0017a4 Info SrvScript 05F93660 00000015 SPBXScript::OutputTrace () <--------- PersistentVariable.OpenDatabase 30 19:52:55.560 0017a4 Info SrvScript 05F93660 00000015 SPBXScript::OutputTrace () bReturn: False unquote In the Run GSE Action box I only changed ServerName from default ("") to "cs-swyx\MSSQLSERVER" with the default value (""), it produced similar error, but mentioned cs-swyx\SQLEXPRESS.. please advise for correct connection settings thanks Ben
  6. We are hosting Swyx PBx for our customers based on Swyxware Datacenter Edition. This means the SQL server containing the IPPBx Database is on another (Virtual) Server. I know the both the IP-address and the login credentials for that server, but I cannot find a way of conection File Explorer to a specific IPPbx database on that server. How do I do this? What syntax to enter in the Connect dialog box of File Explorer? thanks Ben
  7. Ben Vlaeminck

    Use of Persistent Variables in consecutive rules

    Works perfect Tom! And is much simpler than I originally thought. Thanks a million.... Best regards Ben
  8. Ben Vlaeminck

    Use of Persistent Variables in consecutive rules

    that's clear to me, Tom; I start working on it and confirm when ready.
  9. Ben Vlaeminck

    Use of Persistent Variables in consecutive rules

    Tom, Any active rule, but not the first one I presume, because the GSe action is being called to connect to the DB only after that Start block in the first rule. Is that assumption correct? or does that sequence doens't matter?
  10. Ben Vlaeminck

    Use of Persistent Variables in consecutive rules

    Hi Tom, thanks for the quick reply. This answers my question partially. My first rule where I set the Language, works perfectly, I can see the selected language in the DB table as value of the Persistent Variable. In the second rule, I already figured out I need to include the GSE Action Block. Next to that, in that second rule I want to read the value of the Persistent Variable from the table. Here's what I have in a script Block in the second rule: Dim sLanguageForCallId sLanguageForCallID.Name = "Language_" & PBXCall.CallId sLanguagePrefix = sLanguageForCallID.Value Should this do the Job? What is missing / wrong? Do I understand correctly that if I place following in the Start Block of the first rule, it is available for all following rules in the same user call routing rules? Dim sLanguageForCallID Set sLanguageForCallID = new PersistentVariable sLanguageForCallID.Name = "Language_" & PBXCall.CallId
  11. Hi all, I'm New to Persistent Variables... but managed to get them working within 1 rule. I am a bit confused about the exact 'preparation' to use Persistent Variables in consecutive Call routing rules for a particular user. As outcome of another Post in this forum , the use of Persistent Variables was the best/only solution. Now, I want to implement this, and all works fine inside one rule. When Rules are SKipped (from within the rule), in the next rule I need to access the same Persistent Variable as used in the previous rule. I presume I need to include the GSE Action Block in the next rule and declare (Dim PV and Set as New PV) the Persistent variable again? Thanks for your input in these
  12. Ben Vlaeminck

    Use of Variable to build wav filename to announce

    Great minds think alike... all the best
  13. Ben Vlaeminck

    Use of Variable to build wav filename to announce

    I already figured that out, but thanks for your thought about this. As a solution I was wondering if there could be a function or procedure to delete a PV after the call is ended. If not feasable, a SQL script will need to run on a scheduled base, to delete older records from the table; i.e. records older than today... (or last week/month, leaving resources for troubleshooting passed issues in this respect). As an addition, a more easy / flexible built-in system feature to handle multilanguage would be nice to have. If this solution works out, I may write an addendum to the already available article on the forum about Best Practices to handle Multilanguage announcements . thanks for thinking with me! I'll keep you informed.
  14. Ben Vlaeminck

    Use of Variable to build wav filename to announce

    thanks Tom, I will give this a try in a test setup and confirm results as soon as available.
  15. Ben Vlaeminck

    Use of Variable to build wav filename to announce

    Hi Tom, Is it possible to create a Persistent Variable that who's name is composed of a fixed part and a variable part, whereby the variable part is the CallID() system variable. this way, every unique call maintains it's for the call unique contents that can be checked anywhere in the rules...