You are currently watching the archived read-only Swyx Forum page.
Please click here to head over to the new page.
After 7 1/2 years it was time for Swyx Forum to get some new clothes, more fancy, more modern and more easy to use.
Please note that the content of the old forum wasn't moved, but instead became a read only archive for all times.
Also all existing user accounts were not moved. You would need to register yourself a new account on the new page.
IpPbxImportRR is a command line tool for importing or exporting routing records to or from a SwyxWare v6.11 or newer.
This is a sample application showing how to use the SwyxWare Configuration API (CDS API).
The following is a list of all IpPbxImportRR features:
The following is a list of requirements of IpPbxImportRR:
IpPbxImportRR command line parameters:
IpPbxImportRR -export -server swyxsrv01 -file routingrecords.xls
Exports complete routing table from SwyxServer swyxsrv01 to excel file routingrecords.xls. Uses current windows account to authenticate at SwyxServer. The account needs to have the "SwyxWare system administrators" profile.
IpPbxImportRR -e -s swyxsrv01 -u "Otto Admin" -p "1234" -f rr.csv
Exports complete routing table from SwyxServer swyxsrv01 to csv file rr.csv. Uses username "Otto Admin" and password "1234" to authenticate at SwyxServer. Otto Admin needs to have the "SwyxWare System Administrators" profile.
IpPbxImportRR -export -file routingrecords.xlsx
Exports complete routing table from local SwyxServer to routingrecords.xlsx. Uses current windows account to authenticate at SwyxServer. The account needs to have the "SwyxWare system administrators" profile.
IpPbxImportRR -i -r -f newroutingrecords.xls
Imports routing records defined in newroutingrecords.xls into local SwyxServer. Uses current windows account to authenticate at SwyxServer. The account needs to have the "SwyxWare system administrators" profile. All existing routing records with a description starting with "ImportRR" are removed before the new ones are imported.
Import your existing routing records to get a sample xls file or use one of the template files shipped with this program.
Excel 2007 must be probably installed to read and write xlsx files. I've not checked if the Microsoft Jet OLEDB driver is available without it.
The Microsoft Jet OLEDB driver used for reading and writing excel files cannot handle excel data types properly. Threrefore all fields are exported as strings. The import can handle numeric and boolean fields, too. IpPbxImportRR interprets string values "1" and "true" as boolean true if it expects a boolean value.
For the time restrictions ensure to always specify start and end time with format HH:mm.
The SourceUser field can either be empty or must contain an existing user name. If the name is not found, the record will be imported without a source user restriction.
The SourceGroup field can either be empty or must contain an existing group name. If the name is not found, the record will be imported without a source group restriction.
The SourceLocation field can either be empty or must contain an existing location name. If the name is not found, the record will be imported without a source location restriction.
Note: Don't try importing more than a few thousand routing records. SwyxWare (including the new v6.12) is not able to handle big amounts of routing records at the moment.
This is a Swyx Forum Open Source Project. All support, enhancement and bug requests must be placed into the project's forums.No other support is available!
Use the Using IpPbxImpoirtRR forum for all usage related topics, use the Development forum for all development, enhancement related topics.
Use the project's issue tracker to check if a problem you want to report is already known.
In regard of the license being provided there is neither a guaranteed response time for support requests nor a guaranteed fix time.
This is a Swyx Forum Open Source Project.
Copyright (c) by Swyx Forum
Copyright (c) by Martin Hüser
All Rights Reserved.
Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:
The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software.
THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
SWYX FORUM © 2007-2014 Tom Wellige