You can't export that list directly from within RGP. The Sales Report does include products purchased and customer name. You can also point Microsoft Access directly at your MySQL database and do whatever type of reporting you desire.
I tried to get my list with emails and purchased products but still nothing and I stocked. Can somebody tell me how can I do that "step by step" or give me some instructions from internet :)
I'm not sure the specific problems you are having, but if you go to Data Entry -> View -> Custom Queries you can produce an email list based on products purchased.
I want to get excel file with: client names, emails nad purchased products. When I go to data entry > view > custom quries and I choose purchased products and after that click on "Review query", I can't see any customers. When I uncheck purchsed products I have all customers. Finally, I want to get excel file with customers names, emails, products in one file in rows and columns.
After clicking "Purchased Products", you must SELECT which specific products you want to filter the list on. Then after REVIEW QUERY, you need to save the generate an email list with the button. The list will contain email addresses of all the customers that purchased the selected group of products (but it does not list the products themselves).
Regardless, the only method to export customers are the options available in Customer Queries. Or using a third party tool like Navicat and creating your own database queries.
I am not exactly sure what you are asking. You either need to use the tools provided within RGP to export that data you desire, you contact the original individual who produced the data shown in the screen shot to ask how you get email address. We do not support/assist with direct database management.
Comments
Data Entry -> View -> Customer Queries -> Export
How Can I export client with emails and purchased products?
You can't export that list directly from within RGP. The Sales Report does include products purchased and customer name. You can also point Microsoft Access directly at your MySQL database and do whatever type of reporting you desire.
I tried to get my list with emails and purchased products but still nothing and I stocked. Can somebody tell me how can I do that "step by step" or give me some instructions from internet :)
Hope you will help.
I'm not sure the specific problems you are having, but if you go to Data Entry -> View -> Custom Queries you can produce an email list based on products purchased.
I want to get excel file with: client names, emails nad purchased products. When I go to data entry > view > custom quries and I choose purchased products and after that click on "Review query", I can't see any customers. When I uncheck purchsed products I have all customers. Finally, I want to get excel file with customers names, emails, products in one file in rows and columns.
Is it possible?
After clicking "Purchased Products", you must SELECT which specific products you want to filter the list on. Then after REVIEW QUERY, you need to save the generate an email list with the button. The list will contain email addresses of all the customers that purchased the selected group of products (but it does not list the products themselves).
Hello again,
I have example of file something I want get. Check this picture.
http://zapodaj.net/images/3fcffee8a0f26.png
How Can I get data from sql like that?
The image is broken.
Again
http://zapodaj.net/images/ef12d3fe434d0.png
This is ss of excel file who made my old it specialist.
I think he took it direct from database, How Can I export this?
I need also column "E-Mail"
Please somebody help me...
The screen shot still does not work.
Regardless, the only method to export customers are the options available in Customer Queries. Or using a third party tool like Navicat and creating your own database queries.
http://fotozrzut.pl/zdjecia/b33e653d84.png
Now it should work.
I am not exactly sure what you are asking. You either need to use the tools provided within RGP to export that data you desire, you contact the original individual who produced the data shown in the screen shot to ask how you get email address. We do not support/assist with direct database management.
Please sign in to leave a comment.