Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Joomla Import XML as articles into MySQL database

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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

Drupal 5.x currently does not have a production-ready patch bundle to allow for split read & writes for a MySQL master/slave replication setup. After reading a open discussion/thread on the Drupal site (http://drupal.org/node/147160 (http://drupal.o…
3 proven steps to speed up Magento powered sites. The article focus is on optimizing time to first byte (TTFB), full page caching and configuring server for optimal performance.
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

715 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