Importing contacts/Accounts

From Freephile Wiki

SugarCRM Accounts

definition of the SOAP profile for Accounts

array (
  'module_name' => 'Accounts',
  'module_fields' => 
  array (
    0 => 
    array (
      'name' => 'id',
      'type' => 'id',
      'label' => 'ID',
      'required' => 0,
      'options' => 
      array (
      ),
    ),
    1 => 
    array (
      'name' => 'name',
      'type' => 'name',
      'label' => 'Name:',
      'required' => 1,
      'options' => 
      array (
      ),
    ),
    2 => 
    array (
      'name' => 'date_entered',
      'type' => 'datetime',
      'label' => 'Date Entered:',
      'required' => 0,
      'options' => 
      array (
      ),
    ),
    3 => 
    array (
      'name' => 'date_modified',
      'type' => 'datetime',
      'label' => 'Date Modified:',
      'required' => 0,
      'options' => 
      array (
      ),
    ),
    4 => 
    array (
      'name' => 'modified_user_id',
      'type' => 'assigned_user_name',
      'label' => 'Modified By Id',
      'required' => 0,
      'options' => 
      array (
      ),
    ),
    5 => 
    array (
      'name' => 'modified_by_name',
      'type' => 'assigned_user_name',
      'label' => 'Modified By Id',
      'required' => 0,
      'options' => 
      array (
      ),
    ),
    6 => 
    array (
      'name' => 'created_by',
      'type' => 'assigned_user_name',
      'label' => 'Created By Id',
      'required' => 0,
      'options' => 
      array (
      ),
    ),
    7 => 
    array (
      'name' => 'created_by_name',
      'type' => 'assigned_user_name',
      'label' => 'Created By Id',
      'required' => 0,
      'options' => 
      array (
      ),
    ),
    8 => 
    array (
      'name' => 'description',
      'type' => 'text',
      'label' => 'Description:',
      'required' => 0,
      'options' => 
      array (
      ),
    ),
    9 => 
    array (
      'name' => 'deleted',
      'type' => 'bool',
      'label' => 'Deleted',
      'required' => 0,
      'options' => 
      array (
      ),
    ),
    10 => 
    array (
      'name' => 'assigned_user_id',
      'type' => 'relate',
      'label' => 'Assigned User:',
      'required' => 0,
      'options' => 
      array (
      ),
    ),
    11 => 
    array (
      'name' => 'assigned_user_name',
      'type' => 'relate',
      'label' => 'Assigned to:',
      'required' => 0,
      'options' => 
      array (
      ),
    ),
    12 => 
    array (
      'name' => 'account_type',
      'type' => 'enum',
      'label' => 'Type:',
      'required' => 0,
      'options' => 
      array (
        0 => 
        array (
          'name' => '',
          'value' => '',
        ),
        1 => 
        array (
          'name' => 'Analyst',
          'value' => 'Analyst',
        ),
        2 => 
        array (
          'name' => 'Competitor',
          'value' => 'Competitor',
        ),
        3 => 
        array (
          'name' => 'Customer',
          'value' => 'Customer',
        ),
        4 => 
        array (
          'name' => 'Integrator',
          'value' => 'Integrator',
        ),
        5 => 
        array (
          'name' => 'Investor',
          'value' => 'Investor',
        ),
        6 => 
        array (
          'name' => 'Partner',
          'value' => 'Partner',
        ),
        7 => 
        array (
          'name' => 'Press',
          'value' => 'Press',
        ),
        8 => 
        array (
          'name' => 'Prospect',
          'value' => 'Prospect',
        ),
        9 => 
        array (
          'name' => 'Reseller',
          'value' => 'Reseller',
        ),
        10 => 
        array (
          'name' => 'Other',
          'value' => 'Other',
        ),
      ),
    ),
    13 => 
    array (
      'name' => 'industry',
      'type' => 'enum',
      'label' => 'Industry:',
      'required' => 0,
      'options' => 
      array (
        0 => 
        array (
          'name' => '',
          'value' => '',
        ),
        1 => 
        array (
          'name' => 'Apparel',
          'value' => 'Apparel',
        ),
        2 => 
        array (
          'name' => 'Banking',
          'value' => 'Banking',
        ),
        3 => 
        array (
          'name' => 'Biotechnology',
          'value' => 'Biotechnology',
        ),
        4 => 
        array (
          'name' => 'Chemicals',
          'value' => 'Chemicals',
        ),
        5 => 
        array (
          'name' => 'Communications',
          'value' => 'Communications',
        ),
        6 => 
        array (
          'name' => 'Construction',
          'value' => 'Construction',
        ),
        7 => 
        array (
          'name' => 'Consulting',
          'value' => 'Consulting',
        ),
        8 => 
        array (
          'name' => 'Education',
          'value' => 'Education',
        ),
        9 => 
        array (
          'name' => 'Electronics',
          'value' => 'Electronics',
        ),
        10 => 
        array (
          'name' => 'Energy',
          'value' => 'Energy',
        ),
        11 => 
        array (
          'name' => 'Engineering',
          'value' => 'Engineering',
        ),
        12 => 
        array (
          'name' => 'Entertainment',
          'value' => 'Entertainment',
        ),
        13 => 
        array (
          'name' => 'Environmental',
          'value' => 'Environmental',
        ),
        14 => 
        array (
          'name' => 'Finance',
          'value' => 'Finance',
        ),
        15 => 
        array (
          'name' => 'Government',
          'value' => 'Government',
        ),
        16 => 
        array (
          'name' => 'Healthcare',
          'value' => 'Healthcare',
        ),
        17 => 
        array (
          'name' => 'Hospitality',
          'value' => 'Hospitality',
        ),
        18 => 
        array (
          'name' => 'Insurance',
          'value' => 'Insurance',
        ),
        19 => 
        array (
          'name' => 'Machinery',
          'value' => 'Machinery',
        ),
        20 => 
        array (
          'name' => 'Manufacturing',
          'value' => 'Manufacturing',
        ),
        21 => 
        array (
          'name' => 'Media',
          'value' => 'Media',
        ),
        22 => 
        array (
          'name' => 'Not For Profit',
          'value' => 'Not For Profit',
        ),
        23 => 
        array (
          'name' => 'Recreation',
          'value' => 'Recreation',
        ),
        24 => 
        array (
          'name' => 'Retail',
          'value' => 'Retail',
        ),
        25 => 
        array (
          'name' => 'Shipping',
          'value' => 'Shipping',
        ),
        26 => 
        array (
          'name' => 'Technology',
          'value' => 'Technology',
        ),
        27 => 
        array (
          'name' => 'Telecommunications',
          'value' => 'Telecommunications',
        ),
        28 => 
        array (
          'name' => 'Transportation',
          'value' => 'Transportation',
        ),
        29 => 
        array (
          'name' => 'Utilities',
          'value' => 'Utilities',
        ),
        30 => 
        array (
          'name' => 'Other',
          'value' => 'Other',
        ),
      ),
    ),
    14 => 
    array (
      'name' => 'annual_revenue',
      'type' => 'varchar',
      'label' => 'Annual Revenue:',
      'required' => 0,
      'options' => 
      array (
      ),
    ),
    15 => 
    array (
      'name' => 'phone_fax',
      'type' => 'phone',
      'label' => 'Fax:',
      'required' => 0,
      'options' => 
      array (
      ),
    ),
    16 => 
    array (
      'name' => 'billing_address_street',
      'type' => 'varchar',
      'label' => 'Billing Street:',
      'required' => 0,
      'options' => 
      array (
      ),
    ),
    17 => 
    array (
      'name' => 'billing_address_city',
      'type' => 'varchar',
      'label' => 'Billing City:',
      'required' => 0,
      'options' => 
      array (
      ),
    ),
    18 => 
    array (
      'name' => 'billing_address_state',
      'type' => 'varchar',
      'label' => 'Billing State:',
      'required' => 0,
      'options' => 
      array (
      ),
    ),
    19 => 
    array (
      'name' => 'billing_address_postalcode',
      'type' => 'varchar',
      'label' => 'Billing Postal Code:',
      'required' => 0,
      'options' => 
      array (
      ),
    ),
    20 => 
    array (
      'name' => 'billing_address_country',
      'type' => 'varchar',
      'label' => 'Billing Country:',
      'required' => 0,
      'options' => 
      array (
      ),
    ),
    21 => 
    array (
      'name' => 'rating',
      'type' => 'varchar',
      'label' => 'Rating:',
      'required' => 0,
      'options' => 
      array (
      ),
    ),
    22 => 
    array (
      'name' => 'phone_office',
      'type' => 'phone',
      'label' => 'Phone Office:',
      'required' => 0,
      'options' => 
      array (
      ),
    ),
    23 => 
    array (
      'name' => 'phone_alternate',
      'type' => 'phone',
      'label' => 'Alternate Phone:',
      'required' => 0,
      'options' => 
      array (
      ),
    ),
    24 => 
    array (
      'name' => 'website',
      'type' => 'varchar',
      'label' => 'Website:',
      'required' => 0,
      'options' => 
      array (
      ),
    ),
    25 => 
    array (
      'name' => 'ownership',
      'type' => 'varchar',
      'label' => 'Ownership:',
      'required' => 0,
      'options' => 
      array (
      ),
    ),
    26 => 
    array (
      'name' => 'employees',
      'type' => 'num',
      'label' => 'Employees:',
      'required' => 0,
      'options' => 
      array (
      ),
    ),
    27 => 
    array (
      'name' => 'ticker_symbol',
      'type' => 'varchar',
      'label' => 'Ticker Symbol:',
      'required' => 0,
      'options' => 
      array (
      ),
    ),
    28 => 
    array (
      'name' => 'shipping_address_street',
      'type' => 'varchar',
      'label' => 'Shipping Street:',
      'required' => 0,
      'options' => 
      array (
      ),
    ),
    29 => 
    array (
      'name' => 'shipping_address_city',
      'type' => 'varchar',
      'label' => 'Shipping City:',
      'required' => 0,
      'options' => 
      array (
      ),
    ),
    30 => 
    array (
      'name' => 'shipping_address_state',
      'type' => 'varchar',
      'label' => 'Shipping State:',
      'required' => 0,
      'options' => 
      array (
      ),
    ),
    31 => 
    array (
      'name' => 'shipping_address_postalcode',
      'type' => 'varchar',
      'label' => 'Shipping Postal Code:',
      'required' => 0,
      'options' => 
      array (
      ),
    ),
    32 => 
    array (
      'name' => 'shipping_address_country',
      'type' => 'varchar',
      'label' => 'Shipping Country:',
      'required' => 0,
      'options' => 
      array (
      ),
    ),
    33 => 
    array (
      'name' => 'email1',
      'type' => 'varchar',
      'label' => 'Email:',
      'required' => 0,
      'options' => 
      array (
      ),
    ),
    34 => 
    array (
      'name' => 'parent_id',
      'type' => 'id',
      'label' => 'Parent Account ID',
      'required' => 0,
      'options' => 
      array (
      ),
    ),
    35 => 
    array (
      'name' => 'sic_code',
      'type' => 'varchar',
      'label' => 'SIC Code:',
      'required' => 0,
      'options' => 
      array (
      ),
    ),
    36 => 
    array (
      'name' => 'account_name',
      'type' => 'relate',
      'label' => 'Account Name:',
      'required' => 0,
      'options' => 
      array (
      ),
    ),
    37 => 
    array (
      'name' => 'parent_name',
      'type' => 'relate',
      'label' => 'Member of:',
      'required' => 0,
      'options' => 
      array (
      ),
    ),
    38 => 
    array (
      'name' => 'campaign_id',
      'type' => 'id',
      'label' => 'Campaign ID',
      'required' => 0,
      'options' => 
      array (
      ),
    ),
  ),
  'error' => '',
)