Here I have exported my Magento Advanced Import Dataflow Empty SQL Database. I wrote a PHP application to take values from various sources to create this master sheet. I then exported as csv and imported with no problems using the System->Import->Advanced Dataflows inside Magento

Magento Advanced Import Dataflow SQL Database

CREATE TABLE `master` (
  `mst_id` int(100) NOT NULL AUTO_INCREMENT,
  `store` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `websites` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `attribute_set` varchar(75) COLLATE utf8_unicode_ci NOT NULL,
  `type` varchar(75) COLLATE utf8_unicode_ci NOT NULL,
  `category_ids` int(50) NOT NULL,
  `sku` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `has_options` int(50) NOT NULL,
  `name` varchar(300) COLLATE utf8_unicode_ci NOT NULL,
  `meta_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `meta_description` text COLLATE utf8_unicode_ci NOT NULL,
  `image` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `small_image` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `thumbnail` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `url_key` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `url_path` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `config_attributes` text COLLATE utf8_unicode_ci NOT NULL,
  `custom_design` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `page_layout` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `options_container` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `image_label` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `small_image_label` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `thumbnail_label` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `country_of_manufacture` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `msrp_enabled` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `msrp_display_actual_price_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `gift_message_available` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `price` decimal(12,4) NOT NULL,
  `special_price` decimal(12,4) NOT NULL,
  `msrp` decimal(12,4) NOT NULL,
  `color` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `visibility` text COLLATE utf8_unicode_ci NOT NULL,
  `enable_googlecheckout` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `tax_class_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `cjm_useimages` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `size` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `short_description` text COLLATE utf8_unicode_ci NOT NULL,
  `meta_keyword` text COLLATE utf8_unicode_ci NOT NULL,
  `custom_layout_update` text COLLATE utf8_unicode_ci NOT NULL,
  `cjm_imageswitcher` text COLLATE utf8_unicode_ci NOT NULL,
  `cjm_moreviews` text COLLATE utf8_unicode_ci NOT NULL,
  `special_from_date` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `special_to_date` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `news_from_date` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `news_to_date` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_design_from` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_design_to` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `qty` int(50) NOT NULL DEFAULT '1',
  `min_qty` int(50) NOT NULL DEFAULT '1',
  `use_config_min_qty` smallint(5) NOT NULL DEFAULT '0',
  `is_qty_decimal` smallint(5) NOT NULL DEFAULT '0',
  `backorders` smallint(5) NOT NULL DEFAULT '1',
  `use_config_backorders` smallint(5) NOT NULL DEFAULT '1',
  `min_sale_qty` decimal(12,4) NOT NULL DEFAULT '1.0000',
  `use_config_min_sale_qty` smallint(5) NOT NULL DEFAULT '1',
  `max_sale_qty` decimal(12,4) NOT NULL DEFAULT '1.0000',
  `use_config_max_sale_qty` smallint(5) NOT NULL DEFAULT '1',
  `is_in_stock` smallint(5) NOT NULL DEFAULT '1',
  `low_stock_date` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `notify_stock_qty` smallint(5) NOT NULL DEFAULT '5',
  `use_config_notify_stock_qty` smallint(5) NOT NULL DEFAULT '1',
  `manage_stock` smallint(5) NOT NULL DEFAULT '1',
  `use_config_manage_stock` smallint(5) NOT NULL DEFAULT '1',
  `stock_status_changed_auto` smallint(5) NOT NULL DEFAULT '1',
  `use_config_qty_increments` smallint(5) NOT NULL DEFAULT '0',
  `qty_increments` decimal(12,4) NOT NULL DEFAULT '1.0000',
  `use_config_enable_qty_inc` smallint(5) NOT NULL DEFAULT '0',
  `enable_qty_increments` smallint(5) NOT NULL DEFAULT '0',
  `is_decimal_divided` smallint(5) NOT NULL DEFAULT '0',
  `stock_status_changed_automatically` smallint(5) NOT NULL DEFAULT '1',
  `use_config_enable_qty_increments` smallint(5) NOT NULL DEFAULT '0',
  `product_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `store_id` smallint(5) NOT NULL DEFAULT '0',
  `product_type_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `product_status_changed` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `gallery` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `related` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `upsell` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `crosssell` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `tier_prices` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `associated` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `bundle_options` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `grouped` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `group_price_price` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `downloadable_options` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `super_attribute_pricing` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `product_tags` text COLLATE utf8_unicode_ci NOT NULL,
  `weight` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `is_recurring` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `recurring_profile` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`mst_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci