Jump to content

Export addresses to Google Contacts


Recommended Posts

I've wanted for a short while to export customer contact information into Google Contacts. From there, I can easily use the contact information in Quickbooks, my accounts package. I have cPanel access and using that and the phpMyAdmin, I went into the database and using the SQL below produced a query which I exported as a csv and imported without issue into. Google contacts. The SQL is below, should anyone wish to use it. I'm not a programmer etc - I learnt SQL ages ago briefly and it may be very crap code, but it works. Please don't ask me "how do I do this", "how do I modify to do this". I don't have the time to fix my own Cubecart site, never mind yours, so this code if offered as a service to those with the knowledge to use it.

If you don't know how to do this, don't use this code! 

 

SELECT DISTINCT
    CONCAT(T1.first_name, ' ', T1.last_name) AS 'Name',
    T1.first_name AS 'Given Name',
    T1.last_name AS 'Family Name',
    '' AS Notes,
    'Wooden Stuff ::: * myContacts' AS `Group Membership`,
    '* Work' AS `E-mail 1 - Type`,
    T1.email AS `E-mail 1 - Value`,
    'Mobile' AS `Phone 1 - Type`,
    T1.mobile AS `Phone 1 - Value`,
    'Home' AS `Phone 2 - Type`,
    T2.phone AS `Phone 2 - Value`,
    '' AS `Address 1 - Type`,
    '' AS `Address 1 - Formatted`,
    CONCAT(T2.line1, ', ', T2.line2) AS 'Address 1 - Street',
    T2.town AS `Address 1 - City`,
    '' AS `Address 1 - PO Box`,
    T2.state AS `Address 1 - Region`,
    T2.postcode AS `Address 1 - Postal Code`,
    'United Kingdom' AS `Address 1 - Country`,
    '' AS `Address 1 - Extended Address`,
    T2.company_name AS `Organization 1 - Name`,
    'Delivery Title' AS `Custom Field 1 - Type`,
    T2.title_d AS `Custom Field 1 - Value`,
    'Delivery First Name' AS `Custom Field 2 - Type`,
    T2.first_name_d AS `Custom Field 2 - Value`,
    'Delivery Surname' AS `Custom Field 3 - Type`,
    T2.last_name_d AS `Custom Field 3 - Value`,
    'Delivery Company' AS `Custom Field 4 - Type`,
    T2.company_name_d AS `Custom Field 4 - Value`,
    'Delivery Address Line 1' AS `Custom Field 5 - Type`,
    T2.line1_d AS `Custom Field 5 - Value`,
    'Delivery Address Line 2' AS `Custom Field 6 - Type`,
    T2.line2_d AS `Custom Field 6 - Value`,
    'Delivery Address Town' AS `Custom Field 7 - Type`,
    T2.town_d AS `Custom Field 7 - Value`,
    'Delivery Address County' AS `Custom Field 8 - Type`,
    T2.state_d AS `Custom Field 8 - Value`,
    'Delivery Address Postcode' AS `Custom Field 9 - Type`,
    T2.postcode_d AS `Custom Field 9 - Value`,
    'Delivery Address Country' AS `Custom Field 10 - Type`,
    T2.country_d AS `Custom Field 10 - Value`,
    'Delivery Phone' AS `Custom Field 11 - Type`,
    T2.phone AS `Custom Field 11 - Value`,
    'Delivery Mobile' AS `Custom Field 12 - Type`,
    T2.mobile AS `Custom Field 12 - Value`,
    'Delivery email' AS `Custom Field 13 - Type`,
    T2.email AS `Custom Field 13 - Value`
FROM
    `CubeCart_customer` T1
INNER JOIN CubeCart_order_summary T2 ON
    T1.customer_id = T2.customer_id
WHERE
    T1.customer_id > 001

Enjoy!

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...