Jump to content
Toggle search
Toggle menu
  • 915 articles
  • 3.8K files
  • 30.2K users
  • 279.2K edits
Catglobe Wiki
Toggle preferences menu
Toggle personal menu
Not logged in
Your IP address will be publicly visible if you make any edits.

User information settings in Export: Difference between revisions

From Catglobe Wiki
More actions
← Older edit
VisualWikitext
Cg_pham (talk | contribs)
Cem, Maysunshine, Bots, Bureaucrats, Administrators
3,880 edits
No edit summary
Cg_pham (talk | contribs)
Cem, Maysunshine, Bots, Bureaucrats, Administrators
3,880 edits
No edit summary
 
Line 3: Line 3:
== 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:


<br>
{| width="1026" cellspacing="0" cellpadding="2" border="0" style="border-collapse:collapse" class="tableintopic"
<table width="1026" cellspacing="0" cellpadding="2" border="0" style="border-collapse:collapse" class="tableintopic"><tbody><tr valign="top" align="left"><td width="192"><p class="bodytext-bold">Option</p></td><td width="216"><p class="bodytext-bold">Table name</p></td><td width="408"><p class="bodytext-bold">Column name</p></td><td width="210"><p class="bodytext-bold">Exported column name</p></td></tr><tr valign="top" align="left"><td width="192"><p class="bodytext">User account information</p></td><td width="216"><p class="bodytext">User</p><p class="bodytext">Resource</p><p class="bodytext">User</p><p class="bodytext">User</p></td><td width="408"><p class="bodytext">Id</p><p class="bodytext">Short_Name</p><p class="bodytext">Password</p><p class="bodytext">PointBalance</p></td><td width="210"><p class="bodytext">User_Id</p><p class="bodytext">User_Username</p><p class="bodytext">User_Password</p><p class="bodytext">User_Points</p></td></tr><tr valign="top" align="left"><td width="192"><p class="bodytext">User e-mail</p></td><td width="216"><p class="bodytext">User</p></td><td width="408"><p class="bodytext">EmailRev</p></td><td width="210"><p class="bodytext">User_Email</p></td></tr><tr valign="top" align="left"><td width="192"><p class="bodytext">Address information</p></td><td width="216"><p class="bodytext">Address</p><p class="bodytext">Address</p><p class="bodytext">Address</p><p class="bodytext">Address</p><p class="bodytext">Address</p><p class="bodytext">Country</p></td><td width="408"><p class="bodytext">Address</p><p class="bodytext">City</p><p class="bodytext">Region</p><p class="bodytext">Zipcode</p><p class="bodytext">Country_Id</p><p class="bodytext">Name</p></td><td width="210"><p class="bodytext">User_Address</p><p class="bodytext">User_City</p><p class="bodytext">User_Region</p><p class="bodytext">User_Zipcode</p><p class="bodytext">User_CountryId</p><p class="bodytext">User_Country</p></td></tr><tr valign="top" align="left"><td width="192"><p class="bodytext">Phone number</p></td><td width="216"><p class="bodytext">Phonenumber</p><p class="bodytext">&nbsp;</p></td><td width="408"><p class="bodytext">[Country_Id][Area_Code][Number][Extension]   (type = 5)</p><p class="bodytext">[Country_Id][Area_Code][Number][Extension] (Type=1) </p><p class="bodytext">[Country_Id][Number] (Type=3)</p><p class="bodytext">[Country_Id][Area_Code][Number][Extension] (Type=6)</p><p class="bodytext">[Country_Id][Area_Code][Number][Extension] (Type=2)</p><p class="bodytext">[Country_Id][Number] (Type=4) </p><p class="bodytext">[Country_Id][Area_Code][Number][Extension] (Type=8) </p><p class="bodytext">[Country_Id][Area_Code][Number][Extension] (Type=11) </p><p class="bodytext">[Country_Id][Area_Code][Number][Extension] (Type=12) </p><p class="bodytext">[Country_Id][Area_Code][Number][Extension] (Type=7) </p><p class="bodytext">[Country_Id][Area_Code][Number][Extension] (Type=9) </p><p class="bodytext">[Country_Id][Area_Code][Number][Extension] (Type=10) </p><p class="bodytext">[Country_Id][Area_Code][Number][Extension] (Type=0) </p></td><td width="210"><p class="bodytext">PhoneType_Business1</p><p class="bodytext">PhoneType_Home1</p><p class="bodytext">PhoneType_Mobile1</p><p class="bodytext">PhoneType_Business2</p><p class="bodytext">PhoneType_Home2</p><p class="bodytext">PhoneType_Mobile2</p><p class="bodytext">PhoneType_BusinessFax</p><p class="bodytext">PhoneType_Fax1</p><p class="bodytext">PhoneType_Fax2</p><p class="bodytext">PhoneType_HomeFax</p><p class="bodytext">PhoneType_Main1</p><p class="bodytext">PhoneType_Main2</p><p class="bodytext">PhoneType_NotIdentified</p></td></tr>
|- valign="top" align="left"
</tbody></table>[[Category:Export_module]]
| 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
 
&nbsp;
 
| width="408" |
[Country_Id][Area_Code][Number][Extension] &nbsp; (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)
 
| width="210" |
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
 
[[Category:Export_module]]

Latest revision as of 10: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
Retrieved from "https://wiki.catglobe.com/index.php?title=User_information_settings_in_Export&oldid=20949"