User information settings in Export: Difference between revisions

Revision as of 10: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

@@ 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:
 <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">&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>
-[[Category:Export_module]]
+</tbody></table>[[Category:Export_module]]