Solved

Joomla Import XML as articles into MySQL database

Posted on 2008-10-14
2
5,823 Views
Last Modified: 2012-06-27
Thanks for reading

I have has a good look around the joomla forums and help and thought I would give this place a shot.

I have a load of XML files that I want to import into Joomla..... I'm quite happy to translate the XML into a standard XML if that is what is needed....but I can't seem to find anything that is definitive on how you go about importing XML data into Joomla
0
Comment
Question by:patricka_0377
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 6

Expert Comment

by:gxp071
ID: 22729468
I've never come across a tool/plugin/component that does what you need. (that does not mean it doesn't exist)  That being said it wouldn't be too difficult to write one as joomla stores articles in a fairly basic sql table and the 1.5 framework its easy to extend through components and plugins.

All you really need to do is write some php that parses your xml and fires off the correct sql queries,  It would also mean you wouldn't have to adjust your current schema.

If you dont want to use php and learn how to make a joomla component you could just use some other language your comfortable with to parse the xml into and sql dump and patch your joomla db manually.

If you do decide to build a custom component heres some useful information:

to build a custom component you will need to use php and have a basic knowledge of sql,  the best place to start is the tutorials on the developer documentation wiki on the joomla.org

http://dev.joomla.org/component/option,com_jd-wiki/Itemid,32/

also there are two great books on joomla extension development published by packtpub

Learning Joomla! 1.5 Extension Development: Creating Modules, Components, and Plugins with PHP -
http://www.packtpub.com/Joomla-Extensions/book

Mastering Joomla! 1.5 Extension and Framework Development
http://www.packtpub.com/joomla-one-point-five-extension-framework/book

Learning Joomla is best for beginners but if you really want to understand how joomla works and build advanced components Mastering Covers everything.

hope that helps.
0
 
LVL 1

Accepted Solution

by:
patricka_0377 earned 0 total points
ID: 23510713
I worked out the database mappings and created a compatible xml schema that could be imported via a routine I wrote in to the database....it was a bit of a fuddle but got there
0

Featured Post

Three Considerations for Containers

Containers like Docker and Rocket are getting more popular every day. In my conversations with customers, they consistently ask what containers are and how they can use them in their environment. If you’re as curious as most people, read our article on Experts Exchange.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

DotNetNuke (DNN) (http://www.dotnetnuke.com) is a leading open source web content management system (CMS) and application development framework for Microsoft .NET. Localization is an essential part of building websites, especially in countries that …
In this article, we will look at our content management system as a whole, to get an idea of how we will start to manage these content items.
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
Suggested Courses

628 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question