importing categories from db - using EasyPopulate !

[AzureCrystal]

Thanks in advance for any help !!

I am trying to use an existing state/county/city database to create those categories and products on the fly in ZenCart using Easy Populate, but having no luck so far.

My SQL skills are a bit rusty, but I was able to create a query to build a CSV file which looks to be in the same format as the exported EasyPopulate CSV file, I am not sure why EasyPopulate does not read it in properly, and not sure how exactly ZenCart builds categories based on the import file, etc... I know I must be missing something obvious !!

Here is the message from Easy Populate, usually I get a"blue" listing of the products imported:

File uploaded.
Temporary filename: /tmp/phpB9t2ko
User filename: cart-zipcode-merge.csv
Size: 147617

Upload Complete

And here is the Query I built using a zipcode db and padding with some dummy data:

SELECT
' ' as v_products_model,
'BuyThisAd.jpg' as v_products_image,
concat(`zip-codes-database-deluxe-sampl`.State, '-', `zip-codes-database-deluxe-sampl`.CountyName, '-', `zip-codes-database-deluxe-sampl`.City ) as v_products_name_1,
'This is a 148 x 200 pixel ad... It will consist of your picture or logo, your office information, and a link to either a video, website, your profile... The ad will on the left and right of our main directory site, any logo or picture must be 100x10' as v_products_description_1,
' ' as v_products_url_1,
' ' as v_specials_price,
' ' as v_specials_date_avail,
' ' as v_specials_expires_date,
'250' as v_products_price,
'0' as v_products_weight,
' ' as v_date_avail,
'9/3/2008 6:09:49 PM' as v_date_added,
'4' as v_products_quantity,
' ' as v_manufacturers_name,
'Banner Ads' as v_categories_name_1,
'Personal Use' as v_categories_name_2,
'Accident & Injuries' as v_categories_name_3,
`zip-codes-database-deluxe-sampl`.State as v_categories_name_4,
`zip-codes-database-deluxe-sampl`.CountyName as v_categories_name_5,
`zip-codes-database-deluxe-sampl`.City as v_categories_name_6,
'--none--' as v_tax_class_title,
'1' as v_status,
'EOREOR' as EOREOR
FROM
`zip-codes-database-deluxe-sampl`
ORDER BY
`zip-codes-database-deluxe-sampl`.ZipCode ASC

I think the data may be in the right format, but my export using Navicat into xls may have done something naughty with the conversion, any help will be DEEPLY appreciated :-))))

I will gladly post more info, I wish I knew more about the ZenCart db structures, but, too many things to learn tonight...