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...
[code] $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')[/code]
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 [code] ,General SIP,auto,Alice ,General SIP,auto,Fred ,General SIP,auto,Dave ,General SIP,auto,Sue [/code]
This above would create 4 'General SIP' extensions and automatically allocate extension numbers to them.
Allowed device types
[code]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[/code]
