Hi Michael,
Yes, I did speak to Paul, and he was very helpful. He gave me the option of redoing the import with the Import Manager linked to here or to manually add the domains as a Service.
I'm not working with that many clients, so the solution was to:
Set up a Package Group called "Domains".
Set up Packages for each domain TLD we sell.
For each client with a domain, manually add a Service for the domain with "use module" unchecked.
Edit the added domain Service (click "Manage"), resetting the renewal date, making sure that "use module" and "prorate" are unchecked
I realize this is an old post, but in case you can still use it to add to the importer, the database structure for the knowledgebase in v. 6.x of WHMCS is:
--
-- Table structure for table `tblknowledgebase`
--
CREATE TABLE IF NOT EXISTS `tblknowledgebase` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`title` text NOT NULL,
`article` text NOT NULL,
`views` int(10) NOT NULL DEFAULT '0',
`useful` int(10) NOT NULL DEFAULT '0',
`votes` int(10) NOT NULL DEFAULT '0',
`private` text NOT NULL,
`order` int(3) NOT NULL,
`parentid` int(10) NOT NULL,
`language` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;
-- --------------------------------------------------------
--
-- Table structure for table `tblknowledgebasecats`
--
CREATE TABLE IF NOT EXISTS `tblknowledgebasecats` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`parentid` int(10) NOT NULL DEFAULT '0',
`name` text NOT NULL,
`description` text NOT NULL,
`hidden` text NOT NULL,
`catid` int(10) NOT NULL,
`language` text NOT NULL,
PRIMARY KEY (`id`),
KEY `parentid` (`parentid`),
KEY `name` (`name`(64))
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;
-- --------------------------------------------------------
--
-- Table structure for table `tblknowledgebaselinks`
--
CREATE TABLE IF NOT EXISTS `tblknowledgebaselinks` (
`categoryid` int(10) NOT NULL,
`articleid` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `tblknowledgebasetags`
--
CREATE TABLE IF NOT EXISTS `tblknowledgebasetags` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`articleid` int(10) NOT NULL,
`tag` varchar(64) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;