products database structure? How to?

Zen Cart 1.3.9h
Easy Populate 1.3.5.4

Having trouble importing a tab delimited text file catalog.

I did one mod to a standard zen cart: ALTER TABLE products ADD products_msrp DECIMAL ( 15, 4 ) NOT NULL AFTER products_price ;

Tried the import with all fields downloaded from easy populate, and also with adding v_products_msrp before v_products_price.

Note: many of my fields contain no data.

Questions:

When creating the text file, must all the fields be represented in the text file, or may one use only the fields that are to be imported?

Is there a way to display the database structure so that I can check that all the fields are represented in my text file?

Is there a way to see where the import is bombing? It looks like I get about half way through the upload of the first record before it crashes. I get 1 record created and a bunch of pipes and data after that, greyed out.

Thanks for any insight anyone can offer! New to both Zen Cart and EP, so thanks for understanding.

Rob

EP keeys on the model number so one must have a model number assigned

There is a wiki article on how yo use

kobra:

EP keeys on the model number so one must have a model number assigned

I have completely clean products database. No products at all.

I have completely clean products database. No products at all.
Create a couple so that when you download you will have a structure

See the wiki article

kobra:

Create a couple so that when you download you will have a structure
Thanks! I will try that. Re-reading the wiki once again.

Resolved

Two issues. A couple of my field names had a preceeding space and no EOFEOF after each record.

Thanks for your help.