Jump to content

Module: Import Pages from CSV file


ryan

Recommended Posts

In our use case we needed to import thousands of CSV entries automatically per cronjob.

So we ended up with a little shell script using the CSV package by the League of Extraordinary Packages and custom logic to import the CSV entries as pages.

This wasn't that difficult thanks to the Composer integration of ProcessWire. ;)

Regards, Andreas

  • Like 3
Link to comment
Share on other sites

  • 1 year later...

Hi Guys,

In short: I would like to base the template and parent of the imported pages to be based on values in the csv

Great work on the module Ryan, it's a very useful extension to Processwire indeed! 🙂 
I was wondering if it would be possible to set multiple templates for the pages that are created, maybe based on a .csv field value?

I'm using Padloper for variation products which ends up looking like this:

- Parent Product Page       ( needs productprarent template )
     - Variation child page   ( needs variation template )
     - Variation child page
     - Variation child page

so In my cvs file I guess I would use something like this?

Type          template               title              color               price            image
Parent       productparent      T-Shirt                                5   
Child         variation                T-Shirt         Blue                                     templates/img/blue.jpg
Child         variation                T-Shirt         Red                                      templates/img/red.jpg
Child         variation                T-Shirt         Green                                  templates/img/green.jpg   

This way I could create a parent of all sets of children, if values aren't filled there the system uses the price of the parent.
I was thinking of something in de lines of:

 

if($CsvLine->type == "Child") {
    $page->parent = $parent($CsvLine->title);
}


if takes makes any sense :')

Do you think something like this could be done?

Thanks in advance! 🙂
Bram

 

  • Like 1
Link to comment
Share on other sites

  • 1 month later...
  • 1 month later...
On 4/15/2019 at 1:25 PM, bramwolf said:

Hi Guys,


In short: I would like to base the template and parent of the imported pages to be based on values in the csv

Great work on the module Ryan, it's a very useful extension to Processwire indeed! 🙂 
I was wondering if it would be possible to set multiple templates for the pages that are created, maybe based on a .csv field value?

I'm using Padloper for variation products which ends up looking like this:

- Parent Product Page       ( needs productprarent template )
     - Variation child page   ( needs variation template )
     - Variation child page
     - Variation child page

so In my cvs file I guess I would use something like this?

Type          template               title              color               price            image
Parent       productparent      T-Shirt                                5   
Child         variation                T-Shirt         Blue                                     templates/img/blue.jpg
Child         variation                T-Shirt         Red                                      templates/img/red.jpg
Child         variation                T-Shirt         Green                                  templates/img/green.jpg   

This way I could create a parent of all sets of children, if values aren't filled there the system uses the price of the parent.
I was thinking of something in de lines of:

 


if($CsvLine->type == "Child") {
    $page->parent = $parent($CsvLine->title);
}


if takes makes any sense :')

Do you think something like this could be done?

Thanks in advance! 🙂
Bram

 

Hi Bram, 

Did you find a solution for it? I'm looking also for an option to import products in the same way.

Link to comment
Share on other sites

  • 3 months later...

Is it possible to import users with this module?

When I try I get the error

Unable to import page because it has no required 'title' field or it is blank.

If I add a title column to the CSV it doesn't show on the next page. I simply get a 'title' select field to map it like the other field but no title field shows in the in the dropdown.

Link to comment
Share on other sites

@Guy Incognito

did you do everything renobird wrote in his post on page #4 of this thread?
In particular "... In order for title to show as a connection option during your import, you need to add the title field to the user template file. ..."
http://processwire.com/talk/topic/383-module-import-pages-from-csv-file/?p=10160

For me the import works, I just edited ~200 users.

  • Like 2
  • Thanks 1
Link to comment
Share on other sites

9 hours ago, Ralf said:

@Guy Incognito

did you do everything renobird wrote in his post on page #4 of this thread?
In particular "... In order for title to show as a connection option during your import, you need to add the title field to the user template file. ..."
http://processwire.com/talk/topic/383-module-import-pages-from-csv-file/?p=10160

For me the import works, I just edited ~200 users.

Hi @Ralf - thanks for this - completely missed Reno's note but this sounds like my exact issue and will try it out today.

Link to comment
Share on other sites

Hi all, new processwire user here. I am trying to to import a number of post with Chinese/UTF-8 titles, but the module can only import those with latin characters. Can anyone advise me how to solve it? The best is for sure to display the  UTF-8 permalink same with the title, but it's also okay just to have permalinks with numbers or random characters. Any advice for the tweak or pointing me the right direction of changing the code is appreciated. 

Link to comment
Share on other sites

Hi all , just an update regarding my question. I found out it's due to the importPageValue function. The processwire path sanitizer cannot create the appropriate path name and it leds to a failure of creating pages without an ascii character on the title.  

            $page->set($name, $value); 
            if($name == 'title') $page->name = $this->sanitizer->pageName($value, 2); // Sanitizer::translate
 

I tried appending a rand at the end of $page->name and the csv can be imported. However no matter whether I tried

$this->sanitizer->pageName(utf8decode($value), 2)

Or

$this->sanitizer->pageName($value, Sanitizer::toUTF8)

They do not work. Can anyone advise me if anything is done wrongly? 

Thanks all. 

Link to comment
Share on other sites

Welcome to the PW forums @eddietoast!

Check that you have extended page name support enabled: https://processwire.com/blog/posts/page-name-charset-utf8/

That may be all you need to get Chinese page names working, but I've noticed that people have had a few questions/problems with Chinese characters, particularly regarding the $config->pageNameWhitelist setting. 

In this issue Ryan seems to recommend setting $config->pageNameWhitelist to empty, but then in this issue an empty value for that setting seemed to cause a different problem. And the topic linked to below has some related discussion:

If you find you can't get Chinese page names working then please open an issue at Github because it sounds like this is something that might need some attention from Ryan. Or if you do get it working please make a post in the tutorials section explaining what settings you used.

An alternative might be to use my recently released Sanitizer EasySlugger to create latin page names from Chinese characters. To do that I expect you would need to edit the ImportPagesCSV module to call $sanitizer->utf8Slugger() when the pages are created. Or you might like to use the code I posted here (it's an addon action for the Admin Actions module) as a starting point for your own custom CSV import action.

P.S. Please use the code button in the forum post editor toolbar when you are including code in a post.

  • Like 1
Link to comment
Share on other sites

HI @Robin S

I tried testing Chinese characters with the white list yesterday and realised it should be the problem. I added a Chinese character in the whitelist and that character can be used for names,

$config->pageNameWhitelist = '_.abcdefghijklmnopqrstuvwxyz0123456789æåäßöüđжхцчшщюяàáâèéëêěìíïîõòóôøùúûůñçčćďĺľńňŕřšťýžабвгдеёзийклмнопрстуфыэęąśł我';

Building a white list for Chinese characters can be a problem (in terms of quantity) so I ended up using RAND() as a temporary solution. 

And thanks for recommending the slugger and I think it's very useful. I just wonder whether it supports Cantonese conversion as well? Anyway I will test further and see how it works. 

Many thanks for your reply and noted on the code formatting in the post ; ).  

 

  • Like 1
Link to comment
Share on other sites

  • 2 months later...

Short note for all those who use this module.

In a fresh install of ProcessWire 3.0.148 this module (yes, it's only officially support until 2.7 - but still) stopped working properly.

Settings like skipping existing pages/entries will be ignored and the import into date fields is not possible at all.

Last working environment I can confirm is ProcessWire 3.0.133.

  • Like 3
Link to comment
Share on other sites

  • 1 month later...
  • 1 month later...
  • 4 weeks later...

The timing on this update saved me tons of work, thanks @ryan!

I'm using the guide to importing users from page 3 of this topic, but I am having no luck pulling the roles in. How should I format these in my csv? I tried spelling out the name of the roles as well as using the ids, with and without spaces inside the quotes. 

EDITED for solution:

within the "", each role name is spelled out on its own line, so:

"guest
login-register
team-member
download"

 

 

Edited by creativejay
solved it
Link to comment
Share on other sites

  • 1 month later...

Hello Ryan,

thank you for the updated version of the module.
Unfortunately, I have found a mistake in the module:

In the monolingual version of Processwire (3.0.148) everything works fine yet when you update the imported pages (modify the existing page) a warning appears:
Warning: count(): Parameter must be an array or an object that implements Countable in ...\site\modules\ImportPagesCSV\ImportPagesCSV.module on line 515

In the multilingual version of Processwire (3.0.148) the title field is not filled in. And the same warning appears when you update the imported pages.

Furthermore, I have prepared a multilingual import CSV with "|" and imported the data. Unfortunately, that did not work as expected.

My CSV file:
"Article Name","Price","externalID"
"Apfel A"|"Apple A",1.25,abc123
"Apfel B"|"Apple B",1.15,abc124
"Birne B"|"Pear B",1.35,abc125

Resultat:
$Page->name:
apfel-a-apple-a
apfel-b-apple-b
birne-b-pear-b

$Page->title: NULL

Could you please provide an examplary CSV structure for the multilingual version?

Kind regards
Wlad

Link to comment
Share on other sites

  • 2 weeks later...

Hi, 

I use this module to import a collection of clothes. I use the FieldTypePage in my product template for the sizes. If the size page title/name is a number the import script can't find the page and I get te following error.

FieldtypePage: Unable to locate page match for: 128

  • ProcessWire 3.0.158 dev
  • ImportPagesCSV 1.0.8
Link to comment
Share on other sites

  • 2 months later...

Hi everyone!

Was wondering if anyone been getting this error when you import? 
 

Quote

Warning: count(): Parameter must be an array or an object that implements Countable in D:\XAMPP\htdocs\d2g2\site\modules\ImportPagesCSV\ImportPagesCSV.module on line 515

Been scratching my head on this. Checked 515 and this is what I got. 

		if($page->id && count($page->get('ImportPagesCSVData'))) {

Any idea what's tripping it? 
 

Link to comment
Share on other sites

21 minutes ago, Pip said:

Hi everyone!

Was wondering if anyone been getting this error when you import? 
 

Been scratching my head on this. Checked 515 and this is what I got. 


		if($page->id && count($page->get('ImportPagesCSVData'))) {

Any idea what's tripping it? 
 

PS: Import goes in still btw. Whether if it's correct or not, I have to double check as I've added in hundreds. 😕 

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 Marco Ro
      Hi guys!
      I'm a bit anxious because this is the first module I present! (beta modulo) But I will finally be able to share something with the community too! :)
      This is a BETA version of the PayPal payment system called: PayPal Commerce Platform.
      It is an advanced system (Business Pro account is needed) that brings various benefits in terms of fees and above all integrates direct payment with credit/debit cards. 
      The module integrates with Padloper 0.0.2, which is the current installation I'm using.
      This system integrates the classic PayPal buy button, the alternative or local payment method and the new payment system: credit/debit cards that doesn't go through the PayPal account. It is a Stripe-style payment, it connects directly with the bank and integrates 3D security validation.
      I say that it is a BETA because this module currently only works with Sandbox account, to put it live you need to change API url manually (manually for the moment).
      Because this module is not ready for live:
      I would like to have your opinion on how I built the module (is the first one I do). I don't want to share something that is not fish but I need a comparison with someone more experienced than me, for be sure that this is the best way to code the module.
      If you want to try this I created a git, you will find all the instructions for installation and correct operation. (Git has a MIT licensed)
      https://github.com/MarcooRo/processwire-PayPal-Commerce-Platform I hope I did something that you guys can like :)
    • By monollonom
      (once again I was surprised to see a work of mine pop up in the newsletter, this time without even listing the module on PW modules website 😅. Thx @teppo !)
      FieldtypeQRCode
      Github: https://github.com/romaincazier/FieldtypeQRCode
      Modules directory: https://processwire.com/modules/fieldtype-qrcode/
      A simple fieldtype generating a QR Code from the public URL of the page, and more.
      Using the PHP library QR Code Generator by Kazuhiko Arase.

      Options
      In the field’s Details tab you can change between .gif or .svg formats. If you select .svg you will have the option to directly output the markup instead of a base64 image. SVG is the default.
      You can also change what is used to generate the QR code and even have several sources. The accepted sources (separated by a comma) are: httpUrl, editUrl, or the name of any text/URL/file/image field.
      If LanguageSupport is installed the compatible sources (httpUrl, text field, ...) will return as many QR codes as there are languages. Note however that when outputting on the front-end, only the languages visible to the user will be generated.
      Formatting
      Unformatted value
      When using $page->getUnformatted("qrcode_field") it returns an array with the following structure:
      [ [ "label" => string, // label used in the admin "qr" => string, // the qrcode image "source" => string, // the source, as defined in the configuration "text" => string // and the text used to generate the qrcode ], ... ] Formatted value
      The formatted value is an <img>/<svg> (or several right next to each other). There is no other markup.
      Should you need the same markup as in the admin you could use:
      $field = $fields->get("qrcode_field"); $field->type->markupValue($page, $field, $page->getUnformatted("qrcode_field")); But it’s a bit cumbersome, plus you need to import the FieldtypeQRCode's css/js. Best is to make your own markup using the unformatted value.
      Static QR code generator
      You can call FieldtypeQRCode::generateQRCode to generate any QR code you want. Its arguments are:
      string $text bool $svg Generate the QR code as svg instead of gif ? (default=true) bool $markup If svg, output its markup instead of a base64 ? (default=false) Hooks
      Please have a look at the source code for more details about the hookable functions.
      Examples
      $wire->addHookAfter("FieldtypeQRCode::getQRText", function($event) { $page = $event->arguments("page"); $event->return = $page->title; // or could be: $event->return = "Your custom text"; }) $wire->addHookAfter("FieldtypeQRCode::generateQRCodes", function($event) { $qrcodes = $event->return; // keep everything except the QR codes generated from editUrl foreach($qrcodes as $key => &$qrcode) { if($qrcode["source"] === "editUrl") { unset($qrcodes[$key]); } } unset($qrcode); $event->return = $qrcodes; })
    • By Sebi
      AppApiFile adds the /file endpoint to the AppApi routes definition. Makes it possible to query files via the api. 
      This module relies on the base module AppApi, which must be installed before AppApiFile can do its work.
      Features
      You can access all files that are uploaded at any ProcessWire page. Call api/file/route/in/pagetree?file=test.jpg to access a page via its route in the page tree. Alternatively you can call api/file/4242?file=test.jpg (e.g.,) to access a page by its id. The module will make sure that the page is accessible by the active user.
      The GET-param "file" defines the basename of the file which you want to get.
      The following GET-params (optional) can be used to manipulate an image:
      width height maxwidth maxheight cropX cropY Use GET-Param format=base64 to receive the file in base64 format.
    • 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
       
×
×
  • Create New...