Importing contacts/Accounts
Jump to navigation
Jump to search
SugarCRM Accounts[edit | edit source]
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' => '',
)