osCmax v2.5 User Manual
Results 1 to 5 of 5

EasyPopulate only recognizes first line

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 ...

      
  1. #1
    osCMax Testing Team
    Join Date
    Oct 2003
    Posts
    52
    Rep Power
    0


    Default EasyPopulate only recognizes first line

    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?

  2. #2
    osCMax Testing Team
    Join Date
    Oct 2003
    Posts
    52
    Rep Power
    0


    Default RE: EasyPopulate only recognizes first line

    [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. #3
    osCMax Developer

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    19,907
    Rep Power
    568


    Default RE: EasyPopulate only recognizes first line

    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


    osCmax Installation Service
    - Have our professionals install osCmax on your server - same day service!
    osCmax 2.5 User Manual - the must have beginners guide to osCmax v2.5

    Stay Up To Date with everything osCMax:
    Free osCmax Newsletters - Security notices, New Releases, osCMax News
    osCmax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation

  4. #4
    osCMax Testing Team
    Join Date
    Oct 2003
    Posts
    52
    Rep Power
    0


    Default RE: EasyPopulate only recognizes first line

    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. #5
    osCMax Developer

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    19,907
    Rep Power
    568


    Default RE: EasyPopulate only recognizes first line

    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


    osCmax Installation Service
    - Have our professionals install osCmax on your server - same day service!
    osCmax 2.5 User Manual - the must have beginners guide to osCmax v2.5

    Stay Up To Date with everything osCMax:
    Free osCmax Newsletters - Security notices, New Releases, osCMax News
    osCmax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation

Similar Threads

  1. Sage Line 50
    By spottedhaggis in forum osCmax v2 Customization/Mods
    Replies: 3
    Last Post: 12-02-2006, 06:27 AM
  2. Off line setup
    By phily in forum osCmax v2 Installation issues
    Replies: 1
    Last Post: 08-29-2006, 04:36 AM
  3. How to remove this line?
    By shreky in forum osCmax v2 Installation issues
    Replies: 2
    Last Post: 05-07-2006, 12:38 PM
  4. database.php on line 17
    By Anonymous in forum osCmax v1.7 Discussion
    Replies: 2
    Last Post: 04-29-2004, 10:41 PM
  5. Please help - I need to put my store on line
    By pbicontact in forum osCommerce 2.2 Modification Help
    Replies: 1
    Last Post: 04-20-2004, 08:49 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •