Bulk loading extensions

From sailpbx
Revision as of 10:11, 2 April 2012 by Adminwiki (talk | contribs) (csvload.pl)
Jump to: navigation, search

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