Home› Users Mailing List
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

Removing all rules in one shot

Manoj SoniManoj Soni Posts: 163 ✭
in Users Mailing List
Dear Users
Is there a way to remove all the rules from the study in one shot. However there is way to remove rule one by one. that I am using.
Thanks and Regards
Manoj

Comments

  • tdpurnattdpurnat Posts: 126 ✭
    Dear Manoj,
    Removing a rule one by one functionality is available.
    I use SQL scripts directly in the database, but only on my pure testing instance. This really is not an option on any instance with production data.
    In other situations, when absolutely neccessary, I unfortunately also remove one by one. It's a bit of a pain, because persistent filters have not been implemented on that page, which means you need to keep filtering to find each rule or group of rules after every delete.
    However, if you do not like a rule anymore, you can also update it to change it's evaluation expression to something that will never trigger, and reupload the xml... The point here is that you keep the same rule name, but change either the expression and perhaps even the target.
    Problem with this is that the expression still is evaluated at every save the form data (affects the speed of system). So even better, point the updated rules to a CRF never used. Then they stay in DB but don't evaluate during data entry of the CRFs you really use.
    Tina
    ----------
    Tina D Dannemann Purnat, M.Sc., PMP, CCDM
    Skype tdpurnat | Office +49 89 38 03 89 67 | http://www.linkedin.com/in/tinadpurnat
    Why are my emails so terse? emailcharter.org
    2013/12/6 Manoj Soni
    Dear Users
    Is there a way to remove all the rules from the study in one shot. However there is way to remove rule one by one. that I am using.
    Thanks and Regards
    Manoj
  • GerbenRienkGerbenRienk Posts: 837 ✭✭✭
    Hello Manoj,
    In addition to Tina's remarks: some time ago Lindsay Stevens suggested
    using a Selenium script to do this. Selenium is used in combination with
    FireFox and works great as a sort of scripting-tool, although designed as
    a testing-tool.
    In short what you would do is record:
    - go to the manage rules-screen
    - delete the first rule
    - confirm
    Then you save this script and edit it in a xml-editor and copy (the middle
    part of) it and paste it as many times as yuo have rules.
    Hope this helps,
    Gerben Rienk
    > > Dear Manoj,
    > >
    > > Removing a rule one by one functionality is available.
    > >
    > > I use SQL scripts directly in the database, but only on my pure testing
    > > instance. This really is not an option on any instance with production
    > > data.
    > > In other situations, when absolutely neccessary, I unfortunately also
    > > remove one by one. It's a bit of a pain, because persistent filters have
    > > not been implemented on that page, which means you need to keep filtering
    > > to find each rule or group of rules after every delete.
    > >
    > > However, if you do not like a rule anymore, you can also update it to
    > > change it's evaluation expression to something that will never trigger,
    > > and
    > > reupload the xml... The point here is that you keep the same rule name,
    > > but change either the expression and perhaps even the target.
    > > Problem with this is that the expression still is evaluated at every save
    > > the form data (affects the speed of system). So even better, point the
    > > updated rules to a CRF never used. Then they stay in DB but don't evaluate
    > > during data entry of the CRFs you really use.
    > >
    > > Tina
    > >
    > >
    > >
    > >
    > >
    > >
    > >
    > >
    > > ----------
    > > *Tina D Dannemann Purnat, M.Sc., PMP, CCDM*
    > > *Skype* tdpurnat | *Office* +49 89 38 03 89 67 |
    > > http://www.linkedin.com/in/tinadpurnat
    > >
    > > Why are my emails so terse? emailcharter.org
    > >
    > >
    > > 2013/12/6 Manoj Soni
    > >
    >> >> Dear Users
    >> >>
    >> >> Is there a way to remove all the rules from the study in one shot.
    >> >> However
    >> >> there is way to remove rule one by one. that I am using.
    >> >>
    >> >> Thanks and Regards
    >> >> Manoj
    >> >>
    >> >>
  • tdpurnattdpurnat Posts: 126 ✭
    Hi Gerben,
    Hm, I have missed this message on the list previously! Does this work when you try to delete rules that contain a certain string, so that I could delete only those rules belonging to a CRF or Study (my naming convention allows identifying rules this way)....
    How would I do this?
    Tina
    ----------
    Tina D Dannemann Purnat, M.Sc., PMP, CCDM
    Skype tdpurnat | Office +49 89 38 03 89 67 | http://www.linkedin.com/in/tinadpurnat
    Why are my emails so terse? emailcharter.org
    2013/12/6 Gerben Rienk
    Hello Manoj,
    In addition to Tina's remarks: some time ago Lindsay Stevens suggested
    using a Selenium script to do this. Selenium is used in combination with
    FireFox and works great as a sort of scripting-tool, although designed as
    a testing-tool.
    In short what you would do is record:
    - go to the manage rules-screen
    - delete the first rule
    - confirm
    Then you save this script and edit it in a xml-editor and copy (the middle
    part of) it and paste it as many times as yuo have rules.
    Hope this helps,
    Gerben Rienk
    > Dear Manoj,
    >
    > Removing a rule one by one functionality is available.
    >
    > I use SQL scripts directly in the database, but only on my pure testing
    > instance. This really is not an option on any instance with production
    > data.
    > In other situations, when absolutely neccessary, I unfortunately also
    > remove one by one. It's a bit of a pain, because persistent filters have
    > not been implemented on that page, which means you need to keep filtering
    > to find each rule or group of rules after every delete.
    >
    > However, if you do not like a rule anymore, you can also update it to
    > change it's evaluation expression to something that will never trigger,
    > and
    > reupload the xml... The point here is that you keep the same rule name,
    > but change either the expression and perhaps even the target.
    > Problem with this is that the expression still is evaluated at every save
    > the form data (affects the speed of system). So even better, point the
    > updated rules to a CRF never used. Then they stay in DB but don't evaluate
    > during data entry of the CRFs you really use.
    >
    > Tina
    >
    >
    >
    >
    >
    >
    >
    >
    > ----------
    > *Tina D Dannemann Purnat, M.Sc., PMP, CCDM*
    > *Skype* tdpurnat | *Office* +49 89 38 03 89 67 |
    > http://www.linkedin.com/in/tinadpurnat
    >
    > Why are my emails so terse? emailcharter.org
    >
    >
    > 2013/12/6 Manoj Soni
    >
    >> Dear Users
    >>
    >> Is there a way to remove all the rules from the study in one shot.
    >> However
    >> there is way to remove rule one by one. that I am using.
    >>
    >> Thanks and Regards
    >> Manoj
    >>
    >>
  • Manoj SoniManoj Soni Posts: 163 ✭
    Thanks you so much for the reply.
    Gerben Sir: I checked the script you gave me and found that, to change the text in upper case, works only for one first field in the CRF, for both input and textarea.
    Is there a way for doing for the all the fields.
    Thanks and Regards
    Manoj
    On Fri, Dec 6, 2013 at 2:28 PM, Gerben Rienk wrote:
    Hello Manoj,
    In addition to Tina's remarks: some time ago Lindsay Stevens suggested
    using a Selenium script to do this. Selenium is used in combination with
    FireFox and works great as a sort of scripting-tool, although designed as
    a testing-tool.
    In short what you would do is record:
    - go to the manage rules-screen
    - delete the first rule
    - confirm
    Then you save this script and edit it in a xml-editor and copy (the middle
    part of) it and paste it as many times as yuo have rules.
    Hope this helps,
    Gerben Rienk
    > Dear Manoj,
    >
    > Removing a rule one by one functionality is available.
    >
    > I use SQL scripts directly in the database, but only on my pure testing
    > instance. This really is not an option on any instance with production
    > data.
    > In other situations, when absolutely neccessary, I unfortunately also
    > remove one by one. It's a bit of a pain, because persistent filters have
    > not been implemented on that page, which means you need to keep filtering
    > to find each rule or group of rules after every delete.
    >
    > However, if you do not like a rule anymore, you can also update it to
    > change it's evaluation expression to something that will never trigger,
    > and
    > reupload the xml... The point here is that you keep the same rule name,
    > but change either the expression and perhaps even the target.
    > Problem with this is that the expression still is evaluated at every save
    > the form data (affects the speed of system). So even better, point the
    > updated rules to a CRF never used. Then they stay in DB but don't evaluate
    > during data entry of the CRFs you really use.
    >
    > Tina
    >
    >
    >
    >
    >
    >
    >
    >
    > ----------
    > *Tina D Dannemann Purnat, M.Sc., PMP, CCDM*
    > *Skype* tdpurnat | *Office* +49 89 38 03 89 67 |
    > http://www.linkedin.com/in/tinadpurnat
    >
    > Why are my emails so terse? emailcharter.org
    >
    >
    > 2013/12/6 Manoj Soni
    >
    >> Dear Users
    >>
    >> Is there a way to remove all the rules from the study in one shot.
    >> However
    >> there is way to remove rule one by one. that I am using.
    >>
    >> Thanks and Regards
    >> Manoj
    >>
    >>
  • lindsay.stevenslindsay.stevens Posts: 404 ✭✭✭
    Hi Manoj,
    I described the technique Gerben mentioned at [1]. I used it to remove about 150 rules from a study. It took only a few minutes, and it was beautiful to watch.
    URL filters are used to limit the Rules table, then the action of deleting the rule at the top of the table is submitted, and it keeps doing that until there aren't any rules left in that filter subset. As long as you can identify the rules you want to remove with a filter, it should work. If you want to get rid of all rules then supply no filter.
    [1] https://en.wikibooks.org/wiki/OpenClinica_User_Manual/DeleteManyRules
    Best regards,
    Lindsay
    On 6 December 2013 20:13, Manoj Soni wrote:
    Thanks you so much for the reply.
    Gerben Sir: I checked the script you gave me and found that, to change the text in upper case, works only for one first field in the CRF, for both input and textarea.
    Is there a way for doing for the all the fields.
    Thanks and Regards
    Manoj
    On Fri, Dec 6, 2013 at 2:28 PM, Gerben Rienk wrote:
    Hello Manoj,
    In addition to Tina's remarks: some time ago Lindsay Stevens suggested
    using a Selenium script to do this. Selenium is used in combination with
    FireFox and works great as a sort of scripting-tool, although designed as
    a testing-tool.
    In short what you would do is record:
    - go to the manage rules-screen
    - delete the first rule
    - confirm
    Then you save this script and edit it in a xml-editor and copy (the middle
    part of) it and paste it as many times as yuo have rules.
    Hope this helps,
    Gerben Rienk
    > Dear Manoj,
    >
    > Removing a rule one by one functionality is available.
    >
    > I use SQL scripts directly in the database, but only on my pure testing
    > instance. This really is not an option on any instance with production
    > data.
    > In other situations, when absolutely neccessary, I unfortunately also
    > remove one by one. It's a bit of a pain, because persistent filters have
    > not been implemented on that page, which means you need to keep filtering
    > to find each rule or group of rules after every delete.
    >
    > However, if you do not like a rule anymore, you can also update it to
    > change it's evaluation expression to something that will never trigger,
    > and
    > reupload the xml... The point here is that you keep the same rule name,
    > but change either the expression and perhaps even the target.
    > Problem with this is that the expression still is evaluated at every save
    > the form data (affects the speed of system). So even better, point the
    > updated rules to a CRF never used. Then they stay in DB but don't evaluate
    > during data entry of the CRFs you really use.
    >
    > Tina
    >
    >
    >
    >
    >
    >
    >
    >
    > ----------
    > *Tina D Dannemann Purnat, M.Sc., PMP, CCDM*
    > *Skype* tdpurnat | *Office* +49 89 38 03 89 67 |
    > http://www.linkedin.com/in/tinadpurnat
    >
    > Why are my emails so terse? emailcharter.org
    >
    >
    > 2013/12/6 Manoj Soni
    >
    >> Dear Users
    >>
    >> Is there a way to remove all the rules from the study in one shot.
    >> However
    >> there is way to remove rule one by one. that I am using.
    >>
    >> Thanks and Regards
    >> Manoj
    >>
    >>
  • tdpurnattdpurnat Posts: 126 ✭
    Wow, thanks for the tip! This is very useful!
    Tina
    ----------
    Tina D Dannemann Purnat, M.Sc., PMP, CCDM
    Skype tdpurnat | Office +49 89 38 03 89 67 | http://www.linkedin.com/in/tinadpurnat
    Why are my emails so terse? emailcharter.org
    2013/12/6 Lindsay Stevens
    Hi Manoj,
    I described the technique Gerben mentioned at [1]. I used it to remove about 150 rules from a study. It took only a few minutes, and it was beautiful to watch.
    URL filters are used to limit the Rules table, then the action of deleting the rule at the top of the table is submitted, and it keeps doing that until there aren't any rules left in that filter subset. As long as you can identify the rules you want to remove with a filter, it should work. If you want to get rid of all rules then supply no filter.
    [1] https://en.wikibooks.org/wiki/OpenClinica_User_Manual/DeleteManyRules
    Best regards,
    Lindsay
    On 6 December 2013 20:13, Manoj Soni wrote:
    Thanks you so much for the reply.
    Gerben Sir: I checked the script you gave me and found that, to change the text in upper case, works only for one first field in the CRF, for both input and textarea.
    Is there a way for doing for the all the fields.
    Thanks and Regards
    Manoj
    On Fri, Dec 6, 2013 at 2:28 PM, Gerben Rienk wrote:
    Hello Manoj,
    In addition to Tina's remarks: some time ago Lindsay Stevens suggested
    using a Selenium script to do this. Selenium is used in combination with
    FireFox and works great as a sort of scripting-tool, although designed as
    a testing-tool.
    In short what you would do is record:
    - go to the manage rules-screen
    - delete the first rule
    - confirm
    Then you save this script and edit it in a xml-editor and copy (the middle
    part of) it and paste it as many times as yuo have rules.
    Hope this helps,
    Gerben Rienk
    > Dear Manoj,
    >
    > Removing a rule one by one functionality is available.
    >
    > I use SQL scripts directly in the database, but only on my pure testing
    > instance. This really is not an option on any instance with production
    > data.
    > In other situations, when absolutely neccessary, I unfortunately also
    > remove one by one. It's a bit of a pain, because persistent filters have
    > not been implemented on that page, which means you need to keep filtering
    > to find each rule or group of rules after every delete.
    >
    > However, if you do not like a rule anymore, you can also update it to
    > change it's evaluation expression to something that will never trigger,
    > and
    > reupload the xml... The point here is that you keep the same rule name,
    > but change either the expression and perhaps even the target.
    > Problem with this is that the expression still is evaluated at every save
    > the form data (affects the speed of system). So even better, point the
    > updated rules to a CRF never used. Then they stay in DB but don't evaluate
    > during data entry of the CRFs you really use.
    >
    > Tina
    >
    >
    >
    >
    >
    >
    >
    >
    > ----------
    > *Tina D Dannemann Purnat, M.Sc., PMP, CCDM*
    > *Skype* tdpurnat | *Office* +49 89 38 03 89 67 |
    > http://www.linkedin.com/in/tinadpurnat
    >
    > Why are my emails so terse? emailcharter.org
    >
    >
    > 2013/12/6 Manoj Soni
    >
    >> Dear Users
    >>
    >> Is there a way to remove all the rules from the study in one shot.
    >> However
    >> there is way to remove rule one by one. that I am using.
    >>
    >> Thanks and Regards
    >> Manoj
    >>
    >>
This discussion has been closed.