Bulk loading extensions

csvload.pl

requires perl text/CSV - get it from sailpbx.com

wget http://www.sailpbx.com/sail/sail-3.1/perl-Text-CSV-1.12-1.el5.rf.noarch.rpm
rpm -Uvh perl-Text-CSV-1.12-1.el5.rf.noarch.rpm

You will find csvload.pl in /opt/sark/scripts. Before you use it make sure you take a copy of your database (/opt/sark/db/sark.db).

usage is as follows

perl /opt/sark/scripts/csvload.pl csvfilename {dbfilename}

dbfilename is only necessary if you are working on a copy of sark.db - leave it blank to work on /opt/sark/db/sark.db.

Create a CSV file using your favourite spreadsheet tool. The columns are as follows...

 *	$macaddr      		optional
 *	$vendordevice             any valid device type (see below)
 *	$pkey 			extension number or 'auto' to generate
 *	$name  			users callerid name
 *	$ddi  			        associate a DDI with this extension (optional)
 *	$location                    local/remote (default is local)	
 *	$cluster                     cluster (default is 'default')

At its simplest level you can create a spreadsheet with only three columns filled out; i.e. the device, key and the name. so a valid csv might look like this

,General SIP,auto,Alice
,General SIP,auto,Fred
,General SIP,auto,Dave
,General SIP,auto,Sue

This above would create 4 'General SIP' extensions and automatically allocate extension numbers to them.

Allowed device types

• Aastra 480i
• Aastra 51i
• Aastra 53i
• Aastra 55i
• Aastra 57i
• Aastra 9112i
• Aastra 9133i
• Aastra VXT
• AastraVXT
• Cisco 7940
• Cisco 7960
• General SIP
• Grandstream 10x
• Grandstream GXP 2000
• MAILBOX
• Polycom IP320/330
• Polycom VXT
• SPA-1000
• SPA-2000
• SPA-2002
• SPA-2102
• SPA-3000FXS
• SPA-3102FXS
• SPA-841
• SPA-901
• SPA-921
• SPA-922
• SPA-941
• SPA-942
• SPA-962
• SPA-PAP2T
• Siemens C460IP
• Siemens C470IP
• Siemens S450IP
• Snom 300
• Snom 300 VXT
• Snom 300 XML
• Snom 320
• Snom 320 VXT
• Snom 320 XML
• Snom 360
• Snom 360 VXT
• Snom 360 XML
• Snom 370
• Snom 370 VXT
• Snom 370 XML
• Snom 820
• Snom 820 VXT
• Snom 820 XML
• Snom 870
• Snom 870 VXT
• Snom 870 XML
• Snom VXT
• Yealink T18
• Yealink T20
• Yealink T22
• Yealink T26
• Yealink T28
• Yealink T2x
• Yealink VXT