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

Extracting Data

Hey All,

"Is there any way to extract data from a CRF with unlimited repeating items in a group so that the output is a "normalized" spreadsheet? In other words, the repeating items would list vertically in the spreadsheet rather than adding the fields across the spreadsheet horizontally?
Or, is there a reporting function that will pull a report in the manner described above?"

Thanks for your input in advance!

Greg Johnson, MCSE
Information Technology Support Engineer
Prairie Education & Research Cooperative
Phone: (217) 492-9100 x112

** PERC CONFIDENTIALITY NOTICE **
This information is intended only for the use of the individual or entity named above. The authorized recipient of this information is prohibited from disclosing this information to any other party and is required to destroy the information after its stated need has been fulfilled. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or action taken in reliance to the contents of these documents is strictly prohibited. If you have received this email in error, please notify the sender immediately to arrange for return of these documents.

Comments

  • rahularyarahularya Posts: 35
    Hi Greg,

    I am also looking for the same. Please if anyone can suggest this. It will be a great help

    Regards
    Rahul Arya
    From: Greg Johnson
    To: "[email protected]"
    Sent: Mon, March 29, 2010 9:53:31 PM
    Subject: [Users] Extracting Data
    Hey All,

    "Is there any way to extract data from a CRF with unlimited repeating items in a group so that the output is a "normalized" spreadsheet? In other words, the repeating items would list vertically in the spreadsheet rather than adding the fields across the spreadsheet horizontally?
    Or, is there a reporting function that will pull a report in the manner described above?"

    Thanks for your input in advance!

    Greg Johnson, MCSE
    Information Technology Support Engineer
    Prairie Education & Research Cooperative
    Phone: (217) 492-9100 x112

    ** PERC CONFIDENTIALITY NOTICE **
    This information is intended only for the use of the individual or entity named above. The authorized recipient of this information is prohibited from disclosing this information to any other party and is required to destroy the information after its stated need has been fulfilled. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or action taken in reliance to the contents of these documents is strictly prohibited. If you have received this email in error, please notify the sender immediately to arrange for return of these documents.
  • hevoilahevoila Posts: 126
    Hello Rick,
    I need to have your code to process the code with our JRE.
    I've an exception occurs here the message:
    Exception in thread "main" java.lang.UnsupportedClassVersionError: Bad version n
    umber in .class file
    at java.lang.ClassLoader.defineClass1(Native Method)
    at java.lang.ClassLoader.defineClass(Unknown Source)
    at java.security.SecureClassLoader.defineClass(Unknown Source)
    at java.net.URLClassLoader.defineClass(Unknown Source)
    at java.net.URLClassLoader.access$100(Unknown Source)
    at java.net.URLClassLoader$1.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(Unknown Source)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at java.lang.ClassLoader.loadClassInternal(Unknown Source)
    Could you send me your code to extracting DATA?
    very good job for all you've done,
    Thanks,
    Hevoila.
  • Hi everyone, i need to show some items when one item evaluates in true example:
    pseudocode
    if (item01 == true) then
    show(item02);
    show(item03);
    else
    hide(item02);
    hide(item03);
    thank you all
    Regards.
    Matias.
    > Date: Wed, 21 Apr 2010 15:13:31 +0200
    >
    > To: [email protected]
    > CC: [email protected]
    > Subject: [Developers] Extracting Data
    >
    > Hello Rick,
    >
    > I need to have your code to process the code with our JRE.
    >
    > I've an exception occurs here the message:
    > Exception in thread "main" java.lang.UnsupportedClassVersionError: Bad version n
    > umber in .class file
    > at java.lang.ClassLoader.defineClass1(Native Method)
    > at java.lang.ClassLoader.defineClass(Unknown Source)
    > at java.security.SecureClassLoader.defineClass(Unknown Source)
    > at java.net.URLClassLoader.defineClass(Unknown Source)
    > at java.net.URLClassLoader.access$100(Unknown Source)
    > at java.net.URLClassLoader$1.run(Unknown Source)
    > at java.security.AccessController.doPrivileged(Native Method)
    > at java.net.URLClassLoader.findClass(Unknown Source)
    > at java.lang.ClassLoader.loadClass(Unknown Source)
    > at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
    > at java.lang.ClassLoader.loadClass(Unknown Source)
    > at java.lang.ClassLoader.loadClassInternal(Unknown Source)
    >
    > Could you send me your code to extracting DATA?
    >
    > very good job for all you've done,
    >
    > Thanks,
    >
    > Hevoila.
    >
This discussion has been closed.