adrian

Admin Actions

65 posts in this topic

Hi everyone,

Here's a new module that I have been meaning to build for a long time.

http://modules.processwire.com/modules/process-admin-actions/

https://github.com/adrianbj/ProcessAdminActions

 

What does it do?

Do you have a bunch of admin snippets laying around, or do you recreate from them from scratch every time you need them, or do you try to find where you saw them in the forums, or on the ProcessWire Recipes site?

Admin Actions lets you quickly create actions in the admin that you can use over and over and even make available to your site editors (permissions for each action are assigned to roles separately so you have full control over who has access to which actions).

 

Included Actions

It comes bundled with a several actions and I will be adding more over time (and hopefully I'll get some PRs from you guys too). You can browse and sort and if you have @tpr's Admin on Steroid's datatables filter feature, you can even filter based on the content of all columns. 

Screen Shot 2016-11-29 at 11.30.44 AM.png

The headliner action included with the module is: PageTable To RepeaterMatrix which fully converts an existing (and populated) PageTable field to either a Repeater or RepeaterMatrix field. This is a huge timesaver if you have an existing site that makes heavy use of PageTable fields and you would like to give the clients the improved interface of RepeaterMatrix.

Copy Content To Other Field
This action copies the content from one field to another field on all pages that use the selected template.

Copy Field Content To Other Page
Copies the content from a field on one page to the same field on another page.

Copy Repeater Items To Other Page
Add the items from a Repeater field on one page to the same field on another page.

Copy Table Field Rows To Other Page
Add the rows from a Table field on one page to the same field on another page.

Create Users Batcher
Allows you to batch create users. This module requires the Email New User module and it should be configured to generate a password automatically.

Delete Unused Fields
Deletes fields that are not used by any templates.

Delete Unused Templates
Deletes templates that are not used by any pages.

Email Batcher
Lets you email multiple addresses at once.

Field Set Or Search And Replace
Set field values, or search and replace text in field values from a filtered selection of pages and fields.

FTP Files to Page
Add files/images from a folder to a selected page.

Page Active Languages Batcher
Lets you enable or disable active status of multiple languages on multiple pages at once.

Page Manipulator
Uses an InputfieldSelector to query pages and then allows batch actions on the matched pages.

Page Table To Repeater Matrix
Fully converts an existing (and populated) PageTable field to either a Repeater or RepeaterMatrix field.

Template Fields Batcher
Lets you add or remove multiple fields from multiple templates at once.

Template Roles Batcher
Lets you add or remove access permissions, for multiple roles and multiple templates at once.

User Roles Permissions Batcher
Lets you add or remove permissions for multiple roles, or roles for multiple users at once.

 

Creating a New Action

If you create a new action that you think others would find useful, please add it to the actions subfolder of this module and submit a PR. If you think it is only useful for you, place it in /site/templates/AdminActions/ so that it doesn't get lost on module updates.

A new action file can be as simple as this:

class UnpublishAboutPage extends ProcessAdminActions {

    protected function executeAction() {
        $p = $this->pages->get('/about/');
        $p->addStatus(Page::statusUnpublished);
        $p->save();
        return true;
    }

}

Each action:

  • class must extend "ProcessAdminActions" and the filename must match the class name and end in ".action.php" like: UnpublishAboutPage.action.php
  • the action method must be: executeAction()

As you can see there are only a few lines needed to wrap the actual API call, so it's really worth the small extra effort to make an action.

Obviously that example action is not very useful. Here is another more useful one that is included with the module. It includes $description, $notes, and $author variables which are used in the module table selector interface. It also makes use of the defineOptions() method which builds the input fields used to gather the required options before running the action.

class DeleteUnusedFields extends ProcessAdminActions {

    protected $description = 'Deletes fields that are not used by any templates.';
    protected $notes = 'Shows a list of unused fields with checkboxes to select those to delete.';
    protected $author = 'Adrian Jones';
    protected $authorLinks = array(
        'pwforum' => '985-adrian',
        'pwdirectory' => 'adrian-jones',
        'github' => 'adrianbj',
    );

    protected function defineOptions() {

        $fieldOptions = array();
        foreach($this->fields as $field) {
            if ($field->flags & Field::flagSystem || $field->flags & Field::flagPermanent) continue;
            if(count($field->getFieldgroups()) === 0) $fieldOptions[$field->id] = $field->label ? $field->label . ' (' . $field->name . ')' : $field->name;
        }

        return array(
            array(
                'name' => 'fields',
                'label' => 'Fields',
                'description' => 'Select the fields you want to delete',
                'notes' => 'Note that all fields listed are not used by any templates and should therefore be safe to delete',
                'type' => 'checkboxes',
                'options' => $fieldOptions,
                'required' => true
            )
        );

    }


    protected function executeAction($options) {

        $count = 0;
        foreach($options['fields'] as $field) {
            $f = $this->fields->get($field);
            $this->fields->delete($f);
            $count++;
        }

        $this->successMessage = $count . ' field' . _n('', 's', $count) . ' ' . _n('was', 'were', $count) . ' successfully deleted';
        return true;

    }

}

 

This defineOptions() method builds input fields that look like this:

Screen Shot 2016-11-29 at 12.32.59 PM.png

Finally we use $options array in the executeAction() method to get the values entered into those options fields to run the API script to remove the checked fields.

There is one additional method that I didn't outline called: checkRequirements() - you can see it in action in the PageTableToRepeaterMatrix action. You can use this to prevent the action from running if certain requirements are not met.

At the end of the executeAction() method you can populate $this->successMessage, or $this->failureMessage which will be returned after the action has finished.

 

Populating options via URL parameters
You can also populate the option parameters via URL parameters. You should split multiple values with a “|” character.

You can either just pre-populate options:

http://mysite.dev/processwire/setup/admin-actions/options?action=TemplateFieldsBatcher&templates=29|56&fields=219&addOrRemove=add

or you can execute immediately:

http://mysite.dev/processwire/setup/admin-actions/execute?action=TemplateFieldsBatcher&templates=29|56&fields=219&addOrRemove=add


Note the “options” vs “execute” as the last path before the parameters.

 

Automatic Backup / Restore

Before any action is executed, a full database backup is automatically made. You have a few options to run a restore if needed:

  • Follow the Restore link that is presented after an action completes
  • Use the "Restore" submenu: Setup > Admin Actions > Restore
  • Move the restoredb.php file from the /site/assets/cache/AdminActions/ folder to the root of your site and load in the browser
  • Manually restore using the AdminActionsBackup.sql file in the /site/assets/cache/AdminActions/ folder

I think all these features make it very easy to create custom admin data manipulation methods that can be shared with others and executed using a simple interface without needing to build a full Process Module custom interface from scratch. I also hope it will reduce the barriers for new ProcessWire users to create custom admin functionality.

Please let me know what you think, especially if you have ideas for improving the interface, or the way actions are defined.

 

 

29 people like this

Share this post


Link to post
Share on other sites

This is very cool. Both the module and the bundled actions will be super useful. Thanks! :)

3 people like this

Share this post


Link to post
Share on other sites

Nice!

Just an idea: could the actions accept url params? Eg. prefill the template selector with "basic-page" using this url:

/admin/setup/admin-actions/options?action=TemplateFieldsBatcher&templates=basic-page

This would enable linking the action from other places of the admin (eg. add right-click menu option on pagelist, etc).

Plus another idea: actions could be put into a subdir, if users start to contribute actions their number will increase.

Btw I see you haven't overcomplicated the UI of the roles :)

2 people like this

Share this post


Link to post
Share on other sites

Whoa, Adrian you rock as usual :) thanks so much! And the idea of contribution to the actions is the best part of all.

3 people like this

Share this post


Link to post
Share on other sites

Awesome idea and bad ass realization @adrian! (pardon my French)

I did not install yet but will do soon and check it out. As @szabesz said collaboration is the baddest part. I can expect a load of wise stuff to learn from those actions contributed by PW gurus. It just might happen that there will be a lot of actions - maybe put them in a folder?

And one question about the backup. It seems it is custom and not integrated with db backup module. Is there a reason for that?

 

2 people like this

Share this post


Link to post
Share on other sites
5 hours ago, tpr said:

Nice!

Just an idea: could the actions accept url params? Eg. prefill the template selector with "basic-page" using this url:


/admin/setup/admin-actions/options?action=TemplateFieldsBatcher&templates=basic-page

This would enable linking the action from other places of the admin (eg. add right-click menu option on pagelist, etc).

 

I like the idea - are you thinking that if all required options are passed it would be possible to run directly with no intermediate "Execute Action" button? Perhaps an additional url parameter: ?execute=true - without this, all options would be prefilled, but the user would still have the option to modify if needed before executing.

Any thoughts?

 

5 hours ago, tpr said:

Plus another idea: actions could be put into a subdir, if users start to contribute actions their number will increase.

Yeah, I did think about it, but I think you're right, it is probably a good idea.

 

5 hours ago, tpr said:

Btw I see you haven't overcomplicated the UI of the roles :)

I think you are being genuine and not sarcastic, but just wanted to clarify. I am actually wondering if maybe I should convert the config settings page to a DataTables layout (like how it is on the main module process page) - not sure how simple that would be to implement at this point, but might be nice if this starts to fill out with a lot of actions. Btw, in case you guys didn't realize, you can actually remove the superuser role from any actions you know you won't ever use so that you have a shorter list to choose/filter from when using the module.

1 person likes this

Share this post


Link to post
Share on other sites
2 minutes ago, Ivan Gretsky said:

Awesome idea and bad ass realization @adrian! (pardon my French)

Glad you like it :)

 

3 minutes ago, Ivan Gretsky said:

I did not install yet but will do soon and check it out. As @szabesz said collaboration is the baddest part. I can expect a load of wise stuff to learn from those actions contributed by PW gurus. It just might happen that there will be a lot of actions - maybe put them in a folder?

Definitely part of my goal! And yes, I agree with you and @tpr - a subfolder is the way to go.

 

3 minutes ago, Ivan Gretsky said:

And one question about the backup. It seems it is custom and not integrated with db backup module. Is there a reason for that?

Are you talking about this module: http://modules.processwire.com/modules/process-database-backups/ - what if users don't have it installed? 

At the moment it only stores the one version of the backup - it gets overwritten every time you run a new action. It would be no problem to store more backups, but I was worried that it might be tempting to restore an old backup which could take you back too far and you might lose some manually adjusted content etc. The idea of the automatic backup was to provide a quick recovery from an action that didn't do what you expected. I am definitely happy to revisit this though, so please everyone give me your ideas on this.

Share this post


Link to post
Share on other sites
10 minutes ago, adrian said:

what if users don't have it installed? 

Let's inform them ;) Jokes aside, the db backup module is supported by Ryan, so it should be safe to rely on it.

10 minutes ago, adrian said:

which could take you back too far and you might lose some manually adjusted content etc.

Sensible use cases would dictate to try things out in a development environment not on a live site, so I would not worry too much about this.

Edited by szabesz
typo
2 people like this

Share this post


Link to post
Share on other sites

@adrian How about adding:

protected $authorForumsProfile = '985-adrian';

so that one can more easily identify the author? Should be used as trailing part of the href attribute, of course ;) 

2 people like this

Share this post


Link to post
Share on other sites
1 hour ago, szabesz said:

Sensible use cases would dictate to try things out in a development environment not on a live site, so I would not worry too much about this.

Let me think about this a little more - even in a dev environment restoring to a really old backup could be disastrous if you're still developing the site. I guess that's the responsibility of the dev to be smart about things though.

 

29 minutes ago, szabesz said:

@adrian How about adding:


protected $authorForumsProfile = '985-adrian';

so that one can more easily identify the author? Should be used as trailing part of the href attribute, of course ;) 

I like it - I think giving authors proper credit will hopefully promote more contributions.

I have gone with PW developer directory link, PW forum profile, and also Github account, with linked icons.

Screen Shot 2016-11-30 at 7.28.31 AM.png

I could maybe provide the option for the author to fully customize their links, but don't want things getting too ugly. Any thoughts?

2 people like this

Share this post


Link to post
Share on other sites

Ok, the optional author links are now available. These are the current options:

    protected $authorLinks = array(
        'pwforum' => '985-adrian',
        'pwdirectory' => 'adrian-jones',
        'github' => 'adrianbj',
    );

 

3 people like this

Share this post


Link to post
Share on other sites
On 11/30/2016 at 0:09 AM, tpr said:

Just an idea: could the actions accept url params? Eg. prefill the template selector with "basic-page" using this url:


/admin/setup/admin-actions/options?action=TemplateFieldsBatcher&templates=basic-page

This would enable linking the action from other places of the admin (eg. add right-click menu option on pagelist, etc).

Ok, this functionality is ready, although please test carefully at this stage.

You can populate the option parameters via URL parameters. You should split multiple values with a "|" character.

There are two options:

1) You can either just pre-populate the options values, but still showing the options page where you can make changes via the options form GUI:

http://mysite.dev/processwire/setup/admin-actions/options?action=TemplateFieldsBatcher&templates=29|56&fields=219&addOrRemove=add

2) or you can execute immediately with the passed options values:

http://mysite.dev/processwire/setup/admin-actions/execute?action=TemplateFieldsBatcher&templates=29|56&fields=219&addOrRemove=add


Note the "options" vs "execute" as the last path segment before the parameters. 

Please try it out and let me know what you think. Do you think it might also be nice to have an option to redirect to another page after it has executed, rather than showing the results page? With your suggestion of linking from other places in the admin are you thinking about maybe an ajax call to an action, rather than loading the page? I haven't tested this yet, but it might be a nice option. I might even be able to return a JSON formatted response if called via ajax?

3 people like this

Share this post


Link to post
Share on other sites

Thanks, it's a great step forward :) A JSON return would be great - I think a use case could be established first to see how this could work.

1 person likes this

Share this post


Link to post
Share on other sites
Just now, tpr said:

I think a use case could be established first to see how this could work.

Well you should get to work on one then :)  

Send me a PR with a new action and I can work on the ajax response to suit your needs and we'll take it from there!

2 people like this

Share this post


Link to post
Share on other sites

I don't have any particular feature in mind now but I'm sure there will be one later :)

1 person likes this

Share this post


Link to post
Share on other sites

It's now available in the modules directory: http://modules.processwire.com/modules/process-admin-actions/ 

It also includes a few new actions. The first post and the Github ReadMe give a small description of each action.

Hope you all find something useful among them.

Again, please feel free to contribute some actions, or if you have an idea but don't know how to build, let me know and maybe I can put it together.

4 people like this

Share this post


Link to post
Share on other sites
7 hours ago, adrian said:

or if you have an idea but don't know how to build, let me know and maybe I can put it together.

Best service ever :rolleyes:

1 person likes this

Share this post


Link to post
Share on other sites
14 hours ago, adrian said:

if you have an idea but don't know how to build, let me know and maybe I can put it together.

<attempted geek joke> If you are into the new syntax of PHP 7.1, how about something like this...

public function declareBrexitReferendumResult() : void;     /* UK version */
public function declarePresidentialElectionResult() : void; /* US version */

...take your pick. :undecided: </attempted geek joke>

4 people like this

Share this post


Link to post
Share on other sites

For those of you who are experienced with the PW API (and those looking to learn), there is now an "Action Code" viewer that shows the executeAction() method of the action you are about to execute. It is of course collapsed by default and only available to superusers.

Anyway, hope you'll find it useful and either reassuring (if you're worried about what code it about to be executed on your site), or informative as to what can be done with the API.

Screen Shot 2016-12-04 at 12.19.22 PM.png

 

10 people like this

Share this post


Link to post
Share on other sites

Hi everyone,

To celebrate @teppo featuring this module in PW Weekly, I have added a new action: Create Users Batcher

It lets you quickly create many users by entering: "username, email address" on separate lines in a textarea.

This action requires the EmailNewUser module and it must be configured to automatically generate a user password. The action checks for this module and that setting before it will let you proceed. I also recommend that you install the PasswordForceChange module to reduce the risks of having emailed a password to a user.

You can set multiple roles to be added to each new user. Be aware that at least one of these roles must have the "profile-edit" permission so that the user has the ability to change their password when they first login.

Screen Shot 2016-12-10 at 10.05.07 PM.png

 

Note that EmailNewUser will report each successful user creation and email sent success.

Screen Shot 2016-12-10 at 10.05.34 PM.png

 

I hope that the next time you need to create several users for a new client that you'll give this a try.

And of course, don't forget to send me your own actions for inclusion with the module :) 

8 people like this

Share this post


Link to post
Share on other sites

Quick update to the CreateUsersBatcher action. It now allows two options:

1) Define Username and email address (requires EmailNewUser to generate password).

2) Define additional user template fields (whichever ones you want). If you use this option and include the password, then you don't need the EmailNewUser module.

You could even given all staff at a client's office the same temp password and let me know by phone (this way there is no security risk with emailing even a temporary password that will be changed) - it's your choice.

Hopefully this screenshot will help to explain it better - note that the "New Users" textarea lists the fields from the user template and the order they need to be entered. In this example I have additional "first_name" and "last_name" fields, as well as the field added by the PasswordForceChange module which you can set to 1 to enforce this if you want.

Screen Shot 2016-12-11 at 1.33.57 PM.png

5 people like this

Share this post


Link to post
Share on other sites

New version now supports running actions via the API. 

Here's an example of copying content of a field from one page to another.

Simply load the module, and call the action class name as a method while passing the required options as an array:

$options = array(
   'field' => 99, 
   'sourcePage' => 1131, 
   'destinationPage' => 1132
);
$modules->get("ProcessAdminActions")->CopyFieldContentToOtherPage($options);

Hopefully you'll find a use for this in your hooks or template files.

6 people like this

Share this post


Link to post
Share on other sites

I think the admin UI could be re-arranged into a table layout:

  • first column: action names
  • second column: description/notes
  • third column: applied roles + and Edit button, that opens a modal or perhaps only unhides the role asmSelector. Alternatively you can set the asmSelect to operate in "inline" mode, I've experimented with that and it worked.

I know it would take some time, but sooner or later this has to be done :)

 

2 people like this

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.

  • Similar Content

    • By bernhard
      Hi,
      just stumbled over a little module that i built for my last project. it helped me to test performance of my rockdatatables module to generate 3000 random json datasets and i want to share it with you. maybe it saves some time for someone.
      https://gitlab.com/baumrock/RockDummyData/
      easy example:
      $rdd = $modules->get('RockDummyData'); for($i=0; $i<15; $i++) { // this has to be inside the for-loop to always get a new dummy $dummy = $rdd->getDummy(); echo date("d.m.Y H:i:s", $dummy->timestamp) . "<br>"; } more advanced:
      $json = new stdClass(); $json->data = array(); $rdd = $modules->get('RockDummyData'); for($i=0; $i<3000; $i++) { // this has to be inside the for-loop to always get a new dummy $dummy = $rdd->getDummy(); $obj = new stdClass(); $obj->name = $dummy->forename . ' ' . $dummy->surname; $obj->position = $dummy->job; $obj->office = $dummy->city; $obj->color = $dummy->color; $obj->start_date = new stdClass(); $obj->start_date->display = date('d.m.Y',$dummy->timestamp); $obj->start_date->sort = $dummy->timestamp; $obj->salary = rand(0,10000); $json->data[] = $obj; } echo json_encode($json); you have to store your random datasets on your own into the /data folder. there are several services for creating all kinds of random data on the web - if you know one service that allows sharing those datasets let me know and i can include common needed data into the module
    • By AndySh
      Hello!
      I need your assistance please. I purchased the module FormBuilder. Unfortunately, the module discontinued delivering customer submissions to e-mail box specified in the module settings. Direct mailing to the e-mail box works OK. The module settings stays the same and are correct, like "Send e-mail to administrator(s) is checked. The last version of FormBuilder 3.0 has been installed. Please advise how to resolve the issue becase I cannot get orders from customers anymore (((
    • By kixe
      As described in this post (https://processwire.com/talk/topic/8551-custom-urls-for-pages/?p=82742) the option 'Name Format Children' under the tab 'Family' in template settings doesn't work properly and also not as expected. I had a look inside the code and made some changes which are working properly, which offers much more options, more consistency and less code too.

      The result is the following. You have 3 Options for generating name and title, which could be combined in endless variations.
      Name is always derived from title, same like creating pages manually.
      type date: if function detects # character anywhere in the string, conversion will be: deletion of # and string will be used as format parameter for PHP date() function type field: if string is a fieldname of the parent page the value of this field will be used type string: if string doesn't fit to the 2 preceeding it will be taken as it is All parts (separated by comma) will be composed in the order of setting. You can use unlimited numbers of parts

      I made a pull request on github: https://github.com/ryancramerdesign/ProcessWire/pull/831

      Example screenshots

      Setting ...


      will result in


       
    • By kongondo
      FieldtypeRuntimeMarkup and InputfieldRuntimeMarkup
       
      Modules Directory: http://modules.processwire.com/modules/fieldtype-runtime-markup/
      GitHub: https://github.com/kongondo/FieldtypeRuntimeMarkup
       
      This module allows for custom markup to be dynamically (PHP) generated and output within a page's edit screen (in Admin).
       
      The value for the fieldtype is generated at runtime. No data is saved in the database. The accompanying InputfieldRuntimeMarkup is only used to render/display the markup in the page edit screen.
       
      The field's value is accessible from the ProcessWire API in the frontend like any other field, i.e. it has access to $page and $pages.
       
      The module was commissioned/sponsored by @Valan. Although there's certainly other ways to achieve what this module does, it offers a dynamic and flexible alternative to generating your own markup in a page's edit screen whilst also allowing access to that markup in the frontend. Thanks Valan!
       
      Warning/Consideration
      Although access to ProcessWire's Fields' admin pages is only available to Superusers, this Fieldtype will evaluate and run the custom PHP Code entered and saved in the field's settings (Details tab). Utmost care should therefore be taken in making sure your code does not perform any CRUD operations!! (unless of course that's intentional) The value for this fieldtype is generated at runtime and thus no data is stored in the database. This means that you cannot directly query a RuntimeMarkup field from $pages->find(). Usage and API
       
      Backend
      Enter your custom PHP snippet in the Details tab of your field (it is RECOMMENDED though that you use wireRenderFile() instead. See example below). Your code can be as simple or as complicated as you want as long as in the end you return a value that is not an array or an object or anything other than a string/integer.
       
      FieldtypeRuntimeMarkup has access to $page (the current page being edited/viewed) and $pages. 
       
      A very simple example.
      return 'Hello'; Simple example.
      return $page->title; Simple example with markup.
      return '<h2>' . $page->title . '</h2>'; Another simple example with markup.
      $out = '<h1>hello '; $out .= $page->title; $out .= '</h1>'; return $out; A more advanced example.
      $p = $pages->get('/about-us/')->child('sort=random'); return '<p>' . $p->title . '</p>'; An even more complex example.
      $str =''; if($page->name == 'about-us') { $p = $page->children->last(); $str = "<h2><a href='{$p->url}'>{$p->title}</a></h2>"; } else { $str = "<h2><a href='{$page->url}'>{$page->title}</a></h2>"; } return $str; Rather than type your code directly in the Details tab of the field, it is highly recommended that you placed all your code in an external file and call that file using the core wireRenderFile() method. Taking this approach means you will be able to edit your code in your favourite text editor. It also means you will be able to type more text without having to scroll. Editing the file is also easier than editing the field. To use this approach, simply do:
      return wireRenderFile('name-of-file');// file will be in /site/templates/ If using ProcessWire 3.x, you will need to use namespace as follows:
      return ProcessWire\wireRenderFile('name-of-file'); How to access the value of RuntimeMarkup in the frontend (our field is called 'runtime_markup')
       
      Access the field on the current page (just like any other field)
      echo $page->runtime_markup; Access the field on another page
      echo $pages->get('/about-us/')->runtime_markup; Screenshots
       
      Backend
       

       

       
      Frontend