Don't know of any Linux editors that can do that, which doesn't mean anything as I only know a little about pico and shudder when I use vi (I can never remember how to write and quit!). Used to have a great editor on our Acorn machines called StongEd, could do all that and more. The trick was to be able to insert data into the same spot in each row and as the file is already delimited with : a spreadsheet seemed the obvious choice and as I do not have Linux desktops it had to be a Windows one. My solution required no scripting and very little knowledge - which is why I came up with it :-).
Having said that, I am also in Parramatta and although I won't quite just say 'bend over' :-) I am willing to give you the kick up the butt ;-) > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of > Matthew Hannigan > Sent: Tuesday, 28 May 2002 12:33 PM > To: Simon Bryan > Cc: Jeff; Slug > Subject: Re: [SLUG] Transfer Users > > > > Simon, > Your persistance is to be applauded. Though you > lose points for using a spreadsheet rather than a > unix editor :-) > > It really should be a lot easier to do this task under > unix. > > I have a script 'userexp' which takes a passwd/group/shadow > file and spits out a whole bunch of 'useradd' commands > to be run on another server, but it's not really ready > for mass consumption yet. > > Someone kick me in the pants and I might release it. > > Regards, > -Matt > > > Simon Bryan wrote: > > Thanks all, > > What I ended up doing was to use Webmins add user facility. > > Details: > > load both the passwd file and the shadow file into Excel, > delete unwanted > > users and then inserted the encrypted passwords into the second > column in > > the passwd file using cut and paste, added five dummy columns > at the end of > > each row containg zz in each cell, inserted a column at the > beginnin with > > 'create' in each cell. Added the group Staff to my server, > deleted all the > > exisiting UID's and replaced them with 'zz', replaced all the exisiting > > GID's with the GID for the group staff. Saved that as csv file, > loaded it > > into NoteTab Light, replaced all the , with : then replaced all > the zz with > > nothing. > > > > Used Webmin and 'add users from a batch file' and bingo all > users created, > > including Home directoires etc as well as updating the Samba > users at the > > same time. > > > > Total time about 10 minutes, once I had worked out the process. > > > > I thought about just copying the files and directories but that was a > > problem (for me anyway) as they are on different servers and I > was not sure > > how to copy the directories and preserve permissions. Also this > gave me a > > chance to put all the users into a Staff group and eleiminate all the > > individual groups that I had created when using 'useradd'. > > > > > > Cheers, > > > > > >>-----Original Message----- > >>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of > >>Jeff > >>Sent: Tuesday, 28 May 2002 8:45 AM > >>To: Simon Bryan; Slug > >>Subject: Re: [SLUG] Transfer Users > >> > >> > >>Simon, > >> I have about 60 users on my system and have upgraded the main > >>hard drive twice. Both times I simply copied the > >>/etc/passwd file and the /etc/group files over first. When I copy > >>the /home > >>directory accross and any other directory the users use I make > >>sure the copy > >>is with permissions and owner preserved. > >>This works for me. > >> > >> > >>----- Original Message ----- > >>From: "Simon Bryan" <[EMAIL PROTECTED]> > >>To: "Slug" <[EMAIL PROTECTED]> > >>Sent: Tuesday, May 28, 2002 8:32 AM > >>Subject: [SLUG] Transfer Users > >> > >> > >> > >>>Sent this last night, hasn't appeared. I think I may have had > rtf format > >>>set. > >>> > >>>Hi all, > >>>The last remaining task in changin from Mandrake 6 to a new server with > >>>RH7.2 is to transfer the users. > >>>I have a system for transferring the users using a file and > >> > >>Webmin's bulk > >> > >>>adduser routine, which I have used in the past. However this > time I need > >> > >>to > >> > >>>transfer the passwords as well, once I have created the users > >> > >>can I simply > >> > >>>copy over the shadow password file, or should I do it first, or > >> > >>won't that > >> > >>>work at all. > >>> > >>>Any advice appreciated, > >>>Cheers > >>> > >>> > >>>_________________________________________ > >>>Simon Bryan > >>>IT Manager > >>>OLMC Parramata > >>>ICQ#: 137562751 > >>>_________________________________________ > >>> > >>>-- > >>>SLUG - Sydney Linux User's Group - http://slug.org.au/ > >>>More Info: http://lists.slug.org.au/listinfo/slug > >>> > >>> > >> > >> > >>-- > >>SLUG - Sydney Linux User's Group - http://slug.org.au/ > >>More Info: http://lists.slug.org.au/listinfo/slug > > > > > > > -- > SLUG - Sydney Linux User's Group - http://slug.org.au/ > More Info: http://lists.slug.org.au/listinfo/slug -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
