May 2017 - EpiData-list - University of Manitoba Mailing Lists

Reg Epidata Manager 4.0.2.101
by EpiData development and support 03 Aug '17

03 Aug '17

This is a very basic question. 1) I am not able to automatically calculate the number of hours from the calculate option. I have input date and time and entered it into the calculate option but it is not giving me the correct answer. e.g. I have input date of injury and time of injury; and date of presentation and time of presentation. I need to calculate the number of hours of delay in presentation. I am not able to do that. 2) Is it possible to change the time option and exclude the seconds? Thank you, With regards, Madhurita

1 3

Re: [EpiData-list] Problem defining the key variable for a relational
by EpiData development and support 25 May '17

25 May '17

Thank you Jamie, that would appear to be the problem. I'll try to redo the structure from scratch. -Ruwan -----Original Message----- From: epidata-list-bounces(a)lists.umanitoba.ca [mailto:epidata-list-bounces@lists.umanitoba.ca] On Behalf Of epidata-list-request(a)lists.umanitoba.ca Sent: Wednesday, May 24, 2017 1:00 PM To: epidata-list(a)lists.umanitoba.ca Subject: EpiData-list Digest, Vol 160, Issue 1 Send EpiData-list mailing list submissions to epidata-list(a)lists.umanitoba.ca To subscribe or unsubscribe via the World Wide Web, visit https://urldefense.proofpoint.com/v2/url?u=http-3A__lists.umanitoba.ca_mail… or, via email, send a message with subject or body 'help' to epidata-list-request(a)lists.umanitoba.ca You can reach the person managing the list at epidata-list-owner(a)lists.umanitoba.ca When replying, please edit your Subject line so it is more specific than "Re: Contents of EpiData-list digest..." EpiData-list mailing list ___________________________________ Today's Topics: 1. Problem defining the key variable for a relational database (EpiData development and support) 2. Re: Problem defining the key variable for a relational database (EpiData development and support) ---------------------------------------------------------------------- Message: 1 Date: Tue, 23 May 2017 21:10:26 +0000 From: EpiData development and support <epidata-list(a)lists.umanitoba.ca> To: "epidata-list(a)lists.umanitoba.ca" <epidata-list(a)lists.umanitoba.ca> Subject: [EpiData-list] Problem defining the key variable for a relational database Message-ID: <MWHPR1201MB01589C72CC80AFF050E2F45696F90(a)MWHPR1201MB0158.namprd12.prod.outlook.com> Content-Type: text/plain; charset="us-ascii" Hi there, I have a relational database with three key variables (district_id; health facility_id; patient_id). It is relational as there are three forms: Patient Demographics, Patient Progress, Laboratory. For the Progress form, for some reason, when try to enter the variables in the key (Right click form>Define key), I cannot add anything more than the patient_ID. The other options are greyed out. For all other forms, entering multiple variables in the key is no problem. I'd appreciate some advice on what (obvious) option I am missing. Thank you! Ruwan ------------------------------ Message: 2 Date: Wed, 24 May 2017 11:35:46 -0400 From: EpiData development and support <epidata-list(a)lists.umanitoba.ca> To: EpiData List <epidata-list(a)lists.umanitoba.ca> Subject: Re: [EpiData-list] Problem defining the key variable for a relational database Message-ID: <89B424E3-7B17-4F75-8E4B-8106D0CD3AD1(a)bell.net> Content-Type: text/plain; charset=utf-8 I assume that your structure is like this: Demographics form \?> Progress form (1-many) \?> Laboratory form (1-many) Once you define a key(s) in demographics, it automatically defined for the child forms because it(they) define the relation. When you define a new key in progress, they key or keys you defined for Progress show, but are greyed out because you cannot remove them. So in progress, you can add a new key, which will be automatically defined for laboratory. You MUST know what your relationships and keys are before you start. Once you have created a subform, you cannot change the keys in the parent form. I find it best to set up the data forms with just the keys and maybe a couple of other fields first, to make sure the structure works for you. You can defined the type of relationship (1-1 or 1-many) and try out the flow of data entry from one form to another and back again. Then add in the rest of the fields. Jamie > On May 23, 2017, at 17:10, EpiData development and support <epidata-list(a)lists.umanitoba.ca> wrote: > > I have a relational database with three key variables (district_id; health facility_id; patient_id). It is relational as there are three forms: Patient Demographics, Patient Progress, Laboratory. > > For the Progress form, for some reason, when try to enter the variables in the key (Right click form>Define key), I cannot add anything more than the patient_ID. The other options are greyed out. For all other forms, entering multiple variables in the key is no problem. > > I'd appreciate some advice on what (obvious) option I am missing. ------------------------------ ________________________________________ EpiData-list(a)lists.umanitoba.ca https://urldefense.proofpoint.com/v2/url?u=http-3A__lists.umanitoba.ca_mail… End of EpiData-list Digest, Vol 160, Issue 1 ********************************************

1 0

Problem defining the key variable for a relational database
by EpiData development and support 24 May '17

24 May '17

Hi there, I have a relational database with three key variables (district_id; health facility_id; patient_id). It is relational as there are three forms: Patient Demographics, Patient Progress, Laboratory. For the Progress form, for some reason, when try to enter the variables in the key (Right click form>Define key), I cannot add anything more than the patient_ID. The other options are greyed out. For all other forms, entering multiple variables in the key is no problem. I'd appreciate some advice on what (obvious) option I am missing. Thank you! Ruwan

1 1