How to export signup list as CSV.

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

subscribing

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...

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);
}

disabling clean url is not really an option...
No other solutions?

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.

I do not see this "Bulk Operations" table in the Administer Section for my Signup Enabled Node. I am using Drupal 6.1.4. Am I missing something?

Any help provided would be appreciated.

Sorry. To see the bulk operations view, you need to install the VBO module, and then enable the view. You may need to add operations to the view to make it fully functional.

> There's no really good place in the drupal.org handbooks for contrib documentation yet.

They seem a bit lost in the handbook IA at the moment, but you can link to your docs page from the project page, and put in a request for a path like http://drupal.org/handbook/modules/image

As a child page here would be a good place: http://drupal.org/node/627222

I tried this and it worked if I wanted a list of everyone who has ever signed up, but I need a different CSV file for each event. Any ideas? Can this be built into to the Sign Up Module?

Use the signup node as an argument on the view.

That argument was already setup. I was working on a clients site and realized they only had one event available for signup... I downloaded the VBO Module and set the VBO Sign Up view with a feed and it worked.

Thanks Everyone!

And that extra little tidbit of information, in case, like me, you were seeing the csv or whatever 'feed' icon on the views preview but not on the signups tab for each node.

You need to go to the main signup configuration page at admin/settings/signup and in the 'advanced settings' fieldset you'll find an option "HOW TO DISPLAY THE ADMINISTRATIVE LIST OF SIGNED-UP USERS" switch that from the default signup provided to an embeded view and choose the view you added the feed display too as described above.

That's really not as obvious as it should be :/

I need a VBO option to set signup limits on all selected events with signups. Is that possible?

Either that, or a way to set a default limit on signups that can be overridden by the event creator.

> I need a VBO option to set signup limits on all selected events with signups. Is that possible?

Probably not, but file separate feature request please.

I've added extra fields to the signup form. I used Views Bonus to export the signup list as CSV , (Name, Job Title, Phone, Dietary Requirements) but only the "Name" field is exported from the additional info field. Is it possible to export these extra information fields as seperate CSV fields?

I just found the answer to my own query, so I thought I'd share it.

Add "User:Additional Signup Info" field to your view.
In the display options for that field there is a "Field Name" field.
add the name of the custom field from your "additional info" , (e.g. Phone) and it will be added as a seperate field in your view, and in your csv export.

Thank you pstead that worked for me!