[Sommaire] [Imprimer]

   1  <?php
   2  /*********************************************************************************
   3   * The contents of this file are subject to the SugarCRM Public License Version 1.1.2
   4   * ("License"); You may not use this file except in compliance with the 
   5   * License. You may obtain a copy of the License at http://www.sugarcrm.com/SPL
   6   * Software distributed under the License is distributed on an  "AS IS"  basis,
   7   * WITHOUT WARRANTY OF ANY KIND, either express or implied. See the License for
   8   * the specific language governing rights and limitations under the License.
   9   * The Original Code is:  SugarCRM Open Source
  10   * The Initial Developer of the Original Code is SugarCRM, Inc.
  11   * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc.;
  12   * All Rights Reserved.
  13   *Contributor(s): ______________________________________.
  14   ********************************************************************************/
  15  /*********************************************************************************
  16   * $Header$
  17   * Description:  TODO: To be written.
  18   * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc.
  19   * All Rights Reserved.
  20   * Contributor(s): ______________________________________..
  21   ********************************************************************************/
  22  //error_reporting(E_ALL);
  23  //error_reporting(0);
  24  global $current_language;
  25  
  26  $mod_strings = return_module_language($current_language, "Import");
  27  
  28  include_once ('modules/Import/error.php');
  29  
  30  
  31  $outlook_contacts_field_map = array(
  32  "Title"=>"salutation",
  33  // SPECIAL FIELD:
  34  "Full Name"=>"full_name",
  35  "Company"=>"company",
  36  // END
  37  "First Name"=>"first_name",
  38  "Last Name"=>"last_name",
  39  "Job Title"=>"title",
  40  "Department"=>"department",
  41  "Birthday"=>"birthdate",
  42  "Home Phone"=>"phone_home",
  43  "Mobile Phone"=>"phone_mobile",
  44  "Business Phone"=>"phone_work",
  45  "Other Phone"=>"phone_other",
  46  "Business Fax"=>"phone_fax",
  47  "E-mail Address"=>"email1",
  48  "E-mail 2"=>"email2",
  49  "Assistant's Name"=>"assistant",
  50  "Assistant's Phone"=>"assistant_phone",
  51  "Business Street"=>"primary_address_street",
  52  "Business City"=>"primary_address_city",
  53  "Business State"=>"primary_address_state",
  54  "Business Postal Code"=>"primary_address_postalcode",
  55  "Business Country/Region"=>"primary_address_country",
  56  "Home Street"=>"alt_address_street",
  57  "Home City"=>"alt_address_city",
  58  "Home State"=>"alt_address_state",
  59  "Home Postal Code"=>"alt_address_postalcode",
  60  "Home Country/Region"=>"alt_address_country",
  61  );
  62  
  63  
  64  $outlook_accounts_field_map = array(
  65  "Company"=>"name",
  66  "Business Street"=>"billing_address_street",
  67  "Business City"=>"billing_address_city",
  68  "Business State"=>"billing_address_state",
  69  "Business Country"=>"billing_address_country",
  70  "Business Postal Code"=>"billing_address_postalcode",
  71  "Business Fax"=>"phone_fax",
  72  "Company Main Phone"=>"phone_office",
  73  "Web Page"=>"website",
  74  //Government ID Number, 
  75  //Organizational ID Number, 
  76  );
  77  
  78  $act_contacts_field_map = array(
  79  "Web Site"=>"website",
  80  "Company"=>"account_name",
  81  "Name Suffix"=>"salutation",
  82  "Title"=>"title",
  83  "First Name"=>"first_name",
  84  "Last Name"=>"last_name",
  85  "Address 1"=>"primary_address_street",
  86  "Address 2"=>"primary_address_street_2",
  87  "Address 3"=>"primary_address_street_3",
  88  "City"=>"primary_address_city",
  89  "State"=>"primary_address_state",
  90  "Zip"=>"primary_address_postalcode",
  91  "Country"=>"primary_address_country",
  92  "Phone"=>"phone_work",
  93  "Phone Ext-"=>"phone_work_ext",
  94  "Mobile Phone"=>"phone_mobile",
  95  "Alt Phone"=>"phone_other",
  96  "Fax"=>"phone_fax",
  97  "E-mail Login"=>"email1",
  98  "E-mail"=>"email1",
  99  "E-Mail 2"=>"email2",
 100  "Assistant"=>"assistant",
 101  "Asst. Phone"=>"assistant_phone",
 102  "Home Address 1"=>"alt_address_street",
 103  "Home Address 2"=>"alt_address_street_2",
 104  "Home Address 3"=>"alt_address_street_3",
 105  "Home City"=>"alt_address_city",
 106  "Home State"=>"alt_address_state",
 107  "Home Zip"=>"alt_address_postalcode",
 108  "Home Country"=>"alt_address_country",
 109  "Home Phone"=>"phone_home",
 110  );
 111  
 112  
 113  $act_accounts_field_map = array(
 114  "Revenue"=>"annual_revenue",
 115  "Number of Employees"=>"employees",
 116  "Company"=>"name",
 117  "Address 1"=>"billing_address_street",
 118  "City"=>"billing_address_city",
 119  "State"=>"billing_address_state",
 120  "Zip Code"=>"billing_address_postalcode",
 121  "Country"=>"billing_address_country",
 122  "Phone"=>"phone_office",
 123  "Fax Phone"=>"phone_fax",
 124  "Ticker Symbol"=>"ticker_symbol",
 125  "Web Site"=>"website",
 126  );
 127  
 128  /*
 129  "Last Activity"=>"",
 130  "Last Modified Date"=>"",
 131  "Created Date"=>"",
 132  "Reports To"=>"",
 133  "Last Stay-in-Touch Request Date"=>"",
 134  "Last Stay-in-Touch Save Date"=>"",
 135  */
 136  $salesforce_contacts_field_map = array(
 137  "Salutation"=>"salutation",
 138  "Description"=>"description",
 139  "First Name"=>"first_name",
 140  "Last Name"=>"last_name",
 141  "Title"=>"title",
 142  "Department"=>"department",
 143  "Birthdate"=>"birthdate",
 144  "Lead Source"=>"lead_source",
 145  "Assistant"=>"assistant",
 146  "Asst. Phone"=>"assistant_phone",
 147  "Contact ID"=>"id",
 148  "Mailing Street"=>"primary_address_street",
 149  "Mailing Address Line1"=>"primary_address_street_2",
 150  "Mailing Address Line2"=>"primary_address_street_3",
 151  "Mailing Address Line3"=>"primary_address_street_4",
 152  "Mailing City"=>"primary_address_city",
 153  "Mailing State"=>"primary_address_state",
 154  "Mailing Zip/Postal Code"=>"primary_address_postalcod3",
 155  "Mailing Country"=>"primary_address_country",
 156  "Other Street"=>"alt_address_street",
 157  "Other Address Line 1"=>"alt_address_street_2",
 158  "Other Address Line 2"=>"alt_address_street_3",
 159  "Other Address Line 3"=>"alt_address_street_4",
 160  "Other City"=>"alt_address_city",
 161  "Other State"=>"alt_address_state",
 162  "Other Zip/Postal Code"=>"alt_address_postalcode",
 163  "Other Country"=>"alt_address_country",
 164  "Phone"=>"phone_work",
 165  "Mobile"=>"phone_mobile",
 166  "Home Phone"=>"phone_home",
 167  "Other Phone"=>"phone_other",
 168  "Fax"=>"phone_fax",
 169  "Email"=>"email1",
 170  "Email Opt Out"=>"email_opt_out",
 171  "Do Not Call"=>"do_not_call",
 172  "Account Name"=>"account_name",
 173  "Account ID"=>"account_id",
 174  );
 175  
 176  
 177  
 178  
 179  /*
 180  ommited vtiger_fields to map:
 181  "Account Number"=>"",
 182  "Account Site"=>"",
 183  "Last Activity"=>"",
 184  "Parent Account"=>"",
 185  "Parent Account ID"=>"",
 186  "Parent Account Site"=>"",
 187  "Created Date"=>"",
 188  "Last Modified Date"=>"",
 189  "Billing Address Line3"=>"",
 190  "Shipping Address Line3"=>"",
 191  */
 192  $salesforce_accounts_field_map = array(
 193  "Account Name"=>"name",
 194  "Annual Revenue"=>"annual_revenue",
 195  "Type"=>"type",
 196  "Ticker Symbol"=>"ticker_symbol",
 197  "Rating"=>"rating",
 198  "Industry"=>"industry",
 199  "SIC Code"=>"sic_code",
 200  "Ownership"=>"ownership",
 201  "Employees"=>"employees",
 202  "Description"=>"description",
 203  "Account ID"=>"id",
 204  "Billing Street"=>"billing_address_street",
 205  "Billing Address Line1"=>"billing_address_street_2",
 206  "Billing Address Line2"=>"billing_address_street_3",
 207  "Billing City"=>"billing_address_city",
 208  "Billing State"=>"billing_address_state",
 209  "Billing Zip/Postal Code"=>"billing_address_postalcode",
 210  "Billing Country"=>"billing_address_country",
 211  "Shipping Street"=>"shipping_address_street",
 212  "Shipping Address Line1"=>"shipping_address_street_2",
 213  "Shipping Address Line2"=>"shipping_address_street_3",
 214  "Shipping City"=>"shipping_address_city",
 215  "Shipping State"=>"shipping_address_state",
 216  "Shipping Zip/Postal Code"=>"shipping_address_postalcode",
 217  "Shipping Country"=>"shipping_address_country",
 218  "Phone"=>"phone_office",
 219  "Fax"=>"phone_fax",
 220  "Website"=>"website"
 221  );
 222  
 223  /*
 224  "Fiscal Quarter"=>"",
 225  "Age"=>"",
 226  "Expected Revenue"=>"",
 227  */
 228  $salesforce_opportunities_field_map = array(
 229  
 230  "Opportunity Name"=>"name" ,
 231  "Type"=>"opportunity_type",
 232  "Lead Source"=>"lead_source",
 233  "Amount"=>"amount",
 234  "Created Date"=>"date_entered",
 235  "Close Date"=>"date_closed",
 236  "Next Step"=>"next_step",
 237  "Stage"=>"sales_stage",
 238  "Probability (%)"=>"probability",
 239  "Account Name"=>"account_name"
 240  );
 241  
 242  if (! isset($_REQUEST['step'] ) )
 243  {
 244      $_REQUEST['step'] = 1;
 245  }
 246  
 247  $mod_list_strings = return_mod_list_strings_language($current_language,"Import");
 248  
 249  include_once('modules/Import/ImportStep'. $_REQUEST['step']. '.php');
 250  
 251  ?>