Re-assign multiple subjects to a site

Dear All,

I'd like to move a number of subjects, let's say 200, from a site to another. The subjects are already created and CRFs are marked as complete for them. Is there any method to do it or I have to do manually?

I took a look at this thread https://forums.openclinica.com/discussion/12811/easier-method-to-assign-multiple-subjects-to-a-site but no none suggested a solution.

I really appreciate any help you could provide.

Luciano

Comments

  • lindsay.stevenslindsay.stevens Posts: 402 ✭✭✭
    via Email
    It can be done but requires some programming.

    Either by updating the database directly, or scripting the action using the
    reassign page. In both cases it takes some time to prepare and QA, so you
    must balance that against time to do it manually and QA, and whether the
    script would ever be used again.

    If it has to be done quickly, I'd go with the database option. My approach
    would be, in a test environment, turn on all statement logging in Postgres,
    reassign a subject, then inspect what commands OC sent to perform the
    migration. Then copy those commands and replace the subject id with the
    next one to migrate. Check it worked ok in the UI, then try it with a loop
    over all subject IDs.

    The scripting action approach is similar, but involves using a Firefox
    add-on called Selenium IDE (or the regular webdriver) to record / replicate
    the action of reassigning a subject via the UI. It's a little more tedious
    but same result.

    In either case, tell your users there'll be some downtime, turn off tomcat,
    take an extra db backup, run the script, then restart tomcat.



    Best regards,
    Lindsay


    On 22 Sep. 2017 20:53, "casc01"
    wrote:

    OpenClinica https://forums.openclinica.com/
    casc01 started a new discussion: Re-assign multiple subjects to a site

    Dear All,

    I'd like to move a number of subjects, let's say 200, from a site to
    another. The subjects are already created and CRFs are marked as complete
    for them. Is there any method to do it or I have to do manually?

    I took a look at this thread https://forums.openclinica.
    com/discussion/12811/easier-method-to-assign-multiple-subjects-to-a-site
    but no none suggested a solution.

    I really appreciate any help you could provide.

    Luciano
Sign In or Register to comment.