Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2008
    Posts
    46
    Plugin Contributions
    0

    Default Downloading easy populate csv and it's blank?

    Hi guys,
    I'm about to give up, I can't find any help and I don't know what to do.
    I'm trying to download a .csv of my currently uploaded products so I can upgrade to easy populate 4.0 (I can't remember which one I currently have but the last update I did was Easypopulate csv by citychou) and it's coming up blank.

    These links allow me to download some data though so I have no idea why the first one won't let me?
    Download Model/Price/Qty .csv file to edit
    Download Model/Price/Qty/Last Modified/Status .csv file to edit
    Download Model/Category .csv file to edit
    Download Froogle tab-delimited .txt file
    Download Model/Attributes .csv file

    Zencart version 1.5 btw


    ETA: I got an error log when I tried to download the complete csv to my temp file. Here it is.


    MySQL error 1054: Unknown column 'p.EASYPOPULATE_CONFIG_CUSTOM_FIELDS' in 'field list'
    When executing:
    SELECT
    p.products_id as v_products_id,
    p.products_model as v_products_model,
    p.products_image as v_products_image,
    p.products_price as v_products_price,
    p.products_weight as v_products_weight,
    p.products_last_modified as v_last_modified,
    p.products_date_added as v_date_added,
    p.products_tax_class_id as v_tax_class_id,
    p.products_quantity as v_products_quantity,
    p.manufacturers_id as v_manufacturers_id,
    subc.categories_id as v_categories_id,
    p.products_status as v_status,
    p.metatags_title_status as v_metatags_title_status,
    p.metatags_products_name_status as v_metatags_products_name_status,
    p.metatags_model_status as v_metatags_model_status,
    p.metatags_price_status as v_metatags_price_status,
    p.metatags_title_tagline_status as v_metatags_title_tagline_status, p.EASYPOPULATE_CONFIG_CUSTOM_FIELDS as v_EASYPOPULATE_CONFIG_CUSTOM_FIELDS FROM
    products as p,
    categories as subc,
    products_to_categories as ptoc
    WHERE
    p.products_id = ptoc.products_id AND
    ptoc.categories_id = subc.categories_id

    MySQL error 1054: Unknown column 'p.EASYPOPULATE_CONFIG_CUSTOM_FIELDS' in 'field list'
    When executing:
    SELECT
    p.products_id as v_products_id,
    p.products_model as v_products_model,
    p.products_image as v_products_image,
    p.products_price as v_products_price,
    p.products_weight as v_products_weight,
    p.products_last_modified as v_last_modified,
    p.products_date_added as v_date_added,
    p.products_tax_class_id as v_tax_class_id,
    p.products_quantity as v_products_quantity,
    p.manufacturers_id as v_manufacturers_id,
    subc.categories_id as v_categories_id,
    p.products_status as v_status,
    p.metatags_title_status as v_metatags_title_status,
    p.metatags_products_name_status as v_metatags_products_name_status,
    p.metatags_model_status as v_metatags_model_status,
    p.metatags_price_status as v_metatags_price_status,
    p.metatags_title_tagline_status as v_metatags_title_tagline_status, p.EASYPOPULATE_CONFIG_CUSTOM_FIELDS as v_EASYPOPULATE_CONFIG_CUSTOM_FIELDS FROM
    products as p,
    categories as subc,
    products_to_categories as ptoc
    WHERE
    p.products_id = ptoc.products_id AND
    ptoc.categories_id = subc.categories_id

    MySQL error 1054: Unknown column 'p.EASYPOPULATE_CONFIG_CUSTOM_FIELDS' in 'field list'
    When executing:
    SELECT
    p.products_id as v_products_id,
    p.products_model as v_products_model,
    p.products_image as v_products_image,
    p.products_price as v_products_price,
    p.products_weight as v_products_weight,
    p.products_last_modified as v_last_modified,
    p.products_date_added as v_date_added,
    p.products_tax_class_id as v_tax_class_id,
    p.products_quantity as v_products_quantity,
    p.manufacturers_id as v_manufacturers_id,
    subc.categories_id as v_categories_id,
    p.products_status as v_status,
    p.metatags_title_status as v_metatags_title_status,
    p.metatags_products_name_status as v_metatags_products_name_status,
    p.metatags_model_status as v_metatags_model_status,
    p.metatags_price_status as v_metatags_price_status,
    p.metatags_title_tagline_status as v_metatags_title_tagline_status, p.EASYPOPULATE_CONFIG_CUSTOM_FIELDS as v_EASYPOPULATE_CONFIG_CUSTOM_FIELDS FROM
    products as p,
    categories as subc,
    products_to_categories as ptoc
    WHERE
    p.products_id = ptoc.products_id AND
    ptoc.categories_id = subc.categories_id
    Last edited by kezerb; 18 Jul 2012 at 03:12 AM.

  2. #2
    Join Date
    Sep 2012
    Posts
    2
    Plugin Contributions
    0

    Default Re: Downloading easy populate csv and it's blank?

    I commented out the following lines in the easypopulate.php file and I do not got around this issue:
    Note: *** I do not use customer fields. ****
    This can be found if you search other versions of easypopulate on this site...


    $custom_fields == FALSE;
    /* if(strlen(EASYPOPULATE_CONFIG_CUSTOM_FIELDS) > 0)
    {
    $custom_fields = explode(',',EASYPOPULATE_CONFIG_CUSTOM_FIELDS);
    }
    */

  3. #3
    Join Date
    Jun 2007
    Location
    Bronx, New York, United States
    Posts
    931
    Plugin Contributions
    9

    Default Re: Downloading easy populate csv and it's blank?

    Quote Originally Posted by John... View Post
    I commented out the following lines in the easypopulate.php file and I do not got around this issue:
    Note: *** I do not use customer fields. ****
    This can be found if you search other versions of easypopulate on this site...


    $custom_fields == FALSE;
    /* if(strlen(EASYPOPULATE_CONFIG_CUSTOM_FIELDS) > 0)
    {
    $custom_fields = explode(',',EASYPOPULATE_CONFIG_CUSTOM_FIELDS);
    }
    */
    Even better, you could use the actual installer built into EasyPopulate (easypopulate.php?install) and not the install.sql file provided with the new version.

    OR

    use the following code:

    Code:
    INSERT INTO configuration VALUES
    ('', 'Custom Products Fields', 'EASYPOPULATE_CONFIG_CUSTOM_FIELDS', '', 'Enter a comma seperated list of fields to be automatically added to import/export file(ie: products_length, products_width). Please make sure field exists in PRODUCTS table.', '31' , '10', NULL, now(), NULL, NULL);

 

 

Similar Threads

  1. v150 Easy Populate 4 vs. Easy Populate CSV - What's going on with so many Easy Populates?
    By oleancomputers in forum All Other Contributions/Addons
    Replies: 4
    Last Post: 20 Jun 2013, 05:58 PM
  2. Easy Populate 1.2.5.7.csv and VAT -- gross vs net price
    By jagall in forum All Other Contributions/Addons
    Replies: 1
    Last Post: 30 Sep 2011, 12:31 PM
  3. Easy Populate CSV cannot upload csv files
    By alimtlai in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 29 Sep 2009, 02:22 PM
  4. easy populate 1.2.5.5.csv - fetch_array error on .csv generation
    By emmtqg in forum All Other Contributions/Addons
    Replies: 6
    Last Post: 4 Sep 2009, 07:10 PM
  5. Replies: 0
    Last Post: 2 Sep 2009, 11:59 AM

Posting Permissions

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