Difference between revisions of "User information settings in Export"
(jrfconvert import) |
|||
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | + | | |
| − | | ||
| − | ==User information settings in Export== | + | == 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: | The following table shows what columns are included when a user information option is checked in the user information settings of export: | ||
| − | |||
| − | [Country_Id][Area_Code][Number][Extension] (Type=1) | + | {| width="1026" cellspacing="0" cellpadding="2" border="0" style="border-collapse:collapse" class="tableintopic" |
| + | |- valign="top" align="left" | ||
| + | | width="192" | | ||
| + | Option | ||
| + | |||
| + | | width="216" | | ||
| + | Table name | ||
| + | |||
| + | | width="408" | | ||
| + | Column name | ||
| + | |||
| + | | width="210" | | ||
| + | Exported column name | ||
| + | |||
| + | |- valign="top" align="left" | ||
| + | | width="192" | | ||
| + | User account information | ||
| + | |||
| + | | width="216" | | ||
| + | User | ||
| + | |||
| + | Resource | ||
| + | |||
| + | User | ||
| + | |||
| + | User | ||
| + | |||
| + | | width="408" | | ||
| + | Id | ||
| + | |||
| + | Short_Name | ||
| + | |||
| + | Password | ||
| + | |||
| + | PointBalance | ||
| + | |||
| + | | width="210" | | ||
| + | User_Id | ||
| + | |||
| + | User_Username | ||
| + | |||
| + | User_Password | ||
| + | |||
| + | User_Points | ||
| + | |||
| + | |- valign="top" align="left" | ||
| + | | width="192" | | ||
| + | User e-mail | ||
| + | |||
| + | | width="216" | | ||
| + | User | ||
| + | |||
| + | | width="408" | | ||
| + | EmailRev | ||
| + | |||
| + | | width="210" | | ||
| + | User_Email | ||
| + | |||
| + | |- valign="top" align="left" | ||
| + | | width="192" | | ||
| + | Address information | ||
| + | |||
| + | | width="216" | | ||
| + | Address | ||
| + | |||
| + | Address | ||
| + | |||
| + | Address | ||
| + | |||
| + | Address | ||
| + | |||
| + | Address | ||
| + | |||
| + | Country | ||
| + | |||
| + | | width="408" | | ||
| + | Address | ||
| + | |||
| + | City | ||
| + | |||
| + | Region | ||
| + | |||
| + | Zipcode | ||
| + | |||
| + | Country_Id | ||
| + | |||
| + | Name | ||
| + | |||
| + | | width="210" | | ||
| + | User_Address | ||
| + | |||
| + | User_City | ||
| + | |||
| + | User_Region | ||
| + | |||
| + | User_Zipcode | ||
| + | |||
| + | User_CountryId | ||
| + | |||
| + | User_Country | ||
| + | |||
| + | |- valign="top" align="left" | ||
| + | | width="192" | | ||
| + | Phone number | ||
| + | |||
| + | | width="216" | | ||
| + | Phonenumber | ||
| + | |||
| + | | ||
| + | |||
| + | | width="408" | | ||
| + | [Country_Id][Area_Code][Number][Extension] (type = 5) | ||
| + | |||
| + | [Country_Id][Area_Code][Number][Extension] (Type=1) | ||
[Country_Id][Number] (Type=3) | [Country_Id][Number] (Type=3) | ||
| Line 15: | Line 126: | ||
[Country_Id][Area_Code][Number][Extension] (Type=2) | [Country_Id][Area_Code][Number][Extension] (Type=2) | ||
| − | [Country_Id][Number] (Type=4) | + | [Country_Id][Number] (Type=4) |
| − | [Country_Id][Area_Code][Number][Extension] (Type=8) | + | [Country_Id][Area_Code][Number][Extension] (Type=8) |
| − | [Country_Id][Area_Code][Number][Extension] (Type=11) | + | [Country_Id][Area_Code][Number][Extension] (Type=11) |
| − | [Country_Id][Area_Code][Number][Extension] (Type=12) | + | [Country_Id][Area_Code][Number][Extension] (Type=12) |
| − | [Country_Id][Area_Code][Number][Extension] (Type=7) | + | [Country_Id][Area_Code][Number][Extension] (Type=7) |
| − | [Country_Id][Area_Code][Number][Extension] (Type=9) | + | [Country_Id][Area_Code][Number][Extension] (Type=9) |
| − | [Country_Id][Area_Code][Number][Extension] (Type=10) | + | [Country_Id][Area_Code][Number][Extension] (Type=10) |
[Country_Id][Area_Code][Number][Extension] (Type=0) | [Country_Id][Area_Code][Number][Extension] (Type=0) | ||
| − | | width="210" | | + | |
| + | | width="210" | | ||
PhoneType_Business1 | PhoneType_Business1 | ||
| Line 57: | Line 169: | ||
PhoneType_NotIdentified | PhoneType_NotIdentified | ||
| − | + | |} | |
| − | + | ||
| − | + | ***Note: The phone number has Country_Id is country code which get from column [Numbers] of table Country | |
| + | |||
| + | [[Category:Export_module]] | ||
Latest revision as of 11:14, 16 December 2011
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
