drupal|May 22, 2020|2 min read

Drupal 7 - Code for Exporting all your content nodes in json files

TL;DR

Query all node IDs, load each node with node_load, and write the serialized data to JSON files for later import into Drupal 8.

Drupal 7 - Code for Exporting all your content nodes in json files

Introduction

When I migrated all of my drupal-7 website to drupal-8, I wrote automation to import all my old nodes into new drupal-8. Drupal did not provide any best way to migrate all of my nodes. So, I wrote this automation.

In this post, I will describe how I exported all my nodes into JSON files. In another post, I will explain how I imported them, with their URL alias intact.

Php code

{% highlight php linenos %}

name; } return $txNames; } function getUser($uid) { $u = user_load($uid); return $u->mail; } ///////////////////////////////////////////////////////////////////// ///////////////////////////////////////////////////////////////////// // Execution starts from here $nid = 1905; $howMany = 100; $till = $nid + $howMany; $dir = '/var/www/html/sites/default/files/exports/nodes'; for ($i=$nid; $i < $till; $i++) { $nd = node_load($i); if (!isset($nd) || !isset($nd->nid)) { continue; } $nd->user = getUser($nd->uid); //switch node type switch($nd->type) { case 'add_drawings': $nd->field_drawing_tags = getTermNames($nd->field_drawing_tags); $nd->field_drawing_category = getTermNames($nd->field_drawing_category); $nd->field_drawing_software = getTermNames($nd->field_drawing_software); break; case 'article': $nd->field_tags = getTermNames($nd->field_tags); $nd->field_article_category = getTermNames($nd->field_article_category); break; case 'page': case 'youtube_videos': //nothing special break; case 'my_book_reference': $nd->field_book_category = getTermNames($nd->field_book_category); break; case 'my_toolbox_reference': $nd->field_tool_category = getTermNames($nd->field_tool_category); break; default: print "\nHow on earth this can be possible! Type: ".$nd->type."\n"; } $alias = drupal_get_path_alias('node/'.$i); $folder = $dir . '/' . $nd->type; if (!file_exists($folder)) { mkdir($folder, 0777, true); } $filepath = $folder . '/' . $nd->nid . '.json'; $nd->alias = $alias; $data = json_encode((array)$nd); //write writeFile($filepath, $data); print "Written nid: ".$nd->nid.', alias: '.$alias."\n"; //print $data."\n\n"; } {% endhighlight %} ## Explanation of code See the comment which says: *Execution starts from here*. Line no. 33 Note: I ran this code through the devel/PHP module. So, this has a small timeout value when running a PHP script. So, I'm running this with 100s of nodes at a time. So, that loop where I'm starting nid=1905, you can start it from *1* *Line no 37*, the directory where I want to save the JSON files. *Line no 45*, Fetching author of the node and saving user details in an attribute in JSON. *Line no 48*. A switch case on my content types. *Line no 50*, saving term name. As in new DB. The term id will not be the same, but my taxonomy term name was unique in a vocabulary. *Line no 77*, saving the alias of node. The rest of the code is pretty easy to understand.

Related Posts

Drupal 7&#58; How to save a node programmatically and add an image field from a public URL

Drupal 7&#58; How to save a node programmatically and add an image field from a public URL

Note: I have public URLs of these images, which I want to save. return…

Drupal&#58; How to block a user by email programatically

Drupal&#58; How to block a user by email programatically

Many times, while administering your drupal website, you must have encountered…

Drupal Helpful codes for database queries

Drupal Helpful codes for database queries

Being a drupal user from last around 5 years, I used to know small codes for…

List all the Node ids which do not have images from my domain

List all the Node ids which do not have images from my domain

I use drupal-7 in my website. I used to write articles and put images in that…

Drupal 8 - How to Theme Form and its Fields with reordering fields

Drupal 8 - How to Theme Form and its Fields with reordering fields

Introduction In this post, we will see how to theme form and its fields…

Drupal 8 - How to create a Page with admin access and create its menu entry in Reports (No Coding)

Drupal 8 - How to create a Page with admin access and create its menu entry in Reports (No Coding)

Introduction I needed a report page, where I wanted to have some information…

Latest Posts

Claude Code Skills — Build a Better Engineering Workflow with AI-Powered Code Reviews, Security Scans, and More

Claude Code Skills — Build a Better Engineering Workflow with AI-Powered Code Reviews, Security Scans, and More

Most developers use Claude Code like a search engine — ask a question, get an…

Building an AI Voicebot for Visitor Check-In — A Practical Guide to Handling the Messy Parts

Building an AI Voicebot for Visitor Check-In — A Practical Guide to Handling the Messy Parts

Every office lobby has the same problem: a visitor walks in, nobody’s at the…

Server Security Best Practices — Complete Hardening Guide for Production Systems

Server Security Best Practices — Complete Hardening Guide for Production Systems

Every breach post-mortem tells the same story: an unpatched service, a…

Staff Engineer Study Plan for MAANG Interviews — The Complete 12-Week Roadmap

Staff Engineer Study Plan for MAANG Interviews — The Complete 12-Week Roadmap

If you’re a Senior Engineer (L5) preparing for Staff (L6+) roles at MAANG…

XSS and CSRF Explained — The Complete Guide with Real Attack Examples and Defenses

XSS and CSRF Explained — The Complete Guide with Real Attack Examples and Defenses

XSS and CSRF have been in the OWASP Top 10 for over a decade. They’re among the…

OWASP Top 10 (2021) — Every Vulnerability Explained with Code

OWASP Top 10 (2021) — Every Vulnerability Explained with Code

The OWASP Top 10 is the industry standard for web application security risks. If…