Although it is possible, going through the steps Brian indicated, I would very strongly recommend never to do this.
If and when however you decide you must take these steps
- make a copy of the production environment as test environment
- practice the steps and combine them in a script
- check the script
- delete your test instance and create a new one from the production instance
- recheck the script
- have your manager sign the script (and accept the consequences)
- keep the signed script in your trial master file
- only then run it on the production instance
This may seem ridiculous, but I can assure you that if you do not follow these steps and start issueing sql-commands at the backend, even if everything was completed smoothly, you are in big trouble when the next problem arises: everyone will point at you, even if the new problem has nothing to do with your actions. And you have no way to proof that one has nothing to do with the other.
You may want to consider these alternatives:
If you want to delete one or more Subjects in your Study, create a site in your Study called “Dummy” or “Test” or “Trash” or “Training”. Reassign the Subjects you don’t want to see again to this Site and rename them to Z_[oldID]. Then as root delete the Subjects. The result will be that anyone logged on to a Site will not see them in the SubjectMatrix and anyone logged on to the Study will only see them at the end of the list. Their (deleted) data will not be part of your dataextracts.
If you want to delete a CRFVersion you can do more or less the same. Download the CRF. Go to the CRF list and edit the name of the CRF to “Z_[oldCRFname].
Make the corrections to the downloaded XL and upload it as a new CRF. Edit the StudyEvents that refer to this CRF.
Hope this helps,
Gerben Rienk Visserhttp://www.trialdatasolutions.com
Van: [email protected]
] Namens saeed esmaili sardari
Verzonden: donderdag 20 september 2012 15:28
Aan: Brian Mutinda; [email protected]
CC: [email protected]
Onderwerp: Re: [Users] [Developers] Removing a CRF and/or a SUBJECT completely
This is actually what I tried and it worked, so for anyone who wants to completely remove a CRF or a CRF version from the uploaded CRFs list:
1. Use CRF table to get the CRF_id
2. In table item_group remove the record with the same CRF_id
3. In table item_form_metadata remove the record with the same CRF_id
4. In table item_group_metadata remove the record with the same CRF_id
5. In table versioning_map remove the record with the same CRF_id
6. In table event_definition_crf remove the record with the same CRF_id
7. In table section remove the record with the same CRF_id
8. In table crf_version remove the record with the same CRF_id
9. In table crf remove the record with the same CRF_id
From: Brian Mutinda
To: saeed esmaili sardari ; [email protected]
Cc: "[email protected]
Sent: Thursday, September 20, 2012 5:34 AM
Subject: Re: [Developers] Removing a CRF and/or a SUBJECT completely
It is very possible but need to be cautious. Go thro' the back end and located the table for CRFs. the if need may be the events definition table.
On Tue, Sep 18, 2012 at 4:51 PM, saeed esmaili sardari wrote:
Removing a CRF and/or a SUBJECT completely
I was wondering if there is a way to completely remove a CRF so that the very same CRF name is available for re-uploading?
If we simply use the remove or delete option, it does not completely remove it and another XML file with the same name and version cannot be uploaded.
Same for subjects, is there a way to delete a CRF and/or a subject as if it is never created?