使用 SQL 从 VTiger 导出活动联系人 CSV

在使用 SQL 从 VTiger 导出活动帐户 CSV中，我们研究了如何使用直接 SQL 数据库访问导出给定活动的组织名称和电子邮件。

本文展示如何做同样的事情。有关详细说明，请参见之前的文章。

export_campaign_contacts.sql

SELECT CONCAT(cont.firstname, " ", cont.lastname) AS "Name", cont.email AS "EMail" FROM vtiger_campaigncontrel AS ccr JOIN vtiger_contactdetails cont ON (cont.contactid = ccr.contactid) WHERE `campaignid` =(SELECT postvalue FROM `vtiger_modtracker_detail` WHERE fieldname = "record_id" AND `id` = (SELECT `id` FROM `vtiger_modtracker_detail` WHERE postvalue = (SELECT campaign_no FROM vtiger_campaign WHERE `campaignname` = "MyCampaign") and fieldname = "campaign_no")) AND cont.email <> ''

SELECT CONCAT(cont.firstname, " ", cont.lastname) AS "Name", cont.email AS "EMail" FROM vtiger_campaigncontrel AS ccr JOIN vtiger_contactdetails cont ON (cont.contactid = ccr.contactid) WHERE `campaignid` =(SELECT postvalue FROM `vtiger_modtracker_detail` WHERE fieldname = "record_id" AND `id` = (SELECT `id` FROM `vtiger_modtracker_detail` WHERE postvalue = (SELECT campaign_no FROM vtiger_campaign WHERE `campaignname` = "MyCampaign") and fieldname = "campaign_no")) AND cont.email <> ''

除了在 vtiger_contactdetails 和 vtiger_campaigncontrel 上连接而不是帐户相关的等效项之外，唯一的重大区别是组装名称。对于联系人，名字和姓氏分开存储。因此我们使用 CONCAT(cont.firstname, " ", cont.lastname) 从该信息中获取单个名称字符串。

如前一篇文章所示，你可以使用 phpmyadmin 将查询结果直接导出为 CSV 或 Excel。虽然这可能看起来是一个繁琐的过程，但它比手动复制和粘贴数百个联系人要少得多。

Check out similar posts by category: Databases

If this post helped you, please consider buying me a coffee or donating via PayPal to support research & publishing of new posts on TechOverflow

Buy me a coffee