EasyPopulate only recognizes first line

[icecold]

EasyPopulate 2.76 is recognizing only the first line in the spreadsheet and therefore just the first product ... it's not a EOROR error. I'm testing it using just two products, in an empty database with just the options and values filled, nothing else relevant to categories.

=================================================
v_products_model v_categories_name_1 EOREOR
RICSA4I1 Combos 4 In 1 EOREOR
RICSB4I1 Combos 4 In 1 EOREOR
Note: I'm omitting non-used columns for a better representation and illustrative purposes.
=================================================

When inserting to the db, recognizes only first line and adds one new product instead of two.

User filename: EP2006Apr21-1402revt.txt
Size: 237
| RICSA4I1 | Combos | 4 In 1 | | | | | !New Product!
| RICSB4I1 |

Upload EP File

Any ideas?

[icecold]

[quote="icecold"]EasyPopulate 2.76 is recognizing only the first line in the spreadsheet and therefore just the first product ... itBTW this an OscMax2 clean installation ... with security patches added, just that ...

[michael_s]

Make sure your data does not have double quotes anywhere in it, and if you have single quotes, make sure each is escaped with a backslash...

[icecold]

thank you for the information. My data doesn't have any kind of quotes, what is really strange is the fact the same information is working in an older version of OSCMax (1.7), when i try to export it to the newer Easy Populate 2.76(OSCMax2RC2) in the local test server, problems started.

I did all kinds of tests, first by using a full spreadsheet created from the admin panel in the live site(OSMax 1.7 -- EasyPopulate 2.72), and then compared it side by side with another one created in the test server(OSCMax2RC2 with patches -- EasyPopulate 2.76), as I found several differences in column names and arrangement, between both versions.

Saved the new spreadsheet uploaded it to local test server, and it recognized only the first product.

Another test, create just a model/category spreadsheet within local server, and fill two columns, exactly as depicted in my initial message.

After all these problems i am wondering if there is a guideline to match, existing tab delimited spreadsheets, to the new EasyPopulate format.

Thanks

[michael_s]

Don't bother. Just export the old spreadsheet format. Then manually copy the fileds from the old spreadsheet to the new format, placing the data in the correct fields. There are quite a few new fields in the new database, and you are most likely missing one or 2. It is not recommended to use easypopulate to do the job.

It sounds like a column/field mismatch problem somewhere, especially since you are trying to cross oscmax database versions...

I suggest mysqldiff on a backup of your original database, then using the diff to upgrade the table format, then finally importing the newly formatted data to your new shop.