Import from WP Filebase

Hello,

is there any chance you provide an import plugin from other Downloads plugins for WP Monitor, Mike? I used an old Wp Filebase version 0.1.3.4 previously, we have over 1000 files and well…it took me an hour to add the few categories already – I don’t want to think about the files.

I tried myself based on your legacy importer (renamed all the fields), but I’m a bit stuck with the featured image, which is just a pic with thumb_ and then the same name as the download file in the same folder, and I have no idea how to add them.

There are just two tables wordpress_wpfb_cats and wordpress_wpfb_files.

Or, maybe, has anyone else here tried yet??

Thank you, Martina.

CREATE TABLE IF NOT EXISTS wordpress_wpfb_cats (
cat_id int(8) unsigned NOT NULL AUTO_INCREMENT,
cat_name varchar(255) NOT NULL DEFAULT ”,
cat_description text,
cat_folder varchar(255) NOT NULL DEFAULT ”,
cat_parent int(8) unsigned NOT NULL DEFAULT ‘0’,
cat_files bigint(20) unsigned NOT NULL DEFAULT ‘0’,
cat_required_level tinyint(2) NOT NULL DEFAULT ‘0’,
cat_icon varchar(255) DEFAULT NULL,
PRIMARY KEY (cat_id),
UNIQUE KEY UNIQUE_FOLDER (cat_folder,cat_parent)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=74 ;

INSERT INTO wordpress_wpfb_cats (cat_id, cat_name, cat_description, cat_folder, cat_parent, cat_files, cat_required_level, cat_icon) VALUES
(2, ‘1992’, ‘videos 1992’, ‘1992’, 0, 1, 0, ‘_caticon.jpg’),
(3, ‘1998’, ‘Videos 1998’, ‘1998’, 0, 1, 0, ‘_caticon.jpg’),
(4, ‘2002’, ‘Videos 2002’, ‘2002’, 0, 1, 0, ‘_caticon.jpg’);


CREATE TABLE wordpress_wpfb_files (
file_id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
file_name varchar(255) NOT NULL DEFAULT ”,
file_size bigint(20) unsigned NOT NULL DEFAULT ‘0’,
file_date datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
file_hash varchar(32) NOT NULL DEFAULT ”,
file_thumbnail varchar(255) DEFAULT NULL,
file_display_name varchar(255) NOT NULL DEFAULT ”,
file_description text,
file_requirement varchar(255) DEFAULT NULL,
file_version varchar(64) DEFAULT NULL,
file_author varchar(255) DEFAULT NULL,
file_language varchar(255) DEFAULT NULL,
file_platform varchar(255) DEFAULT NULL,
file_license varchar(255) NOT NULL DEFAULT ”,
file_required_level tinyint(2) unsigned DEFAULT NULL,
file_offline enum(‘0′,’1’) NOT NULL DEFAULT ‘0’,
file_direct_linking enum(‘0′,’1’) NOT NULL DEFAULT ‘0’,
file_category int(8) unsigned NOT NULL DEFAULT ‘0’,
file_update_of bigint(20) unsigned DEFAULT NULL,
file_post_id bigint(20) unsigned DEFAULT NULL,
file_added_by bigint(20) unsigned DEFAULT NULL,
file_hits bigint(20) unsigned NOT NULL DEFAULT ‘0’,
file_ratings bigint(20) unsigned NOT NULL DEFAULT ‘0’,
file_rating_sum bigint(20) unsigned NOT NULL DEFAULT ‘0’,
file_last_dl_ip varchar(100) NOT NULL DEFAULT ”,
file_last_dl_time datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
PRIMARY KEY (file_id),
UNIQUE KEY UNIQUE_FILE (file_name,file_category),
FULLTEXT KEY FULLTEXT (file_description)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1320 ;

INSERT INTO wordpress_wpfb_files (file_id, file_name, file_size, file_date, file_hash, file_thumbnail, file_display_name, file_description, file_requirement, file_version, file_author, file_language, file_platform, file_license, file_required_level, file_offline, file_direct_linking, file_category, file_update_of, file_post_id, file_added_by, file_hits, file_ratings, file_rating_sum, file_last_dl_ip, file_last_dl_time) VALUES
(2, ‘1992-PartibrejkersAndJohhnyDepp.WMV’, 31378625, ‘1992-02-01 00:01:22’, ‘6362f87f5babdcd410cfe00f8be4de3f’, ‘thumb_1992-PartibrejkersAndJohhnyDepp.jpg’, ‘Concert Partibrejkers and Johhny Depp’, ‘Concert Partibrejkers-Johnny plays guitar’, ‘|’, ”, ”, ‘en’, ‘wmv’, ”, 0, ‘0’, ‘1’, 2, 0, 0, 2, 752, 0, 0, ‘91.178.208.36’, ‘2014-01-03 21:02:33’),
(3, ‘1998-FaliLVTvCNN.wmv’, 1997651, ‘1998-05-15 00:01:23’, ‘3382b533c73844ba03219d07d0098472’, ‘thumb_FaliLV.jpg’, ‘Fear and loathing in Las Vegas TV report’, ‘Report Fear and loathing in Las Vegas on TV CNN’, ‘|’, ”, ”, ‘en’, ‘wmv’, ”, 0, ‘0’, ‘1’, 3, 0, 0, 2, 409, 0, 0, ‘2.178.64.242’, ‘2013-12-15 15:02:58’),
(4, ‘2002-01-28-r3worldmusicaward.rm’, 15328546, ‘2002-01-28 00:01:31’, ‘2a5e1d32a7019d9cc863a7b9d4628c6a’, ‘thumb_2002-01-28-r3worldmusicaward.jpg’, ‘R3 World Music Award’, ‘R3 World Music Award’, ‘|’, ”, ”, ‘en’, ”, ”, 0, ‘0’, ‘1’, 4, 0, 0, 2, 920, 0, 0, ‘2.178.66.54’, ‘2013-12-17 12:17:37’);

http://wordpress.org/plugins/download-monitor/