Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Easy Populate & Products Attributes


VJ

Recommended Posts

Sorry Todd, it's been awhile since I looked into OSC code.

 

I'm not sure what the problem is with my shop using Easy Populate

 

When I had it at http://www.makepeace.org.au/shop/ - EP worked fine.

 

My test store at http://www.makepeace.org.au/shop_dev/ - still works fine.

 

Now that I've moved the live store to the root I can't upload my excel files to the shop (same file works fine in test store though)

 

I changed the temp directory in admin/easypopulate.php to what it should be ('/temp/')

 

But when I try and import the database Oscommerce is still looking for the temp files at /shop/temp/

 

How do I get it to see the new temp file?

 

Here is a screenshot of my EP screen:

 

Those bits should just say temp not shop/temp/

 

I'm not familiar with v2.75.

 

what does your temp directory setting show in your easypopulate.php ?

Edited by surfalot
Link to comment
Share on other sites

thans for your reply surfalot, although it still doesnt work :blink:

 

I realised that i actually have the structure 'public_html/' and then everything is in there. It says it is looking for 'home/discoun/public_html/' maybe this si why it is not working? is there a way to change this? i know nothing about programming, this is just something i spotted, what do you think?

 

check with your host for the complete path to your web docs. Then set it to what they tell you in your configure.php.

if that doesn't help set it to this in your admin/includes/configure.php:

  define('DIR_FS_DOCUMENT_ROOT', $DOCUMENT_ROOT);

beyond that, I need some versions to help further. EP vers? PHP vers? MySQL vers? PHP globals on/off ??

Link to comment
Share on other sites

what country are you in?

 

the problem is your excel is not using the comma for your CSV separator.

go to your windows control panel. open regional and language options. click on customize. find list separator.

this is what excel will use. you need to use that same character in your easypopulate.php.

 

find this:

if ($excel_safe_output == true) { $separator = ","; }

change the $separator = "," to reflect what your windows is expecting for the separator.

 

post 4939 for more info on this.

 

I am in the US.

 

Via control panel/language options/customize...The seperator was already set to ","....

 

easypopulate.php looks like this, as you can see I implemented the "fix" from the more info thread you recommended:

 

EP-problem2.gif

 

This problem only happens when I insert that html into the product description column.

 

Every time I save before upload I get:

 

EP-problem3.gif

 

Ideas?

 

-Dano

Link to comment
Share on other sites

I am in the US.

 

Via control panel/language options/customize...The seperator was already set to ","....

 

easypopulate.php looks like this, as you can see I implemented the "fix" from the more info thread you recommended:

 

This problem only happens when I insert that html into the product description column.

 

Ideas?

 

-Dano

 

if you are in the US, you don't need that fix and it would be better if you didn't use it.

please post or pm me a link to the export file. I would like to see the export with your html in it.

Link to comment
Share on other sites

I'm not familiar with v2.75.

 

what does your temp directory setting show in your easypopulate.php ?

 

$tempdir = "/temp/";

$tempdir2 = "/temp/";

Link to comment
Share on other sites

$tempdir = "/temp/";

$tempdir2 = "/temp/";

 

and admin/includes/config

 

// Define the webserver and path parameters

// * DIR_FS_* = Filesystem directories (local/physical)

// * DIR_WS_* = Webserver directories (virtual/URL)

define('HTTP_SERVER', 'http://www.makepeace.org.au'); // eg, http://localhost - should not be empty for productive servers

define('HTTP_CATALOG_SERVER', 'http://www.makepeace.org.au');

define('HTTPS_CATALOG_SERVER', '');

define('ENABLE_SSL_CATALOG', 'false'); // secure webserver for catalog module

define('DIR_FS_DOCUMENT_ROOT', $DOCUMENT_ROOT); // where the pages are located on the server

define('DIR_WS_ADMIN', '/admin/'); // absolute path required

define('DIR_FS_ADMIN', '/xxxxxxxxxxpublic_html/admin/'); // absolute pate required

define('DIR_WS_CATALOG', ''); // absolute path required

define('DIR_FS_CATALOG', '/xxxxxx/xxxxxxx/public_html/'); // absolute path required

define('DIR_WS_IMAGES', 'images/');

define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');

define('DIR_WS_CATALOG_IMAGES', DIR_WS_CATALOG . 'images/');

define('DIR_WS_INCLUDES', 'includes/');

define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/');

define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');

define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');

define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');

define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');

define('DIR_WS_CATALOG_LANGUAGES', DIR_WS_CATALOG . 'includes/languages/');

define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/');

define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/');

define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/');

define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/');

Link to comment
Share on other sites

further: this is my error:

 

Warning: move_uploaded_file(/xxxxx/xxxx/xxxxxx/shop/temp/october2005faces.txt.xls) [function.move-uploaded-file]: failed to open stream: No such file or directory in //xxxxx/xxxx/xxxxxx/admin/easypopulate_functions.php on line 32

 

Warning: move_uploaded_file() [function.move-uploaded-file]: Unable to move '/tmp/phpqHhN4a' to '/xxxxx/xxxx/xxxxxx/shop/temp/october2005faces.txt.xls' in /xxxxx/xxxx/xxxxxx/admin/easypopulate_functions.php on line 32

 

File uploaded.

Temporary filename: /tmp/phpqHhN4a

User filename: october2005faces.txt.xls

Size: 90773

 

Warning: file(/xxxxx/xxxx/xxxxxx/shop/temp/october2005faces.txt.xls) [function.file]: failed to open stream: No such file or directory in /xxxxx/xxxx/xxxxxx/admin/easypopulate.php on line 656

 

Warning: Invalid argument supplied for foreach() in /xxxxx/xxxx/xxxxxx/admin/easypopulate.php on line 679

Link to comment
Share on other sites

I just found another issue:

 

When I try to "Upload and Import EP File", the screen refreshes, but I don't get anything. No error or success message. There is nothing in the database.

 

Per the manual, I tried downloading a complete EP file and without even opening it, I tried to upload. Same results.

 

It can't be a size issue, as there are only three products in the store right now.

 

Any ideas?

 

Hi,

 

I got the same problem with Easy Populate 2.76 MS2.

I switched from PHP 4 and MySQL 4 to PHP 5 and MySQL 5.

Under previous configuation RasyPopulate worked fine. Now I can not import anything.

 

I think it is related to PHP5.

 

Did anybody solved this problem ?

Link to comment
Share on other sites

Hi,

 

I got the same problem with Easy Populate 2.76 MS2.

I switched from PHP 4 and MySQL 4 to PHP 5 and MySQL 5.

Under previous configuation RasyPopulate worked fine. Now I can not import anything.

 

I think it is related to PHP5.

 

Did anybody solved this problem ?

more importantly is your PHP globals on/off?

Is the php error reporting turned on? (ask your host)

then look at this post about php 5. but that problem will still insert the first line, then quit.

post 5554 might have more info for you to look at.

Link to comment
Share on other sites

Hello!

I use EP for add new products in my store.

Now i need second manufacturer, i make it - work fine, but what need to add it in EP?

 

How i make (easypopulate.php)

        'v_instock',
        'v_tax_class_title',
        'v_manufacturers_name',
        'v_manufacturers_id',
//after it i add
		'v_manufacturers2_name',
        'v_manufacturers2_id',

                $row['v_froogle_color']                        = '';
                $row['v_froogle_size']                        = '';
                $row['v_froogle_quantitylevel']                = '';
                $row['v_froogle_manufacturer_id']        = '';
//after
	    $row['v_froogle_manufacturer2_id']        = '';

                // if the filelayout says we need a manufacturers name, get it
                if (isset($filelayout['v_manufacturers_name'])){
                        if ($row['v_manufacturers_id'] != ''){
                                $sql2 = "SELECT manufacturers_name
                                        FROM ".TABLE_MANUFACTURERS."
                                        WHERE
                                        manufacturers_id = " . $row['v_manufacturers_id']
                                        ;
                                $result2 = tep_db_query($sql2);
                                $row2 =  tep_db_fetch_array($result2);
                                $row['v_manufacturers_name'] = $row2['manufacturers_name'];
                        }
                }
//after
				                // if the filelayout says we need a manufacturers name, get it
                if (isset($filelayout['v_manufacturers2_name'])){
                        if ($row['v_manufacturers2_id'] != ''){
                                $sql2 = "SELECT manufacturers2_name
                                        FROM ".TABLE_MANUFACTURERS2."
                                        WHERE
                                        manufacturers2_id = " . $row['v_manufacturers2_id']
                                        ;
                                $result2 = tep_db_query($sql2);
                                $row2 =  tep_db_fetch_array($result2);
                                $row['v_manufacturers2_name'] = $row2['manufacturers2_name'];
                        }
                }

    $header_array['v_manufacturers_name'] = $iii++;
//after
    $header_array['v_manufacturers2_name'] = $iii++;

                        p.products_tax_class_id as v_tax_class_id,
                        p.products_quantity as v_products_quantity,
                        p.manufacturers_id as v_manufacturers_id,
//after
						p.manufacturers2_id as v_manufacturers2_id,

                        'v_froogle_instock'                => $iii++,
                        'v_froogle_ shipping'                => $iii++,
                        'v_manufacturers_name'                => $iii++,
//after
						'v_manufacturers2_name'                => $iii++,

                        'v_froogle_manufacturer_id'        => $iii++,
//after
                        'v_froogle_manufacturer_id'        => $iii++,

                        'size'                        => $iii++,
                        'quantity'                => $iii++,
                        'product_id'                => $iii++,
                        'manufacturer_id'        => $iii++,
//after 
						'manufacturer2_id'        => $iii++,

                        p.products_tax_class_id as v_tax_class_id,
                        p.products_quantity as v_products_quantity,
                        p.manufacturers_id as v_manufacturers_id,
//after
						p.manufacturers2_id as v_manufacturers2_id,

                p.products_tax_class_id as v_tax_class_id,
                p.products_quantity as v_products_quantity,
                p.manufacturers_id as v_manufacturers_id,
//after
                p.manufacturers2_id as v_manufacturers2_id,

               // temprow has the old style low to high level categories.
                $newlevel = 1;
                // let's turn them into high to low level categories
                for( $categorylevel=EP_MAX_CAT+1; $categorylevel>0; $categorylevel--){
                        if ($temprow['v_categories_name_' . $categorylevel] != ''){
                                $row['v_categories_name_' . $newlevel++] = $temprow['v_categories_name_' . $categorylevel];
                        }
                }

                if ($row['v_manufacturers_id'] != ''){
                        $sql2 = "SELECT manufacturers_name
                                FROM ".TABLE_MANUFACTURERS."
                                WHERE
                                manufacturers_id = " . $row['v_manufacturers_id']
                                ;
                        $result2 = tep_db_query($sql2);
                        $row2 =  tep_db_fetch_array($result2);
                        $row['v_manufacturers_name'] = $row2['manufacturers_name'];
                }
//after
				                // temprow has the old style low to high level categories.
                // let's turn them into high to low level categories
                for( $categorylevel=EP_MAX_CAT+1; $categorylevel>0; $categorylevel--){
                        if ($temprow['v_categories_name_' . $categorylevel] != ''){
                                $row['v_categories_name_' . $newlevel++] = $temprow['v_categories_name_' . $categorylevel];
                        }
                }

                if ($row['v_manufacturers2_id'] != ''){
                        $sql2 = "SELECT manufacturers2_name
                                FROM ".TABLE_MANUFACTURERS2."
                                WHERE
                                manufacturers2_id = " . $row['v_manufacturers2_id']
                                ;
                        $result2 = tep_db_query($sql2);
                        $row2 =  tep_db_fetch_array($result2);
                        $row['v_manufacturers2_name'] = $row2['manufacturers2_name'];
                }

       if ($v_manufacturer_id==''){
                $v_manufacturer_id="NULL";
        }
//after
		        if ($v_manufacturer2_id==''){
                $v_manufacturer2_id="NULL";
        }

        // OK, we need to convert the manufacturer's name into id's for the database
        if ( isset($v_manufacturers_name) && $v_manufacturers_name != '' ){
                $sql = "SELECT man.manufacturers_id
                        FROM ".TABLE_MANUFACTURERS." as man
                        WHERE
                                man.manufacturers_name = '" . $v_manufacturers_name . "'";
                $result = tep_db_query($sql);
                $row =  tep_db_fetch_array($result);
                if ( $row != '' ){
                        foreach( $row as $item ){
                                $v_manufacturer_id = $item;
                        }
                } else {
                        // to add, we need to put stuff in categories and categories_description
                        $sql = "SELECT MAX( manufacturers_id) max FROM ".TABLE_MANUFACTURERS;
                        $result = tep_db_query($sql);
                        $row =  tep_db_fetch_array($result);
                        $max_mfg_id = $row['max']+1;
                        // default the id if there are no manufacturers yet
                        if (!is_numeric($max_mfg_id) ){
                                $max_mfg_id=1;
                        }

                        // Uncomment this query if you have an older 2.2 codebase
                        /*
                        $sql = "INSERT INTO ".TABLE_MANUFACTURERS."(manufacturers_id, manufacturers_name, manufacturers_image) VALUES ('".$max_mfg_id."','".$v_manufacturers_name."','".EP_MANF_IMAGE."')";
                        */

                        // Comment this query out if you have an older 2.2 codebase
                        $sql = "INSERT INTO ".TABLE_MANUFACTURERS."(manufacturers_id, manufacturers_name, manufacturers_image, date_added, last_modified) VALUES ('" . $max_mfg_id . "', '" . $v_manufacturers_name . "','" . EP_MANF_IMAGE . "', " . CURRENT_TIMESTAMP . "," . CURRENT_TIMESTAMP . ")";
                        $result = tep_db_query($sql);
                        $v_manufacturer_id = $max_mfg_id;
                }
        }
//after
		        // OK, we need to convert the manufacturer's name into id's for the database
        if ( isset($v_manufacturers2_name) && $v_manufacturers2_name != '' ){
                $sql = "SELECT man.manufacturers2_id
                        FROM ".TABLE_MANUFACTURERS2." as man
                        WHERE
                                man.manufacturers2_name = '" . $v_manufacturers2_name . "'";
                $result = tep_db_query($sql);
                $row =  tep_db_fetch_array($result);
                if ( $row != '' ){
                        foreach( $row as $item ){
                                $v_manufacturer2_id = $item;
                        }
                } else {
                        // to add, we need to put stuff in categories and categories_description
                        $sql = "SELECT MAX( manufacturers2_id) max FROM ".TABLE_MANUFACTURERS2;
                        $result = tep_db_query($sql);
                        $row =  tep_db_fetch_array($result);
                        $max_mfg_id = $row['max']+1;
                        // default the id if there are no manufacturers yet
                        if (!is_numeric($max_mfg_id) ){
                                $max_mfg_id=1;
                        }

                        // Uncomment this query if you have an older 2.2 codebase
                        /*
                        $sql = "INSERT INTO ".TABLE_MANUFACTURERS."(manufacturers_id, manufacturers_name, manufacturers_image) VALUES ('".$max_mfg_id."','".$v_manufacturers_name."','".EP_MANF_IMAGE."')";
                        */

                        // Comment this query out if you have an older 2.2 codebase
                        $sql = "INSERT INTO ".TABLE_MANUFACTURERS2."(manufacturers2_id, manufacturers2_name, manufacturers2_image, date_added, last_modified) VALUES ('" . $max_mfg_id . "', '" . $v_manufacturers2_name . "','" . EP_MANF_IMAGE . "', " . CURRENT_TIMESTAMP . "," . CURRENT_TIMESTAMP . ")";
                        $result = tep_db_query($sql);
                        $v_manufacturer2_id = $max_mfg_id;
                }
        }

 

 

                                        products_weight,
                                       products_quantity,
                                       manufacturers_id,
//after
manufacturers2_id

                                                            '$v_products_weight',
                                                           '$v_products_quantity',
                                                           '$v_manufacturer_id',
//after
'$v_manufacturer2_id'

                                        ', products_last_modified=CURRENT_TIMESTAMP
                                       , products_quantity="' . $v_products_quantity .  
                                       '" ,manufacturers_id=' . $v_manufacturer_id . 
//after
									'" ,manufacturers2_id=' . $v_manufacturer2_id .

 

in export xls i see new column - v_manufacturers2_name and i see allright manufacturers2 in his products, but if i change manufacturer2 and make upload and insert this file i have error -

File uploaded.
Temporary filename: /home/u50422/aquast.ru/tmp/php3qTlTD
User filename: EP2007Apr03-140255.xls
Size: 40064
| ванна MIAN | editorPics | | ванна MIAN | Описание т | | | | 2320 | 8.00 | | 0000-00-00 | 421 | 1 | Цвет | 14 | | Хром | 15 | | Серебро | 16 | | Золото | 17 | | хром/золот | 2 | | | 55 | Ванны | Прямоуголь | | | | | | --нет-- | Active Updated
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '" ,manufacturers2_id=13 , products_status=1 ' at line 4

UPDATE products SET products_price="2320" ,products_image="editorPics/img42ca6b6ced90d.jpg" ,products_subimage1="" ,products_subimage2="" ,products_subimage3="" ,products_subimage4="" ,products_subimage5="" ,products_subimage6="", products_weight="8.00", products_tax_class_id="", products_date_available= NULL, products_date_added= "0000-00-00 00:00:00", products_last_modified=CURRENT_TIMESTAMP , products_quantity="421" ,manufacturers_id=NULL" ,manufacturers2_id=13 , products_status=1 WHERE (products_id = "282")

[TEP STOP]

PLEASE HELP!

Edited by Orik
Link to comment
Share on other sites

thankyou surfalot, everything is almost working now.

 

i changed

define('DIR_FS_DOCUMENT_ROOT', 'public_html/');

 

to

define('DIR_FS_DOCUMENT_ROOT', $DOCUMENT_ROOT );

 

and I added a '/' before 'temp/' in easypopulate.php

 

I can now download files and edit them fine although i tried to upload a file and insert it into the db and i got this:

 

File uploaded.

Temporary filename: /tmp/phpSaBan1

User filename: EP2007Apr03-1705.txt

Size: 531343

| capcom_cla | Capcom Cla | Brand new, | | 26.99 | 0.00 | | 2006-11-22 | 0 | Sony | Gaming | PSP Games | | --none-- | Inactive | !New Product!

| burnout_le | Burnout Le | Brand new, | | 19.99 | 0.00 | | 2006-11-22 | 0 | Sony | Gaming | PSP Games | | --none-- | Inactive | !New Product!

| sudoku.gif | Go Sudoku | Brand new, | | 15.99 | 0.00 | | 2006-11-22 | 0 | Sony | Gaming | PSP Games | | --none-- | Inactive | !New Product!

| gradius.gi | Gradius Co | Brand new, | | 26.99 | 0.00 | | 2006-11-22 | 0 | Sony | Gaming | PSP Games | | --none-- | Inactive | !New Product!

| gripshift. | Gripshift | GripShift | | 16.99 | 0.00 | | 2006-11-22 | 0 | Sony | Gaming | PSP Games | | --none-- | Inactive | !New Product!

| goblet.gif | Harry Pott | Brand new, | | 17.99 | 0.00 | | 2006-11-22 | 0 | Sony | Gaming | PSP Games | | --none-- | Inactive | !New Product!

| king_kong. | Peter Jack | Brand new, | | 19.99 | 0.00 | | 2006-11-22 | 0 | Sony | Gaming | PSP Games | | --none-- | Inactive | !New Product!

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's King Kong PSP', 'king_kong.gif', '0', '1', CURRE' at line 14

 

INSERT INTO products ( products_image, products_model, products_price, products_status, products_last_modified, products_date_added, products_date_available, products_tax_class_id, products_weight, products_quantity, manufacturers_id) VALUES ( 'Peter Jackson's King Kong PSP', 'king_kong.gif', '0', '1', CURRENT_TIMESTAMP, "0", "2006-11-22 22:33:01", '', '', 'Sony', '454')

 

What is wrong with the SQL syntax?

 

also, just a general question: If I upload a EP file containing products that are already in my store would they be added twice, or just ignored?

 

And, when I upload an EP file do I need to include products that are already active in my store or can I just upload a spreadsheet with all the products i want to add to my store?

Link to comment
Share on other sites

thankyou surfalot, everything is almost working now.

 

i changed

define('DIR_FS_DOCUMENT_ROOT', 'public_html/');

 

to

define('DIR_FS_DOCUMENT_ROOT', $DOCUMENT_ROOT );

 

and I added a '/' before 'temp/' in easypopulate.php

 

I can now download files and edit them fine although i tried to upload a file and insert it into the db and i got this:

 

What is wrong with the SQL syntax?

 

also, just a general question: If I upload a EP file containing products that are already in my store would they be added twice, or just ignored?

 

And, when I upload an EP file do I need to include products that are already active in my store or can I just upload a spreadsheet with all the products i want to add to my store?

the problem is the single qoute in your data. you should try the excel safe option.

 

the download will then be comma separated (for the US (maybe all english countries)), and quoted values and the file extension will change to .CSV. You can open in excel and save back to the same CSV to import (or save as... DOS CSV file type).

 

Looks like your first column is an image. EP requires all products have a unique model number (per the directions). That is how imported products are matched with existing products for an update. If no matching model number is found, a new product is created.

 

you can import any portion of your inventory, new products or updated products.

Link to comment
Share on other sites

okay, ive turned the excel safe option on.

 

When i download a .csv file to edit like you say none of my products have unique model numbers. Im worried that if i now download a .csv file and give each product a unique number and then re-upload the file it will create doubles of every product because it will see each product as different to the ones already in my store (without a unique num.)

 

sorry if that didnt make sense :/ do you understand what im saying?

Link to comment
Share on other sites

okay, ive turned the excel safe option on.

 

When i download a .csv file to edit like you say none of my products have unique model numbers. Im worried that if i now download a .csv file and give each product a unique number and then re-upload the file it will create doubles of every product because it will see each product as different to the ones already in my store (without a unique num.)

 

sorry if that didnt make sense :/ do you understand what im saying?

 

yes, if you have all the product entered in the shop now without model numbers, then upload all of them with new model numbers, you will have duplicate products.

 

if you have the complete product list downloaded with easy populate, you can try this.

*****************************************

First, backup your database using something like phpMyAdmin or the osC backup just in case.

*****************************************

then you can clear all your products by running the following script in phpMyAdmin.

then you can import your products with model numbers using easy populate.

 

DELETE FROM `products`;
DELETE FROM `products_attributes`;
DELETE FROM `products_attributes_download`;
DELETE FROM `products_description`;
DELETE FROM `products_notifications`;
DELETE FROM `products_options`;
DELETE FROM `products_options_values`;
DELETE FROM `products_options_values_to_products_options`;
DELETE FROM `products_to_categories`;
ALTER TABLE `products` AUTO_INCREMENT = 1;
ALTER TABLE `products_attributes` AUTO_INCREMENT = 1;
ALTER TABLE `products_description` AUTO_INCREMENT = 1;
ALTER TABLE `products_options_values_to_products_options` AUTO_INCREMENT = 1;

 

there is a more complete script available if you need orders, manufacturer, customers, etc. cleaned up.

 

if you have any problems with this you can restore the backup and try something else.

Link to comment
Share on other sites

okay then, it looks like i will go ahead with what you are suggesting (and I do want to keep orders, customers etc.) I just want to make sure of a few things first:

 

EP can handle HTML descriptions ok without any problems right?

 

How do I enable product attributes with EP? they are currently set to 'false' so when i download a file they are not included, obviously deleting them would loose them as they are not in my EP file.

 

How do I reduce the Category depth to 2 instead of 3?

 

and when I go to EP in the Admin section of my site even though Excel Safe Output is set to true it says 'Field seperator: comma' will my descriptions interfer with this? or does Excel safe output stop that from happening?

 

 

thankyou, youve been ssoooooooooo helpful so far, I thought I would never get Ep to work :)

Link to comment
Share on other sites

Hi,

 

I've a problem downloading all the attributes, for example if I've the following attributes:

 

- size

- color

- type

- extra

- other

 

In the $attributes_options_select I've filled in all the above attributes: size, color, type, extra, other

 

But for some reason I can only download the 'size' attribute and all other attributes doesn't download.. I want to download this so I can make a default file, which I can easily update.. Is there something I'm doing wrong or forgot to do.. because I really can't get it working.. Hope someone could help me out..

 

BTW I'm using Easy Populate 2.76d

Link to comment
Share on other sites

EP can handle HTML descriptions ok without any problems right?

yes. there has been a bug reported for php vers 4.3.4+ and early versions of php 5. if the your data field starts with a double quote, it's not handled correctly. there is a fix for that.

 

How do I enable product attributes with EP? they are currently set to 'false' so when i download a file they are not included, obviously deleting them would loose them as they are not in my EP file.

set that to true and it should work.

How do I reduce the Category depth to 2 instead of 3?

check the settings in easypopulate.php.

 

and when I go to EP in the Admin section of my site even though Excel Safe Output is set to true it says 'Field seperator: comma' will my descriptions interfer with this? or does Excel safe output stop that from happening?

that's OK. true CSV format (which is what I was trying to accomplish) quotes all the fields so commas in the field should not hurt anything. Asside from the issue mentioned above, all special characters should be handled correctly.

Link to comment
Share on other sites

Hi,

 

I've a problem downloading all the attributes, for example if I've the following attributes:

 

- size

- color

- type

- extra

- other

 

In the $attributes_options_select I've filled in all the above attributes: size, color, type, extra, other

 

But for some reason I can only download the 'size' attribute and all other attributes doesn't download.. I want to download this so I can make a default file, which I can easily update.. Is there something I'm doing wrong or forgot to do.. because I really can't get it working.. Hope someone could help me out..

 

BTW I'm using Easy Populate 2.76d

so you've set this:

$attribute_options_select = array('size', 'color','type','extra','other');

and those are exactly the same names as in the database (case sensitive)

I just looked at the code and ran a test with 2.76d and all seems to be OK. I don't see any php or mysql versions issues in that code.

Link to comment
Share on other sites

Just tried to do it hard code.. but also doesn't work.. really don't know what to do.. or what I'm doing wrong..

if you don't have php globals problems, you may consider trying the version I uploaded. There is some confusion about what v2.76d is since the other uploaders didn't give their work a unique version number. all the settings are in the easypopulate file not the admin.

Link to comment
Share on other sites

yes. there has been a bug reported for php vers 4.3.4+ and early versions of php 5. if the your data field starts with a double quote, it's not handled correctly. there is a fix for that.

set that to true and it should work.

 

check the settings in easypopulate.php.

that's OK. true CSV format (which is what I was trying to accomplish) quotes all the fields so commas in the field should not hurt anything. Asside from the issue mentioned above, all special characters should be handled correctly.

 

thankyou surfalot, it worked great ! :D

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...