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

Problems with importing / exporting huge amount of information into Links SQL

Aug 13, 2003, 3:05 AM
Apeiron
Novice (11 posts)
Aug 13, 2003, 3:05 AM
Views: 1185
Shortcut
Quote Reply
Problems with importing / exporting huge amount of information into Links SQL
I had to transfer 45.000 items into Links SQL and i tryed to use the following function:
DATABASE > LINKS + PROPERTIES > IMPORT DATA > IMPORT DATA FROM FILE.

I made a file with the following content:
Code:
1520|English Course Work on Newspaper Reading /english/ (WinWord)|http://www.refeulichki.net/referats/12/240-1130.ZIP|1@1.1|2000-03-27|2000-03-27||Referat Admin|1@1.1|191|No|No|No|Yes|0.00|0|0|0000-00-00 00:00:00|20030616100055|||||||10|Иностранные языки
1521|English topics /english/ (W&D)|http://www.refeulichki.net/referats/12/240-1130.ZIP|1@1.1|2000-03-27|2000-03-27||Referat Admin|1@1.1|1140|No|No|Yes|Yes|0.00|0|0|0000-00-00 00:00:00|20030804122019|||||||10|Иностранные языки
1522|English topics /english/ (W&D)|http://www.refeulichki.net/referats/12/240-1131.ZIP|1@1.1|2000-03-27|2000-03-27||Referat Admin|1@1.1|686|No|No|No|Yes|0.00|0|0|0000-00-00 00:00:00|20030619130857|||||||10|Иностранные языки
1523|J.W.Geothe /на нем. языке/ (WinWord 97)|http://www.refeulichki.net/referats/pda-0142.zip|1@1.1|2000-03-27|2000-03-27||Referat Admin|1@1.1|106|No|No|No|Yes|0.00|0|0|0000-00-00 00:00:00|20030612161936|||||||10|Иностранные языки
1524|Higher Education in The U.K. /english/|http://www.refeulichki.net/referats/12/240-1494.ZIP|1@1.1|2000-03-27|2000-03-27||Referat Admin|1@1.1|305|No|No|No|Yes|0.00|0|0|0000-00-00 00:00:00|20030607233609|||||||10|Иностранные языки
1515|Anwendung eines neuranalen Netzwrkesfuer die Erkennung der Zeit-Frequenz Repraesentationen /german/|http://www.refeulichki.net/referats/12/240-1312.ZIP|1@1.1|2000-03-27|2003-06-17||Referat Admin|1@1.1|78|No|No|No|Yes|0.00|0|0|0000-00-00 00:00:00|20030804122015|||||||10|Иностранные языки
1516|Argentina /english/|http://www.refeulichki.net/referats/12/240-1447.ZIP|1@1.1|2000-03-27|2000-03-27||Referat Admin|1@1.1|140|No|No|No|Yes|0.00|0|0|0000-00-00 00:00:00|20030625133539|||||||10|Иностранные языки
1517|British traditional holidays /english/ (WinWord)|http://www.refeulichki.net/referats/referats/12/VDV-0166.ZIP|1@1.1|2000-03-27|2000-03-27||Referat Admin|1@1.1|420|No|No|No|Yes|2.50|2|0|0000-00-00 00:00:00|20030619141337|||||||10|Иностранные языки
1518|Business associations /english/ (RTF)|http://www.refeulichki.net/referats/12/240-0941.ZIP|1@1.1|2000-03-27|2000-03-27||Referat Admin|1@1.1|211|No|No|No|Yes|0.00|0|0|0000-00-00 00:00:00|20030620144640|||||||10|Иностранные языки

When i push the button, links SQL thinks for a while (15-20 mins) and than prints the following message "45.000 links are successfully imported".

But after than EVERY IMPORTED LINK has two or three catygories (one link belongs to few categories at the same time). How can i correct that? Please :(
Subject Author Views Date
Post Problems with importing / exporting huge amount of information into Links SQL Apeiron 1185 Aug 13, 2003, 3:05 AM