I have found with a very quick and easy way to do this using HeidiSQL. HeidiSQL is a Windows based GUI for connecting to MySQL. Works like a charm and very easy for us GUI users... I believe there are Mac and Linux variants also available.
580 records just added from a CSV in one swelled foop! Feel free to reply to me off-list if you want additional instructions. - Gerard Duguay, Seattle Pacific University gerard-at-spu-dot-edu -----Original Message----- From: Josh Ward [mailto:[email protected]] Sent: Monday, August 09, 2010 11:08 AM To: [email protected] Cc: [email protected] Subject: Re: [Packetfence-users] bulk import of registered devices On 8/9/10 10:41 AM, Olivier Bilodeau wrote: > > and it will probably be slow but that's not Josh's fault. A faster way > would be to insert directly into MySQL figuring out the node table. A > tool like phpmyadmin makes this kind of work very easy to do. Agreed! Although you need to be careful when doing this. You need to add the person and then the nodes and make sure you don't duplicate anything, etc. The pfcmd route is slow (a couple of seconds each, so ... it should work :-) ) but it's super easy to script. I've found you should always use caution when directly manipulating the PF database... If you aren't, bad things can happen. -Josh ------------------------------------------------------------------------------ This SF.net email is sponsored by Make an app they can't live without Enter the BlackBerry Developer Challenge http://p.sf.net/sfu/RIM-dev2dev _______________________________________________ Packetfence-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/packetfence-users ------------------------------------------------------------------------------ This SF.net email is sponsored by Make an app they can't live without Enter the BlackBerry Developer Challenge http://p.sf.net/sfu/RIM-dev2dev _______________________________________________ Packetfence-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/packetfence-users
