Any advice on how to batch-add users ?

2 views
Skip to first unread message

Colm

unread,
Nov 27, 2009, 3:57:22 PM11/27/09
to CommunityEngine
Hello,

I finally got a CE site working on heroku by taking the unglorious
route of copying an existing heroku CE based site. THe glorious
results can be seen on http://ttennis.heroku.com, nothing to write
home about yet.

Since I plan to move a mailing list with ~100 users to CE, I'd like to
know if anyone has any tips on how to batch add users ? I know that if
I go the route of e-mailing users inviting them to sign up that it'll
take months for all of them to do so, thats just how it works. I was
hoping to populate the sqlite database locally using user data I
already have and then upload to heroku. The plan would be that user
jac...@here.com would be given the default password jack394 and then
would be invited to change it on his first access. Far from perfect
security, but if anyone has any netter ideas, I'm all ears (or eyes to
be exact).
Secondly, when I look at the users table in the database, I see there
is a crytped_password and a salt. My understanding is that the salt is
generated and used to generate the encrypted password. If that is so,
then I should be good to generate a salt and encrypted password for
the list of users. Any advice on an easy way to do this as a batch
would be appreciated, but I'm sure it will be an enjoyable learning
experience.

Many thanks,
Colm

Jim Ruther Nill

unread,
Nov 28, 2009, 10:25:54 AM11/28/09
to communi...@googlegroups.com
you can use the manage_fixtures plugin to move all your db table entries to the deployed one.


--

You received this message because you are subscribed to the Google Groups "CommunityEngine" group.
To post to this group, send email to communi...@googlegroups.com.
To unsubscribe from this group, send email to communityengi...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/communityengine?hl=en.





--
"We do not believe in ourselves until someone reveals that deep inside us is valuable, worth listening to, worthy of our trust, sacred to our touch." - E. E. Cummings

Colm

unread,
Nov 29, 2009, 6:19:30 PM11/29/09
to CommunityEngine
Hi Jim,

Thanks for the reply but given my newness to rails I'll quite happily
make changes to the local db and then "heroku db:push" them up to
heroku.
What I think I'll do is generate a sale and manually encrypt each of
the passwords using SHA1, maybe even a web-based one like
http://www.tech-faq.com/sha-1-generator.shtml
The user model shows that I'd use the following "Digest::SHA1.hexdigest
("--#{salt}--#{password}--")" for generating the encrypted password.
Quite cumbersome, but I think its simple enough, and needs little
coding ability so I might just get there.

Regards / Colm

On Nov 28, 3:25 pm, Jim Ruther Nill <jvn...@gmail.com> wrote:
> you can use the manage_fixtures plugin to move all your db table entries to
> the deployed one.
>
>
>
> On Sat, Nov 28, 2009 at 2:57 AM, Colm <c...@carbontracking.com> wrote:
> > Hello,
>
> > I finally got a CE site working on heroku by taking the unglorious
> > route of copying an existing heroku CE based site. THe glorious
> > results can be seen onhttp://ttennis.heroku.com, nothing to write
> > home about yet.
>
> > Since I plan to move a mailing list with ~100 users to CE, I'd like to
> > know if anyone has any tips on how to batch add users ? I know that if
> > I go the route of e-mailing users inviting them to sign up that it'll
> > take months for all of them to do so, thats just how it works. I was
> > hoping to populate the sqlite database locally using user data I
> > already have and then upload to heroku. The plan would be that user
> > jack...@here.com would be given the default password jack394 and then
> > would be invited to change it on his first access. Far from perfect
> > security, but if anyone has any netter ideas, I'm all ears (or eyes to
> > be exact).
> > Secondly, when I look at the users table in the database, I see there
> > is a crytped_password and a salt. My understanding is that the salt is
> > generated and used to generate the encrypted password. If that is so,
> > then I should be good to generate a salt and encrypted password for
> > the list of users. Any advice on an easy way to do this as a batch
> > would be appreciated, but I'm sure it will be an enjoyable learning
> > experience.
>
> > Many thanks,
> > Colm
>
> > --
>
> > You received this message because you are subscribed to the Google Groups
> > "CommunityEngine" group.
> > To post to this group, send email to communi...@googlegroups.com.
> > To unsubscribe from this group, send email to
> > communityengi...@googlegroups.com<communityengine%2Bunsu...@googlegroups.com>
> > .

Jim Ruther Nill

unread,
Nov 30, 2009, 3:37:26 AM11/30/09
to communi...@googlegroups.com
If that's better for you, then goodluck! Ask away if you need any help. :)

To unsubscribe from this group, send email to communityengi...@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/communityengine?hl=en.


Reply all
Reply to author
Forward
0 new messages