Dear All, I have a relational database comprising of 8 data entry forms.
The structure is as follow;
FFNO FAMIDNUM CARD Family --------------- Ecouple ----------------------- Under5 ------ Growth Monitoring form | | | | | FFNO | CSNO | | | | Agesex Form Contraception
The field names in capital are unique key fields for relating the form during data entry. When I relate Growth Monitoring form Under5 form, the relating happens. When I relate Under5 Form with Ecouple the following message is displayed.
Loading data D:\EpiData\Try\Gm.rec, please wait.. Excluded: 1243184 records marked for deletion File name : D:\EpiData\Try\Gm.rec Growth Monitoring Register Fields: 9 Total records: 6 Included: 6 . relate card UNDER5 Loading data D:\EpiData\Try\UNDER5.REC, please wait.. Excluded: 1243148 records marked for deletion File name : D:\EpiData\Try\UNDER5.REC . relate FAMIDNUM Ecouple Loading data D:\EpiData\Try\Ecouple.REC, please wait.. Excluded: 1243148 records marked for deletion 1 4218388
The relation happens only up to 2 forms only. What is meant by the error message 1 4218388
Is there any way out. I am doing it through EPI6 at present which does it seamlessly. Do we still have development issue regarding RELATE command in the Epidata Analysis (Ver 2 Build 112b). I am attaching this sample database in the form of CHC ZIP. Please enlighten upon this problem.
Sincerely,
Dr. Shavinder
.
I can reproduce this exactly with my installed version of Analysis (Build 112). When I isolate the GM.REC file by changing its name (i.e. no longer have associated .chk and index files), the "Excluded: ..." message continues. So this is not a problem of the index file. The only way I could get rid of this message was by removing the File description from the first header line in the .rec file.
That is, changing
14 1 Filelabel: Growth Monitoring Register
to
14 1
I haven't seen this before, with many test files, so I just don't get it. EPI6 ignores everything else on the first line of a .rec file, so this suggests that there is some problem with the file description. Analysis doesn't care if this is not present. However, I've not seen this ever before. Jens can shed light on the header line. Sometimes it includes the word VLAB, but this doesn't help with this problem.
Jamie
Dr Shavinder wrote:
I have a relational database comprising of 8 data entry forms.When I relate Growth Monitoring form Under5 form, the relating happens. When I relate Under5 Form with Ecouple the following message is displayed.
Loading data D:\EpiData\Try\Gm.rec, please wait.. Excluded: 1243184 records marked for deletion File name : D:\EpiData\Try\Gm.rec Growth Monitoring Register Fields: 9 Total records: 6 Included: 6 . relate card UNDER5 Loading data D:\EpiData\Try\UNDER5.REC, please wait.. Excluded: 1243148 records marked for deletion File name : D:\EpiData\Try\UNDER5.REC . relate FAMIDNUM Ecouple Loading data D:\EpiData\Try\Ecouple.REC, please wait.. Excluded: 1243148 records marked for deletion 1 421838
participants (1)
-
epidata-list＠lists.umanitoba.ca