User information settings in Export
The following table shows what columns are included when a user information option is checked in the user information settings of export:
|
Option |
Table name |
Column name |
Exported column name |
|
User account information |
User Resource User User |
Id Short_Name Password PointBalance |
User_Id User_Username User_Password User_Points |
|
User e-mail |
User |
EmailRev |
User_Email |
|
Address information |
Address Address Address Address Address Country |
Address City Region Zipcode Country_Id Name |
User_Address User_City User_Region User_Zipcode User_CountryId User_Country |
|
Phone number |
Phonenumber
|
[Country_Id][Area_Code][Number][Extension] (type = 5) [Country_Id][Area_Code][Number][Extension] (Type=1) [Country_Id][Number] (Type=3) [Country_Id][Area_Code][Number][Extension] (Type=6) [Country_Id][Area_Code][Number][Extension] (Type=2) [Country_Id][Number] (Type=4) [Country_Id][Area_Code][Number][Extension] (Type=8) [Country_Id][Area_Code][Number][Extension] (Type=11) [Country_Id][Area_Code][Number][Extension] (Type=12) [Country_Id][Area_Code][Number][Extension] (Type=7) [Country_Id][Area_Code][Number][Extension] (Type=9) [Country_Id][Area_Code][Number][Extension] (Type=10) [Country_Id][Area_Code][Number][Extension] (Type=0) |
PhoneType_Business1 PhoneType_Home1 PhoneType_Mobile1 PhoneType_Business2 PhoneType_Home2 PhoneType_Mobile2 PhoneType_BusinessFax PhoneType_Fax1 PhoneType_Fax2 PhoneType_HomeFax PhoneType_Main1 PhoneType_Main2 PhoneType_NotIdentified |
- Note: The phone number has Country_Id is country code which get from column [Numbers] of table Country