Add this line to your application's Gemfile:

gem 'administrate_exportable'

And then execute:

$ bundle

Or install it yourself as:

$ gem install administrate_exportable

For each resource you want to be exportable, add the following line to the their respective Administrate controller.

include AdministrateExportable::Exporter

and the following line in the config/routes.rb file, correctly nested on resources

get :export, on: :collection

Example:

namespace :admin do
  resources :organizations do
    get :export, on: :collection
  end
....

By default all the attributes from ATTRIBUTE_TYPES will be exported. If you want to exclude an attribute, you can use the option: export: false.

Example:

class BusinessDashboard < Administrate::BaseDashboard
  ATTRIBUTE_TYPES = {
    id: Field::Number.with_options(export: false),
    name: Field::String,
    description: Field::Text,
...

For the default field types from Administrate, we export the values you got from the partial views/fields/index. And if it is a custom field, we just run field.to_s. But if you want to specify the value to be exported, you can use the option transform_on_export, to pass a Proc that receives the field. Example:

ATTRIBUTE_TYPES = {
 created_at: Field::DateTime.with_options(transform_on_export: -> (field) { field.data.strftime("%F") })

By default the gem adds the Export button to the partial views/admin/application/_index_header.html.erb. But if you have your own Administrate index views or override that partial in your application you can add the link manually:

link_to('Export', [:export, namespace.to_sym, page.resource_name.to_s.pluralize.to_sym, sanitized_order_params(page, :id).to_h.merge(format: :csv)], class: 'button') if valid_action?(:export)

Example:

....
 <div>
    <%= link_to(
      t(
        "administrate.actions.new_resource",
        name: page.resource_name.titleize.downcase
      ),
      [:new, namespace.to_sym, page.resource_path.to_sym],
      class: "button",
    ) if valid_action?(:new) && show_action?(:new, new_resource) %>

    <%= link_to(
      'Export',
      [:export, namespace.to_sym, page.resource_name.to_s.pluralize.to_sym, sanitized_order_params(page, :id).to_h.merge(format: :csv)],
      class: 'button'
    ) if valid_action?(:export) %>
  </div>
....

If you are using Pundit in your project you will receive an error saying undefined method 'export?' for #<Admin::OrganizationPolicy>. This is because the export action is not defined in the policy.

To fix this issue you need to add the export action to the policy and define the logic for who can export the resource.

Example:

module Admin
  class OrganizationPolicy < ApplicationPolicy
    # ... other methods ...

    def export?
      # Define the logic for who can export organizations
      # For example, allow only admins to export:
      user.admin?
    end

    # ... other methods ...
  end
end

After checking out the repo, run bin/setup to install dependencies. Then, run rake spec to run the tests. You can also run bin/console for an interactive prompt that will allow you to experiment.

To install this gem onto your local machine, run bundle exec rake install. To release a new version, update the version number in version.rb, and then run bundle exec rake release, which will create a git tag for the version, push git commits and tags, and push the .gem file to rubygems.org.

Bug reports and pull requests are welcome on GitHub at https://github.com/SourceLabsLLC/administrate_exportable.

The gem is available as open source under the terms of the MIT License.