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

Repeat Key Issue in Data Extraction

Hi All,

We have an issue with the extracted data for repeated group items where an update to a field is performed. We used to have a field, say field "A" in a repeated group and it had some data (multiple records for several subjects). Then we performed a CRF update and we updated field "A" and we transferred the old data to the newly added field, but the "repeat key" numbers are not matching the old records. For example for the repeat key of "1", the newly added field gets its own repeat key of say "33" where there are only "32" records in the subjects CRF. The software, however, knows a way to reconnect this key of "33" to the record "1" since when we view the data for the subject, the new field properly shows up for the first record. But when we export the .xml data, this field (the new one) has a different repeat key, and we are using this key to collect the data for a single record.

Any comments or suggestions on the issue?

Thanks
Saeed.

Comments

  • Hi All,

    We have an issue with the extracted data for repeated group items where an update to a field is performed. We used to have a field, say field "A" in a repeated group and it had some data (multiple records for several subjects). Then we performed a CRF update and we updated field "A" and we transferred the old data to the newly added field, but the "repeat key" numbers are not matching the old records. For example for the repeat key of "1", the newly added field gets its own repeat key of say "33" where there are only "32" records in the subjects CRF. The software, however, knows a way to reconnect this key of "33" to the record "1" since when we view the data for the subject, the new field properly shows up for the first record. But when we export the .xml data, this field (the new one) has a different repeat key, and we are using this key to collect the data for a single record.

    Any comments or suggestions on the issue?

    Thanks
    Saeed.
  • jamuna269jamuna269 Posts: 109
    Hi Saeed,
    Which version of OpenClinica are you using? Did you originally import the data, especially with the row#1? There are some issues with respect to importing data into repeating groups and saving it. What data extract is showing is likely how the data is saved into the database, check the audit trail to see if you get any clue.
    Jamuna
    On Wed, Oct 10, 2012 at 9:25 AM, saeed esmaili sardari wrote:
    Hi All,

    We have an issue with the extracted data for repeated group items where an update to a field is performed. We used to have a field, say field "A" in a repeated group and it had some data (multiple records for several subjects). Then we performed a CRF update and we updated field "A" and we transferred the old data to the newly added field, but the "repeat key" numbers are not matching the old records. For example for the repeat key of "1", the newly added field gets its own repeat key of say "33" where there are only "32" records in the subjects CRF. The software, however, knows a way to reconnect this key of "33" to the record "1" since when we view the data for the subject, the new field properly shows up for the first record. But when we export the .xml data, this field (the new one) has a different repeat key, and we are using this key to collect the data for a single record.

    Any comments or suggestions on the issue?

    Thanks
    Saeed.
  • Hi Jamuna,

    The version we are using is Version: 3.1.2-Community, and when we imported the data we did not have any control on the repeat key. We just exported the data from the "old" crfs, we then uploaded the new CRFs and then we imported the data back into the new CRFs.

    Saeed.

    From: Jamuna Nyayapathi
    To: saeed esmaili sardari ; [email protected]
    Cc: "[email protected]inica.org"
    Sent: Wednesday, October 10, 2012 10:26 AM
    Subject: Re: [Users] Repeat Key Issue in Data Extraction
    Hi Saeed,
    Which version of OpenClinica are you using? Did you originally import the data, especially with the row#1? There are some issues with respect to importing data into repeating groups and saving it. What data extract is showing is likely how the data is saved into the database, check the audit trail to see if you get any clue.
    Jamuna
    On Wed, Oct 10, 2012 at 9:25 AM, saeed esmaili sardari wrote:
    Hi All,

    We have an issue with the extracted data for repeated group items where an update to a field is performed. We used to have a field, say field "A" in a repeated group and it had some data (multiple records for several subjects). Then we performed a CRF update and we updated field "A" and we transferred the old data to the newly added field, but the "repeat key" numbers are not matching the old records. For example for the repeat key of "1", the newly added field gets its own repeat key of say "33" where there are only "32" records in the subjects CRF. The software, however, knows a way to reconnect this key of "33" to the record "1" since when we view the data for the subject, the new field properly shows up for the first record. But when we export the .xml data, this field (the new one) has a different repeat key, and we are using this key to collect the data for a single record.

    Any comments or suggestions on the issue?

    Thanks
    Saeed.
  • jamuna269jamuna269 Posts: 109
    Hi Saeed,
    One way to fix the issue would be using the import module itself to update the row#1 data in the new crf instead of using the Data Entry from UI. When you do that make sure the older data is also included as import will reenter the data altogether again.
    This issue is fixed in 3.1.3 and the fix for it is available in 3.1.3_RC1 and can be downloaded from here.
    https://dev.openclinica.com/distros/enterprise/OpenClinica-ws-3.1.3-RC1.zip
    You can follow this issue here
    https://issuetracker.openclinica.com/view.php?id=14354
    Thanks,
    Jamuna
    On Wed, Oct 10, 2012 at 10:41 AM, saeed esmaili sardari wrote:
    Hi Jamuna,

    The version we are using is Version: 3.1.2-Community, and when we imported the data we did not have any control on the repeat key. We just exported the data from the "old" crfs, we then uploaded the new CRFs and then we imported the data back into the new CRFs.

    Saeed.

    From: Jamuna Nyayapathi
    To: saeed esmaili sardari ; [email protected]
    Cc: "[email protected]"
    Sent: Wednesday, October 10, 2012 10:26 AM
    Subject: Re: [Users] Repeat Key Issue in Data Extraction
    Hi Saeed,
    Which version of OpenClinica are you using? Did you originally import the data, especially with the row#1? There are some issues with respect to importing data into repeating groups and saving it. What data extract is showing is likely how the data is saved into the database, check the audit trail to see if you get any clue.
    Jamuna
    On Wed, Oct 10, 2012 at 9:25 AM, saeed esmaili sardari wrote:
    Hi All,

    We have an issue with the extracted data for repeated group items where an update to a field is performed. We used to have a field, say field "A" in a repeated group and it had some data (multiple records for several subjects). Then we performed a CRF update and we updated field "A" and we transferred the old data to the newly added field, but the "repeat key" numbers are not matching the old records. For example for the repeat key of "1", the newly added field gets its own repeat key of say "33" where there are only "32" records in the subjects CRF. The software, however, knows a way to reconnect this key of "33" to the record "1" since when we view the data for the subject, the new field properly shows up for the first record. But when we export the .xml data, this field (the new one) has a different repeat key, and we are using this key to collect the data for a single record.

    Any comments or suggestions on the issue?

    Thanks
    Saeed.
This discussion has been closed.