Download the Rmarkdown file that created this page using the Code button above

Own your data! Here’s how to record who performed actions recorded in the database.

First make sure you exist (in the database)

Make sure you are connected to the database.

Find out who’s there already (as of the last time this page was updated):

affiliationid personfirstname personlastname primaryemail affiliationstartdate
2 Wendy Wetland wendy@swamps.edu 2018-01-01
4 Kelly Hondula khondula@sesync.org 2017-06-01
5 Nate Jones njones@sesync.org 2017-07-01
7 Christine Maietta cmaietta@sesync.org 2018-08-13

Add a new person with the db_describe_person function from the lastest updates of the rodm2 package.

# devtools::install_github("khondula/rodm2")
library(rodm2)
db_describe_person(db = db, 
                   PersonFirstName = "Wendy", 
                   PersonLastName = "Wetland", 
                   AffiliationStartDate = "2018-01-01", 
                   PrimaryEmail = "wendy@swamps.edu")

This updates both the “People” and “Affiliations” table. Affiliation IDs are linked to Actions through the ActionBy table which affiliates people with actions and can describe thier role in the action.

LS0tCnRpdGxlOiAiQWRkIHlvdXJzZWxmIHRvIHRoZSBkYXRhYmFzZSIKb3V0cHV0OiBodG1sX25vdGVib29rCi0tLQoKPiBEb3dubG9hZCB0aGUgUm1hcmtkb3duIGZpbGUgdGhhdCBjcmVhdGVkIHRoaXMgcGFnZSB1c2luZyB0aGUgKipDb2RlKiogYnV0dG9uIGFib3ZlCgpPd24geW91ciBkYXRhISBIZXJlJ3MgaG93IHRvIHJlY29yZCB3aG8gcGVyZm9ybWVkIGFjdGlvbnMgcmVjb3JkZWQgaW4gdGhlIGRhdGFiYXNlLiAKCmBgYHtyIHNldHVwLCBpbmNsdWRlPUZBTFNFLCBtZXNzYWdlPUZBTFNFfQprbml0cjo6b3B0c19jaHVuayRzZXQoZWNobyA9IFRSVUUpCmxpYnJhcnkoa25pdHIpCmxpYnJhcnkobWFncml0dHIpCmBgYAoKCiMjIyBGaXJzdCBtYWtlIHN1cmUgeW91IGV4aXN0IChpbiB0aGUgZGF0YWJhc2UpCgpNYWtlIHN1cmUgeW91IGFyZSBbY29ubmVjdGVkXShodHRwczovL3BhbG1lcmxhYi51bWQuZWR1L2Nob3B0YW5rLWRiL2Nvbm5lY3QubmIuaHRtbCkgdG8gdGhlIGRhdGFiYXNlLiAKCmBgYHtyLCBpbmNsdWRlID0gRkFMU0UsIG1lc3NhZ2U9RkFMU0V9CmxpYnJhcnkoUlBvc3RncmVTUUwpCnBhc3N3b3JkIDwtIHJlYWRsaW5lKHByb21wdD0iRW50ZXIgcGFzc3dvcmQ6ICIpCmRiIDwtIGRiQ29ubmVjdChQb3N0Z3JlU1FMKCksIAogICAgICAgICAgICAgICAgaG9zdCA9ICJzZXN5bmMtcG9zdGdpczAxLnJlc2VhcmNoLnNlc3luYy5vcmciLAogICAgICAgICAgICAgICAgZGJuYW1lID0gImNob3B0YW5rIiwgCiAgICAgICAgICAgICAgICB1c2VyID0gInBhbG1lcmdyb3VwIiwKICAgICAgICAgICAgICAgIHBhc3N3b3JkID0gcGFzc3dvcmQpCmBgYAoKRmluZCBvdXQgd2hvJ3MgdGhlcmUgYWxyZWFkeSAoYXMgb2YgdGhlIGxhc3QgdGltZSB0aGlzIHBhZ2Ugd2FzIHVwZGF0ZWQpOgoKYGBge3IsIGVjaG89RkFMU0UsIHJlc3VsdHM9J2FzaXMnfQpkYlJlYWRUYWJsZShkYiwgYygib2RtMiIsICJwZW9wbGUiKSkgJT4lCiAgZHBseXI6OmxlZnRfam9pbihkYlJlYWRUYWJsZShkYiwgYygib2RtMiIsICJhZmZpbGlhdGlvbnMiKSksCiAgICAgICAgICAgICAgICAgICBieSA9ICJwZXJzb25pZCIpICU+JQogIGRwbHlyOjpzZWxlY3QoYWZmaWxpYXRpb25pZCwgcGVyc29uZmlyc3RuYW1lLCBwZXJzb25sYXN0bmFtZSwgcHJpbWFyeWVtYWlsLCBhZmZpbGlhdGlvbnN0YXJ0ZGF0ZSkgJT4lCiAga25pdHI6OmthYmxlKCkKYGBgCgpBZGQgYSBuZXcgcGVyc29uIHdpdGggdGhlIGBkYl9kZXNjcmliZV9wZXJzb25gIGZ1bmN0aW9uIGZyb20gdGhlIGxhc3Rlc3QgdXBkYXRlcyBvZiB0aGUgYHJvZG0yYCBwYWNrYWdlLiAKCmBgYHtyfQojIGRldnRvb2xzOjppbnN0YWxsX2dpdGh1Yigia2hvbmR1bGEvcm9kbTIiKQpsaWJyYXJ5KHJvZG0yKQpkYl9kZXNjcmliZV9wZXJzb24oZGIgPSBkYiwgCiAgICAgICAgICAgICAgICAgICBQZXJzb25GaXJzdE5hbWUgPSAiV2VuZHkiLCAKICAgICAgICAgICAgICAgICAgIFBlcnNvbkxhc3ROYW1lID0gIldldGxhbmQiLCAKICAgICAgICAgICAgICAgICAgIEFmZmlsaWF0aW9uU3RhcnREYXRlID0gIjIwMTgtMDEtMDEiLCAKICAgICAgICAgICAgICAgICAgIFByaW1hcnlFbWFpbCA9ICJ3ZW5keUBzd2FtcHMuZWR1IikKYGBgCgpUaGlzIHVwZGF0ZXMgYm90aCB0aGUgIlBlb3BsZSIgYW5kICJBZmZpbGlhdGlvbnMiIHRhYmxlLiBBZmZpbGlhdGlvbiBJRHMgYXJlIGxpbmtlZCB0byBBY3Rpb25zIHRocm91Z2ggdGhlIFtBY3Rpb25CeV0oaHR0cDovL29kbTIuZ2l0aHViLmlvL09ETTIvc2NoZW1hcy9PRE0yX0N1cnJlbnQvdGFibGVzL09ETTJDb3JlX0FjdGlvbkJ5Lmh0bWwpIHRhYmxlIHdoaWNoIGFmZmlsaWF0ZXMgcGVvcGxlIHdpdGggYWN0aW9ucyBhbmQgY2FuIGRlc2NyaWJlIHRoaWVyIHJvbGUgaW4gdGhlIGFjdGlvbi4KCg==