Import SnapDex

[interfx]

How easy is it to import links from another link based system? For example, snapdex?

Anyone ever convert this format? If not how hard is it to convert manually the structure to be read by IndexU?


Thanks -
Todd

[esm]

I have never used snapdex but send me the data structures for the tables and I'll take a look...

[interfx]

Here's an example line from my MySQL backup...

INSERT INTO links (id,cid,name,url,description,approved,date,hits,Nu m_Votes,Votes,Rating,user,user_name) VALUES ("452","38","Plastics 2 Us","http://www.plastics2us.com/","Welcome to Plastics2us.com ... your guide to the best plastic resources on the Web. All the information you need, organized into easy-to-navigate categories, with expert commentary about every aspect in the plastics industry so you can find exactly what you're looking for. ","1","2/7/2001 0:00:00","187","0","0","0","0","http://");
#

[esm]

your information

id,                   "452",                        
cid,                  "38",                         
name,                 "Plastics 2 Us",              
url,                  "http://www.plastics2us.com/",
description,          "Welcome to Plastics2us.com ..
approved,             "1",                          
date,                 "2/7/2001 0:00:00",           
hits,                 "187",                        
Nu m_Votes,           "0",                          
Votes,                "0",                          
Rating,               "0",                          
user,                 "0",                          
user_name             "http://

the corresponding INDEXU idx_link table

CREATE TABLE idx_link (
  link_id mediumint(8) unsigned NOT NULL auto_increment,
  category_id smallint(5) unsigned NOT NULL,
  title varchar(100) NOT NULL,
  url text NOT NULL,
  description text NOT NULL,
  contact_name varchar(100) NOT NULL,
  email varchar(100) NOT NULL,
  hits mediumint(9),
  votes smallint(6) NOT NULL,
  rating float(4,2) DEFAULT '0.00' NOT NULL,
  date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
  bid smallint(6),
  new char(1),
  hot char(1),
  top_rated char(1),
  pick char(1),
  password varchar(20),
  updated char(1),
  reviews smallint(6),
  avg_review float(4,2),
  last_updated datetime,
  official_review text,
  keywords varchar(255),
  cat1 smallint(6) NOT NULL,
  cat2 smallint(6) NOT NULL,
  sp_cat char(1),
  sp_cat_date_limit date,
  sp_cat_order smallint(6),
  suspended char(1),
  PRIMARY KEY (link_id),
  KEY title (`title`)
);

INDEXU does not have a user or user_name field. but you could create those ( use the admin control panel to do it ). Approve is the same as suspended. and I am not sure what the Nu m_Votes field is.

just map what you have to indexu and populate some of the required fields and you are ready to go. but add the categories first