@Daniel. Thanks for your reply about my problem which to restate it is that I can’t seem to get the proper seperator. I have tried over and over in various ways including your suggestion of just using seperator=”“. Nothing works.
Here is my latest:
{exp:csvee seperator="," query="SELECT email FROM exp_members WHERE email !='needs@email.com' AND email !='deceased@something.org'" show_headings="no"}
It seems simple but nothing seems to work. I was able to get the delimiter I want, which is a space only by editing the plugin itself. Even trying that for the seperator doesn’t help.
Any suggestions?
Thanks,
Carole
Excellent Ryan! worked like a charm. The file has a .html that needs to be removed, but then works great. Although, my CSV file is putting all of the results in one row. The column heads are first and then the results are to the right instead of underneath. Anyway, I can wrap the results underneath the columns heads?
Hi there!
Does anyone know if it’s possible to get the CSV file to download when loading the template. Maybe i’m doing something wrong, but when I load the template i just get the query results displayed at the browser, but not CSV file to download. Is it suppose to be like that?
This is the code that i’m using:
{exp:csvee delimiter="," filename="test.csv" query="SELECT exp_weblog_titles.title as name FROM exp_weblog_data INNER JOIN exp_weblog_titles ON exp_weblog_data.entry_id = exp_weblog_titles.entry_id WHERE exp_weblog_data.weblog_id='16' ORDER BY exp_weblog_titles.title ASC"}
