This is a discussion on EasyPopulate only recognizes first line within the osCMax v2 Customization/Mods forums, part of the osCMax v2.0 Forums category; EasyPopulate 2.76 is recognizing only the first line in the spreadsheet and therefore just the first product ... it's not ...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
|
#1
| |||
| |||
| 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? |
| Sponsored Links | ||
| ||
|
#2
| |||
| |||
| [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 ... |
|
#3
| ||||
| ||||
| 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...
__________________ Michael Sasek osCMax Developer
|
|
#4
| |||
| |||
| 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 |
|
#5
| ||||
| ||||
| 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.
__________________ Michael Sasek osCMax Developer
|
| Sponsored Links | ||
| ||
| Thread Tools | |
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Sage Line 50 | spottedhaggis | osCMax v2 Customization/Mods | 3 | 12-02-2006 07:27 AM |
| Off line setup | phily | osCMax v2 Installation issues | 1 | 08-29-2006 05:36 AM |
| How to remove this line? | shreky | osCMax v2 Installation issues | 2 | 05-07-2006 01:38 PM |
| database.php on line 17 | Anonymous | osCMax v1.7 Discussion | 2 | 04-29-2004 11:41 PM |
| Please help - I need to put my store on line | pbicontact | osCommerce 2.2 Modification Help | 1 | 04-20-2004 09:49 AM |