by
455 17
0
5
1,958
2
Top 1% !
Famous
Tagged
Specified
OpenSource
Popularity: 11409th place
Languagemysql

Contacts Export from VTiger to Google Contacts

Copy Embed Code
<iframe id="embedFrame" style="width:600px; height:300px;"
src="https://www.snip2code.com/Embed/1523275/Contacts-Export-from-VTiger-to-Google-Co?startLine=0"></iframe>
Click on the embed code to copy it into your clipboard Width Height
Leave empty to retrieve all the content Start End
SELECT REPLACE (REPLACE (accountname, '"', '_'), ',', '_') AS 'Name', REPLACE (REPLACE (accountname, '"', '_'), ',', '_') AS 'Given Name', '' AS 'Additional Name', '' AS 'Family Name', '' AS 'Yomi Name', '' AS 'Given Name Yomi', '' AS 'Additional Name Yomi', '' AS 'Family Name Yomi', '' AS 'Name Prefix', '' AS 'Name Suffix', '' AS 'Initials', '' AS 'Nickname', '' AS 'Short Name', '' AS 'Maiden Name', '' AS 'Birthday', '' AS 'Gender', '' AS 'Location', '' AS 'Billing Information', '' AS 'Directory Server', '' AS 'Mileage', '' AS 'Occupation', '' AS 'Hobby', '' AS 'Sensitivity', '' AS 'Priority', '' AS 'Subject', '' AS 'Notes', '* My Contacts' AS 'Group Membership', '* Work' AS 'E-mail 1 - Type', REPLACE (REPLACE (email1, '"', '_'), ',', '_') AS 'E-mail 1 - Value', 'Εργασία 2' AS 'E-mail 2 - Type', REPLACE (REPLACE (email2, '"', '_'), ',', '_') AS 'E-mail 2 - Value', 'Εργασία 2' AS 'Phone 1 - Type', REPLACE (REPLACE (phone, '"', '_'), ',', '_') AS 'Phone 1 - Value', 'Work' AS 'Phone 2 - Type', REPLACE (REPLACE (otherphone, '"', '_'), ',', '_') AS 'Phone 2 - Value', 'Fax' AS 'Phone3 - Type', REPLACE (REPLACE (fax, '"', '_'), ',', '_') AS 'Phone 3 - Value', 'Home' AS 'Address 1 - Type', CONCAT('"',bill_street,'\n',bill_city,bill_state,' ',bill_pobox,'\n',bill_country,'"') AS 'Address 1 - Formatted', REPLACE (REPLACE (bill_street, '"', '_'), ',', '_') AS 'Address 1 - Street', REPLACE (REPLACE (bill_city, '"', '_'), ',', '_') AS 'Address 1 - City', '' AS 'Address 1 - PO Box', REPLACE (REPLACE (bill_state, '"', '_'), ',', '_') AS 'Address 1 - Region', REPLACE (REPLACE (bill_pobox, '"', '_'), ',', '_') AS 'Address 1 - Postal Code', REPLACE (REPLACE (bill_country, '"', '_'), ',', '_') AS 'Address 1 - Country', '' AS 'Address 1 - Extended Address', 'Home Page' AS 'Website 1 - Type', REPLACE (REPLACE (website, '"', '_'), ',', '_') AS 'Website 1 - Value' FROM vtigercrm600.vtiger_account LEFT JOIN vtigercrm600.vtiger_accountbillads ON vtiger_account.accountid = vtiger_accountbillads.accountaddressid; # NOTE: - After the execution click on export button and save it as csv # NOTE: The " and , have been replaced by _ # NOTE: If you want to use this snippet, consider to change the "vtigercrm600" with your database name. ;)
If you want to be updated about similar snippets, Sign in and follow our Channels

blog comments powered by Disqus