Field: User Email

From Catglobe Wiki
Jump to: navigation, search



Field: User_Email

Field: User_Email

Type

String

General Description

Email address is used as a communication mechanism in almost all contact activities between the system and user

Import Group

User Information

Business Rules

  • 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.

Auto mapping

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

Validation

  • 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)

Notes

N/A