- EpiData-list - University of Manitoba Mailing Lists

Importing data to Epidata analysis
by epidata-list＠lists.umanitoba.ca 09 Jan '13

09 Jan '13

Dear all, I would like to import data from the clipboard to Epidata analysis but it is not working. The data is in excel; I select and copy the range of cells that I need to import to Epidata analysis With Epidata analysis I select import from clipboard in the file drop down menu but i get the message below: "Separators: (tab: 7153)(semicolon: 0)(comma: 0)(space: 0) Lines: 14753 Cannot define number of variables" What could I be doing wrong? WK

1 2

EntryClient and Manager for Android
by epidata-list＠lists.umanitoba.ca 01 Jan '13

01 Jan '13

-

1 0

new testversion - prerelease - of EpiData Manager and EntryClient
by epidata-list＠lists.umanitoba.ca 22 Dec '12

22 Dec '12

Dear all A new version for testing was uploaded yesterday. The intention was that all issues have been adressed such that in the beginning of 2013 we can change the uploaded version to a general production version. Please find the updated versions at http://www.epidata.dk/testing.php Changes are as follows: Manager: * Updated designer form (moved icons) * Updated shortcuts on keyboard etc. to correct wiki. * Simplified import and add structure to a single method. * Pasting fields and sections is adapted to shift 20,20 pixels from original position. * Export forms adapted for (hopefully) more intuitive action. * If you open EntryClient from within Manager the user is asked if project should close and open in entryclient. * A new field attribute on automatic time fields to allow for three assets: set at new record, set on first save and save on update/edit * Recent files list is shared between Manager and EntryClient * Installation is now operating system specific and NOT dependent on java. Please test in the following 1-2 weeks and in the first week of 2013 we will fix any reported issue before releasing this version as the next public release. Regards and best seasonal wishes to all Jens Lauritsen Torsten Christiansen EpiData Association, Denmark

1 1

problems with import/export to stata
by epidata-list＠lists.umanitoba.ca 21 Dec '12

21 Dec '12

Hi Hope to get some help with a few problems. I'm a new epidata user and have downloaded manager v1.1.2 and entry v 1.1.1.1 - seemed to be the newest reliable version. Please correct me if wrong. I need to import some basic data from stata, add new variables in epidata, enter data and export it back to stata. So far importing data works fine, it's ok adding new variables and clicking "tools" - "export to stata" and "ok" works too. But back in stata the storage format has been change in some of my original data (eg string %10s - changed to %207s), and as well in some of the newly defined. Also missing data is in some cases "." in other ".z". I'm using stata 11 or 12 and have tried correcting the settings in "edit" - "settings" - "export" and "field definitions". It's not too deficult making it to a correct format while in stata - it's just a bit annoying. But whats worse - I tired importing it back to epidata again - making a few changes and then exporting to stata once more and then some of the storage types had completely changed - eg integer to float. Any suggestions? I downloaded epidata 3.1 as well but it does not seem to be compatible with importing stata newer than version 8. Any suggestions would be much appreciated! Anne

1 1

Comments for new released EpiData Manager 1.3
by epidata-list＠lists.umanitoba.ca 19 Dec '12

19 Dec '12

Dear EpiData list, After spending a whole day to explore the newly released EpiData Manager and EpiData EntryClient, I have some comments: 1. The new EpiData Manager is not as flexible as the older version in which I can add code for check file. For example, I cannot use EpiData Manager to calculate BMI. Or if I have 10 questions about mental health then I have no way to calculate the total score. The patients in some studies should be referred to psychiatrist if they have a mental health score > cutoff point at the time of assessment. There should be “EDIT” like the olde version. 2. Another example to show that “EDIT” to check data entry should be included. In the old EpiData, I can add some codes to do extra things. Ex: when I enter postal code for Vietnam, the city/province variable includes only cities or provinces in Vietnam. Or if I enter postal code for Australia, the city/province variable only has option to choose among Australian cities. No way to do this in this version. 3. I can enter data using Unicode font but when I export the data to CSV or STATA…, they do not work. It does not appear correctly (Vietnamese). 4. I love the way the old Epidata align fields because the variable names are aligned to the right of the screen. 5. The undo, redo symbol should be on the menu bar as users may need them 6. In Epidata Manager, Tools > EpiData EntryClient should open the form that users are working on. This is because the data manager will need to look at the format of the data entry form or want to test the form. 7. The Tools > Report should have an option for “code book” as we may need it to check the data. In the old version, the code book includes information about the mean, … 8. If the double entry file has password, then “Incorrect Password” message appears when validating data. No box appear for entering password in this case. 9. In the old EpiData, we can create parent-child data file which is very helpful in community survey or longitudinal data with the same baseline information. I cannot do this in this new version. I have some year experience teaching EpiData at the university, so I am happy to be the tester or to contribute something to this very interesting and helpful version. Thank you, Truc Thai Thanh Truc (♂), MPH Department of Biostatistics - Faculty of Public Health - HCMC University of Medicine and Pharmacy Email: <mailto:thaithanhtruc@gmail.com> thaithanhtruc(a)gmail.com or <mailto:thaithanhtruc@fphhcm.edu.vn> thaithanhtruc(a)fphhcm.edu.vn or <mailto:thai@connect.qut.edu.au> thai(a)connect.qut.edu.au Mobile: +84 908 381 266

1 8

RE: [EpiData-list] RE: EpiData-list Digest, Vol 108, Issue 2
by epidata-list＠lists.umanitoba.ca 15 Dec '12

15 Dec '12

Dear EpiData list, After spending a whole day to explore the newly released EpiData Manager and EpiData EntryClient, I have some comments: 1. The new EpiData Manager is not as flexible as the older version in which I can add code for check file. For example, I cannot use EpiData Manager to calculate BMI. Or if I have 10 questions about mental health then I have no way to calculate the total score. The patients in some studies should be referred to psychiatrist if they have a mental health score > cutoff point at the time of assessment. There should be “EDIT” like the olde version. 2. Another example to show that “EDIT” to check data entry should be included. In the old EpiData, I can add some codes to do extra things. Ex: when I enter postal code for Vietnam, the city/province variable includes only cities or provinces in Vietnam. Or if I enter postal code for Australia, the city/province variable only has option to choose among Australian cities. No way to do this in this version. 3. I can enter data using Unicode font but when I export the data to CSV or STATA…, they do not work. It does not appear correctly (Vietnamese). 4. I love the way the old Epidata align fields because the variable names are aligned to the right of the screen. 5. The undo, redo symbol should be on the menu bar as users may need them 6. In Epidata Manager, Tools > EpiData EntryClient should open the form that users are working on. This is because the data manager will need to look at the format of the data entry form or want to test the form. 7. The Tools > Report should have an option for “code book” as we may need it to check the data. In the old version, the code book includes information about the mean, … 8. If the double entry file has password, then “Incorrect Password” message appears when validating data. No box appear for entering password in this case. 9. In the old EpiData, we can create parent-child data file which is very helpful in community survey or longitudinal data with the same baseline information. I cannot do this in this new version. I have some year experience teaching EpiData at the university, so I am happy to be the tester or to contribute something to this very interesting and helpful version. Thank you, Truc Thai Thanh Truc (♂), MPH Department of Biostatistics - Faculty of Public Health - HCMC University of Medicine and Pharmacy Email: <mailto:thaithanhtruc@gmail.com> thaithanhtruc(a)gmail.com or <mailto:thaithanhtruc@fphhcm.edu.vn> thaithanhtruc(a)fphhcm.edu.vn or <mailto:thai@connect.qut.edu.au> thai(a)connect.qut.edu.au Mobile: +84 908 381 266

1 0

RE: EpiData-list Digest, Vol 108, Issue 2
by epidata-list＠lists.umanitoba.ca 15 Dec '12

15 Dec '12

Dear Jens Lauritsen The properties of the fields should be flexible. We only have 3 options to calculate things now. No way to calculate BMI or to use other formula. Regards, Truc ThS Thái Thanh Trúc (♂) Bộ môn Thống kê Y học - Khoa Y tế công cộng - Đại học Y dược TPHCM Email: <mailto:thaithanhtruc@gmail.com> thaithanhtruc(a)gmail.com hoặc <mailto:thaithanhtruc@fphhcm.edu.vn> thaithanhtruc(a)fphhcm.edu.vn hoặc <mailto:thai@connect.qut.edu.au> thai(a)connect.qut.edu.au ĐTDĐ: +84 908 381 266 ---------------------------------------------------------------------------------------------------------------------------------------------------- Thai Thanh Truc (♂), MPH Department of Biostatistics - Faculty of Public Health - HCMC University of Medicine and Pharmacy Email: <mailto:thaithanhtruc@gmail.com> thaithanhtruc(a)gmail.com or <mailto:thaithanhtruc@fphhcm.edu.vn> thaithanhtruc(a)fphhcm.edu.vn or <mailto:thai@connect.qut.edu.au> thai(a)connect.qut.edu.au Mobile: +84 908 381 266

1 0

inconsistens between mutlible formulars
by epidata-list＠lists.umanitoba.ca 15 Dec '12

15 Dec '12

My problem is hard to describe - of course. ;) I have 7 formulars with EpiData. There is a ID-field in each of it. After exporting them to Stata-files it is important that the order of the data rows fits to the other Stata-files. For example ID "X77" should appear in each 7 data sets in the same row. But it doesn't. Sometimes there are errors in it. Now I want to figure out, how this can happen? Does it happen if I reedit an entry or something like that. Do you have an idea? Christian Buhtz

1 1

Re:EpiData-list Digest, Vol 109, Issue 5
by epidata-list＠lists.umanitoba.ca 11 Dec '12

11 Dec '12

Dear all, When I use the new versions of manager and entryclient, I encountered some problems in win7 and xp. 1) manager 1.3.0.9 (using sample.epx) a)When I export the file sample.epx to SPSS file, the software gave me the warning: >Warning # 1151 >A field to be read under the EDATE format is invalid. The field must contain >day, month, and year separated by spaces, dashes, slashes, decimal points, or >commas. Note that American style dates (month/day/year) can be read under the >ADATE format. >Command line: 21 Current case: 1 Current splitfile group: 1 >Field contents: '201012/09/' >Record number: 1 Starting column: 36 Record length: 8192 I checked the syntax of sample.sps. The segment VL3 27-35(A) is not correct. It should be VL3 27-29(A). The length of the field VL3 is 3, right? b) I clicked the plus button in Valuelabel section of Field Properties, then the message box popped: Access violation. Press OK to ignore and risk data corruption. I pressed the OK button,then Field Valuelabel Editor appeared but the same message box too.I pressed the OK button then the program was not responding. c) I clicked Manage button in Valuelabel section in Field Properties, then the Valuelabel Editor displayed but the program was not responding immediately. Then I restarted the program and clicked plus button in Valuelabel section in Field Properties, the program disappeared and I must kill the process in Task Manager or I cannot open the manager again because it will not respond my double click on the program icon in file manager. EpiData Manager Program Version: 1.3.0.9 r517 Core version: 1.3.0.1 r635 FPC Version: 2.6.0 Platform: i386-Win32 Filename: Q:\Tools\Data\epidatamanager.1.3.0.9.win.32\samples\sample.epx XML Version: 2 Field count: 33 Record count: 12 2)entryclient 1.3.0.4 (using sample.epx) When I click Paths in the Program Settings, the entryclient did not response any operations and I have to end it in task manager. EpiData Entry Client Program Version: 1.3.0.4 r199 Core version: 1.3.0.1 r635 FPC Version: 2.6.0 Platform: i386-Win32 Filename: Q:\Tools\Data\epidataentryclient.1.3.0.4.win.32\samples\sample.epx XML Version: 2 Field count: 33 Record count: 12 Could you help me? Thanks! -- Best Regards, Richard Zhou 2012.12.10 At 2012-12-01 02:00:44,epidata-list-request@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. new pre-public-release versions of Manager, Entryclient and > Analysis (epidata-list(a)lists.umanitoba.ca) > > >---------------------------------------------------------------------- > >Message: 1 >Date: Thu, 29 Nov 2012 23:03:57 +0100 >From: epidata-list(a)lists.umanitoba.ca >Subject: [EpiData-list] new pre-public-release versions of Manager, > Entryclient and Analysis >To: EpiData-list(a)lists.umanitoba.ca >Message-ID: <50B7DBCD.4020802(a)epidata.dk> >Content-Type: text/plain; charset=ISO-8859-1; format=flowed > >Dear All > >On the testing page: http://www.epidata.dk/testing.php >You will now find a revised version for download of EpiData Manager and >EntryClient > >These have further bug-fixes in relation to copy and paste fields. >the manager is now version 1.3.0.9 and EntryClient 1.3.0.4 > >Additionally we are adapting EpiData Analysis to a common form of having >documents in the same folders as Manager and EntryClient and also that >the installer programme will conform to more recent security principles >in Windows 7 etc. As a first test of this a new installer is now found at: >Analysis 2.2.2.179: >http://www.epidata.dk/downloads/setupepidatastat_2.2.2.179.exe > >One single file can be started in English, French, Spanish or Chinese. >If you use Windows XP non-asian version the Chinese part will look >strange. Notice it is ONLY the installer which comes in different >languages NOT the software as such. We are aware that some of the text >which should be in e.g. Spanish is not translated yet, but please test >the installer in terms of rights and places where files are kept. > >We have initiated the translation principles for the interface of >Manager and EntryClient. More news on that later. For news on the >changes in Manager and EntryClient please see previous announcements. > >Regards > >Torsten Christiansen >Jens Lauritsen >EpiData Association >Denmark > > > > > > > >------------------------------ > >________________________________________ >EpiData-list(a)lists.umanitoba.ca >http://lists.umanitoba.ca/mailman/listinfo/epidata-list > > >End of EpiData-list Digest, Vol 109, Issue 5 >********************************************

1 0

Re: EpiData-list Digest, Vol 110, Issue 1
by epidata-list＠lists.umanitoba.ca 09 Dec '12

09 Dec '12

Sir/Madam Can you please help, I want Epidata import to SPSS. AMANAT ALI Statistical Data Analyst/ Computer Composer Cell No. +92-301-6052359 ________________________________ From: "epidata-list-request(a)lists.umanitoba.ca" <epidata-list-request(a)lists.umanitoba.ca> To: epidata-list(a)lists.umanitoba.ca Sent: Saturday, December 8, 2012 11:00 PM Subject: EpiData-list Digest, Vol 110, 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 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: EpiData-list Digest, Vol 109, Issue 5 (epidata-list(a)lists.umanitoba.ca) 2. Re: designed a long questionnaire (epidata-list(a)lists.umanitoba.ca) 3. Re: Re: designed a long questionnaire (epidata-list(a)lists.umanitoba.ca) ---------------------------------------------------------------------- Message: 1 Date: Sat, 8 Dec 2012 11:08:08 +0100 From: epidata-list(a)lists.umanitoba.ca Subject: [EpiData-list] RE: EpiData-list Digest, Vol 109, Issue 5 To: <epidata-list(a)lists.umanitoba.ca> Message-ID: <4325fffdbb2f36dbc42ddcc3b35ced49(a)mwinf5d08.me-wanadoo.net> Content-Type: text/plain; charset="us-ascii" Please, note the new link for "Course materials in French" : http://www.reseau-naissance.fr/module-pagesetter-viewpub-tid-2-pid-28.html Thank you Bernard BRANGER, Nantes, France ******************************************** ------------------------------ Message: 2 Date: Sat, 8 Dec 2012 13:31:34 +0000 From: epidata-list(a)lists.umanitoba.ca Subject: [EpiData-list] Re: designed a long questionnaire To: epidata-list(a)lists.umanitoba.ca Message-ID: <CACEkZF945hrU8iXw4438SEToO=is8VtF5ic__16g9bwQL9VwtQ(a)mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 Dear colleagues, I have designed a long questionnaire (more than 600 lines) for national survey data. Clearly, I could have done related rec files, unfortunately the data entry Clerc wanted all questionnaire on one page. After reading few records using the analysis or view data there appears to be a problem. Although some fields have been entered in the data entry form, the data does not show in the analysis (using Epidata Analysis, Stata, Excel). Is there any other way to analyis this data beside editing manuelly ? Kind regards Tieble On 30 November 2012 18:00, <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. new pre-public-release versions of Manager, Entryclient and > Analysis (epidata-list(a)lists.umanitoba.ca) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Thu, 29 Nov 2012 23:03:57 +0100 > From: epidata-list(a)lists.umanitoba.ca > Subject: [EpiData-list] new pre-public-release versions of Manager, > Entryclient and Analysis > To: EpiData-list(a)lists.umanitoba.ca > Message-ID: <50B7DBCD.4020802(a)epidata.dk> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > > Dear All > > On the testing page: http://www.epidata.dk/testing.php > You will now find a revised version for download of EpiData Manager and > EntryClient > > These have further bug-fixes in relation to copy and paste fields. > the manager is now version 1.3.0.9 and EntryClient 1.3.0.4 > > Additionally we are adapting EpiData Analysis to a common form of having > documents in the same folders as Manager and EntryClient and also that > the installer programme will conform to more recent security principles > in Windows 7 etc. As a first test of this a new installer is now found at: > Analysis 2.2.2.179: > http://www.epidata.dk/downloads/setupepidatastat_2.2.2.179.exe > > One single file can be started in English, French, Spanish or Chinese. > If you use Windows XP non-asian version the Chinese part will look > strange. Notice it is ONLY the installer which comes in different > languages NOT the software as such. We are aware that some of the text > which should be in e.g. Spanish is not translated yet, but please test > the installer in terms of rights and places where files are kept. > > We have initiated the translation principles for the interface of > Manager and EntryClient. More news on that later. For news on the > changes in Manager and EntryClient please see previous announcements. > > Regards > > Torsten Christiansen > Jens Lauritsen > EpiData Association > Denmark > > > > > > > > ------------------------------ > > ________________________________________ > EpiData-list(a)lists.umanitoba.ca > http://lists.umanitoba.ca/mailman/listinfo/epidata-list > > > End of EpiData-list Digest, Vol 109, Issue 5 > ******************************************** > ------------------------------ Message: 3 Date: Sat, 08 Dec 2012 16:27:24 +0100 From: epidata-list(a)lists.umanitoba.ca Subject: Re: [EpiData-list] Re: designed a long questionnaire To: epidata-list(a)lists.umanitoba.ca Message-ID: <6b418a19-5ff8-4408-b0cc-bdf89e187022(a)email.android.com> Content-Type: text/plain; charset=UTF-8 Which version of the software? What type of Fields container ni data in analysis? Regards jens Lauritsen epidata-list(a)lists.umanitoba.ca skrev: >Dear colleagues, >I have designed a long questionnaire (more than 600 lines) for national >survey data. >Clearly, I could have done related rec files, unfortunately the data >entry >Clerc wanted all questionnaire on one page. >After reading few records using the analysis or view data there appears >to >be a problem. >Although some fields have been entered in the data entry form, the data >does not show in the analysis (using Epidata Analysis, Stata, Excel). >Is there any other way to analyis this data beside editing manuelly ? >Kind regards > >Tieble > >On 30 November 2012 18:00, <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. new pre-public-release versions of Manager, Entryclient >and >> Analysis (epidata-list(a)lists.umanitoba.ca) >> >> >> >---------------------------------------------------------------------- >> >> Message: 1 >> Date: Thu, 29 Nov 2012 23:03:57 +0100 >> From: epidata-list(a)lists.umanitoba.ca >> Subject: [EpiData-list] new pre-public-release versions of Manager, >> Entryclient and Analysis >> To: EpiData-list(a)lists.umanitoba.ca >> Message-ID: <50B7DBCD.4020802(a)epidata.dk> >> Content-Type: text/plain; charset=ISO-8859-1; format=flowed >> >> Dear All >> >> On the testing page: http://www.epidata.dk/testing.php >> You will now find a revised version for download of EpiData Manager >and >> EntryClient >> >> These have further bug-fixes in relation to copy and paste fields. >> the manager is now version 1.3.0.9 and EntryClient 1.3.0.4 >> >> Additionally we are adapting EpiData Analysis to a common form of >having >> documents in the same folders as Manager and EntryClient and also >that >> the installer programme will conform to more recent security >principles >> in Windows 7 etc. As a first test of this a new installer is now >found at: >> Analysis 2.2.2.179: >> http://www.epidata.dk/downloads/setupepidatastat_2.2.2.179.exe >> >> One single file can be started in English, French, Spanish or >Chinese. >> If you use Windows XP non-asian version the Chinese part will look >> strange. Notice it is ONLY the installer which comes in different >> languages NOT the software as such. We are aware that some of the >text >> which should be in e.g. Spanish is not translated yet, but please >test >> the installer in terms of rights and places where files are kept. >> >> We have initiated the translation principles for the interface of >> Manager and EntryClient. More news on that later. For news on the >> changes in Manager and EntryClient please see previous announcements. >> >> Regards >> >> Torsten Christiansen >> Jens Lauritsen >> EpiData Association >> Denmark >> >> >> >> >> >> >> >> ------------------------------ >> >> ________________________________________ >> EpiData-list(a)lists.umanitoba.ca >> http://lists.umanitoba.ca/mailman/listinfo/epidata-list >> >> >> End of EpiData-list Digest, Vol 109, Issue 5 >> ******************************************** >> >_______________________________________________ >EpiData-list mailing list >EpiData-list(a)lists.umanitoba.ca >http://lists.umanitoba.ca/mailman/listinfo/epidata-list -- Sendt fra min Android telefon med K-9 Mail. Undskyld hvis jeg er lidt kortfattet. ------------------------------ ________________________________________ EpiData-list(a)lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list End of EpiData-list Digest, Vol 110, Issue 1 ********************************************

1 1