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):
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==