Ben Vlaeminck

Members
  • Content count

    23
  • 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. 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
  2. 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
  3. 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
  4. Ben Vlaeminck

    Use of Persistent Variables in consecutive rules

    that's clear to me, Tom; I start working on it and confirm when ready.
  5. 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?
  6. 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
  7. 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
  8. Ben Vlaeminck

    Use of Variable to build wav filename to announce

    Great minds think alike... all the best
  9. 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.
  10. 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.
  11. 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...
  12. Ben Vlaeminck

    Use of Variable to build wav filename to announce

    Hi Tom, or others? Please pick this one up, it's blocking my customer... I was on the go to use Persistent Variables for this one, i.e. setting the LanguageChoice variable as a Persistent Variable, but I don't think that will work. - first call comes in, and Dutch is choosen; messages will announce in Dutch - While first call is still in the Call Routing script, with possible other announcements to come, a second call comes in, setting the LanguageChoice to English; this will make that my first call will hear coming messages in english too, I should think... So, I'm looking for a way to pass my LanguageChoice variable contents from rule to rule for a specific call only. for another call LanguageChoice can hold another value, but also needed in multiple consecutive rules from the same user Call Routing. thanks for your ideas about this! Ben
  13. Ben Vlaeminck

    Use of Variable to build wav filename to announce

    Tom, one more problem... This works perfectly within the rule the variable content was set, all announcements follow correct language. But in that rule, at the end I Skip the rule to go to the next rule in CRM, and there the content of the variable is lost... what do i do wrong? what do i mis?
  14. Ben Vlaeminck

    Use of Variable to build wav filename to announce

    thanks Tom, Tested and works perfectly case closed best regards Ben
  15. Ben Vlaeminck

    Use of Variable to build wav filename to announce

    Thank you Tom, I noticed this article already, but it's not really what I'm looking for. The full purpose of my setup is to use the Language Choice not only in this rule, but also in rules following this one to determine the language of ALL announcements played for this call. Not by checking theVariable value and havind 2 or 3 different blocks for 2 or 3 different language announcements. One Block should do the job for any language. All other Announcements have also been setup in order to comply to this structure "LC_NameOfAnnouncement.wav" whereby LC is the LanguageChoice. Is this possible?