- EpiData-list - University of Manitoba Mailing Lists

Make a Cascades and calculate some fields
by EpiData development and support 21 Jun '17

21 Jun '17

Dear All,I have 2 problems.1. Please somebody can help me to do a cascade in Epidata?My database have 4 levels (Region, District, Health Aeria and Village). I want to make a cascade model. So, when i select one region, i want to only have the district linked to the r?gion. The same for district and health aeria and village.2. How to have results with addition of some fields (Integer). In this Epidata version, we can calculate hours and concatenate. Best Regards?_______________________________________Konan Diby JP, MD, MPH Attaché de Recherche Labo. Biostatistique & Informatique Médicale UFR Sciences Médicale, Univ. F. Houphouët-Boigny 22 BP 1041 Abidjan 22, Côte d'Ivoire Tel./Fax: (+225) 22 401 403 GSM: (+225) 05 994 326 / 07 250 561 skype's: dibykonanjp

1 1

Re: [EpiData-list] EpiData-list Digest, Vol 159, Issue 2 Message 1
by EpiData development and support 20 Jun '17

20 Jun '17

You can develop relational data form to have this kind of structure. Use "RELATE" command in EpiData entry. Here's a simple example on my blog. https://myominnoo.blogspot.com/2016/03/creating-relational-form-in-epidata-… You can also use EpiData Manager and EntryClient to have this kind. All the best -- *Myo Minn Oo* Operational Research Fellow *International Union Against Tuberculosis and Lung Disease (The Union)* 36, 27th Street, Between 72nd and 73rd Streets, Mandalay, Myanmar Tel: +95 11-201182, 2 71082 Fax: (+95) 2 71082 www.theunion.org worldlunghealth.org <http://www.worldlunghealth.org/> *Tel:* (+95) 99705 45333, 94513 35581 *Skype:* myoetc *Email:* myominnoo(a)theunionmyanmar.org, dr.myominnoo(a)gmail.com

1 0

Re: [EpiData-list] EpiData-list Digest, Vol 159, Issue 2
by EpiData development and support 19 Jun '17

19 Jun '17

Dear All,Please somebody can help me to do a cascade in Epidata?My database have 4 levels (Region, District, Health Aeria and Village).I want to make a cascade model. When i select one region, i want to only have the district linked to the région. The same for district and health aeria and village.Best Regards _______________________________________Konan Diby JP, MD, MPH Attaché de Recherche Labo. Biostatistique & Informatique Médicale UFR Sciences Médicale, Univ. F. Houphouët-Boigny 22 BP 1041 Abidjan 22, Côte d'Ivoire Tel./Fax: (+225) 22 401 403 GSM: (+225) 05 994 326 / 07 250 561 skype's: dibykonanjp Le Vendredi 14 avril 2017 17h00, "epidata-list-request(a)lists.umanitoba.ca" <epidata-list-request(a)lists.umanitoba.ca> a écrit : Send EpiData-list mailing list submissions to epidata-list(a)lists.umanitoba.ca To subscribe or unsubscribe via the World Wide Web, visit http://lists.umanitoba.ca/mailman/listinfo/epidata-list 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. Re: Reg Epidata Manager 4.0.2.101 (EpiData development and support) 2. Re: Reg Epidata Manager 4.0.2.101 (EpiData development and support) 3. AUTO: CN=Louise Cullen/O=NWHB is out of the office. (returning 18/04/2017) (EpiData development and support) ---------------------------------------------------------------------- Message: 1 Date: Thu, 13 Apr 2017 13:24:16 -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] Reg Epidata Manager 4.0.2.101 Message-ID: <6576F7E6-6E13-4FA0-AD4D-EF24A964BA2A(a)bell.net> Content-Type: text/plain; charset=utf-8 1) Can you wait and do this in Analysis or another software? Unless your data entry logic depends on this time difference, it should not be necessary to do the calculation in EntryClient. 2) It would be nice, but not in this version. You certainly don?t have to enter the seconds - they will always show up as 00. Jamie > On Apr 13, 2017, Madhurita wrote: > > 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? > ------------------------------ Message: 2 Date: Thu, 13 Apr 2017 19:26:49 +0200 From: EpiData development and support <epidata-list(a)lists.umanitoba.ca> To: epidata-list(a)lists.umanitoba.ca Subject: Re: [EpiData-list] Reg Epidata Manager 4.0.2.101 Message-ID: <8C5A0DE3-7509-4108-9EE8-CFDC4C789894(a)epidata.dk> Content-Type: text/plain; charset=utf-8 Have you made the target variable a float? That is say length 6 and two or three decimals? Best wishes Jens Lauritsen On 13 April 2017 19:24:16 CEST, EpiData development and support <epidata-list(a)lists.umanitoba.ca> wrote: >1) Can you wait and do this in Analysis or another software? Unless >your data entry logic depends on this time difference, it should not be >necessary to do the calculation in EntryClient. > >2) It would be nice, but not in this version. You certainly don?t have >to enter the seconds - they will always show up as 00. > >Jamie > >> On Apr 13, 2017, Madhurita wrote: >> >> 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? >> > >_______________________________________________ >EpiData-list mailing list >EpiData-list(a)lists.umanitoba.ca >http://lists.umanitoba.ca/mailman/listinfo/epidata-list -- Sent from my Android device with K-9 Mail. Please excuse my brevity. ------------------------------ Message: 3 Date: Thu, 13 Apr 2017 22:02:39 +0100 From: EpiData development and support <epidata-list(a)lists.umanitoba.ca> To: epidata-list(a)lists.umanitoba.ca Subject: [EpiData-list] AUTO: CN=Louise Cullen/O=NWHB is out of the office. (returning 18/04/2017) Message-ID: <OF5889B08C.4B83D5E6-ON80258101.00739980-80258101.00739980(a)mailb.hse.ie> Content-Type: text/plain; charset="ISO-8859-1" I am out of the office until 18/04/2017. Please contact Tracey McCole on 071 9852900 if you require further assistance, otherwise I will attend to your email when I return Note: This is an automated response to your message "EpiData-list Digest, Vol 159, Issue 1" sent on 13/04/2017 18:00:15. This is the only notification you will receive while this person is away. *************************************************************************** "T? an fhaisn?is sa r?omhphost seo (ceangalt?in san ?ireamh) faoi r?n. Baineann s? leis an t? ar seoladh chuige amh?in agus t? s? ar intinn go bhfaighfidh siadsan amh?in ? agus gurb iadsan amh?in a dh?anfaidh breithni? air. M?s rud ? nach tusa an duine ar leis ?, t? cosc ioml?n ar aon fhaisn?is at? ann, a ?s?id, a chraobhscaoileadh, a scaipeadh, a nochtadh, a fhoilsi?, n? a ch?ipe?il . Seains gurb iad tuairim? pearsanta an ?dar at? san r?omhphost agus nach tuairim? FSS iad. M? fuair t? an r?omhphost seo tr? dhearmad, bheadh muid bu?och d? gcuirfe? in i?il don.Deasc Seirbh?s? ECT ar an nguth?n ag +353 71 9820555 n? ar an r?omhphost chuig ICT.Helpdesk(a)hse.ie agus ansin glan an r?omhphost seo ded' ch?ras." *************************************************************************** "Information in this email (including attachments) is confidential. It is intended for receipt and consideration only by the intended recipient.If you are not an addressee or intended recipient, any use, dissemination,distribution, disclosure, publication or copying of information contained in this email is strictly prohibited..Opinions expressed in this email may be personal to the author and are not necessarily the opinions of the HSE. If this email has been received by you in error we would be grateful if you could immediately notify the ICT Service Desk by telephone at +353 71 9820555 or by email to ICT.Helpdesk(a)hse.ie and thereafter delete this e-mail from your system" *************************************************************************** ------------------------------ ________________________________________ EpiData-list(a)lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list End of EpiData-list Digest, Vol 159, Issue 2 ********************************************

1 0

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

indexing records in epidatastat and retrieving values
by EpiData development and support 14 Apr '17

14 Apr '17

Dear Sir, I am trying to retrieve value of variables based on other variables. Example: a dataset with 3 observations: # region_code ill 1 21 4 2 30 10 3 40 6 i have tried the following: sort region_code gen i s =_n @ill[1] but i am getting the result of the last observation and not the first. I will be thankful if you advise on how to retrieve the value of a variable based on record indexing. Sincerely Nada -- Nada Ghosn, MD Head, Epidemiology Surveillance Program (Esumoh) Ministry of Public Health Beirut, Museum square Lebanon Tel +961.1.614194 Fax +961.1.610920 Email esumohleb(a)gmail.com, esumoh(a)moph.gov.lb Website www.moph.gov.lb

1 1

AUTO: CN=Louise Cullen/O=NWHB is out of the office. (returning 18/04/2017)
by EpiData development and support 13 Apr '17

13 Apr '17

I am out of the office until 18/04/2017. Please contact Tracey McCole on 071 9852900 if you require further assistance, otherwise I will attend to your email when I return Note: This is an automated response to your message "EpiData-list Digest, Vol 159, Issue 1" sent on 13/04/2017 18:00:15. This is the only notification you will receive while this person is away. *************************************************************************** "Tá an fhaisnéis sa ríomhphost seo (ceangaltáin san áireamh) faoi rún. Baineann sé leis an té ar seoladh chuige amháin agus tá sé ar intinn go bhfaighfidh siadsan amháin é agus gurb iadsan amháin a dhéanfaidh breithniú air. Más rud é nach tusa an duine ar leis é, tá cosc iomlán ar aon fhaisnéis atá ann, a úsáid, a chraobhscaoileadh, a scaipeadh, a nochtadh, a fhoilsiú, ná a chóipeáil . Seains gurb iad tuairimí pearsanta an údar atá san ríomhphost agus nach tuairimí FSS iad. Má fuair tú an ríomhphost seo trí dhearmad, bheadh muid buíoch dá gcuirfeá in iúil don.Deasc Seirbhísí ECT ar an nguthán ag +353 71 9820555 nó ar an ríomhphost chuig ICT.Helpdesk(a)hse.ie agus ansin glan an ríomhphost seo ded' chóras." *************************************************************************** "Information in this email (including attachments) is confidential. It is intended for receipt and consideration only by the intended recipient.If you are not an addressee or intended recipient, any use, dissemination,distribution, disclosure, publication or copying of information contained in this email is strictly prohibited..Opinions expressed in this email may be personal to the author and are not necessarily the opinions of the HSE. If this email has been received by you in error we would be grateful if you could immediately notify the ICT Service Desk by telephone at +353 71 9820555 or by email to ICT.Helpdesk(a)hse.ie and thereafter delete this e-mail from your system" ***************************************************************************

1 0

EpiData Manager, Append Records
by EpiData development and support 14 Mar '17

14 Mar '17

Hello, This is in reference to using EpiData Manager and trying to append records using the Tools > Append option, for a Project that has 2 dataforms. When the Append Project window appears, the fields available are only from the 1st dataform. After successfully appending, the dataset for the 1st form is complete, and the 2nd form appears to have the correct number of records, but when viewing the data, or exporting, all rows for the appended records are null. This is the same case with a Project with a parent and child forms. The data is complete for the Parent form, but the Child form has rows with null values for all appended records. EpiData Manager: (2017/03/14 - 10:05:27) Program Version: 4.0.2.101 r1409 Core version: 4.0.0.0 r1373 FPC Version: 3.0.0 Platform: x86_64-Win64 XML Version: 4 Dataforms Count: 2 Please let me know if you need additional information. Kind regards, Claudia Hansen | Data Systems Programmer, Data Management, GHR-GHPN 359 Blackwell Street, Suite 200 | Durham, NC 27701 O: 919.544.7040 ext. 11718 | chansen(a)fhi360.org | www.fhi360.org<http://www.fhi360.org/> | FHI 360 Facebook<https://www.facebook.com/fhi360> [Description: Description: Description: fhi 360 email.jpg]

1 0

EpiData Manager (v4.0.2.101) and EntryClient (v4.0.2.49) released
by EpiData development and support 03 Mar '17

03 Mar '17

Dear List. Today we have released a minor update for EpiData Manager (v4.0.2.101) and EntryClient (v4.0.2.49) with the following changes: *Manager* * Fixed a bug where starting with -i commandline, but with no arguments, which caused A/V * On Variable properties - moved EntryMode to basic pane. * Grouped Value Labels and Ranges together * Removed variable property "Show Value Label Notes" - was not used * Fixed bug were it was posible to try import data to valuelabels with unsuppported variables selected. * Rename "max missing value" and "2nd max..." to "last missing value" and "2nd last..." as it is actualle the order of missing values that matters *EntryClient* * Changed the behaviour and text for the dialog when an existing index/key is found * Fixed a bug where the program would crash on close if preferences were opened with a project opened * All hints (including error hints) now follow the timing set in preferences. * Fixed a bug where the default font on windows might not have been present on all operating systems The new version is as always available from the download page: http://www.epidata.dk/download.php Kind regards Torsten Bonde Christiansen EpiData

1 0

Suggestions for Epidata Manager
by EpiData development and support 17 Feb '17

17 Feb '17

Dear Sir, I have been using Epidata Manager, EntryClient for past one year. I like it's simple and user friendly features. With my recent use I have few suggestions: 1. In variable properties>Calculate, please provide option to calculate using any mathematical operation sign (+, -,÷,×) between atleast four variables. 2. For jump rules, if it should be allowed to set the values of the questions jumped as per the value of jump. For eg. If there are variables A, B, C and D. If Code 1 is selected in A then jump to D and put the code 2 in B and C. If Code 2 in a selected in A then jump to C and put the code 1 in B. 3. In date variables an option of automatic date and time capture which is once captured and doesn't not change if the same form opened next time. This will help if we have multiple sections for data entry in single form which will be entered at different time intervals. 4. In browse data, it will be helpful if we can select and see any particular data entry in columns. Warm regards, Peeyush peeyush1902(a)gmail.com

1 1