List View Population

[atin]

Hii
I have changed the name Opportunities module as CashAdvance, but all the coding remains same. Now I want to populate the Opportunities List from my created table in database and listview should look like name| Agent| Lead Type| Status| Industry.

CREATE TABLE `cashadvance` (
`id` char(36) NOT NULL,
`deleted` tinyint(1) NOT NULL default '0',
`converted` tinyint(1) NOT NULL default '0',
`date_entered` datetime NOT NULL,
`date_modified` datetime NOT NULL,
`modified_user_id` char(36) default NULL,
`assigned_user_id` char(36) default NULL,
`created_by` char(36) default NULL,
`salutation` varchar(5) default NULL,
`first_name` varchar(25) default NULL,
`last_name` varchar(25) default NULL,
`title` varchar(100) default NULL,
`refered_by` varchar(100) default NULL,
`lead_source` varchar(100) default NULL,
`lead_source_description` text,
`status` varchar(100) default NULL,
`status_description` text,
`department` varchar(100) default NULL,
`reports_to_id` char(36) default NULL,
`do_not_call` varchar(3) default '0',
`phone_home` varchar(25) default NULL,
`phone_mobile` varchar(25) default NULL,
`phone_work` varchar(25) default NULL,
`phone_other` varchar(25) default NULL,
`phone_fax` varchar(25) default NULL,
`email1` varchar(100) default NULL,
`email2` varchar(100) default NULL,
`email_opt_out` varchar(3) default '0',
`primary_address_street` varchar(150) default NULL,
`primary_address_city` varchar(100) default NULL,
`primary_address_state` varchar(100) default NULL,
`primary_address_postalcode` varchar(20) default NULL,
`primary_address_country` varchar(100) default NULL,
`alt_address_street` varchar(150) default NULL,
`alt_address_city` varchar(100) default NULL,
`alt_address_state` varchar(100) default NULL,
`alt_address_postalcode` varchar(20) default NULL,
`alt_address_country` varchar(100) default NULL,
`description` text,
`account_name` varchar(150) default NULL,
`account_description` text,
`contact_id` char(36) default NULL,
`account_id` char(36) default NULL,
`opportunity_id` char(36) default NULL,
`opportunity_name` varchar(255) default NULL,
`opportunity_amount` varchar(50) default NULL,
`campaign_id` char(36) default NULL,
`portal_name` varchar(255) default NULL,
`portal_app` varchar(255) default NULL,
`invalid_email` tinyint(1) default '0',
`pg_industry` varchar(45) default NULL,
`lead_type` varchar(45) default NULL,
`partner_name` varchar(225) default NULL,
`partner_phone` varchar(45) default NULL,
`vm_card` double default NULL,
`pg_gross_monthly_vol` double default NULL,
`pg_amount_need` double default NULL,
`pg_app_sent` varchar(3) default '0',
`pg_conf_delivary` varchar(45) NOT NULL,
`pg_app_by` varchar(45) default NULL,
PRIMARY KEY (`id`),
KEY `idx_lead_acct_name_first` (`account_name`,`deleted`),
KEY `idx_lead_last_first` (`last_name`,`first_name`,`deleted`),
KEY `idx_lead_del_stat` (`last_name`,`status`,`deleted`,`first_name`),
KEY `idx_lead_opp_del` (`opportunity_id`,`deleted`),
KEY `idx_leads_acct_del` (`account_id`,`deleted`),
KEY `idx_lead_email1` (`email1`,`deleted`),
KEY `idx_lead_email2` (`email2`,`deleted`),
KEY `idx_lead_assigned` (`assigned_user_id`),
KEY `idx_lead_contact` (`contact_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Plz help me………………….
PHP/5.2.4
Apache/2.2.6 (Win32)
Windows NT
MySql-5.0.45
Sugar Ver: 4.5
Thanks in advance
Atin

[andopes]

Hi, atin.

Instead of create a new table with some new fields and some came from opportunities table why not create custom fields under opportunity?
This way you can easily add this new fields into ListView and any other layouts.

Your strategy require a lots of code modification, it is not upgrade safe and take much time.
Is there any reason to do that?

Cheers

[atin]

Hi André Lopes,
Thanks for the reply.
Actually I have changed Opportunity to the CashAdvance module. As contact list is populated from contact table,I wan that my CashAdvance list will populated from cashadvance table. How can I do this..........plz help me.
Thanks in advance.
Atin

[andopes]

Hi, Atin

Can you explain better your scenario?
Did you renamed Opportunities to CashAdvance or did you created a new module using Opportunities as template?

Cheers

[atin]

Hiii
André Lopes,
I have renamed Opportunities to CashAdvance. So all templates are same as opportunity...............
Thanks in advance
Atin

[atin]

Hiii
André Lopes,
I am waiting for your suggestion. plz help me regarding this.
Thanks in advance
Atin