Why do titles have to be converted - Revision history

Philip Lacey at 16:27, 10 September 2016

2016-09-10T16:27:59Z

Philip Lacey at 23:24, 9 November 2014

2014-11-09T23:24:44Z

Philip Lacey at 23:23, 9 November 2014

2014-11-09T23:23:54Z

Philip Lacey at 02:41, 22 March 2014

2014-03-22T02:41:22Z

Philip Lacey: Created page with "Business Express uses a number of pre-built types. One of these types is the Complex – Title Block. The title block consists of 4 input fields, the first of which is a sel..."

2013-02-01T15:29:02Z

Created page with "Business Express uses a number of pre-built types. One of these types is the Complex – Title Block. The title block consists of 4 input fields, the first of which is a sel..."

New page

bxp software uses a number of pre-built types. One of these types is the Complex – Title Block. The title block consists of 4 input fields, the first of which is a select box with titles in it.

There are many titles in the world.
Mr, Ms, Mme, Dr, Fr and so

There are many variations for each type as well
Mr. Mr MR MR.

Consistency and space usage in BE is extremely important.

BE has a base standard list to ensure consistency. This standard list, to be consistent across all variations, means that 1 = Mr Mr. MR MR., 2 = Ms. Ms MS MS., and so on.

As this is a number it also saves space when storing the item in the database. For speed purposes it also makes listing and lookup much easier as the database matching on numbers is far more precise than text based matching.

One of the complications of this process is that the titles must be converted to their representative numeric value. To save a ton of effort in this regard BE has a function which will perform this tidy up in seconds.

Main Menu > Database Management > Data Cleaning > Data field – Convert Title to Numeric

As BE is unable to take personal responsibility for just “converting” data on behalf of our clients, we must ensure that our clients decide to use the function and on which fields as the conversion process does not just have to be on the title field, as a title drop down list could be any field in a campaign

@@ Line 10: / Line 10: @@
-Consistency and space usage in BE is extremely important.
+Consistency and space usage in bxp is extremely important.
-BE has a base standard list to ensure consistency.  This standard list, to be consistent across all variations, means that 1 = Mr Mr. MR MR., 2 = Ms. Ms MS MS., and so on.
+bxp has a base standard list to ensure consistency.  This standard list, to be consistent across all variations, means that 1 = Mr Mr. MR MR., 2 = Ms. Ms MS MS., and so on.
@@ Line 19: / Line 19: @@
-One of the complications of this process is that the titles must be converted to their representative numeric value.  To save a ton of effort in this regard BE has a function which will perform this tidy up in seconds.
+One of the complications of this process is that the titles must be converted to their representative numeric value.  To save a ton of effort in this regard bxp has a function which will perform this tidy up in seconds.
@@ Line 25: / Line 25: @@
-As BE is unable to take personal responsibility for just “converting” data on behalf of our clients, we must ensure that our clients decide to use the function and on which fields as the conversion process does not just have to be on the title field, as a title drop down list could be any field in a campaign
+As bxp is unable to take personal responsibility for just “converting” data on behalf of our clients, we must ensure that our clients decide to use the function and on which fields as the conversion process does not just have to be on the title field, as a title drop down list could be any field in a campaign

@@ Line 30: / Line 30: @@
 [[Category:Topic:Contact Centre]]
 [[Category:Topic:Customer Relationship Management]]
 [[Category:Module Specific:Form Management]]

@@ Line 28: / Line 28: @@
-[[Category:Learning:Contact Centre]]
+[[Category:Topic:Contact Centre]]
-[[Category:Learning:Customer Relationship Management]]
+[[Category:Topic:Customer Relationship Management]]
 [[Category:Module Specific:Form Management]]

← Older revision		Revision as of 02:41, 22 March 2014
Line 26:		Line 26:

	As BE is unable to take personal responsibility for just “converting” data on behalf of our clients, we must ensure that our clients decide to use the function and on which fields as the conversion process does not just have to be on the title field, as a title drop down list could be any field in a campaign		As BE is unable to take personal responsibility for just “converting” data on behalf of our clients, we must ensure that our clients decide to use the function and on which fields as the conversion process does not just have to be on the title field, as a title drop down list could be any field in a campaign
		+
		+
		+	[[Category:Learning:Contact Centre]]
		+	[[Category:Learning:Customer Relationship Management]]
		+	[[Category:Module Specific:Form Management]]