We hope you'll join us for our 4/23 webinar on using data tables to apply reference ranges and AE codes in OC4. For more information and to register, visit https://register.gotowebinar.com/register/2882170018956684555

How to update DOB for all subjects to 01/01/1900 once data exported

girelandgireland Posts: 1
edited August 2016 in Forum How-Tos

DOB is going to be a mandatory field in our study, but once they have been entered and the data has been exported, we would like to anonymise the DOB to a standard one for all subjects (ie all 01/01/1900). We also want to do this for hospital number. Does anyone know of the best way for us to do this (preferably without xml as we have no experts here)? Is it possible to run update queries, similar to that in MS Access, or would you need to import the CRFs with updated fields?

Thanks for you help!


  • GerbenRienkGerbenRienk Posts: 838 ✭✭✭
    edited August 2016
    Hi Georgina,
    In these situations Selenium would be my weapon of first choice. The wikibook has a nice page about it:
    You could write a script that uses the StudySubjectID to lookup the ViewStudySubject page and there update the date of birth.
    I hope this does not sound too abstract and if so, feel free to ask.
    Kind regards,
    Gerben Rienk
    ps. do not forget that in the study audit log the original dob will be recorded, like in the screenshot and similar in the odm-xml output

Sign In or Register to comment.