Difference between revisions of "User information settings in Export"
| 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: | ||
| − | <br> | + | <br> |
| − | + | <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"> </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> | |
| − | [[Category:Export_module]] | + | </tbody></table>[[Category:Export_module]] |
Revision as of 12:13, 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 |
