Admin at 23:06, 18 June 2015

2015-06-18T23:06:16Z

← Older revision		Revision as of 23:06, 18 June 2015
Line 64:		Line 64:

	==Additional Input Columns==		==Additional Input Columns==

			[[File:PENT_SmartMover_AdditionalInput.png\|link=]]

	;Suite		;Suite
	:Select the field in the input database that contains the Suite address information, if any.		:Select the field in the input database that contains the Suite address information, if any.

Admin: Created page with "{{PentahoSmartMoverNav |SmartMoverCollapse= }} {{CustomTOC}} The Input Columns tab configures the fields that will be used for the Change-of-Address lookup of the SmartMover..."

2015-06-18T23:05:30Z

Created page with "{{PentahoSmartMoverNav |SmartMoverCollapse= }} {{CustomTOC}} The Input Columns tab configures the fields that will be used for the Change-of-Address lookup of the SmartMover..."

New page

{{PentahoSmartMoverNav
|SmartMoverCollapse=
}}

{{CustomTOC}}

The Input Columns tab configures the fields that will be used for the Change-of-Address lookup of the SmartMover Component, as well as the input for name splitting and address parsing.

[[File:PENT_SmartMover_Input.png|link=]]

To identify a changed address, the following fields are required for each record:
#Either FirstName and LastName, FullName or Company
#Address
#Either City and State, and or ZIP

Existing field names are selected using the dropdown boxes.

==Input Name==
===Name Format===
;Full Name
:If this is an individual person's address and the entire name is stored as a single string, pass the contents of that field here.

:If the contact Name is already parsed, the Component can use information via the fields below.

===Parsed Components===
;Prefix
:This would be a title or honorific such as "Mr," "Miss," or "Dr."

;First Name
:This field accepts the given name for each record containing an individual address.

;Middle Name
:This field accepts an individual's middle name if one exists.

;Last Name
:This field accepts the family name for each record containing an individual address.

;Suffix
:This field accepts any part of the name that follows the family name, such as degrees ("MD" or "PhD") and generational indicators ("IV" or "Jr."), if one exists.

==Input Address==
;Company
:If the database records may be business type, include the company field here.

;Address
:Select the field in the input database that contains the first line of street address information. It may also contain secondary address information such as suite and private mailbox numbers.

;Address2
:Select the field in the input database that contains the second line of street address information, if any.

;City
:Select the field in the input database that contains the city information.

;State/Province
:Select the field in the input database that contains the state information.

;Zip/Postal Code
:Select the field in the input database that contains the postal code information.

;Country
:Select the field containing the country of the input data.

==Additional Input Columns==
;Suite
:Select the field in the input database that contains the Suite address information, if any.

;Private Mailbox
:Select the field in the input database that contains the Private Mailbox number, if any.

;Urbanization
:Select the field in the input database that contains the urbanization information, if any.

:Urbanization is used to break ties between similar addresses in Puerto Rico. The urbanization name tells the address checking logic in which "neighborhood" to look, if more than one likely address candidate is found.

:If just one address is found, the address checking logic can correct the address and return the urbanization name.

;Plus 4
:Select the field in the input database that contains the Plus 4 extension for US ZIP codes, if this information is stored separately.

[[Category:Pentaho]]

Pentaho:SmartMover:Input - Revision history

Admin at 23:06, 18 June 2015

Admin: Created page with "{{PentahoSmartMoverNav |SmartMoverCollapse= }} {{CustomTOC}} The Input Columns tab configures the fields that will be used for the Change-of-Address lookup of the SmartMover..."