I have a friend using a link manager (not LSQL).

So each time a link is validated in his system he send to me a XML file via FTP (in the following folder -http://www.mysite.com/xml/lsql/)

So I have now many XML files in this folder

01.xml
02.xml
03.xml
.
.
.
NN.xml
(NN is the Link_ID in his own database)


Each XML file has the following structure (sample for the LINK_ID 45)

<LINK>
<ID>45</ID>
<DATEADD>YYYY-MM-DD</DATEADD>
<URL>http://www.thewebsiteurl.com</URL>
<TITLE>The title of the website 45</TITLE>
<DESCRIPTION>The description of the Website 45 The description of the Website 45 The description of the Website 45</DESCRIPTION>
<LANGUAGE>EN</LANGUAGE>
<CATEGORIES>
<CAT id="12" Name="Full Name of the category 12" />
<CAT id="25" Name="Full Name of the category 25" />
</CATEGORIES>
<SUBMITER>
<EMAIL>xxxx@xxxx.com</EMAIL>
<NAME>Firstname Lastname</NAME>
</SUBMITER>
</LINK>

I would like to set up a cron job to import these XML files automatically in my Links Database.

Is there a way to do it easily ? (checking if the link is note already in the database, then importing it and updating all the concerning tables and so on...)

Txs
FMP