Jump to content

Batch Child Editor


adrian

Recommended Posts

  • 4 weeks later...

Hi everybody,

I am running in a problem when I try to import a date into a dateTime field type (the fields remain blank after the import, if I import the same data in a standard text field the import result is ok).

Is the DateTime field type supported in the CSV import function of BCE ?
Thanks & stay safe

Link to comment
Share on other sites

Just now, antpre said:

@adrian the date in the csv is dd/mm/yyyy and the datetime field is input format is set to the same.

But thanks for the pointer. I will dig a bit on fromat tomorrow.

Regards

I tried both timestamp and YYYY-MM-DD and they worked fine, so I expect that will be the issue.

Link to comment
Share on other sites

On 12/13/2019 at 6:55 AM, pullasuti said:

Hello. Not the greatest first post, but here we go 🙂

I'm having a small issue exporting to CSV. Every export begins with an error relating to pagesToInclude:

<br />
<b>Notice</b>:  Undefined index: pagesToInclude in <b>...\site\assets\cache\FileCompiler\site\modules\BatchChildEditor\ProcessChildrenCsvExport.module.php</b> on line <b>112</b><br />

This happens regardless of whether I set a rule for the pages to be included or not. Otherwise the export works, but need manual removal of the first two lines.

Any good ideas?

I've just tried exporting some pages and I'm getting the same error as above in the exported csv file. Then when I try and reimport the csv it's only importing the first line of the csv file.

I've tried uninstalling/resinstalling the module but to no effect.

Link to comment
Share on other sites

@houseofdeadleg - can you send me the module settings data - this module (http://modules.processwire.com/modules/module-settings-import-export/) makes it really easy. Otherwise, if you have Tracy installed, open up the BCE module settings page and then open the Adminer panel and copy the json from the data field.

Can you also post (here or PM) the CSV that you are trying to import that only imports the first line.

Link to comment
Share on other sites

@adrian settings info is below. I've just noticed, after reading through a few other recent posts, that I don't seem to have the field pairing options – something that would be really useful.

{"BatchChildEditor":{"version":"1.8.20","settings":{"enabledTemplates":[],"enabledPages":[],"configurablePages":[],"editModes":["edit","add","update","replace","export"],"defaultMode":"edit","overwriteNames":"","allowOverrideOverwriteNames":"","disableContentProtection":"","allowTemplateChanges":"","allowAdminPages":"","trashOrDelete":"trash","listerDefaultSort":"sort","listerColumns":["title","path","modified","modified_users_id"],"defaultFilter":"","listerConfigurable":null,"csvOptions":["upload"],"csvOptionsCollapsed":[],"csvImportFieldSeparator":",","csvImportFieldEnclosure":"\"","ignoreFirstRow":"","importMultipleValuesSeparator":"|","newImageFirst":"","allowOverrideCsvImportSettings":"","csvExportFieldSeparator":",","csvExportFieldEnclosure":"\"","csvExportExtension":"csv","columnsFirstRow":1,"exportMultipleValuesSeparator":"|","formatExport":"","allowOverrideCsvExportSettings":"","position":"newTab","insertAfterField":false,"removeChildrenTab":1,"loadOpen":null,"openMethod":"normal","tabName":"Batch Child Editor","editModeTitle":"Edit Child Pages","editModeDescription":"You can edit the page titles, sort, delete, add new, or edit pages in a modal popup.","editModeNotes":"","listerModeTitle":"List Child Pages","listerModeDescription":"View child pages in a Lister interface.","listerModeNotes":"","addModeTitle":"Add Child Pages","addModeDescription":"Editing this field will add all the child page titles listed here to the existing set of child pages.","addModeNotes":"Each row is a separate page.\n\nYou can also use CSV formatted lines for populating all text/numeric fields on the page, eg:\n\"Bolivia, Plurinational State of\",BO,\"BOLIVIA, PLURINATIONAL STATE OF\",BOL,68","updateModeTitle":"Update Child Pages","updateModeDescription":"Editing this field will update the field values of the pages represented here.","updateModeNotes":"WARNING: If you use this option, the content of all fields in existing pages will be replaced.\n\nEach row is a separate page.\n\nYou can also use CSV formatted lines for populating all text/numeric fields on the page, eg:\n\"Bolivia, Plurinational State of\",BO,\"BOLIVIA, PLURINATIONAL STATE OF\",BOL,68","replaceModeTitle":"Replace Child Pages","replaceModeDescription":"Editing this field will replace all the child page titles represented here.","replaceModeNotes":"WARNING: If you use this option, all the existing child \\ProcessWire\\pages(and grandchildren) will be deleted and new ones created.\n\nEach row is a separate page.\n\nYou can also use CSV formatted lines for populating all text/numeric fields on the page, eg:\n\"Bolivia, Plurinational State of\",BO,\"BOLIVIA, PLURINATIONAL STATE OF\",BOL,68","exportModeTitle":"Export Child Pages","exportModeDescription":"Creates a CSV file with one row for each child page.","exportModeNotes":"","uninstall":"","submit_save_module":"Submit"}}}

I can't share the csv file I'm afraid.

Link to comment
Share on other sites

Thanks @houseofdeadleg for those settings.

1) Testing here I am not seeing any problems, but I have committed a new version that should fix that notice that is showing up in your CSV export.

2) The field pairing options are available if you define Configurable Pages under the "Where editing tools are available and separately configurable" section. You then define the field pairing on the settings tab of the page whose children you are exporting.

3) You don't need to share sensitive data - please just create a minimum test case CSV file that shows the problem with only the first line importing. Also, are you on Windows, Linux, or MacOS? I am thinking it might be a lined ending issue. Also, what PHP version are you running?

 

Link to comment
Share on other sites

  • 1 month later...

Dear Adrian,

Does the export function of BCE supports multi language text fields ? I saw you mentioning in this threat that it would be a good addition. But not sure whether you implemented it or not.

Thanks again for the great module.

Link to comment
Share on other sites

  • 1 month later...
27 minutes ago, Rudy said:

@adrian is there a way to let the CSV export to show absolute path to any files/images? I noticed that the exported data only shows the filename itself without any context.

Thx
Rudy

Hi Rudy - it's fixed in the latest version.

  • Thanks 1
Link to comment
Share on other sites

  • 3 months later...

Hi @mel47 - I don't really see how BCE relates to that "allow new pages to be created from field" setting - BCE doesn't create pages from a field - it creates them from its own interface. Can you please explain how you are using BCE - maybe I am missing something?

Link to comment
Share on other sites

@adrian Forget that, I messed up. I was thinking pages shouldn't be created by API if this option was checked. I created a hook to solve my problem. But maybe you can help me. Which hook I should used? I tried different versions but the most working one is addHookAfter('saveReady'), but I need to re-save each page. I would like the hook worked either if I created a page via BCE or create/save from admin.

My hook is to check if the page exist in the pageRef field, if so copy in an other pageRef field, if not do nothing.

Thanks

 

Link to comment
Share on other sites

Hi @mel47 - I am not really sure what requires you to re-save each page. Is this to fix an existing problem or is this an issue going forward as well?

That saveReady hook should be fine, but you might also try Pages::added

I'd need to know some more details to really help more than that.

Link to comment
Share on other sites

  • 1 month later...

hello,

i am trying to upload a csv with images.

all the fields beeing uploaded as expected but the images. they are not showing up.

the csv and images ar locally and the paths to the images pointing straight to the folder.

file:///Users/xxuser/Desktop/201124_Website/binary/MEE_M_3802_00.002.jpg

is there a problem uploading images from local? or are there any permission issues i am missing?

 

thanks a million,
stefan

Link to comment
Share on other sites

48 minutes ago, adrian said:

Hi @sww,

I just checked with an image at a local path and it worked fine, but I think the issue might be the "file://" at the beginning. Does it work if you remove that?

Doesn't work either.  /Users/…  was the first way I tried.
If I do it on my localhost it works just fine.

Link to comment
Share on other sites

Ok, I think I understand your scenario now - you are trying to batch add pages on a remote server but the images are in a local path on your computer? If that's correct, then this won't work - you'll need to move the images to the server and adjust the paths but that should be a pretty simple search / replace in your text editor. 

For example, search for /Users/xxuser/Desktop/201124_Website/binary/ and replace with something like /var/www/site/assets/tempimages/ (or wherever you decide to FTP them to).

Link to comment
Share on other sites

7 minutes ago, adrian said:

Ok, I think I understand your scenario now - you are trying to batch add pages on a remote server but the images are in a local path on your computer? If that's correct, then this won't work - you'll need to move the images to the server and adjust the paths but that should be a pretty simple search / replace in your text editor. 

For example, search for /Users/xxuser/Desktop/201124_Website/binary/ and replace with something like /var/www/site/assets/tempimages/ (or wherever you decide to FTP them to).

Yes, that was my scenario. Okay, good to know then. One last thing. Is there way the images will just be moved from the temp folder to the final destination if they are on the same host/space … instead of duplicated?

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 MarkE
      This fieldtype and inputfield bundle was built for storing measurement values within a field, rendering them in a variety of formats and converting them to other units or otherwise modifying them via the API.
      The API consists of a number of predefined functions, some of which include...
      render() for rendering the measurement object, valueAs() for converting the value to another unit value, convertTo() for converting the whole measurement object to different units, and add() and subtract() for for modifying the stored value by the value (converted as required) in another measurement. In the admin the inputfield includes a checkbox (which can be optionally disabled) for converting values on page save. For an example if a value was typed in as centimeters, the unit was changed to metres, and the page saved with this checkbox selected, said value would be automatically converted so that e.g. 170 cm becomes 1.7 m.

      A simple length field using Fieldtype Measurement and Inputfield Measurement.
      Combination units (e.g. feet and inches) are also supported.
      Please note that this module is 'proof of concept' at the moment - there are limited units available and quite a lot of code tidying to do. More units will be added shortly.
      See the GitHub at https://github.com/MetaTunes/FieldtypeMeasurement for full details and updates.
    • By tcnet
      File Manager for ProcessWire is a module to manager files and folders from the CMS backend. It supports creating, deleting, renaming, packing, unpacking, uploading, downloading and editing of files and folders. The integrated code editor ACE supports highlighting of all common programming languages.
      https://github.com/techcnet/ProcessFileManager

      Warning
      This module is probably the most powerful module. You might destroy your processwire installation if you don't exactly know what you doing. Be careful and use it at your own risk!
      ACE code editor
      This module uses ACE code editor available from: https://github.com/ajaxorg/ace

      Dragscroll
      This module uses the JavaScript dragscroll available from: http://github.com/asvd/dragscroll. Dragscroll adds the ability to drag the table horizontally with the mouse pointer.
      PHP File Manager
      This module uses a modified version of PHP File Manager available from: https://github.com/alexantr/filemanager
       
    • By tcnet
      This module implements the website live chat service from tawk.to. Actually the module doesn't have to do much. It just need to inserted a few lines of JavaScript just before the closing body tag </body> on each side. However, the module offers additional options to display the widget only on certain pages.
      Create an account
      Visit https://www.tawk.to and create an account. It's free! At some point you will reach a page where you can copy the required JavaScript-code.

      Open the module settings and paste the JavaScript-code into the field as shown below. Click "Submit" and that's all.

      Open the module settings
      The settings for this module are located int the menu Modules=>Configure=>LiveChatTawkTo.

       
    • By tcnet
      Session Viewer is a module for ProcessWire to list session files and display session data. This module is helpful to display the session data of a specific session or to kick out a logged in user by simply delete his session file. After installation the module is available in the Setup menu.

      The following conditions must be met for the module to work properly:
      Session files
      Session data must be stored in session files, which is the default way in ProcessWire. Sessions stored in the database are not supported by this module. The path to the directory where the session files are stored must be declared in the ProcessWire configuration which is by default: site/assets/sessions.
      Serialize handler
      In order to transform session data easier back to a PHP array, the session data is stored serialized. PHP offers a way to declare a custom serialize handler. This module supports only the default serialize handlers: php, php_binary and php_serialize. WDDX was dropped in PHP 7.4.0 and is therefore not supported by this module as well as any other custom serialize handler. Which serialize handler is actually used you can find out in the module configuration which is available under Modules=>Configure=>SessionViewer.

      Session data
      The session data can be displayed in two different ways. PHP's default output for arrays print_r() or by default for this module nice_r() offered on github: https://github.com/uuf6429/nice_r. There is a setting in the module configuration if someone prefers print_r(). Apart from the better handling and overview of the folded session data the output of nice_r() looks indeed nicer.

      Links
      ProcessWire module directory
      github.com
    • By Robin S
      Repeater Easy Sort
      Adds a compact "easy-sort" mode to Repeater and Repeater Matrix, making those fields easier to sort when there are a large number of items.
      The module also enhances Repeater Matrix by allowing a colour to be set for each matrix type. This colour is used in the item headers and in the "add new" links, to help visually distinguish different matrix types in the inputfield.
      Screencasts
      A Repeater field

      A Repeater Matrix field with custom header colours

      Easy-sort mode
      Each Repeater/Matrix item gets an double-arrow icon in the item header. Click this icon to enter easy-sort mode.
      While in easy-sort mode:
      The items will reduce in width so that more items can be shown on the screen at once. The minimum width is configurable in the field settings. Any items that were in an open state are collapsed, but when you exit easy-sort mode the previously open items will be reopened. You can drag an item left/right/up/down to sort it within the items. The item that you clicked the icon for is shown with a black background. This makes it easier to find the item you want to move in easy-sort mode. You can click an item header to open the item. An "Exit easy-sort mode" button appears at the bottom of the inputfield. Configuration
      In the field settings for Repeater and Repeater Matrix fields you can define a minimum width in pixels for items in easy-sort mode. While in easy-sort mode the items will be sized to neatly fill the available width on any screen size but will never be narrower than the width you set here.
      In the field settings for Repeater Matrix you can define a custom header colour for each matrix type using an HTML "color" type input. The default colour for this type of input is black, so when black is selected in the input it means that no custom colour will be applied to the header.
      Exclusions
      The easy-sort mode is only possible on Repeater/Matrix fields that do not use the "item depth" option.
       
      https://github.com/Toutouwai/RepeaterEasySort
      https://processwire.com/modules/repeater-easy-sort/
×
×
  • Create New...