Easy Populate & Excel Problem

[gameparts]

I have Easy Populate working fine apparently and am able to export my file using the "Download complete tab-delimited .txt file to edit
" funciton.

When I import it into Excel however using a "tab delimiter" I get the following error message:

"File not loaded completely"

And all I get are the headings from "v_products_model" to "v_status" which is columns A through IV in excel.

I've tried using other types of delimiters (ie comma, semicolon) and it just crams everything into the first column. And then I have the same problem if I use the Data to Colums funciton in Excel

What am I doing wrong with the export out of Easy Populate and import into Excel?

Thanks!

[gameparts]

ok, I figured out that my problem was too many attributes for Excel to handle.

Now I have another problem. When I use easy populate to import my file, with just the basics, the items are not imported properly. Only 1 of 5 shows up, and the categories are off. Why do I get this error message too: "No products_model field in record. This line was not imported
"

Any help would be greatly appreciate for this newbie!

Here is my file:

v_products_model v_products_image v_products_name_1 v_products_description_1 v_products_url_1 v_products_price v_products_weight v_date_avail v_date_added v_products_quantity v_manufacturers_name v_categories_name_1 v_categories_name_2 v_categories_name_3 v_tax_class_title v_status EOREOR

1 oscommerce.gif Test Fun Game This is a test description. 12.95 5 11/28/2004 23:56 99 A to F Taxable Goods Active EOREOR
1 test.jpg 1776 The Birth of a Nation Game - Reiss - 1974 (Lori) Reenact the events of American history. Box very good condition. Some wear at corners. Small superficial label tear on box top. One inch patch of writing on box bottom. Contents like new. Complete. 70s 24 4 11/28/2004 23:56 1 A to F Taxable Goods Active EOREOR
1 g1993.jpg g1876 Centennial Baseball Game Chatham Hill Games, 1994 (lori) Baseball as it was played in the real good old days..... Box good. Wear at corners. Minor crushing on box bottom and superficial tape tears. Contents good. Cards unpunched. Cardboard playing pieces missing. 90s 16 5 11/28/2004 23:56 1 A to F Taxable Goods Active EOREOR
1 g2090.JPG g221B Bakers Steet Time Machine Game, 1997 The master detective game. Complete and very good. One playing piece was broken and reglued. 90s 18 4 11/28/2004 23:56 1 A to F Taxable Goods Active EOREOR
1 g1811.jpg gAbacus Primative Version Constructed out of birch and pine, this signed and dated game board holds a uniqueness all its own due to being hand painted and finished to acheive an authentic look of yesteryear. Can be used for counting or hung on your wall as a decoration. Size 12 x 13 inches. Newly manufactured 42 5 11/28/2004 23:56 99 A to F Taxable Goods Active EOREOR

[auntie22]

Hello,

I to have the same problem. If anyone can assist, it would be appreciated.

[groggory]

maybe we need to revamp the attributes contrib. These tables are getting out of hand. Or maybe we need to just use them differently so we don't have gobs of attributes.

[michael_s]

What happens if you just download the model/attributes tab delimited text file? This removes all the others columns and may help. If you work on each section of the DB separately with EP (using the smaller EP files that you can download), you may be able to work around this issue.

The problem is that excel cannot handle more than 256 columns, and really has nothing to do with the database. If you have a lot of attributes, you will always have a problem with excel.

[gameparts]

I'm not sure what downloading just the model/attributes file would be good for. What would you then do with it?

[auntie22]

Hello,

I did not download the updated easypopulate because I was having the same trouble you have

What I did was work from the stock ms2 max easy populate,

I did what msasek said in this version, first I downloaded a complete tab-delimited file, then I downloaded a Model, Price & quantity, I deleted the extra categories from the tab-deliminated file and inserted the ones I needed from the model, price & quantity, this is what mine looks like now v_products_model v_products_image v_products_name_1 v_products_description_1 v_products_price v_products_weight v_date_avail v_date_added v_manufacturers_name v_categories_name_1 v_categories_name_2 v_categories_name_3 v_products_price v_products_quantity v_tax_class_title v_status EOREOR
I then uploaded just a sample and it worked great, now if I could only figure out how the size & color work I would be tickled.

Hope this helps.

[lem]

My problem is a little different. When I download the complete file, it opens great in microsoft excel. After I upload the file into the database, it does not give me any warnings and appears succesful. However, the parts do not show up! And when I go into the database, they are not their either. Am I doing something wrong? After I get done in Excell, I save it as a Text (tab delimited). PLEASE HELP! Thank you!

Lem

[groggory]

I just looked through your file and there are no model numbers. That and excel can't handle the size of it. You're gonna have to find yourself a new spreadsheet program to deal with this.

Easypopulate REQUIRES model numbers.

[gameparts]

Can model numbers be just anything generic? Like can I put my model numbers as 123 or 234, or 544 or whatever I want? Any suggestions on spreadsheet programs? Thanks!