Posted by jaydul on February 24, 2015 at 4:35pm
How to bulk Import XML files -Content from xml systems category base to drupal
Hello I have custom CMS we are moving to Drupal.Our custom CMS has bulk post system via XML feed.
We post 1000 articles/News via xml per hour on our CMS.
We need to know how to import bulk xml as Categories (Taxonomy) base.
Here is our xml file below
<?xml version="1.0" encoding="utf-8" standalone="yes"?><rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
<channel>
<Category>Sports</Category>
<title>Title</title>
<description>Image Location</description>
<item>
<title>Bulgaria votes in parliamentary poll</title>
<description>Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Nam liber tempor cum soluta nobis eleifend option congue nihil imperdiet doming id quod mazim placerat facer possim assum. Lorem ipsum dolor sit amet, consectetur adipisici elit, sed eiusmod tempor incidunt ut labore et dolore magna aliqua. Lorem ipsum dolor sit amet. Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi.Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. At vero eos et accusam et justo duo dolores et ea rebum. Sanctus sea sed takimata ut vero voluptua. Consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat.</description>
<alt>tag1,tag2,tag3</alt>
<pubDate>2/15/2015 8:26:01 AM</pubDate>
</item>
<item>
<Category>Sports</Category>
<title>Youssou Ndour awarded Polar Prize</title>
<description>At vero eos et accusam et justo duo dolores et ea rebum. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. Excepteur sint obcaecat cupiditat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Sanctus sea sed takimata ut vero voluptua.Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Nam liber tempor cum soluta nobis eleifend option congue nihil imperdiet doming id quod mazim placerat facer possim assum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi.</description>
<alt>tag1,tag2,tag3</alt>
<pubDate>2/15/2015 8:26:01 AM</pubDate>
</item>
</channel></rss>
Comments
Check out the Migrate module
Check out the Migrate module and its documentation. It's the best approach nowadays for importing just about anything into Drupal.
The Boise Drupal Guy!
One thing to keep in mind
One thing to keep in mind with feeds module or migrate module:
If they are using node_save(), the hooks inside that function can slow down the importing by a bunch! I've had hook_node_insert() from pathauto and expire modules eating up ~2.5 seconds per save because of their heavy lifting. If at all possible you can disable those hooks during the migrations/import then you can have much much faster imports(less possible timeouts as well)