November 2011 - EpiData-list - University of Manitoba Mailing Lists

I can't normally export data to Stata
by epidata-list＠lists.umanitoba.ca 20 Dec '11

20 Dec '11

Dear friends, I can't export my data file to Stata. In dta file, labels of variables are normally displayed in Chinese character, but contents of records all are irrecognizable. My settings about Export in EpiData Manager(v0.8.8): Stata version: Stata 8,9Stata file encoding: Chinese simple(CP936) If you need my data file, I will email it to you.Thanks! RegardsRichard Zhou 2011.11.26 ===============================================================================

1 1

jumping variables
by epidata-list＠lists.umanitoba.ca 17 Nov '11

17 Nov '11

Dear List When i ad space, and than ad variables. They tend to jump around when i try to move them. Seems like there is no pattern to the jumping. Im using Program version 0.8.6.1 EpiData Manager on a Mac OSX system. Any tips or fixes? lars

1 4

Locking of a dataset in EpiData Entry
by epidata-list＠lists.umanitoba.ca 16 Nov '11

16 Nov '11

Dear Epi-data I have looked through all possible help-files for Epi-Data entry, but have not been able to find an answer. I am therefore writing now. Is it possible to lock the dataset in EpiData Entry, when entry has been finalized and the dataset is final? And will epi-data log any changes made - if possible with eg a password - if any are made after the data is locked? Thank you in advance for your help. Kind Regards Anna Aabakke M.D. and Ph.D.-student Dep. Gynaecology and Obstetrics University of Copenhagen, Holbæk Hospital

1 1

How to analyse for outcomes at specific periods during follow ups
by epidata-list＠lists.umanitoba.ca 15 Nov '11

15 Nov '11

Dear ALL I have a relational (Epidata entry) data base which I have data for over one year follow up of patients. I would like to analyse in Epidata analysis and check the Blood pressure, blood sugar readings......at every six months follow up for each patient since they were enrolled. How do I get to select six month, twelve month....visits for each patient form their date of enrollment. ( in my database I have var: entrydate at registration and visitdate on each visit) Thank you Walter

1 1

Double entry verification
by epidata-list＠lists.umanitoba.ca 10 Nov '11

10 Nov '11

Is it possible to use the Double Entry Verification tool on a relational database? The related REC files are: * Infant health diary.rec (the "Parent" file), and * Infant health diary weekly record.rec (the "Child" file) I created the double entry databases: * Infant health diary_dbl.rec, and * Infant health diary weekly record_dbl.rec In "Infant health diary_dbl.chk" I edited the code for the relate command so that the double entry file is linked: RELATE idchild "Infant health diary weekly record_dbl.rec" When opening "Infant health diary_dbl.rec" for entry, I'm not given a warning stating that EpiData is in double entry verification mode. Is there something else I need to do to make this work? If not, I realise I can set up a second relational database and check for inconsistencies once all the data's been entered. Cheers, Suzanna Vidmar Senior Research Officer Clinical Epidemiology and Biostatistics Unit Murdoch Childrens Research Institute Royal Children's Hospital Flemington Road Parkville Victoria 3052 Australia telephone: +61 3 9345 6372 facsimile: +61 3 9345 6000 email: suzanna.vidmar(a)mcri.edu.au www.mcri.edu.au <http://www.mcri.edu.au/> ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________

1 4

RE : EpiData-list Digest, Vol 97, Issue 7
by epidata-list＠lists.umanitoba.ca 09 Nov '11

09 Nov '11

Hi, A response to Réjean, I did not experience your "out of memory" problem, but I had the "Unable to open the file. An unknown error occured" one several times (because of ranges in DMY date fields, see my message on the list). In this case, you can edit the epx file in wordpad or notpad, and delete the wrong lines, supposing you can identify then (possibly lines concerning value labels in your case). Another solution is to backup files often, so that you don't have to start all over again each time. Sorry, this won't give you the solution of your problem, but maybe will help you keep your patience while testing the Manager! Confraternellement, Pascal Thibon, MD, Epidemiologist CHU Caen France

1 1

EpiData Manager bugs - Request for assistance - Follow-up.
by epidata-list＠lists.umanitoba.ca 08 Nov '11

08 Nov '11

Ma 08 nov 2011 To Torsten Bonde Christiansen: Dear colleague, As asked, the EpiData Manager version that was downloaded from the test web site on october 26 2011 is: Program Version: 0.8.8 r371 Core version: 0.8 r475 FPC Version: 2.4.4 Platform: i386-Win32 No installation was needed; it was simply copied on the desktop (bureau in french) by one of our IT peoples; should it be installed in a specific répertoire (folder)? It's a simple exe file that run after cliquing on the EpiData Manager icon. If of any use for you, the portable PC I use is a lenovo T400 running on Windows 7 and 64 bits (bibites in french?). If I can pass over those major bugs, especially this "out of memory" one, I could test this software and began my learning curve at the bottom. This "out of memory" bug remember me the old "runtime error" or "stack overflow" of the old Epi Info DOS; however, in the Win environment, it seem to be a fatal problem for the files... One of the things I also need to know is how to create something similar to the chek command COMMENTLEGAL (with codes and associated values). Many thanks for your support. Best regards, Réjean Réjean Dion, M.D. Médecin-conseil en santé publique (maladies infectieuses) Institut national de santé publique du Québec (INSPQ) / Laboratoire de santé publique du Québec (LSPQ) 20045, chemin Sainte-Marie, Sainte-Anne-de-Bellevue (Québec) Canada H9X 3R5 Tél.: (514) 457-2070 poste 325 Fax.: (514) 457-6346 Courriel / Lotus Notes: rejean.dion(a)inspq.qc.ca

1 1

encryption fields in EpiData
by epidata-list＠lists.umanitoba.ca 08 Nov '11

08 Nov '11

Greetings, I am implementing an application that has to import .REC files, including encryption fields. EpiData documentation says the encryption used is AES/Rijndael, and nothing more. That information is not sufficient, unfortunately. Therefore I would like to ask: (1) What is the keylength used? (2) What is the cipher mode of operation used? (3) If the cipher mode is ECB or CBC, what kind of padding is used? (4) Is an initialization vector or salt used? (I guess none, since EpiData creates the same encrypted text in the first line of the .REC file, whenever the same password is used). Probably these questions should be answered by a technical person, i.e. EpiData developer. Thank you in advance, Theodore Lytras

1 2

Epidata Manager tests
by epidata-list＠lists.umanitoba.ca 08 Nov '11

08 Nov '11

Bonjour à tous ! I have tested ED manager and entry client. It seems to me that this new version works fine and already looks very "professional". I only found 2 bugs (I hope this is the right place to report them) : 1/ ranges in DMY date fields : programming ranges for YMD date fields works fine, but for DMY date fields, the project will refuse to open in ED Entry Client. I only managed to open it after editing the xml file and erasing the lines containing the date range specification ; 2/ crash when trying to edit value labels of boolean fields Althought it's quite illogical, I tried to edit value labels for a boolean field. This caused an immediate crash 4 questions : 1/ I would like to program conditionnal jumps (in field X : jump to fiels Y if field Z=1). In previous versions, this was possible with AFTER ENTRY in chk files. 2/ It would be very useful to test a data structure directly in ED manager (CTRL-T in previous versions) 3/ In ED Entry client: at the end of a record, if you answer "NO" to "Save Y/N", all of the fields are cleared 4/ I work with sas for advanced analysis. Who do I export from ED ? Thanks again for this great software! Pascal THIBON, MD, Epidemiologist CHU Caen France

1 0

Missing example and pdf in linux packages
by epidata-list＠lists.umanitoba.ca 08 Nov '11

08 Nov '11

I just want to inform, if you downloading the Linux packages from the testing area the example file and pdf are only symbolic links and not the documents itself. By the way it seems that the Linux versions are not running under Ubuntu 11.10 due to changes in GTK libraries. I will try to use it on another system later on.

1 0

EpiData Manager bugs - Request for assistance.
by epidata-list＠lists.umanitoba.ca 08 Nov '11

08 Nov '11

Lu 07 nov 2011 This message was sent to epidata-list(a)lists.umanitoba.ca two days ago, but only the tittle was published in the Digest; for this reason, I'm sending it again, with the added mention "Request for assistance". Dear colleagues, I'm exploring EpiData Manager for creating a very simple data entry form. Here is the major bugs I encountered: - I can't save the epx file outside of the "bureau". - Each time I try to use the field value label editor (adding a new value) the system crash with an error message "out of memory"; this jump me out of Manager and when I try to open the existing epx file I can't and the following error message is displayed: "Unable to open the file. An unknown error occured". The file can't be recovered (I recreated a new epx file, but I lost all of them [including my patience after 10 trials]). - Displacing a field on the screen is somewhat erratic; the question beside the field seems to go farther away each time I try to correct the alignment. - Creating a new section box is problematic; I keep creating boxes over and over again and it's impossible to go back or to delete the empty boxes. Giving those bugs, I'm unable to create a project. Is there a manual explaining a little bit more how to use this new interface? The short orientation document is too general to be really usefull for a novice. The concept is interesting and I would like to test it, but I fly in the dark or in the mist actually. Cordialement, Réjean Réjean Dion, M.D. Médecin-conseil en santé publique (maladies infectieuses) Institut national de santé publique du Québec (INSPQ) / Laboratoire de santé publique du Québec (LSPQ) 20045, chemin Sainte-Marie, Sainte-Anne-de-Bellevue (Québec) Canada H9X 3R5 Tél.: (514) 457-2070 poste 325 Fax.: (514) 457-6346 Courriel / Lotus Notes: rejean.dion(a)inspq.qc.ca

1 1

EpiData Manager bugs.
by epidata-list＠lists.umanitoba.ca 05 Nov '11

05 Nov '11

1 0

Re: EpiData-list Digest, Vol 97, Issue 3
by epidata-list＠lists.umanitoba.ca 05 Nov '11

05 Nov '11

Dear Christine Would you please share me your experience of using epidata for outbreak investigation. Thanks Mohammed On Thu, Nov 3, 2011 at 6:00 PM, <epidata-list-request(a)lists.umanitoba.ca>wrote: > 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. How to save an epx file? (epidata-list(a)lists.umanitoba.ca) > 2. Re: How to save an epx file? (epidata-list(a)lists.umanitoba.ca) > 3. Re: EpiData and MPH Training (epidata-list(a)lists.umanitoba.ca) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Wed, 2 Nov 2011 13:24:34 -0400 > From: epidata-list(a)lists.umanitoba.ca > Subject: [EpiData-list] How to save an epx file? > To: epidata-list(a)lists.umanitoba.ca > Message-ID: > < > OF1D1F6BD8.0C8A41FB-ON8525793C.005EA698-8525793C.005FA215(a)isn.rtss.qc.ca> > > Content-Type: text/plain; charset="ISO-8859-1" > > Me 02 nov 2011 > > Hello all/Bonjour à tous, > > I'm testing latest EpiData Manager test version but my start is a bit > problematic, because I can't save the epx file of my new project. > > When I cliq on "Save project" or "Save project as", the following error > message with a big "x" surrounded by a red circle is shown: > Unable to create file "C:\folder\subfolder\filename.epx". > > I work in Windows 7 (for Windows, of course). Can anybody has a solution > to this very simple problem? > > Best regards/Cordialement, > > Réjean > > Réjean Dion, M.D. > Médecin-conseil en santé publique (maladies infectieuses) > Institut national de santé publique du Québec (INSPQ) / > Laboratoire de santé publique du Québec (LSPQ) > 20045, chemin Sainte-Marie, > Sainte-Anne-de-Bellevue (Québec) > Canada H9X 3R5 > Tél.: (514) 457-2070 poste 325 > Fax.: (514) 457-6346 > Courriel / Lotus Notes: rejean.dion(a)inspq.qc.ca > > > ------------------------------ > > Message: 2 > Date: Wed, 02 Nov 2011 19:39:39 +0100 > From: epidata-list(a)lists.umanitoba.ca > Subject: Re: [EpiData-list] How to save an epx file? > To: epidata-list(a)lists.umanitoba.ca > Message-ID: <4EB18E6B.9000504(a)epidata.dk> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > > Good to see that you are testing Rejean > I would assume that the explanation could be, that the > > Unable to create file "C:\folder\subfolder\filename.epx". > > is due to problems with the folder names. > Are you sure you that folder structure and also that you have write > access to it if it exists. > > Before you actually do the save, try to move to a folder, where you have > proper rights, could be "documents" or desktop. > > Regards > Jens Lauritsen > EpiData Association > > On 2011-11-02 18:24, epidata-list(a)lists.umanitoba.ca wrote: > > When I cliq on "Save project" or "Save project as", the following error > > message with a big "x" surrounded by a red circle is shown: > > Unable to create file "C:\folder\subfolder\filename.epx". > > I work in Windows 7 (for Windows, of course). Can anybody has a solution > > to this very simple problem? > > > > > > ------------------------------ > > Message: 3 > Date: Thu, 03 Nov 2011 08:55:21 +1300 > From: epidata-list(a)lists.umanitoba.ca > Subject: Re: [EpiData-list] EpiData and MPH Training > To: <epidata-list(a)lists.umanitoba.ca> > Message-ID: <4EB256FA020000CA0000C02B(a)gw.hvh.co.nz> > Content-Type: text/plain; charset="US-ASCII" > > Hi Eric > > it was good to see your post. I teach some short courses using Epidata to > investigate outbreaks as part of an epi skills development programme > offered by ESR (the New Zealand equivalent of CDC). These are short courses > for public health field staff. I've also used Epidata as part of a mainly > online MPH programme (although the course itself was face to face) in > biosecurity for Drs and Vets from South Asia - again the focus has been > outbreak detection so far. However we are looking at using Epidata as part > of some ongoing project work e.g. knowledge attitude prevalence surveys. If > you would like to talk some more about this maybe we could have a > discusssion off line. > > best wishes > > Christine > > > > Christine Roseveare| Senior Public Health Analyst, Systems Quality and > Intelligence | Clinical Leadership and Intelligence Group | > T 04 570 9194 | M 027 495 9671 | F 04 570 9211 | Regional Public Health | > Private Bag 31-907 Lower Hutt 5040 | www.rph.org.nz > > My hours of work are 9 - 5.30 Monday to Thursday > > > >>> <epidata-list(a)lists.umanitoba.ca> 1/11/2011 9:25 a.m. >>> > Greetings from Burlington, > > > > I am a new member of epidata-list, and I am keen to receive advice about > incorporating training in EpiData Entry and Analyst in the MPH Program at > the Dalla Lana School of Public Health at the Univ. of Toronto. I teach the > course on Public Health Surveillance in the second term. This will be the > second year that I oversee this course, and I would like to find some > better > way to integrate the lectures and the exercises, perhaps through EpiData > training. I suspect that EpiData would be ideal for introducing the > principles and basic skills required for CD outbreak detection and > management. But I think it might also be useful for cluster investigation, > socio-demographic profiles (e.g., recent immigrants in a PHU area) and > monitoring behavioural RF over time. > > > > Keen to hook up with epidata-list members who have some experience offering > training in EpiData at the MPH level. Keen to find useful teaching > exercises > that are shareable, too. > > > > Most grateful for any advice! > > > > Sincerely, > > > > Eric J. Holowaty, > > Professor, Div. of Epidemiology, > > Dalla Lana School of Public Health, > > Univ. of Toronto. > > > > -- > The information contained in this email and > any attachments is confidential and may be > legally privileged. If you have received this > message in error, please notify the sender > immediately and remove all copies of the message, > including any attachments. Any views or > opinions expressed in this email (unless > otherwise stated) may not represent those of > Hutt Valley DHB. > Thank you. > ** Disclaimer added by HVDHB ** > > > > ______________________________________________________________________________ > > This email has been scrubbed for your protection by SMX. > For more information visit http://smxemail.com > > ______________________________________________________________________________ > > > > ------------------------------ > > ________________________________________ > EpiData-list(a)lists.umanitoba.ca > http://lists.umanitoba.ca/mailman/listinfo/epidata-list > > > End of EpiData-list Digest, Vol 97, Issue 3 > ******************************************* >

1 2

Re: [EpiData-list] EpiData and MPH Training
by epidata-list＠lists.umanitoba.ca 02 Nov '11

02 Nov '11

Hi Eric it was good to see your post. I teach some short courses using Epidata to investigate outbreaks as part of an epi skills development programme offered by ESR (the New Zealand equivalent of CDC). These are short courses for public health field staff. I've also used Epidata as part of a mainly online MPH programme (although the course itself was face to face) in biosecurity for Drs and Vets from South Asia - again the focus has been outbreak detection so far. However we are looking at using Epidata as part of some ongoing project work e.g. knowledge attitude prevalence surveys. If you would like to talk some more about this maybe we could have a discusssion off line. best wishes Christine Christine Roseveare| Senior Public Health Analyst, Systems Quality and Intelligence | Clinical Leadership and Intelligence Group | T 04 570 9194 | M 027 495 9671 | F 04 570 9211 | Regional Public Health | Private Bag 31-907 Lower Hutt 5040 | www.rph.org.nz My hours of work are 9 - 5.30 Monday to Thursday >>> <epidata-list(a)lists.umanitoba.ca> 1/11/2011 9:25 a.m. >>> Greetings from Burlington, I am a new member of epidata-list, and I am keen to receive advice about incorporating training in EpiData Entry and Analyst in the MPH Program at the Dalla Lana School of Public Health at the Univ. of Toronto. I teach the course on Public Health Surveillance in the second term. This will be the second year that I oversee this course, and I would like to find some better way to integrate the lectures and the exercises, perhaps through EpiData training. I suspect that EpiData would be ideal for introducing the principles and basic skills required for CD outbreak detection and management. But I think it might also be useful for cluster investigation, socio-demographic profiles (e.g., recent immigrants in a PHU area) and monitoring behavioural RF over time. Keen to hook up with epidata-list members who have some experience offering training in EpiData at the MPH level. Keen to find useful teaching exercises that are shareable, too. Most grateful for any advice! Sincerely, Eric J. Holowaty, Professor, Div. of Epidemiology, Dalla Lana School of Public Health, Univ. of Toronto. -- The information contained in this email and any attachments is confidential and may be legally privileged. If you have received this message in error, please notify the sender immediately and remove all copies of the message, including any attachments. Any views or opinions expressed in this email (unless otherwise stated) may not represent those of Hutt Valley DHB. Thank you. ** Disclaimer added by HVDHB ** ______________________________________________________________________________ This email has been scrubbed for your protection by SMX. For more information visit http://smxemail.com ______________________________________________________________________________

1 0

How to save an epx file?
by epidata-list＠lists.umanitoba.ca 02 Nov '11

02 Nov '11

Me 02 nov 2011 Hello all/Bonjour à tous, I'm testing latest EpiData Manager test version but my start is a bit problematic, because I can't save the epx file of my new project. When I cliq on "Save project" or "Save project as", the following error message with a big "x" surrounded by a red circle is shown: Unable to create file "C:\folder\subfolder\filename.epx". I work in Windows 7 (for Windows, of course). Can anybody has a solution to this very simple problem? Best regards/Cordialement, Réjean Réjean Dion, M.D. Médecin-conseil en santé publique (maladies infectieuses) Institut national de santé publique du Québec (INSPQ) / Laboratoire de santé publique du Québec (LSPQ) 20045, chemin Sainte-Marie, Sainte-Anne-de-Bellevue (Québec) Canada H9X 3R5 Tél.: (514) 457-2070 poste 325 Fax.: (514) 457-6346 Courriel / Lotus Notes: rejean.dion(a)inspq.qc.ca

1 1

epidata as relational database for disaster electronic medical record
by epidata-list＠lists.umanitoba.ca 01 Nov '11

01 Nov '11

In 2006, our region suffered massive flooding. We even had to evacuate one hospital to another. We opened an evacuation shelter in the gymnasium at the local university. One section was basically a field hospital for the medically needy evacuees. Our patient record-keeping at that time was a little week. We recently suffered another massive flood, several-fold worse than 2006. 30,000 people, 15% of our county's population,were evacuated. We had 1800 people in an evacuation shelter in that same gymnasium. About 100 were "medical needs" evacuees--oxygen, BiPAP, skilled nursing needs, etc. Our record keeping was better this time, but still left something to be desired. I'm brainstorming ideas, both paper and electronic. Does anyone have any experience using Epidata as a relational database, so as to serve as a simple lightweight electronic medical record during a disaster? Thanks. --Chris Ryan, MD Clinical Associate Professor of Family Medicine SUNY Upstate Medical University, Binghamton, NY and Medical Director, Broome County Health Department

1 7

EpiData and MPH Training
by epidata-list＠lists.umanitoba.ca 01 Nov '11

01 Nov '11

Greetings from Burlington, I am a new member of epidata-list, and I am keen to receive advice about incorporating training in EpiData Entry and Analyst in the MPH Program at the Dalla Lana School of Public Health at the Univ. of Toronto. I teach the course on Public Health Surveillance in the second term. This will be the second year that I oversee this course, and I would like to find some better way to integrate the lectures and the exercises, perhaps through EpiData training. I suspect that EpiData would be ideal for introducing the principles and basic skills required for CD outbreak detection and management. But I think it might also be useful for cluster investigation, socio-demographic profiles (e.g., recent immigrants in a PHU area) and monitoring behavioural RF over time. Keen to hook up with epidata-list members who have some experience offering training in EpiData at the MPH level. Keen to find useful teaching exercises that are shareable, too. Most grateful for any advice! Sincerely, Eric J. Holowaty, Professor, Div. of Epidemiology, Dalla Lana School of Public Health, Univ. of Toronto.

1 2