Parent-Child Form Record Linking - Revision history

Philip Lacey at 11:51, 2 September 2017

2017-09-02T11:51:54Z

Philip Lacey at 09:12, 2 July 2015

2015-07-02T09:12:03Z

Philip Lacey at 08:31, 2 July 2015

2015-07-02T08:31:01Z

Philip Lacey at 08:28, 2 July 2015

2015-07-02T08:28:31Z

Patrick Jenkins at 08:14, 2 July 2015

2015-07-02T08:14:23Z

Patrick Jenkins at 08:13, 2 July 2015

2015-07-02T08:13:31Z

Patrick Jenkins at 08:12, 2 July 2015

2015-07-02T08:12:29Z

Patrick Jenkins at 08:11, 2 July 2015

2015-07-02T08:11:48Z

Patrick Jenkins at 08:11, 2 July 2015

2015-07-02T08:11:05Z

Patrick Jenkins at 08:09, 2 July 2015

2015-07-02T08:09:56Z

@@ Line 17: / Line 17: @@
-[[File:RecordLinking_Page1.png]]
+[[File:RecordLinking_Page1.png|800px]]
@@ Line 37: / Line 37: @@
-[[File:RecordLinking_Page2.png]]
+[[File:RecordLinking_Page2.png|800px]]
@@ Line 43: / Line 43: @@
-[[File:RecordLinking_Page3.png]]
+[[File:RecordLinking_Page3.png|800px]]

@@ Line 32: / Line 32: @@
-When bxp is performing the record linking function it will group all of the records, or just the non-linked records (depending on the users choice of function), and using the matching field of the child form search for a match in the matching field of the parent form. If there is a match, bxp will insert the bxp record id of the parent form into the selected linking field of the child form. If no match is found the linking field of the child form will contain 0.
+When bxp is performing the record linking function it will group all of the records, or just the non-linked records (depending on the users choice of function).  Using the matching field of the child form search for a match in the matching field of the parent form. If there is a match, bxp will insert the bxp record id of the parent form into the selected linking field of the child form. If no match is found the linking field of the child form will contain 0.
-Once the user has selected the desired fields they simply need to click the ''Perform Record Linking'' button at the bottom of the page, once this button is clicked the record linking process will commence. Depending on the amount of records in the child database this process can take up a minute to complete.
+Once the user has selected the desired fields they simply need to click the ''Perform Record Linking'' button at the bottom of the page.  Once this button is clicked the record linking process will commence. Depending on the amount of records in the child database this process can take up a minute to complete.
@@ Line 40: / Line 40: @@
-Once the record linking process has completed, the user will be redirected to the final page of this process. This pages purpose is to convey to the user the successful completion of the record linking process, this page renders a count of how many records in the child database that did not have a valid parent record found. If there are orphan records found, bxp will render a complete list of these records on screen and provide a user with a button to click through to an orpahn record and link it manually.
+When the record linking process has completed, the user will be redirected to the final page of this process. The purpose of these pages is to convey to the user the successful completion of the record linking process.  This page generates a count of the number of records in the child database that did not have a valid parent record. If there are orphan records found, bxp will generate a complete list of these records on screen and provide a user with a button to click through to an orpahn record and link it manually.
 [[File:RecordLinking_Page3.png]]

@@ Line 20: / Line 20: @@
-After selecting the two forms that will act as the parent and child, a bxp user will be redirect to the second page of this process. On this page the following settings will have to be set:
+After selecting the two forms, the following settings will need to be set:
-'''1) Update all records or only the non-linked records -''' This setting allows the user to select if they wish to perform the record linking process on the entire child database or just the records in the child database that are not linked to a parent record.
+'''1) Update all records or only the non-linked records -''' This setting allows the user to perform the record linking process on the entire child database, or just the records in the child database that are not linked to a parent record.
 '''2) Matching field in the Parent form -''' This should contain the field in the parent form that contains a search value that matches a record in the child form
@@ Line 32: / Line 32: @@
-When bxp is performing the record linking function it will group all of the records or just the non-linked records (depending on the users choice of function), and using the matching field of the child form search for a match in the matching field of the parent form. If there is a match bxp will insert the bxp record id of the parent form into the selected linking filed of the child form. If no match is found the linking filed of the child form will contain 0.
+When bxp is performing the record linking function it will group all of the records, or just the non-linked records (depending on the users choice of function), and using the matching field of the child form search for a match in the matching field of the parent form. If there is a match, bxp will insert the bxp record id of the parent form into the selected linking field of the child form. If no match is found the linking field of the child form will contain 0.
 Once the user has selected the desired fields they simply need to click the ''Perform Record Linking'' button at the bottom of the page, once this button is clicked the record linking process will commence. Depending on the amount of records in the child database this process can take up a minute to complete.

@@ Line 1: / Line 1: @@
 == Overview ==
-bxp provides users of the system the ability to link any two forms together, in a parent child form structure. Any two forms can be linked together if the following two conditions are met:
+bxp has the ability to link any two forms together, in a parent child form structure. Any two forms can be linked if the following two conditions are met:
-) A field in the parent form contains a value that is also present in all of the records associated with it in the child form.
+) A field in the parent form contains a value that is also present in all of the records in a child form.
 ) There is a field in the child database specifically used to store the link between a parent and child form.
@@ Line 11: / Line 11: @@
 == Linking records in a child form to a parent form ==
-To perform record linking in bxp, navigate the following system path: Main Menu > Form Management > Form - Data Cleaning - Mass Update - Parent-Child From Record Linking. After clicking on this link you will be redirected to the first page of this process, here you will need to select the form that will act as the parent and the form that will act as the child. These forms cannot be the same, as one form cannot be the patent and the child at the same time.
+To perform record linking in bxp, navigate the following path: Main Menu > Form Management > Form - Data Cleaning - Mass Update - Parent-Child From Record Linking. After clicking on this link you will be redirected to the first page of this process.  From here select the parent form and the child form. These forms cannot be the same as one form cannot be the parent and the child at the same time.
-There is no limit to the amount of child forms a parent form can have, a parent form can also be a child form for another.
+There is no limit to the amount of child forms a parent form can have.  A parent form can also be a child form for another.

← Older revision		Revision as of 08:14, 2 July 2015
Line 32:		Line 32:


−	When bxp is performing the record linking function it will group all of the records or just the no-linked records (depending on the users choice of function), and using the matching field of the child form search for a match in the matching field of the parent form. If there is a match bxp will insert the bxp record id of the parent form into the selected linking filed of the child form. If no match is found the linking filed of the child form will contain 0.	+	When bxp is performing the record linking function it will group all of the records or just the non-linked records (depending on the users choice of function), and using the matching field of the child form search for a match in the matching field of the parent form. If there is a match bxp will insert the bxp record id of the parent form into the selected linking filed of the child form. If no match is found the linking filed of the child form will contain 0.

	Once the user has selected the desired fields they simply need to click the ''Perform Record Linking'' button at the bottom of the page, once this button is clicked the record linking process will commence. Depending on the amount of records in the child database this process can take up a minute to complete.		Once the user has selected the desired fields they simply need to click the ''Perform Record Linking'' button at the bottom of the page, once this button is clicked the record linking process will commence. Depending on the amount of records in the child database this process can take up a minute to complete.

@@ Line 25: / Line 25: @@
 '''1) Update all records or only the non-linked records -''' This setting allows the user to select if they wish to perform the record linking process on the entire child database or just the records in the child database that are not linked to a parent record.
-'''2) Matching field in the Parent form -''' This should contain the field in the parent form that contains a search value matches a record in the child form
+'''2) Matching field in the Parent form -''' This should contain the field in the parent form that contains a search value that matches a record in the child form
 '''3) Matching field in the Child form -''' This should contain the field in the child form that contains a search value that matches a record in the parent form

@@ Line 23: / Line 23: @@
-) Update all records or only the non-linked records - This setting allows the user to select if they wish to perform the record linking process on the entire child database or just the records in the child database that are not linked to a parent record.
+'''1) Update all records or only the non-linked records -''' This setting allows the user to select if they wish to perform the record linking process on the entire child database or just the records in the child database that are not linked to a parent record.
-) Matching field in the Parent form - This should contain the filed in the parent form that contains a search value matches a record in the child form
+'''2) Matching field in the Parent form -''' This should contain the filed in the parent form that contains a search value matches a record in the child form
-) Matching field in the Child form - This should contain the filed in the child form that contains a search value that matches a record in the parent form
+'''3) Matching field in the Child form -''' This should contain the filed in the child form that contains a search value that matches a record in the parent form
-) Field to store the link  - This should contain the filed in the child form that will store the link between the child and parent form, it is recommended that this field is a ''campaign search question type''
+'''4) Field to store the link  -''' This should contain the filed in the child form that will store the link between the child and parent form, it is recommended that this field is a ''campaign search question type''

← Older revision		Revision as of 08:11, 2 July 2015
Line 14:		Line 14:


−	There is no limit to the amount of child forms a parent form can have, A parent form can also be a child form to another.	+	There is no limit to the amount of child forms a parent form can have, a parent form can also be a child form for another.

← Older revision		Revision as of 08:09, 2 July 2015
Line 1:		Line 1:
	== Overview ==		== Overview ==

−	bxp provides users of the system the ability to link any two forms together, in a parent child form structure. Any two forms can be linked together if the following ~~three~~ conditions are met:	+	bxp provides users of the system the ability to link any two forms together, in a parent child form structure. Any two forms can be linked together if the following two conditions are met: