Quote Originally Posted by LilleyPadGifts View Post
I will answer those questions later because I have since tried to upload a file of products only to receive the "No model field in Record. This line was not imported." when, in fact, I have model numbers in there. I researched it on here, but what someone suggested about copying to a new file only the columns that have info, did not work for me...and most other postings are in regards to a different version of EP. I have followed everything to a T.... and tried multiple times but no luck. HELP!
I'm sorry Lilley, I totally missed your response. I had too narrow of a view because I didn't see any of my text copied. So, if I am correct about how the program works, if the heading does not match the heading expected, then the program considers it not present regardless of the list of data below it. This could be because of an extra space before or after the text of the heading, a change of capitalization, or some modification made to the heading that I have not covered.

Regarding a "new" file, my thoughts on that is to download/export the type of file you are wanting to work with, then remove the "unnecessary" data and fill in the information you are trying to bring in. Don't "touch" the headings and try to do one line of the data you are working with as a test, if that works as expected, then import as much as you need, at least that way only the one item is potentially affected.

As for then only working with the columns of interest, from the downloaded good file, you can delete the other columns that are not needed.

The other thing to consider reviewing is that the newly saved csv file has the expected structure to support import. (Quotes where they should be, the appropriate divider between entries such as a comma, etc...) This would be by looking at the newly created CSV not necessarily by looking at OpenOffice (or the program of choice).