Author Topic: Email list Export  (Read 1248 times)

artonweb

  • Beginner
  • *
  • Posts: 27
    • Art On web
Email list Export
« on: May 11, 2020, 20:52:09 pm »
Helllo.
I am using Joomla 3.9.18 and Virtuemart 3.6.10
I would like to export all emails of my shoppers (mainly guests not users) in a list.
Is this possible?

pinochico

  • 3rd party VirtueMart Developer
  • Jr. Member
  • *
  • Posts: 379
    • MiniJoomla
  • VirtueMart Version: 3
Re: Email list Export
« Reply #1 on: May 11, 2020, 22:26:53 pm »
Yes,

You can go to phpmyadmin and create a mysql command and export the result to CSV.
Or install any mysql manager to Joomla and this mysql command create and save inside this component (I use Mysql Manager, but very old version with option export to csv).
And before save I tested on phpmyadmin, sure.

Now you have a lot of info for search on google how finish it :)
www.minijoomla.org  - new portal for Joomla!, Virtuemart and other extensions
XML Easy Feeder - feeds from products, orders and database table
Virtuemart Email Manager - customs email templates

AH

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3165
  • VirtueMart Version: 3.6.11
Re: Email list Export
« Reply #2 on: May 12, 2020, 11:27:46 am »

There is no core option to do this.

I use a free SQL tool HeidiSQL  https://www.heidisql.com/ to run such queries on a local copy of the live database

It has options to save queries for future use and export as required

You will need to access directly the database or have a local copy
regards
A

Joomla 3.9.18
php 7.3

loppan

  • Jr. Member
  • **
  • Posts: 143
    • CRASHDÏET Official Website
Re: Email list Export
« Reply #3 on: May 12, 2020, 15:36:52 pm »
I do this quite often and as others have already mentioned, there are several options. If your host happens to already have phpmyadmin installed I would recommend that route, very simple point and click :).

Another good & easy to use tool is Acymailing (I assume their free version allow these exports, but can't say for sure, been on a paid plan since forever).

Occasionally I use RolandD's CSVI for this which is great and could be worth it if you plan on doing this often since you can schedule exports tailored exactly to to your liking. It has a learning curve though.

Just my 2 cents ;).

Cheers

artonweb

  • Beginner
  • *
  • Posts: 27
    • Art On web
Re: Email list Export
« Reply #4 on: May 12, 2020, 21:21:04 pm »
@pinochico
Can you help me in order to create the correct query in PHPMyAdmin?

@AH
Very complicated application.
I can't find the option to export some tables and the most serious issue: I don't have the knowledge of MYSQL queries!

GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 9651
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 3.6.8
Re: Email list Export
« Reply #5 on: May 12, 2020, 22:51:10 pm »
SELECT DISTINCT `email` FROM `#__virtuemart_order_userinfos`
GJC Web Design
VirtueMart and Joomla Developers - php developers http://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
http://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation