XML import suggestions

[Keral_Patel]

Hello,

I know somewhat this isn't doable but just want to do it somehow if there is some other way round.

Lets say I want to import multiple feeds into a table

My table is just simply Name, Email and Photo.

Now my first feed is in this format:

<item>
<name>John</name>
<email>[email protected]</email>
<photo>http://www.example.com/photo.jpg</photo>
</item>


My second feed is in this format:

<item>
<Fullname>John</Fullname>
<Email>[email protected]</Email>
<Pic>http://www.example.com/photo.jpg</Pic>
</item>

My third feed is in this format:

<item>
<ID>1</ID>
<Name>John</Name>
<Email>[email protected]</Email>
<Photo>http://www.example.com/photo.jpg</Photo>
</item>

So is there anyway that I can import this into my table. What steps should be done so that proper data is only fetched and inserted into the tables. If something else is there then it can be skipped. But how to fetch the nodes if there is no proper format known in advance.

Moreover the above examples are simple the Item Nodes can be an array of RSS or Channel etc.

Thanks.

 

[Keral_Patel]

Thanks solved it