Cg huyphong at 08:38, 14 December 2011

2011-12-14T08:38:54Z

← Older revision		Revision as of 08:38, 14 December 2011
Line 1:		Line 1:
	[[Category:Import module]]		[[Category:Import module]]
			{{Help_Files_Import_module}}

	==Field: User_Email==		==Field: User_Email==

Cg huyphong at 03:58, 26 April 2011

2011-04-26T03:58:47Z

← Older revision		Revision as of 03:58, 26 April 2011
Line 1:		Line 1:
	[[Category:~~HelpBooks~~]]		[[Category:Import module]]

Catglobe: jrfconvert import

2011-03-07T08:51:42Z

jrfconvert import

New page

[[Category:HelpBooks]]

==Field: User_Email==

{| class="tableintopic" style="border-collapse: collapse" width="1189" cellpadding="2"
| width="168" |
| width="1020" |
|- align="left" valign="top"
| style="border: 1px solid #010101" colspan="2" width="1189" |
==Field: User_Email==
|- align="left" valign="top"
| style="border: 1px solid #010101" width="168" |
Type
| style="border: 1px solid #010101" width="1021" |
String
|- align="left" valign="top"
| style="border: 1px solid #010101" width="168" |
General Description
| style="border: 1px solid #010101" width="1021" |
Email address is used as a communication mechanism in almost all contact activities between the system and user
|- align="left" valign="top"
| style="border: 1px solid #010101" width="168" |
Import Group
| style="border: 1px solid #010101" width="1021" |
User Information
|- align="left" valign="top"
| style="border: 1px solid #010101" width="168" |
Business Rules
| style="border: 1px solid #010101" width="1021" |
* User can only have one email address registered in Catglobe.
* If Import is used to insert a new user, then a new email address is added as well
* If Import is used to update an existing user, then the email address is updated for that user (meaning that any existing email address will be overwritten)
* To update this field for existing users, you must map the import using the User_Id column to show which users to update for. When updating and the imported excel value is NULL the existing database value will be set to blank.
|- align="left" valign="top"
| style="border: 1px solid #010101" width="168" |
Auto mapping
| style="border: 1px solid #010101" width="1021" |
In order to ensure auto mapping then the column name in the Excel must fit with the given name in import. This name is language dependent as shown:

UK: User_Email

DK: Bruger_Email
|- align="left" valign="top"
| style="border: 1px solid #010101" width="168" |
Validation
| style="border: 1px solid #010101" width="1021" |
* Email address must follow the email standard (name@domain), otherwise, invalid value will be informed. System will use a so-called ‘regular expression’ to easily recognize invalid email formats, so be sure to input the correct format. Error type: ERROR (the import job will not be allowed to be executed).
* Domain of email addresses need to exist and be valid. System will try to query the dns server to retrieve information about the domain name and a ‘warning’ message will be shown to let user know if the domain is not recognized by the DNS. Error type: WARNING (the import can be executed, but user is warned on possible problems with the data)
* ‘Name’ needs to exist and valid on the ‘Domain’ as well. System will both try to validate the domain and that the specific email name on the specified domain to retrieve information on the user. A ‘warning’ message will be shown to let user know if the name is invalid for the given domain. Error type: WARNING (the import can be executed, but user is warned on possible problems with the data)
* Email should be unique in database.A "warning" message will be shown to let the user know if there are duplicate email. Error type: WARNING (the import can be executed, but user is warned on possible problems with the data)
|- align="left" valign="top"
| style="border: 1px solid #010101" width="168" |
Notes
| style="border: 1px solid #010101" width="1021" |
N/A
__NOTOC__

Field: User Email - Revision history

Cg huyphong at 08:38, 14 December 2011

Cg huyphong at 03:58, 26 April 2011

Catglobe: jrfconvert import