Hello, Have a look at /usr/local/pf/addons/import-node-csv.pl Regards Fabrice
Le 2013-02-04 10:16, Arthur Emerson III a écrit : > "Arthur Emerson III" <[email protected]> wrote: >> You may have to script something with: >> >> /usr/local/pf/bin/pfcmd person add [pid] >> >> to populate the person table from the PID column of >> your CSV file as the first step, and then script the >> node addition with a second call to pfcmd to create >> the node. It really isn't more than a few lines of >> BASH shell script to do this from the command line, >> if somebody else doesn't have a cleaner solution... > I just looked at the web interface's bulk import > screen this morning, and saw that the file format > it accepts is only a list of MAC addresses, not a > CSV file. :-( > > Assuming that you only want to run this as a one-time > import, the script below will do the job albeit slowly. > > Format the input file as below, and stick it in > /tmp/file.csv: > > 01:11:22:33:44:55,user1, > 01:23:45:67:89:01,user2, > > > (If you can create the file as a Unix/Linux text file > with LF line terminators instead of CR/LF, you can omit > the ending comma.) > > With the CSV file in place, type this at a root shell > prompt: > > cat /tmp/file.csv | while read line > do > mac=`echo $line | cut -f1 -d,` > pid=`echo $line | cut -f2 -d,` > /usr/local/pf/bin/pfcmd person add $pid > /usr/local/pf/bin/pfcmd node add $mac status=\"reg\",pid=$pid > echo "Registered $mac to user $pid..." > done > > It added about one MAC address per second when I just > ran it on our live PF server. If you just want to do > an initial one-time import and nobody has a better > solution, this will work as a last resort... > > -Arthur > > ------------------------------------------------------------------------- > Arthur Emerson III Email: [email protected] > Network Administrator InterNIC: AE81 > Mount Saint Mary College MaBell: (845) 561-0800 Ext. 3109 > 330 Powell Ave. Fax: (845) 562-6762 > Newburgh, NY 12550 SneakerNet: Aquinas Hall Room 11 > > > ------------------------------------------------------------------------------ > Everyone hates slow websites. So do we. > Make your web apps faster with AppDynamics > Download AppDynamics Lite for free today: > http://p.sf.net/sfu/appdyn_d2d_jan > _______________________________________________ > PacketFence-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/packetfence-users -- Fabrice Durand [email protected] :: +1.514.447.4918 (x135) :: www.inverse.ca Inverse inc. :: Leaders behind SOGo (http://www.sogo.nu) and PacketFence (http://packetfence.org) ------------------------------------------------------------------------------ Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_jan _______________________________________________ PacketFence-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/packetfence-users
