• Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Transform XML into .. Drupal

#1 2009-02-26 10:51:48

hammerwd
Member
Registered: 2008-04-27
Posts: 59

Transform XML into .. Drupal

Tags: [drupal, xml]

Hi,

I've got an xml file with all of my content. It comes from a mediawiki:

Code:

<mediawiki xmlns="http://www.mediawiki.org/xml/export-0.3/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.mediawiki.org/xml/export-0.3/ http://www.mediawiki.org/xml/export-0.3.xsd" version="0.3" xml:lang="de">
  <siteinfo>
    <sitename>InfoPoint</sitename>
    <base>http://localhost/mediawiki/index.php/Hauptseite</base>
    <generator>MediaWiki 1.12.0</generator>
    <case>first-letter</case>
      <namespaces>
      <namespace key="-2">Media</namespace>
    </namespaces>
  </siteinfo>
  <page>
    <title>Hauptseite</title>
    <id>1</id>
    <revision>
      <id>873</id>
      <timestamp>2008-12-01T14:30:13Z</timestamp>
      <contributor>
        <username>User1</username>
        <id>1</id>
      </contributor>
      <text xml:space="preserve">Hilfe zur Benutzung und Konfiguration der Wiki Software finden Sie im [http://meta.wikimedia.org/wiki/Help:Contents Benutzerhandbuch].

== Willkommen ==
----
{|border=&quot;0&quot;
|- class=&quot;wikitable sortable&quot;
! width=&quot;30%&quot; | Systeme
! width=&quot;30%&quot; | Andere Systeme
! width=&quot;40%&quot; | == Schneller Einstieg ins Wiki ==

Now I want to transfer it into Drupal .. it needs SQL or XML or CSV.

Here my questions:
- Is it possible to walk through this file, recognize the   <page> and extract text, timestamp and so on and insert it into an SQL statement?
- Could you think of an easier way to do the conversion?

Thank you in advance.
Bye, Chris

Offline

#2 2009-12-20 04:11:28

bronius
Member
Company: BCSWebstudio
Registered: 2009-04-20
Posts: 29
Website

Re: Transform XML into .. Drupal

Chris-
Did you get anywhere with this MediWiki -> TOS -> Drupal migration?  I am interested in creating CCK nodes on the fly against an existing web service, and (having exhausted my experimentation with Feeds and Services Client (drupal contrib modules) TOS came to mind.  I am not sure where to begin as far as creating cck nodes by direct db manipulation.
-Bronius

Offline

#3 2010-03-18 02:40:08

hammerwd
Member
Registered: 2008-04-27
Posts: 59

Re: Transform XML into .. Drupal

Hello Bronius,

sorry for the late reply.
Unfortunately I didn't get anywhere.

But an easier solution might be: iMacros
With a little JavaScript, it enabled me to do a lot out of the free version just with FF.

Offline

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Transform XML into .. Drupal

Board footer

Powered by FluxBB