Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Discussions :

importing from RDF or TXT or XML file

Apr 21, 2003, 11:05 PM
remal
New User (3 posts)
Apr 21, 2003, 11:05 PM
Post #1 of 3
Views: 1356
Shortcut
Quote Reply
importing from RDF or TXT or XML file
hi

can i load links from an XML or RDF or TXT file to the database?

ex XML file:

<Title>CNN Site</Title><URL>http://cnn.com</URL><LinkOwner>john</LinkOwner><Add_Date>2003-04-09</Add_Date><Mod_Date>2003-04-09</Mod_Date><Description>CNN web News Site</Description><Contact_Name>John Mike</Contact_Name><Contact_Email>me@yahoo.com</Contact_Email><Hits>0</Hits><isNew>Yes</isNew><isChanged>No</isChanged><isPopular>No</isPopular><isValidated>Yes</isValidated><Rating>0.00</Rating><Votes>0</Votes><Status>200</Status><Date_Checked>2003-04-21 00:00:00</Date_Checked><Timestmp>20030421153135</Timestmp><Recommended>0</Recommended><CategoryID>105</CategoryID>

<Title>Yahoo Clubs</Title><URL>http://clubs.yahoo.com</URL><LinkOwner>john</LinkOwner><Add_Date>2003-04-09</Add_Date><Mod_Date>2003-04-09</Mod_Date><Description>yahoo clubs</Description><Contact_Name>John Mike</Contact_Name><Contact_Email>me@yahoo.com</Contact_Email><Hits>0</Hits><isNew>Yes</isNew><isChanged>No</isChanged><isPopular>No</isPopular><isValidated>Yes</isValidated><Rating>0.00</Rating><Votes>0</Votes><Status>200</Status><Date_Checked>2003-04-21 00:00:00</Date_Checked><Timestmp>20030421153135</Timestmp><Recommended>0</Recommended><CategoryID>310</CategoryID>

<Title>HotScripts</Title><URL>http://hotscripts.com</URL><LinkOwner>john</LinkOwner><Add_Date>2003-04-09</Add_Date><Mod_Date>2003-04-09</Mod_Date><Description>hotscripts web Site</Description><Contact_Name>John Mike</Contact_Name><Contact_Email>me@yahoo.com</Contact_Email><Hits>0</Hits><isNew>Yes</isNew><isChanged>No</isChanged><isPopular>No</isPopular><isValidated>Yes</isValidated><Rating>0.00</Rating><Votes>0</Votes><Status>200</Status><Date_Checked>2003-04-21 00:00:00</Date_Checked><Timestmp>20030421153135</Timestmp><Recommended>0</Recommended><CategoryID>84</CategoryID>



ex TXT file:

Title|URL|LinkOwner|Add_Date|Mod_Date|Description|Contact_Name|Contact_Email|Hits|isNew|isChanged|isPopular|isValidated|Rating|Votes|Status|Date_Checked|Timestmp|Recommended|CategoryID

CNN Site|http://cnn.com|john|2003-04-09|2003-04-09|CNN web News Site|John Mike|me@yahoo.com|0|Yes|No|No|Yes|0.00|0|200|2003-04-21 00:00:00|20030421153135|0|105


Yahoo Clubs|http://clubs.yahoo.com|john|2003-04-09|2003-04-09|yahoo clubs|John Mike|me@yahoo.com|0|Yes|No|No|Yes|0.00|0|200|2003-04-21 00:00:00|20030421153135|0|310


HotScripts|http://hotscripts.com|john|2003-04-09|2003-04-09|hotscripts web Site|John Mike|me@yahoo.com|0|Yes|No|No|Yes|0.00|0|200|2003-04-21 00:00:00|20030421153135|0|84



by the way, i have 5000 links on my DB, so im looking for a way to (((add))) more links using XML or TXT or any type of format (i can format the oinput file the way i like, XML, RDF, TXT. etc..).



Thank you (:

Last edited by:

remal: Apr 21, 2003, 11:12 PM
Apr 22, 2003, 8:04 PM
remal
New User (3 posts)
Apr 22, 2003, 8:04 PM
Post #2 of 3
Views: 1295
Shortcut
Quote Reply
Re: [remal] importing from RDF or TXT or XML file In reply to
no way to do that? Unimpressed
Apr 23, 2003, 8:15 AM
afinlr
Veteran (1921 posts)
Apr 23, 2003, 8:15 AM
Post #3 of 3
Views: 1278
Shortcut
Quote Reply
Re: [remal] importing from RDF or TXT or XML file In reply to
I'm pretty sure that the easiest way to do it is to use the text file if the records really are in that format. If you go to Database->Links->Properties, at the bottom of the page is a link for 'Import Data'. I assume that if you leave 'Delete old data first' unchecked this will add your data on to the end of the table.