Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Joomla Import XML as articles into MySQL database

Posted on 2008-10-14
2
Medium Priority
?
5,906 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
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

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

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

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.
Knowledge base software has turned out to be a quite reliable method for storing information, promoting collaborative work and for sharing valuable input and solutions.However, some organizations are trying to develop a knowledge base that works wit…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses
Course of the Month10 days, 8 hours left to enroll

572 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