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:

• Exports the complete routing table of a Swyxware system into a Microsoft Excel file or CSV file.
• Imports routing records from an Microsoft excel file or CSV file to a SwyxWare system.
• Before  importing existing routing records with description "ImportRR*" can be deleted instead adding records to the existing ones.

The following is a list of requirements of IpPbxImportRR:

• ImportRR is compatible with SwyxWare v6.11 or newer.
• SwyxWare Administration or SwyxServer should be
  installed on the system where this program is executed.

IpPbxImportRR command line parameters:

-i	-import	import routing records from file to SwyxServer
-e	-export	export routing records from SwyxServer to file
-s	-server	IpPbxServer to use (localhost is used when not specified)
-r	-replace	replace existing records which have a description starting with "ImportRR"
-f	-file <filename>	process <filename>. Can be .xls, .xlsx or .csv
-u	-username <username>	user name to login to SwyxServer. Uses current windows account if not specified
-p	-password <password>	password for login to SwyxServer. Required when username is specified
-?		Show help

Examples

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.

IpPbxImportRR

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.