To the Epidata mailing list.
I have 3 questions about comparison of fields in Epidata Manager v. 1.1.2.
1) I would like to type the ID-number for the person (from 001 to 600) both in the beginning (Var1 – Integer field with length 3) and in the end (Var20 – Integer field with length 3) of my data collection file to be sure, that I am looking at the same person through the collection. Under Extended – Comparison I cannot find “Value must be = than”. How can I do this?
2) I would like to compare a record number for all persons asked for inclusion (Var1 – Auto Increment field) with the ID-number for included persons (Var6 – Integer field with length 3), but I cannot find Var1 under Extended – Comparison. How can I do this?
3) I would like to check, that the registration number (ddmmyyxxxx) of a person not is used in any other record. Can I compare the registration number (Var3 – Integer field with length 10) with the same field for all other records?
Kind regards Trine Graabæk Hansen, Esbjerg, Denmark
1) is not available, but I've asked for it as well. This should be simple to implement. 2) is possible, but only if you edit the project file after you create it, for now. At the moment, auto fields are not accessible in this part of Extended properties. When you create the project in Manager, add the comparison (still will need =), but to any other field. Save the project and open it in a plain text editor. Find the line with the comparison. It will look like this
<Compare toFieldRef="V1" type="fcLT"/>
Change the value for toFieldRef to the field name of your Auto Increment. This works as long as you do not edit the field again in Manager. 3) will work if you make Var3 a key field. You do this with the menu item Project/Key Fields... When you enter Var3, Entry Client checks all existing records.
Jamie
On 2013-02-04, Trine wrote:
I would like to type the ID-number for the person (from 001 to 600) both in the beginning (Var1 – Integer field with length 3) and in the end (Var20 – Integer field with length 3) of my data collection file to be sure, that I am looking at the same person through the collection. Under Extended – Comparison I cannot find “Value must be = than”. How can I do this?
I would like to compare a record number for all persons asked for inclusion (Var1 – Auto Increment field) with the ID-number for included persons (Var6 – Integer field with length 3), but I cannot find Var1 under Extended – Comparison. How can I do this?
I would like to check, that the registration number (ddmmyyxxxx) of a person not is used in any other record. Can I compare the registration number (Var3 – Integer field with length 10) with the same field for all other records?
Hi Trine and Jamie
1) This is correct and is also scheduled to be fixed.
2) I will strongly recommend against your proposal Jamie - do not edit the project file unless you really know what you are doing. Editing XML files is not an easy task and the risk is that you will end up with a broken file that you cannot use again. I have put Trine's suggestion on my todo-list, such that Auto-increment fields can be used in calculations as well.
3) Although Jamies suggestion is correct, this is only for Manager v. 1.3 and up. This is not implemented in the current stable release 1.1.2, but hopefully we are ready to release the current pre-release versions as stable version within a short time.
Regards, Torsten B. Christiansen. EpiData.
On 2013-02-04 16:36, epidata-list@lists.umanitoba.ca wrote:
is not available, but I've asked for it as well. This should be simple to implement.
is possible, but only if you edit the project file after you create it, for now. At the moment, auto fields are not accessible in this part of Extended properties. When you create the project in Manager, add the comparison (still will need =), but to any other field. Save the project and open it in a plain text editor. Find the line with the comparison. It will look like this
<Compare toFieldRef="V1" type="fcLT"/>Change the value for toFieldRef to the field name of your Auto Increment. This works as long as you do not edit the field again in Manager. 3) will work if you make Var3 a key field. You do this with the menu item Project/Key Fields... When you enter Var3, Entry Client checks all existing records.
Jamie
On 2013-02-04, Trine wrote:
I would like to type the ID-number for the person (from 001 to 600) both in the beginning (Var1 – Integer field with length 3) and in the end (Var20 – Integer field with length 3) of my data collection file to be sure, that I am looking at the same person through the collection. Under Extended – Comparison I cannot find “Value must be = than”. How can I do this?
I would like to compare a record number for all persons asked for inclusion (Var1 – Auto Increment field) with the ID-number for included persons (Var6 – Integer field with length 3), but I cannot find Var1 under Extended – Comparison. How can I do this?
I would like to check, that the registration number (ddmmyyxxxx) of a person not is used in any other record. Can I compare the registration number (Var3 – Integer field with length 10) with the same field for all other records?
EpiData-list mailing list EpiData-list@lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list
epidata-list@lists.umanitoba.ca
-
epidata-list＠lists.umanitoba.ca