Update admin_views provided view to match admin/content/file [#2156273]

When viewing admin/content/file the table is different if you have the admin_views module installed.

The latest dev version of File Entity provides a handy "Used In" column.

Admin_views provides an ajax file search and filtering but doesn't include the "Used In" column or the "5 places" link.

In IRC, Devin mentioned that the view in admin_views_default/ needs to be updated to match the other table.

Here is a picture without the admin_views module enabled.
Without admin views

Here is a picture with admin_views module enabled
With admin views

Comment	File	Size	Author
#14	update_admin_view-2156273-13-7.x-2.x.patch	16.47 KB	kmoll
#12	update_admin_view-2156273-12-7.x-2.x.patch	16.01 KB	kmoll
#9	update_admin_view-2156273-9-7.x-2.x.patch	15.43 KB	kmoll
#6	update_admin_view-2156273-6-7.x-2.x.patch	28.28 KB	mtnguru
#3	update_admin_view-2156273-3-7.x-2.x.patch	13.82 KB	kmoll
	with-admin-views-enabled.jpg	45.26 KB	gmclelland
	without-admin_views.jpg	58.04 KB	gmclelland

Comments

Comment #1

gmclelland commented 13 December 2013 at 21:25

Here is a start. I'm not sure why it is printing the same file name twice with and showing the same file with two different usages?

Maybe someone can import this view and make some quick changes to fix it?

Here is the export of the view:

$view = new view();
$view->name = 'admin_views_file';
$view->description = 'Find and manage files.';
$view->tag = 'admin';
$view->base_table = 'file_managed';
$view->human_name = 'Administration: Files';
$view->core = 7;
$view->api_version = '3.0';
$view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */

/* Display: Master */
$handler = $view->new_display('default', 'Master', 'default');
$handler->display->display_options['title'] = 'Files';
$handler->display->display_options['css_class'] = 'admin-views-view';
$handler->display->display_options['use_ajax'] = TRUE;
$handler->display->display_options['use_more_always'] = FALSE;
$handler->display->display_options['access']['type'] = 'menu';
$handler->display->display_options['cache']['type'] = 'none';
$handler->display->display_options['query']['type'] = 'views_query';
$handler->display->display_options['exposed_form']['type'] = 'basic';
$handler->display->display_options['exposed_form']['options']['reset_button'] = TRUE;
$handler->display->display_options['pager']['type'] = 'full';
$handler->display->display_options['pager']['options']['items_per_page'] = '50';
$handler->display->display_options['pager']['options']['offset'] = '0';
$handler->display->display_options['pager']['options']['id'] = '0';
$handler->display->display_options['pager']['options']['quantity'] = '9';
$handler->display->display_options['style_plugin'] = 'table';
$handler->display->display_options['style_options']['columns'] = array(
  'views_bulk_operations' => 'views_bulk_operations',
  'filename' => 'filename',
  'type' => 'type',
  'filesize' => 'filesize',
  'name' => 'name',
  'timestamp' => 'timestamp',
  'edit' => 'edit',
  'delete' => 'edit',
  'count' => 'count',
  'usage' => 'usage',
);
$handler->display->display_options['style_options']['default'] = 'timestamp';
$handler->display->display_options['style_options']['info'] = array(
  'views_bulk_operations' => array(
    'align' => '',
    'separator' => '',
    'empty_column' => 0,
  ),
  'filename' => array(
    'sortable' => 1,
    'default_sort_order' => 'asc',
    'align' => '',
    'separator' => '',
    'empty_column' => 0,
  ),
  'type' => array(
    'sortable' => 1,
    'default_sort_order' => 'asc',
    'align' => '',
    'separator' => '',
    'empty_column' => 0,
  ),
  'filesize' => array(
    'sortable' => 1,
    'default_sort_order' => 'asc',
    'align' => '',
    'separator' => '',
    'empty_column' => 0,
  ),
  'name' => array(
    'sortable' => 1,
    'default_sort_order' => 'asc',
    'align' => '',
    'separator' => '',
    'empty_column' => 0,
  ),
  'timestamp' => array(
    'sortable' => 1,
    'default_sort_order' => 'desc',
    'align' => '',
    'separator' => '',
    'empty_column' => 0,
  ),
  'edit' => array(
    'align' => '',
    'separator' => '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;',
    'empty_column' => 0,
  ),
  'delete' => array(
    'align' => '',
    'separator' => '',
    'empty_column' => 0,
  ),
  'count' => array(
    'sortable' => 1,
    'default_sort_order' => 'asc',
    'align' => '',
    'separator' => '',
    'empty_column' => 0,
  ),
  'usage' => array(
    'align' => '',
    'separator' => '',
    'empty_column' => 0,
  ),
);
$handler->display->display_options['style_options']['sticky'] = TRUE;
$handler->display->display_options['style_options']['empty_table'] = TRUE;
/* No results behavior: Global: Unfiltered text */
$handler->display->display_options['empty']['area_text_custom']['id'] = 'area_text_custom';
$handler->display->display_options['empty']['area_text_custom']['table'] = 'views';
$handler->display->display_options['empty']['area_text_custom']['field'] = 'area_text_custom';
$handler->display->display_options['empty']['area_text_custom']['empty'] = TRUE;
$handler->display->display_options['empty']['area_text_custom']['content'] = 'No files available.';
/* Relationship: File: User who uploaded */
$handler->display->display_options['relationships']['uid']['id'] = 'uid';
$handler->display->display_options['relationships']['uid']['table'] = 'file_managed';
$handler->display->display_options['relationships']['uid']['field'] = 'uid';
$handler->display->display_options['relationships']['uid']['label'] = 'user';
/* Field: Bulk operations: File */
$handler->display->display_options['fields']['views_bulk_operations']['id'] = 'views_bulk_operations';
$handler->display->display_options['fields']['views_bulk_operations']['table'] = 'file_managed';
$handler->display->display_options['fields']['views_bulk_operations']['field'] = 'views_bulk_operations';
$handler->display->display_options['fields']['views_bulk_operations']['label'] = '';
$handler->display->display_options['fields']['views_bulk_operations']['element_label_colon'] = FALSE;
$handler->display->display_options['fields']['views_bulk_operations']['vbo_settings']['display_type'] = '0';
$handler->display->display_options['fields']['views_bulk_operations']['vbo_settings']['enable_select_all_pages'] = 1;
$handler->display->display_options['fields']['views_bulk_operations']['vbo_settings']['force_single'] = 0;
$handler->display->display_options['fields']['views_bulk_operations']['vbo_settings']['entity_load_capacity'] = '10';
$handler->display->display_options['fields']['views_bulk_operations']['vbo_operations'] = array(
  'action::views_bulk_operations_archive_action' => array(
    'selected' => 1,
    'postpone_processing' => 0,
    'skip_confirmation' => 0,
    'override_label' => 1,
    'label' => 'Archive',
    'settings' => array(
      'scheme' => 'public',
      'temporary' => 1,
    ),
  ),
  'action::views_bulk_operations_delete_item' => array(
    'selected' => 1,
    'postpone_processing' => 0,
    'skip_confirmation' => 0,
    'override_label' => 1,
    'label' => 'Delete',
  ),
  'action::views_bulk_operations_script_action' => array(
    'selected' => 0,
    'postpone_processing' => 0,
    'skip_confirmation' => 0,
    'override_label' => 0,
    'label' => '',
  ),
  'action::views_bulk_operations_modify_action' => array(
    'selected' => 1,
    'postpone_processing' => 0,
    'skip_confirmation' => 1,
    'override_label' => 1,
    'label' => 'Change value',
    'settings' => array(
      'show_all_tokens' => 1,
      'display_values' => array(
        '_all_' => '_all_',
      ),
    ),
  ),
  'action::views_bulk_operations_argument_selector_action' => array(
    'selected' => 0,
    'skip_confirmation' => 0,
    'override_label' => 0,
    'label' => '',
    'settings' => array(
      'url' => '',
    ),
  ),
  'action::system_send_email_action' => array(
    'selected' => 0,
    'postpone_processing' => 0,
    'skip_confirmation' => 0,
    'override_label' => 0,
    'label' => '',
  ),
  'action::panelizer_set_status_action' => array(
    'selected' => 0,
    'postpone_processing' => 0,
    'skip_confirmation' => 0,
    'override_label' => 0,
    'label' => '',
  ),
);
/* Field: File: Name */
$handler->display->display_options['fields']['filename']['id'] = 'filename';
$handler->display->display_options['fields']['filename']['table'] = 'file_managed';
$handler->display->display_options['fields']['filename']['field'] = 'filename';
$handler->display->display_options['fields']['filename']['label'] = 'TITLE';
$handler->display->display_options['fields']['filename']['element_label_colon'] = FALSE;
/* Field: File: Type */
$handler->display->display_options['fields']['type']['id'] = 'type';
$handler->display->display_options['fields']['type']['table'] = 'file_managed';
$handler->display->display_options['fields']['type']['field'] = 'type';
$handler->display->display_options['fields']['type']['machine_name'] = 0;
/* Field: File: Size */
$handler->display->display_options['fields']['filesize']['id'] = 'filesize';
$handler->display->display_options['fields']['filesize']['table'] = 'file_managed';
$handler->display->display_options['fields']['filesize']['field'] = 'filesize';
/* Field: User: Name */
$handler->display->display_options['fields']['name']['id'] = 'name';
$handler->display->display_options['fields']['name']['table'] = 'users';
$handler->display->display_options['fields']['name']['field'] = 'name';
$handler->display->display_options['fields']['name']['relationship'] = 'uid';
$handler->display->display_options['fields']['name']['label'] = 'AUTHOR';
$handler->display->display_options['fields']['name']['element_label_colon'] = FALSE;
/* Field: File: Upload date */
$handler->display->display_options['fields']['timestamp']['id'] = 'timestamp';
$handler->display->display_options['fields']['timestamp']['table'] = 'file_managed';
$handler->display->display_options['fields']['timestamp']['field'] = 'timestamp';
$handler->display->display_options['fields']['timestamp']['label'] = 'UPDATED';
$handler->display->display_options['fields']['timestamp']['element_label_colon'] = FALSE;
$handler->display->display_options['fields']['timestamp']['date_format'] = 'short';
/* Field: File: Edit link */
$handler->display->display_options['fields']['edit']['id'] = 'edit';
$handler->display->display_options['fields']['edit']['table'] = 'file_managed';
$handler->display->display_options['fields']['edit']['field'] = 'edit';
$handler->display->display_options['fields']['edit']['label'] = 'OPERATIONS';
$handler->display->display_options['fields']['edit']['element_label_colon'] = FALSE;
/* Field: File: Delete link */
$handler->display->display_options['fields']['delete']['id'] = 'delete';
$handler->display->display_options['fields']['delete']['table'] = 'file_managed';
$handler->display->display_options['fields']['delete']['field'] = 'delete';
$handler->display->display_options['fields']['delete']['label'] = '';
$handler->display->display_options['fields']['delete']['element_label_colon'] = FALSE;
/* Field: File Usage: Use count */
$handler->display->display_options['fields']['count']['id'] = 'count';
$handler->display->display_options['fields']['count']['table'] = 'file_usage';
$handler->display->display_options['fields']['count']['field'] = 'count';
$handler->display->display_options['fields']['count']['label'] = 'USED IN';
$handler->display->display_options['fields']['count']['exclude'] = TRUE;
$handler->display->display_options['fields']['count']['alter']['path'] = '[usage]';
$handler->display->display_options['fields']['count']['element_label_colon'] = FALSE;
$handler->display->display_options['fields']['count']['format_plural'] = TRUE;
/* Field: File: Usage link */
$handler->display->display_options['fields']['usage']['id'] = 'usage';
$handler->display->display_options['fields']['usage']['table'] = 'file_managed';
$handler->display->display_options['fields']['usage']['field'] = 'usage';
$handler->display->display_options['fields']['usage']['label'] = 'USED IN';
$handler->display->display_options['fields']['usage']['alter']['alter_text'] = TRUE;
$handler->display->display_options['fields']['usage']['alter']['text'] = '[count] Places';
$handler->display->display_options['fields']['usage']['element_label_colon'] = FALSE;
$handler->display->display_options['fields']['usage']['text'] = 'Hello';
/* Filter criterion: File: Name */
$handler->display->display_options['filters']['filename']['id'] = 'filename';
$handler->display->display_options['filters']['filename']['table'] = 'file_managed';
$handler->display->display_options['filters']['filename']['field'] = 'filename';
$handler->display->display_options['filters']['filename']['operator'] = 'contains';
$handler->display->display_options['filters']['filename']['group'] = 1;
$handler->display->display_options['filters']['filename']['exposed'] = TRUE;
$handler->display->display_options['filters']['filename']['expose']['operator_id'] = 'filename_op';
$handler->display->display_options['filters']['filename']['expose']['label'] = 'Name';
$handler->display->display_options['filters']['filename']['expose']['operator'] = 'filename_op';
$handler->display->display_options['filters']['filename']['expose']['identifier'] = 'filename';
$handler->display->display_options['filters']['filename']['expose']['remember'] = TRUE;
$handler->display->display_options['filters']['filename']['expose']['remember_roles'] = array(
  2 => '2',
  1 => 0,
  3 => 0,
);
/* Filter criterion: File: Type */
$handler->display->display_options['filters']['type']['id'] = 'type';
$handler->display->display_options['filters']['type']['table'] = 'file_managed';
$handler->display->display_options['filters']['type']['field'] = 'type';
$handler->display->display_options['filters']['type']['group'] = 1;
$handler->display->display_options['filters']['type']['exposed'] = TRUE;
$handler->display->display_options['filters']['type']['expose']['operator_id'] = 'type_op';
$handler->display->display_options['filters']['type']['expose']['label'] = 'Type';
$handler->display->display_options['filters']['type']['expose']['operator'] = 'type_op';
$handler->display->display_options['filters']['type']['expose']['identifier'] = 'type';
$handler->display->display_options['filters']['type']['expose']['remember'] = TRUE;
$handler->display->display_options['filters']['type']['expose']['remember_roles'] = array(
  2 => '2',
  1 => 0,
  3 => 0,
);
/* Filter criterion: User: Name */
$handler->display->display_options['filters']['uid']['id'] = 'uid';
$handler->display->display_options['filters']['uid']['table'] = 'users';
$handler->display->display_options['filters']['uid']['field'] = 'uid';
$handler->display->display_options['filters']['uid']['relationship'] = 'uid';
$handler->display->display_options['filters']['uid']['value'] = '';
$handler->display->display_options['filters']['uid']['group'] = 1;
$handler->display->display_options['filters']['uid']['exposed'] = TRUE;
$handler->display->display_options['filters']['uid']['expose']['operator_id'] = 'uid_op';
$handler->display->display_options['filters']['uid']['expose']['label'] = 'User';
$handler->display->display_options['filters']['uid']['expose']['operator'] = 'uid_op';
$handler->display->display_options['filters']['uid']['expose']['identifier'] = 'uid';
$handler->display->display_options['filters']['uid']['expose']['remember'] = TRUE;
$handler->display->display_options['filters']['uid']['expose']['remember_roles'] = array(
  2 => '2',
  1 => 0,
  3 => 0,
);
/* Filter criterion: File: File ID */
$handler->display->display_options['filters']['fid']['id'] = 'fid';
$handler->display->display_options['filters']['fid']['table'] = 'file_managed';
$handler->display->display_options['filters']['fid']['field'] = 'fid';
$handler->display->display_options['filters']['fid']['exposed'] = TRUE;
$handler->display->display_options['filters']['fid']['expose']['operator_id'] = 'fid_op';
$handler->display->display_options['filters']['fid']['expose']['label'] = 'File ID';
$handler->display->display_options['filters']['fid']['expose']['operator'] = 'fid_op';
$handler->display->display_options['filters']['fid']['expose']['identifier'] = 'fid';
$handler->display->display_options['filters']['fid']['expose']['remember_roles'] = array(
  2 => '2',
  1 => 0,
  3 => 0,
  4 => 0,
  5 => 0,
  6 => 0,
  7 => 0,
);

/* Display: System */
$handler = $view->new_display('system', 'System', 'system_1');
$handler->display->display_options['defaults']['hide_admin_links'] = FALSE;
$handler->display->display_options['hide_admin_links'] = TRUE;
$handler->display->display_options['defaults']['access'] = FALSE;
$handler->display->display_options['path'] = 'admin/content/file';

Comment #2

kmoll commented 2 June 2014 at 18:51

Assigned:

Unassigned

» kmoll

Comment #3

kmoll commented 2 June 2014 at 18:56

Status	File	Size
new	update_admin_view-2156273-3-7.x-2.x.patch	13.82 KB

I have updated the admin view to display the total usage count for the file as well as re-arranging the fields to match the original page table.

Comment #4

kmoll commented 2 June 2014 at 18:59

Status:

Active

» Needs review

Comment #5

dave reid

he/him

English

Nebraska USA

commented 6 June 2014 at 16:01

Issue tags:

+7.x-2.0 beta blocker

Comment #6

mtnguru commented 6 June 2014 at 21:01

Status	File	Size
new	update_admin_view-2156273-6-7.x-2.x.patch	28.28 KB

The patch in comment 3 solves the initial problem with the file usage not being displayed. However the order of the columns and the column headers are slightly different.

Column changes:

Header changed from UPLOADED -> UPDATED
Header changed from NAME -> TITLE
Edit and Delete links combined into one column with a header name of OPERATIONS

Comment #7

kmoll commented 10 June 2014 at 02:20

Ok, I will take a look and re order

Comment #8

kmoll commented 10 June 2014 at 02:20

Status:

Needs review

» Active

Comment #9

kmoll commented 10 June 2014 at 03:17

Status	File	Size
new	update_admin_view-2156273-9-7.x-2.x.patch	15.43 KB

I have updated the view and made the following changes:

Renamed the "Name" column to "Title" to match the non-admin_views page
I have created a single column name "Operations" on the admin_views page to match the non-admin_views page. I did this by hiding the individual 'edit' and 'delete' links and created another field with the "Operations" and re-write the output to display the two links

I have kept the "Uploaded" field as "Updated" to match the non-admin_views page. I believe this is the correct label since the files_managed table only has a timestamp, and if the file is updated, this timestamp is updated. Please correct me if I am wrong about this.

Comment #10

kmoll commented 10 June 2014 at 03:17

Status:

Active

» Needs review

Comment #11

gmclelland commented 10 June 2014 at 21:34

@kmoll - Just checked the patch in #9 and it looks good, but can you also make the column "Used In" column sortable?

Comment #12

kmoll commented 12 June 2014 at 11:38

Status	File	Size
new	update_admin_view-2156273-12-7.x-2.x.patch	16.01 KB

I have made the "Used In" column sortable

Comment #13

gmclelland commented 23 June 2014 at 17:17

Status:

Needs review

» Reviewed & tested by the community

The patch in #12 works for me. Thanks @kmoll

Comment #14

kmoll commented 23 June 2014 at 17:59

Status	File	Size
new	update_admin_view-2156273-13-7.x-2.x.patch	16.47 KB

This is the same patch as #12, just formatted with git format-patch.

Comment #15

25 June 2014 at 16:49

Commit 5e9c095 on 7.x-2.x by aaron:

Issue #2156273 by kmoll, mtnguru: Update admin_views provided view to...

Comment #16

aaron commented 25 June 2014 at 17:06

Status:

Reviewed & tested by the community

» Fixed

Committed to http://drupalcode.org/project/file_entity.git/commit/5e9c095.

Comment #17

9 July 2014 at 17:10

Status:

Fixed

» Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.

Comment #18

gmclelland commented 18 August 2014 at 22:35

Here is a followup issue to this #2323613: Update admin_views operations provided view to match admin/content/file operations if interested.

Comment #19

kenorb commented 11 May 2016 at 15:59

Assigned:

kmoll

» Unassigned

Update admin_views provided view to match admin/content/file

Comments

Comment #1

Comment #2

Comment #3

Comment #4

Comment #5

Comment #6

Comment #7

Comment #8

Comment #9

Comment #10

Comment #11

Comment #12

Comment #13

Comment #14

Comment #15

Comment #16

Comment #17

Comment #18

Comment #19

Child issues

Referenced by

News items

Our community

Documentation

Drupal code base

Governance of community