How to populate new templates with data from CSV spreadsheet/JSON??

[700ml]

Dear all, 

I haven't been able to find an answer to this specific question – my apologies if it has been already answered.

I'm working on a website, with many subpages using the same template (let's say "blog-template"), with fields (title, subtitle, location, price, link, textarea, photos). The data for each subpage is being collected via an online form (JotForm), and each respondent's row corresponds one subpage. 

It's around 50 rows –  creating a new instance of a template, and manual data-entry, will take a very long time – so I wonder if there is a way to automate this process, and convert the (properly formatted if needed) spreadsheet, into a series of ProcessWire pages, all children of the same parent page?

thank you for the support!

[bernhard]

Hi and welcome to the forum

never used it, but there is a module that should do what you are looking for: https://processwire.com/modules/import-pages-csv/

or several posts: https://www.google.com/search?q=site:processwire.com+import+pages+csv

[BillH]

I'm sure it'll be mentioned in the posts you'd find following @bernhard's link, but I'd draw your attention to another module also worth looking at: https://processwire.com/modules/batch-child-editor/ - particularly the Add mode, which can import CSV.

[MarkE]

2 hours ago, bernhard said:

never used it, but there is a module that should do what you are looking for: https://processwire.com/modules/import-pages-csv/

I have used it - it works fine.

[700ml]

Thank you so much for all the replies everyone! Another issue that I've encountered is the fact, that I would need to add things in a nested way. E.g. 

• Page 1 (template: page-store)
  • Page A (template: detail-product)
  • Page B (template: detail-product)
• Page 2 (template: page-store)
  • Page C (template: detail-product)
  • Page D (template: detail-product)

and so forth... for a total of 50 Parent pages, with 1-3 children!

Does anyone know how this parent-child solution could be implemented, and how to create such a nested structure. It's really important for my project that the user can access the subpages via '/page-1/page-a' for example.

Thank you for all the help so far!