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
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