Hi Wolverton,
Thanks for your assistance. I basically save out from CBJUICE2 on one site as csv (comma is the delimiter) and then open in any of the following to remove some users, a) excel (on windows) b) notepad (windows) c) notepad++ (Windows) d) textwrangler (mac), e) numbers (mac) .
...in textwrangler its unicode UTF-8 windows (CLRF). save and then import straight back into CBJUICE on the backup site.
My hash password as an example looks like :$2y$10$KNbGTT82ke1Rquzs6EgoxumwQcl4fuI50/iL0k7D7zC0Tcu53R6ie
sometimes the fields are in "" sometimes not.
Thanks
Joe
example one user upload file :
"name","username","email","password","block","sendEmail","registerDate","lastvisitDate","activation","params","lastResetTime","resetCount","otpKey","otep","requireReset","user_id","firstname","middlename","lastname","hits","message_last_sent","message_number_sent","avatar","avatarapproved","approved","confirmed","lastupdatedate","registeripaddr","cbactivation","banned","banneddate","unbanneddate","bannedby","unbannedby","bannedreason","acceptedterms","website","location","occupation","interests","cb_phonenumber","cb_location","cb_unisonrole","cb_employer","cb_workplace","cb_constituency","cb_unisonmembershipnumber","cb_workplaceaddress","cb_city","cb_postcode","cb_country","usertype"
"joe_batchtest upload","joe_test_upload","joebrickle***@gmail.com","$2y$10$KNbGTT82ke1Rquzs6EgoxumwQcl4fuI50/iL0k7D7zC0Tcu53R6ie","0","0","2014-11-28 08:42:00","2014-11-28 10:43:12","","{""language"":"""",""editor"":"""",""timezone"":""Europe\/London""}","0000-00-00 00:00:00","0","","","0","315","joe_batchtest","","upload","0","0000-00-00 00:00:00","0","","1","1","1","2014-11-28 08:45:24","82.34.175.21","","0","","","","","","0","","","","","","","Member|*|Unison Steward|*|Branch Officer","Bristol City Council","","","6287773","Brunel House","","bs1 5uy","","Registered|Unison Steward|Branch Officer"