Page Comparison

Page needs update

User Name,Password,First Name,Last Name,Email
FieldCoordinator,ignored,Field,Coordinator,josh.zamor@villagereach.org
sjackson,ignored,Sarah,Jackson,sarah.jackson@villagereach.org
,ignored,Jaime,Mausse,gokweni@gmail.com
cmandlate,ignored,Cecília,Mandlate,sallyfrag1979@gmail.com
ecastigo,ignored,Engracia,Castigo,
csoares,ignored,Carmen,Soares,carmendapazsoares@gmail.com
jandre,ignored,João,André,
ahanifo,ignored,Abdul,Hanifo,
afaque,ignored,Abdul,Faque,faqueabdul@gmail.com
alimite,ignored,Agostinho,Limite,agostinholimite@gmail.com
nmote,ignored,Nelson,Mote,nelsonmote23@gmail.com
fcassimo,ignored,Focas,Cassimo,larssifocas@yahoo.com.br

...

This list of user accounts is as of 5th June 2014, and is based on the field coordinator inventory user list provided by Moz office. This set of users and permissions has been backed-up, and can be restored at any point.

For the actual SELV deployment, additional accounts for VillageReach staff will need to be added manually.

sjackson

jmausse

Jaime,Mausse

gokweni@gmail.com

Moz User Accounts by Province.xlsx

SQL to check user's role assignments

select u.username
    , u.email
    , u.verified
    , u.active
    , r.name as roleName
    , p.name as programName
    , dz.name as deliveryZoneName
from users u
left join role_assignments ra on (ra.userid=u.id)
left join roles r on (r.id=ra.roleid)
left join programs p on (p.id=ra.programid)
left join delivery_zones dz on (dz.id=ra.deliveryzoneid)
order by username