Jump to content

Batch Child Editor


adrian

Recommended Posts

  • 1 month later...

I tried to find info on how to import a page hierarchy with Batch Child Editor:

FirstLevel1
FirstLevel1/Child1/
FirstLevel1/Child2/
FirstLevel2
FirstLevel2/Child1/
FirstLevel2/Child2/

Is this possible, or should I first create the first level-pages and then import the second level pages one parent at a time?

Link to comment
Share on other sites

@lpa - BCE only supports one level of importing. If you're importing content along with the second level pages, then you'll need to create the first pages first, but if you're just trying to create a hierarchy of pages with titles only for now, then this might help: https://processwire.com/modules/admin-actions-unordered-list-to-pages/

Otherwise, I tend to do all my complex imports these days with a custom AdminActions action. This is great if you have a complex CSV export from an old site - not sure if this is what you are doing or not, but just in case:

image.png.4cecd9ab3ef58fbb64906924a9ca2836.png

I find this approach really useful as I can quickly do test imports and continue to tweak until I have everything correct. It even allows importing specific items from the CSV (by ID, or some other field if you want). You can then easily remove all test imports and do a full import of everything.

Link to comment
Share on other sites

Great, the UnorderedListToPages Action did just what I needed. Is that Import Media action available somewhere is just in your custom use?

  • Like 1
Link to comment
Share on other sites

1 minute ago, lpa said:

Is that Import Media action available somewhere is just in your custom use?

It's something I built for my own use. I am constantly creating new / modified versions of it for all sorts of imports. Here is a copy of what I am currently using for that version:

Spoiler

<?php

set_time_limit(0);
ini_set('memory_limit','1024M');

class ImportMedia extends ProcessAdminActions {

    protected $title = 'Import Media';
    protected $description = 'Imports media items';
    protected $notes = "Put media.csv file into /site/templates/AdminActions/csv";


    protected function defineOptions() {
        $csvFiles = $this->wire('files')->find($this->wire('config')->paths->templates . 'AdminActions/csv');
        $typeOptions = array('' => 'Choose One');
        foreach($csvFiles as $csvFile) {
            $contentType = pathinfo($csvFile, PATHINFO_FILENAME);
            $typeOptions[$contentType] = ucfirst($contentType);
        }

        return array(
            array(
                'name' => 'removeExisting',
                'label' => 'Remove existing publications',
                'description' => 'This will remove existing publications',
                'type' => 'checkbox'
            ),
            array(
                'name' => 'howMany',
                'label' => 'How Many',
                'description' => 'How many to import',
                'type' => 'select',
                'required' => true,
                'options' => array(
                    '1' => '1',
                    '2' => '2',
                    '10' => '10',
                    '25' => '25',
                    '50' => '50',
                    '100' => '100',
                    'all' => 'All',
                    'byId' => 'One by ID'
                )
            ),
            array(
                'name' => 'imageId',
                'label' => 'Image ID',
                'showIf' => 'howMany=byId',
                'type' => 'integer'
            ),

        );
    }


    protected function executeAction($options) {

        $howMany = $options['howMany'];

        if($options['removeExisting']) {
            foreach($this->wire('pages')->find("template=media, include=all") as $child) {
                $child->delete();
            }
        }


        require_once './includes/parsecsv.lib.php';

        $csvStr = file_get_contents(__DIR__ . '/csv/media.csv');

        // iterate through all rows to create child pages
        $rows = new \parseCSV();
        $rows->encoding('UTF-16', 'UTF-8');
        $rows->heading = true;
        $rows->delimiter = ',';
        $rows->enclosure = '"';
        $rows->parse($csvStr);

        foreach($rows->data as $i => $row) {

            if($howMany == 'byId' && $row['pid'] != $options['imageId']) continue;
            if($howMany !== 'byId' && $i >= $howMany && $howMany != 'all') break;
            $existingPage = $this->wire('pages')->get('template=media, old_id="'.$row['pid'].'"');
            if(!$existingPage->id) {
                $p = new Page();
                $p->of(false);
                $p->template = 'media';
                $p->parent = 4852;
                $title = html_entity_decode($row['title']);
                $title = htmlspecialchars_decode($title, ENT_QUOTES);
                $title = trim($title, '.');
                $p->title = $title;
                $p->save();
            }
            else {
                $p = $existingPage;
                $p->of(false);
            }

            foreach($p->fields as $f) {

                if($f->name == 'title') {
                    continue;
                }
                elseif($f->name == 'image') {

                    $p->image->removeAll();
                    $p->save('image');
                    $p->image = 'https://mysite.com/imagelibrary/albums/'.$row['filepath'].$row['filename'];
                }
                elseif($f->name == 'date') {
                    $p->$f = strtotime($row['user3']);
                }
                elseif($f->name == 'people') {
                    $owners = explode(',', $row['user1']);
                    $authorsStr = '';
                    foreach($owners as $owner) {
                        $name = explode(' ', $owner, 2);
                        $u = $this->wire('pages')->get('template=staff, first_name='.$name[0].', last_name='.$name[1]);
                        if($u->id) {
                            $p->$f->add($u);
                        }
                        else {
                            $authorsStr .= $owner . ', ';
                        }
                    }
                    $p->authors = trim($authorsStr, ', ');
                }
                elseif($f->name == 'media_type') {
                    if($row['user4'] == 'Vector Graphic' || $row['user4'] == 'Raster Graphic') {
                        $p->$f = $this->wire('pages')->get(4850);
                    }
                    elseif($row['user4'] == 'Video') {
                        $p->$f = $this->wire('pages')->get(4851);
                    }
                    else {
                        $p->$f = $this->wire('pages')->get(4849);
                    }
                }
                elseif($f->name == 'vector_or_raster') {
                    $p->$f = pathinfo($row['filename'], PATHINFO_EXTENSION) == 'svg' ? 'Vector' : 'Raster';
                }
                elseif($f->name == 'media_album') {
                    $p->$f = $this->wire('pages')->get('template=media_album, old_id='. $row['aid']);
                }
                elseif($f->name == 'keywords') {
                    $keywords = explode(',', $row['keywords']);
                    $target = array('symbol', 'vector', 'illustration');
                    if(count(array_intersect($keywords, $target)) == count($target)) {
                        $p->is_symbol = 1;
                        unset($keywords[0]);
                        unset($keywords[1]);
                        unset($keywords[2]);
                    }
                    $p->$f = implode(', ', $keywords);
                }
                elseif($f->name == 'projects') {
                    foreach(explode(',', $row['user5']) as $id) {
                        $p->$f->add($this->wire('pages')->get('template=project, old_id='.$id));
                    }
                }
                else {
                    $trans = array(
                        "old_id" => "pid",
                        "body" => "caption"
                    );
                    $rowFieldName = strtr($f->name, $trans);
                    if(isset($row[$rowFieldName])) {
                        $value = html_entity_decode($row[$rowFieldName]);
                        $value = htmlspecialchars_decode($value, ENT_QUOTES);
                        $p->$f = $value;
                    }
                }
            }
            $p->created = $row['ctime'];

            $p->save(array('quiet' => true));

        }

        $this->successMessage = 'Success';
        return true;

    }

}

 

Obviously you'll need to make a lot of changes to have anything useful to you, but it's a good starting point.

Also note that I am making use of this CSV library: https://github.com/parsecsv/parsecsv-for-php so you'll need to grab that so it can be included.

  • Like 1
Link to comment
Share on other sites

  • 3 weeks later...

Hi @adrian 👋 first, many thanks for your module ! it help me a lot.

Unfortunately, I'm facing with a bug/problem.
I have a store pages with a mapMArker field, all fine when I export, the data are well inside de CSV but when I try to import this CSV the mapMarker field is not filled ans display the default value.

Any idea ?

Thanks

Note: I created a hook function (Pages::saveReady)  who copy/paste address in the address field of the mapMarker and use your module to resave all entries and then all is fine

  • Like 1
Link to comment
Share on other sites

I get the following error on attempting to import a CSV file:

Quote

Parse Error: syntax error, unexpected 'class' (T_CLASS), expecting identifier (T_STRING) or variable (T_VARIABLE) or '{' or '$' (line 63 of site/modules/BatchChildEditor/parsecsv-for-php/src/extensions/DatatypeTrait.php)

I'm running ProcessWire 3.0.171, on PHP 7.4x 

 

Link to comment
Share on other sites

On 3/8/2021 at 4:45 PM, adrian said:

Hi @Kiwi Chris - I haven't ever seen that which is strange.

Would you mind doing me a favour and reporting that here: https://github.com/parsecsv/parsecsv-for-php/issues 

Thanks!

I figured out the problem. The hosting control panel said that PHP 7.4 was installed but it was actually only supplying 5.4. I got that fixed and the module works now.

  • Like 1
Link to comment
Share on other sites

  • 3 weeks later...

Hi @adrian, great module!

I am wondering if there is an option to include the system fields into the export, or help me with some code that I can add to the module to do this?

If this is not possible, some help getting me to include the page id into the export is also great.

Hope anyone can help! Thanks.

Link to comment
Share on other sites

@sirhc - you can already export system fields, include the page ID.

There are two ways to do this:

1) Make the parent page separately configurable and then visit the BCE settings on that page's Settings tab and choose the fields you want included in the export.

2) In the Module's CSV export settings, allow the user to override the CSV settings and then when they export, they can choose exactly the fields they want on each export.

Link to comment
Share on other sites

  • 2 months later...

Hello,
On my PW tree, some of parents have thousands child pages, and some tens of thousands child pages, using BCE load child pages is heavy and cannot using edit mode because of error memory/timeout.
Is that possible to add pagination like on edit mode just like lister mode ? or is there any way to use this module with thousands child pages ?

 

Link to comment
Share on other sites

@pwfans - I always disable BCE for pages that have too many children for the edit mode to handle. I don't really think the edit mode makes much sense with that many pages anyway so I don't think pagination will help. If you need to batch edit that many child pages you probably need to write a script via the API (Tracy Console panel or AdminActions perhaps?) to make the changes.

Link to comment
Share on other sites

16 hours ago, adrian said:

@pwfans - I always disable BCE for pages that have too many children for the edit mode to handle. I don't really think the edit mode makes much sense with that many pages anyway so I don't think pagination will help. If you need to batch edit that many child pages you probably need to write a script via the API (Tracy Console panel or AdminActions perhaps?) to make the changes.

Ahh ok, too bad BCE can't handle many pages, it's already has a nice interface for bulk edit. 

Link to comment
Share on other sites

4 hours ago, pwfans said:

Ahh ok, too bad BCE can't handle many pages, it's already has a nice interface for bulk edit. 

But how nice would that interface actually be for hundreds / thousands of pages? What sort of bulk edit actions are you referring to? Changing status, or deleting etc? I suppose there could be a way to select all across all pages if they were to be paginated. I'm afraid I just don't see it as the right tool for the job in this case, but if you want to add support for this, I'm happy to accept a PR.

Link to comment
Share on other sites

15 hours ago, adrian said:

But how nice would that interface actually be for hundreds / thousands of pages? What sort of bulk edit actions are you referring to? Changing status, or deleting etc? I suppose there could be a way to select all across all pages if they were to be paginated. I'm afraid I just don't see it as the right tool for the job in this case, but if you want to add support for this, I'm happy to accept a PR.

For example, sometimes we need to change title/name/template for about 80 pages from about 600+ pages.
We use PW for intranet application.
Thank you for your offer anyway @adrian, we will discuss this with our IT staff first.

Link to comment
Share on other sites

@pwfans - I wonder, do you have a copy of ListerPro? This might be a better option for your needs. It's inline editing isn't quite as convenient as BCE's, but it has pagination and searching and so it  scales infinitely.

Link to comment
Share on other sites

  • 1 month later...

Hi @adrianthank you for the module, I have been using it for years on and off and it has saved tons of work!

I have a question regarding inline editing. I know it has been asked a lot but I have only 1 field to edit per page and wondered if I can go without purchasing ListerPro?

This is how my setup looks like. Imagine that I just have to pick some categories in Category Reference and potentially delete the page. Can you give me a hint/direction how I can approach this?

Thank you!
  

Screenshot 2021-07-17 at 18.02.47.jpg

Link to comment
Share on other sites

@michelangelo - the non-pro version of the Lister doesn't support inline editing. If you don't want to buy ListerPro, then you could perhaps modify the normal BCE edit mode to support custom fields (that wouldn't be too hard actually). The more complicated part would be building in the pagination, which BCE doesn't currently have, although it really does need it, especially with your setup with 3346 child pages. I don't really have time to work on adding those things any time soon, but they would make great additions if someone wants to contribute via a PR.

  • Thanks 1
Link to comment
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 Robin S
      This module lets you add some custom menu items to the main admin menu, and you can set the dropdown links dynamically in a hook if needed.
      Sidenote: the module config uses some repeatable/sortable rows for the child link settings, similar to the ProFields Table interface. The data gets saved as JSON in a hidden textarea field. Might be interesting to other module developers?
      Custom Admin Menus
      Adds up to three custom menu items with optional dropdowns to the main admin menu.
      The menu items can link to admin pages, front-end pages, or pages on external websites.
      The links can be set to open in a new browser tab, and child links in the dropdown can be given an icon.
      Requires ProcessWire v3.0.178 or newer.
      Screenshots
      Example of menu items

      Module config for the menus

      Link list shown when parent menu item is not given a URL

      Advanced
      Setting child menu items dynamically
      If needed you can set the child menu items dynamically using a hook.
      Example:
      $wire->addHookAfter('CustomAdminMenus::getMenuChildren', function(HookEvent $event) { // The menu number is the first argument $menu_number = $event->arguments(0); if($menu_number === 1) { $colours = $event->wire()->pages->findRaw('template=colour', ['title', 'url', 'page_icon']); $children = []; foreach($colours as $colour) { // Each child item should be an array with the following keys $children[] = [ 'icon' => $colour['page_icon'], 'label' => $colour['title'], 'url' => $colour['url'], 'newtab' => false, ]; } $event->return = $children; } }); Create multiple levels of flyout menus
      It's also possible to create multiple levels of flyout submenus using a hook.

      For each level a submenu can be defined in a "children" item. Example:
      $wire->addHookAfter('CustomAdminMenus::getMenuChildren', function(HookEvent $event) { // The menu number is the first argument $menu_number = $event->arguments(0); if($menu_number === 1) { $children = [ [ 'icon' => 'adjust', 'label' => 'One', 'url' => '/one/', 'newtab' => false, ], [ 'icon' => 'anchor', 'label' => 'Two', 'url' => '/two/', 'newtab' => false, 'children' => [ [ 'icon' => 'child', 'label' => 'Red', 'url' => '/red/', 'newtab' => false, ], [ 'icon' => 'bullhorn', 'label' => 'Green', 'url' => '/green/', 'newtab' => false, 'children' => [ [ 'icon' => 'wifi', 'label' => 'Small', 'url' => '/small/', 'newtab' => true, ], [ 'icon' => 'codepen', 'label' => 'Medium', 'url' => '/medium/', 'newtab' => false, ], [ 'icon' => 'cogs', 'label' => 'Large', 'url' => '/large/', 'newtab' => false, ], ] ], [ 'icon' => 'futbol-o', 'label' => 'Blue', 'url' => '/blue/', 'newtab' => true, ], ] ], [ 'icon' => 'hand-o-left', 'label' => 'Three', 'url' => '/three/', 'newtab' => false, ], ]; $event->return = $children; } }); Showing/hiding menus according to user role
      You can determine which menu items can be seen by a role by checking the user's role in the hook.
      For example, if a user has or lacks a role you could include different child menu items in the hook return value. Or if you want to conditionally hide a custom menu altogether you can set the return value to false. Example:
      $wire->addHookAfter('CustomAdminMenus::getMenuChildren', function(HookEvent $event) { // The menu number is the first argument $menu_number = $event->arguments(0); $user = $event->wire()->user; // For custom menu number 1... if($menu_number === 1) { // ...if user does not have some particular role... if(!$user->hasRole('foo')) { // ...do not show the menu $event->return = false; } } });  
      https://github.com/Toutouwai/CustomAdminMenus
      https://processwire.com/modules/custom-admin-menus/
    • By tcnet
      This module for ProcessWire sends a notification email for each failed login attempt. Similar modules exists already in the module directory of ProcessWire. However, this module is designed to notify, even if specified user doesn't exist.
      Settings
      The settings for this module are located in the menu Modules=>Configure=>LoginFailNotifier.
      Notification email
      Specifies the email address to which the notification emails should be sent.
        Email subject
      Specifies the subject line for the notification email.
        Post variables
      Specifies the $_POST variables to be included in the notification email. Each variable must be separated by a comma. For example: login_name,login_pass
        Server variables
      Specifies the $_SERVER variables to be included in the notification email. Each variable must be separated by a comma. For example: REMOTE_ADDR,HTTP_USER_AGENT
      Link to ProcessWire module directory:
      https://processwire.com/modules/login-fail-notifier/
      Link to github.com:
      https://github.com/techcnet/LoginFailNotifier
    • By Fokke
      ProcessWire 3.x markup module for rendering meta tags in HTML document head section. Note that this module is not a full-blown SEO solution, but rather a simple tool for rendering meta tags based on module configuration. Adding custom meta tags is also supported.
      Built-in meta tags
      The following meta tags are supported out-of-the-box:
      Document title consisting of page title and site name Character set Canonical Viewport Description Keywords Hreflang tags Open Graph og:title og:site_name og:type og:url og:description og:image og:image:width og:image:height Twitter meta tags twitter:card twitter:site twitter:creator twitter:title twitter:description twitter:image Facebook meta tags fb:app_id The full documentation with configurable options can be found here: https://github.com/Fokke-/MarkupMetadata
       
      Requirements:
      ProcessWire>=3.0.0 PHP >=7.1 Installation using Composer
      composer require fokke/markup-metadata Manual installation
      Download latest version from https://github.com/Fokke-/MarkupMetadata/archive/master.zip Extract module files to site/modules/MarkupMetadata directory.
    • By m.sieber
      ITRK-Service for ProcessWire
      Module for the automated transfer of imprint, data protection declaration and terms and conditions from IT-Recht Kanzlei to your ProcessWire installation
      What is ITRK Service for ProcessWire?
      ITRK-Service for ProcessWire is a free module for ProcessWire CMS. It provides an interface to the update service of IT-Recht Kanzlei, via which the legal texts of your online presence are automatically updated. In this way, the texts remain legally secure and warning-proof in the long term. Imprint, data protection declaration, revocation and general terms and conditions are currently supported.
      You can find our documentation (in german language) here: https://www.pupit.de/itrk-service-for-processwire/dokumentation/

      Download: https://www.pupit.de/itrk-service-for-processwire/
      Github: https://github.com/pupit-de/pwItrkServiceConnector
    • By LuisM
      Symprowire is a PHP MVC Framework based and built on Symfony using ProcessWire 3.x as DBAL and Service-Provider
      It acts as a Drop-In Replacement Module to handle the Request/Response outside the ProcessWire Admin. Even tough Symfony or any other mature MVC Framework could be intimidating at first, Symprowire tries to abstract Configuration and Symfony Internals away as much as possible to give you a quick start and lift the heavy work for you.
      The main Goal is to give an easy path to follow an MVC Approach during development with ProcessWire and open up the available eco-system.
      You can find the GitHub Repo and more Information here: https://github.com/Luis85/symprowire
      Documentation
      The Symprowire Wiki https://github.com/Luis85/symprowire/wiki How to create a simple Blog with Symprowire https://github.com/Luis85/symprowire/wiki/Symprowire-Blog-Tutorial Last Update
      16.07.2021 // RC 1 v0.6.0 centralized ProcessWire access trough out the Application by wrapping to a Service https://github.com/Luis85/symprowire/releases/tag/v0.6.0-rc-1 Requirements
      PHP ^7.4 Fresh ProcessWire ^3.0.181 with a Blank Profile Composer 2 (v1 should work, not recommended) The usual Symfony Requirements Features
      Twig Dependency Injection Monolog for Symprowire Support for .env YAML Configuration Symfony Console and Console Commands Symfony Webprofiler Full ProcessWire access inside your Controller and Services Webpack Encore support Caveats
      Symfony is no small Framework and will come with a price in terms of Memory Usage and added Overhead. To give you a taste I installed Tracy Debugger alongside to compare ProcessWire profiling with the included Symfony Webprofiler

      So in a fresh install Symprowire would atleast add another 2MB of Memory usage and around 40ms in response time, should be less in production due to the added overhead of the Webprofiler in dev env
       
×
×
  • Create New...