Sysmo DB

Clean or remove invalid people

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Major Major
  • Resolution: Fixed
  • Affects Version/s: 0.5.0
  • Fix Version/s: 0.5.1
  • Component/s: None
  • Labels:
    None

Description

A quick Person.find(:all).select{|p| !p.valid?}.size indicate 50 invalid entries. Many could just be typo's in the email addresses.
Needs checking over, and fixing or removing where appropriate.

Activity

Hide
Finn Bacall added a comment - 2009-11-04 16:14

35 users have email addresses with spaces at the end, making them invalid. running .strip! on the email and saving solves this.
4 users have nil email addresses
1 user has appeared to have entered their email address twice into the field, making it invalid.
1 user has used a . instead of an @ before the domain name in their email address

Show
Finn Bacall added a comment - 2009-11-04 16:14 35 users have email addresses with spaces at the end, making them invalid. running .strip! on the email and saving solves this. 4 users have nil email addresses 1 user has appeared to have entered their email address twice into the field, making it invalid. 1 user has used a . instead of an @ before the domain name in their email address
Hide
Stuart Owen added a comment - 2009-11-17 14:29

Now fixed by both Stuart and Finn.

Show
Stuart Owen added a comment - 2009-11-17 14:29 Now fixed by both Stuart and Finn.

People

Vote (0)
Watch (0)

Dates

  • Created:
    2009-10-28 14:15
    Updated:
    2009-11-17 14:29
    Resolved:
    2009-11-17 14:29

Time Tracking

Estimated:
4h
Original Estimate - 4 hours
Remaining:
4h
Remaining Estimate - 4 hours
Logged:
Not Specified
Time Spent - Not Specified