Plugin: CSVee

Great plugin! Any way to have it only pull the “latest entries” since the last time the plugin was called? I’m using this with FreeForm… I want to use this to send the entries to a fulfillment center in which they can easily check the list for people who signed up to receive a free kit and see who has signed up since the last time they checked? This way they don’t pull the data and have duplicates sent out?

There are a couple options for you, i’ll list them here in difficulty order ascending:

1) Ensure only 1 user has access to the template, and that every time that user logs in, he calls up the template and downloads the file. You could then run a query that collects each entry since the ‘last_visit_date’ of the member account. Of course, this is prone to error, since he could login and forget to download if, say, he was also editing some site entries/other tasks etc.

2) Create a table in your database named, i don’t know, something like “template_last_access”. You’d want columns like “id”, “template_id”, “last_visit” etc. You could then create a simple (ish) plugin to also put on that template which grabs the current template id and date and stores/updates that in its own table. CSVee would need to be run before this other plugin, naturally. This is not prone to any error, at least in any logical sense. Php errors ahoy of course.

Daniel-

Thanks for sharing this plug-in!

I’m having one problem - the code doesn’t seem to work whenever I try to use the group_id parameter. I even tested it with a very basic query, to no avail. I want to restrict to groups 5|8|9|10. Some of those groups are empty, so I thought that was the problem and tested using only group 5 in the parameter, but it still doesn’t work.

Here is my code:

{exp:csvee query="SELECT
exp_members.member_id, 
exp_member_data.m_field_id_2 AS 'First Name', 
exp_member_data.m_field_id_3 AS 'Last Name', 
exp_member_data.m_field_id_7 AS 'Department', 
exp_member_data.m_field_id_8 AS 'Title', 
exp_member_data.m_field_id_9 AS 'Address 2', 
exp_member_data.m_field_id_10 AS 'City', 
exp_member_data.m_field_id_11 AS 'State', 
exp_member_data.m_field_id_12 AS 'ZIP', 
exp_member_data.m_field_id_13 AS 'Phone', 
exp_member_data.m_field_id_14 AS 'Blank', 
exp_member_data.m_field_id_15 AS 'Institution', 
exp_member_data.m_field_id_16 AS 'Address' 
FROM exp_members, exp_member_data WHERE exp_members.member_id = exp_member_data.member_id "
fixed_width="200"
group_id="5"}

Thanks.

Do you get any PHP errors on page or within the file?

None that are apparent. Do I need to have debugging turned on?

All that happens is nothing; I navigate to the URL of the template and nothing.

And you are logged in as a member of group_id 5, when visiting the template?

No, SuperAdmin. Maybe I’m misunderstanding what that parameter does. I thought it would only export the groups that are identified in the parameter. That’s what I was trying to accomplish.

I just wanted to post a ‘thank you’ to the author, Daniel, of this plug-in.

It’s great when your boss asks you if you can export data out of ee for import into Excel and you follow with… ‘No problem’.

This plug-in makes it all too easy.

No, SuperAdmin. Maybe I’m misunderstanding what that parameter does. I thought it would only export the groups that are identified in the parameter. That’s what I was trying to accomplish.

You will need to manually specify that in your query string - the other parameters control other aspects of the functionality.

I just wanted to post a ‘thank you’ to the author, Daniel, of this plug-in. It’s great when your boss asks you if you can export data out of ee for import into Excel and you follow with… ‘No problem’. This plug-in makes it all too easy.

Thank you, you’re welcome!

i’m looking to export entries into a csv file from freeform - without having to use a blank template,

would this require writing custom functionality or can this plugin be used in some way?

Thanks, James

This is an awesome plugin!

I created a Quick Link to the template and it works so well.

Hi there,

First of all, thanks for the plugin! I’m always being asked about exporting data out of EE and this makes it much easier.

At the moment though, I’m finding that the output of the CSV file is loading in my browser (in Safari 4 it is anyway). I then go to Save As to save the CSV file and this works fine.

How can I make the CSV file automatically download to the user’s computer as a downloadable csv file? (i.e. where Windows will prompt the user to save the file to disk/or save to the Downloads folder on a Mac)

I’ve been playing around with the save_path and redirect parameters but can’t seem to get this to work, and I can’t get the save_path to do anything other than give me a php error about permissions.

Here’s my current code for info:

{exp:csvee 
filename="my-export.csv"
query="SELECT 
exp_weblog_titles.title as name,
exp_weblog_data.field_id_126 as telephone,
exp_weblog_data.field_id_127 as fax,
exp_weblog_data.field_id_128 as email
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='4' 
ORDER BY exp_weblog_titles.title ASC"}

Thanks for any help with this.

How can I make the CSV file automatically download to the user’s computer as a downloadable csv file? (i.e. where Windows will prompt the user to save the file to disk/or save to the Downloads folder on a Mac)

I believe this is a browser behaviour.

Thanks.

Do you know the correct syntax for the save_path setting at all? I seem to have tried all sorts of combinations, and ensuring the folder is set to 777 permissions, but with no luck.

Thanks.

There appeared to be a minor bug in the code. Please re-download the archive.

Syntax is fairly straightforward - pass the full server path to the directory:

save_path=”/home/me/my_website/example/”;

(Note: trailing slash!)