How to export signup list as CSV.
| Project: | Signup |
| Version: | 6.x-1.0-rc6 |
| Component: | Documentation |
| Category: | feature request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
I spent 2 hours this morning trying to figure this out, how to export to Microsoft Excel. Neither signup nor signup status modules does this. At least I don't think that they can. A couple of people in other threads brought this up also and I'm going to respond here.
The modules don't need to export CSV because the views bonus module does this wonderful. http://drupal.org/project/views_bonus . Just install and add a feed in a signup module view in views 2. Configure the feed to be csv and attach it to a page with a table of all the users signed up. Click on the csv icon at the bottom of the table when you view it through the node menu tab and open in Excel.
Would someone please put this in the documentation? I think that it is a very important feature.
#1
Ok, good point. Where do you think that should be documented? The INSTALL.txt file that ships with the module? There's no really good place in the drupal.org handbooks for contrib documentation yet. :( The project page is already long and busy, and I don't like using that as the manual. Let me know where the best place(s) are where people would actually find this information.
Thanks,
-Derek
#2
First, thanks for maintaining the Signup module.
I think that there are enough people out there who could use an export of a table of registered attendees to a cvs or doc file that putting it in the readme.txt is justified.
There is extensive integration with the Views module (http://druapl.org/project/views), and also support to embed the signup form as a pane using panels (http://druapl.org/project/panels). With the Views bonus pack (http://drupal.org/project/views_bonus), signup Views can be exported with CSV, DOC, XML and themed text files.We throw parties which have several thousand attending. Access is granted with a card with a barcode on it which corresponds the user number. It would be great to not only download the attendance information but also return the information back to the drupal database with who attended. There are three or four laptops at the each event with a guest list. Many websites center around groups and communities that meet in the wild and having an integrated workflow with event planing would help everyone keep track of what's going on.
What I wanted was a barcode that is created not by submitting a number into a CCK field but when a user clicks on a link in event page. The barcode is then created by the user ID and is added to a form with the event information, time, location, ect. so the person can print it. That would be cool integration with signup.
If I was a fund raiser I would like to be able to target people who have attended my events in the past. Here is a module which functions similar to yours (I assume from reading the description.). http://drupal.org/project/ucount It seems that this is a popular way to track people, to give them a card with a barcode that is their UID.
#3
subscribing
#4
Hello,
can someone tell in a few steps what should be done to make this work? I'm new to views so I don't know what to do... Thank you very much in advance, I really need this module to get the information out of my signups...
#5
Add a new feed display to your view
Change the style to suit your format.
Let's take follow-up in a more relevant place, like #612330: views export module installed but doesn't show in views.
For me Clean URLs breaks export, so if you wish to use export, be prepared to disable Clean URLs (#612182: Clean URLs breaks export)
I believe it should be possible to include a snippet similar to this for the views definitions in signup?: (I have about zero experience with views, this is 10mins of copy-paste)
if (module_exists('views_bonus_pack')) {$handler = $view->new_display('feed', 'CSV export', 'csv_export');
$handler->override_option('style_plugin', 'views_csv');
$handler->override_option('style_options', array(
'mission_description' => FALSE,
'description' => '',
'filename' => 'view-%view.csv',
'seperator' => ',',
'quote' => 1,
'header' => 1,
));
$handler->override_option('row_plugin', '');
$handler->override_option('path', 'node/%/signups/list/csv');
$handler->override_option('menu', array(
'type' => 'none',
'title' => '',
'description' => '',
'weight' => 0,
'name' => 'navigation',
));
$handler->override_option('tab_options', array(
'type' => 'none',
'title' => '',
'description' => '',
'weight' => 0,
));
$handler->override_option('displays', array(
'default' => 'default',
));
$handler->override_option('sitename_title', FALSE);
}
#6
disabling clean url is not really an option...
No other solutions?
#7
My site has clean_urls and I'm using the views_bonus module and have set it up to export csv files with no trouble.
What I did was edit the bulk operations table in the Administer section under the signups tab on a signup enabled node, and added a "feed" to the view. I set the "style" of the feed view to "csv file" and then changed the fields to be what I wanted in my table. Note that when you configure the field in the view, you can choose individual fields within the signup form info by adding "Signup: User: Additional Signup Info" and putting the name of the field from the signup form in the "Field Name" box.