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

Is file look up possible?

Hello

We are involved in very extensive epidemiological research. We have started using Open Clinica for many small studies and plan to expand its use on a bigger scale.

ROBLEM-1

We have 1 CRF1 say fooditemcodes. (It contains 3 items viz food_code , food_description , food_calories). This list is constantly on a rise as we come across new food items relevant to study.

Our second CRF2 is say foodconsumptiondata. This has food consumption data for individual subjects. The 5 items are (subjectid, foodcode, fooddet, foodcal, foodwt).

Our problem: When a particular subject consumes food with foodcode= "A", then we have to make sure that "A" appears in fooditemcodes (CRF1) list by searching and matching. If it matches then it will bring those food_description into itenm: fooddet and food_calories into item: foodcal of CRF2. Then based on foodwt (which is the weight of that food) it will do some computaions.

What we have tried: We were suggested to write a rule comparing food_code with every food code available say A, A1, B------ etc. But it doesn't make any sense as our code list is going to updated constantly. Thats why we thought of creating a separate CRF of food codes and link our food consumption data from CRF1 by linkking food codes in CRF2 and getting the relevant info in CRF1.

Also when data for CRF2 is entered how do repeat the subject id as CRF will not take same subject again and each subject will have several records for each food item it has consumed.

This sort of file look up is extremely needed in our research. Any EFFICIENT solution will be really appreciated.

PROBLEM:-2

In a new study ( which is a sequel to old study) we already know the subjectid, sex, date of birth etc. This data is in foxpro format. Is it possible to import that in Open Clinica.? How to do it?

PROBLEM-3

We have a CRF1 tagged to event1. Entry is in progress. Subject id say X is entered

CRF2 is tagged to event2. Entry for subject id X is being made. Now in this CRF2 can we call or atleast display an item from CRF1 for subject X?


Best regards

Comments

  • charudattacharudatta Posts: 42
    Hello

    We are involved in very extensive epidemiological research. We have started using Open Clinica for many small studies and plan to expand its use on a bigger scale.

    ROBLEM-1

    We have 1 CRF1 say fooditemcodes. (It contains 3 items viz food_code , food_description , food_calories). This list is constantly on a rise as we come across new food items relevant to study.

    Our second CRF2 is say foodconsumptiondata. This has food consumption data for individual subjects. The 5 items are (subjectid, foodcode, fooddet, foodcal, foodwt).

    Our problem: When a particular subject consumes food with foodcode= "A", then we have to make sure that "A" appears in fooditemcodes (CRF1) list by searching and matching. If it matches then it will bring those food_description into itenm: fooddet and food_calories into item: foodcal of CRF2. Then based on foodwt (which is the weight of that food) it will do some computaions.

    What we have tried: We were suggested to write a rule comparing food_code with every food code available say A, A1, B------ etc. But it doesn't make any sense as our code list is going to updated constantly. Thats why we thought of creating a separate CRF of food codes and link our food consumption data from CRF1 by linkking food codes in CRF2 and getting the relevant info in CRF1.

    Also when data for CRF2 is entered how do repeat the subject id as CRF will not take same subject again and each subject will have several records for each food item it has consumed.

    This sort of file look up is extremely needed in our research. Any EFFICIENT solution will be really appreciated.

    PROBLEM:-2

    In a new study ( which is a sequel to old study) we already know the subjectid, sex, date of birth etc. This data is in foxpro format. Is it possible to import that in Open Clinica.? How to do it?

    PROBLEM-3

    We have a CRF1 tagged to event1. Entry is in progress. Subject id say X is entered

    CRF2 is tagged to event2. Entry for subject id X is being made. Now in this CRF2 can we call or atleast display an item from CRF1 for subject X?


    Best regards
  • Dear Charu,
    Regarding problem 1: You should probably keep the food listings in an external, controlled vocabulary and link to them from both of your CRFs. While it's still limited to Firefox users, OpenClinica currently supports the Javascript postMessage() function. You could put that Javascript in a simple PHP app and use Javascript to send it to your form. You can read more about it here:
    https://www.openclinica.org/dokuwiki/doku.php?id=developerwiki:postmessage
    Hope that helps, Tom
    Tom Hickerson - [email protected]
    Senior Developer
    Akaza Research, LLC
    -----Original Message-----
    Sent: Thu 8/26/2010 8:11
    To: [email protected]
    Cc: [email protected]
    Subject: [Developers] Fw: Is file look up possible?

    Hello
    We are involved in very extensive epidemiological research. We have started using Open Clinica for many small studies and plan to expand its use on a bigger scale.
    ROBLEM-1
    We have 1 CRF1 say fooditemcodes. (It contains 3 items viz food_code , food_description , food_calories). This list is constantly on a rise as we come across new food items relevant to study.
    Our second CRF2 is say foodconsumptiondata. This has food consumption data for individual subjects. The 5 items are (subjectid, foodcode, fooddet, foodcal, foodwt).
    Our problem: When a particular subject consumes food with foodcode= "A", then we have to make sure that "A" appears in fooditemcodes (CRF1) list by searching and matching. If it matches then it will bring those food_description into itenm: fooddet and food_calories into item: foodcal of CRF2. Then based on foodwt (which is the weight of that food) it will do some computaions.
    What we have tried: We were suggested to write a rule comparing food_code with every food code available say A, A1, B------ etc. But it doesn't make any sense as our code list is going to updated constantly. Thats why we thought of creating a separate CRF of food codes and link our food consumption data from CRF1 by linkking food codes in CRF2 and getting the relevant info in CRF1.
    Also when data for CRF2 is entered how do repeat the subject id as CRF will not take same subject again and each subject will have several records for each food item it has consumed.
    This sort of file look up is extremely needed in our research. Any EFFICIENT solution will be really appreciated.
    PROBLEM:-2
    In a new study ( which is a sequel to old study) we already know the subjectid, sex, date of birth etc. This data is in foxpro format. Is it possible to import that in Open Clinica.? How to do it?
    PROBLEM-3
    We have a CRF1 tagged to event1. Entry is in progress. Subject id say X is entered
    CRF2 is tagged to event2. Entry for subject id X is being made. Now in this CRF2 can we call or atleast display an item from CRF1 for subject X?
    Best regards
This discussion has been closed.