Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Easy Populate & Products Attributes


VJ

Recommended Posts

I don't know if this will help anyone - but I was getting the double slash lines error (as indicated in some prior posts) in my error messages that indicated the file or directory could not be found. I had created a TEMP folder in the Catalog folder. And then I had edited the easypopulate.php lines to read:

$tempdir = "/catalog/temp/";

$tempdir2 = "/catalog/temp/";

 

Well it was doubling up the catalog portion of the address and looking for catalog//catalog/temp.....

 

So I changed the lines to:

$tempdir = "/temp/";

$tempdir2 = "/temp/";

 

And it works great!!

 

Good luck.

Link to comment
Share on other sites

taking a look at your data, it is set at semicolon delimited. when you opened it up in excel, you should have been prompted for a format of the data.

also check your easypopulate.php file to make sure it is set at tab delimited and not semicolon delimited.

 

Excellent! My easypopulate.php was defaulting to semicolon delimited. I had not changed this setting, so apparently the downloaded file is set this way (even though it says in the comment code that tab delimited is the default setting). The tab delimited line was commented out in my file and the semicolon delimited line was active.

 

Thanks so much for the fast response - now I can proceed!!

Link to comment
Share on other sites

you will probably have problems down the road, set the document_root to how i asked, set the temp to /catalog/temp/ and then all will be fine.

 

Excellent! My easypopulate.php was defaulting to semicolon delimited. I had not changed this setting, so apparently the downloaded file is set this way (even though it says in the comment code that tab delimited is the default setting). The tab delimited line was commented out in my file and the semicolon delimited line was active.

 

Thanks so much for the fast response - now I can proceed!!

Link to comment
Share on other sites

I'm trying to import a CSV file that i've exported from another shop. I've set the delimiter in easypopulate.php, and i've read the instructions... I proceeded with the upload and got this:

 

File uploaded.

Temporary filename: /tmp/phpmgrifC

User filename: export121205.txt

Size: 10107665

 

Brilliant! I thought, but when I examined the product table, there was nothing in it. I expected it to throw an error, so to find this message and nothing in the product table was surpising. Has anyone had anything like this before?

 

thanks in advance.

 

John

Link to comment
Share on other sites

open excel first, then from there select 'file, open' and choose your file, you will then be prompted.

 

When I open the file in excel there is no prompts! Can someone tell me what is wrong because I'm a total novice! Thanks!
Link to comment
Share on other sites

did you first try exporting data to see what you get?

what is your temp file setting?

what is document_root set to in your admin/includes/configure.php? this one is critical.

 

I'm trying to import a CSV file that i've exported from another shop. I've set the delimiter in easypopulate.php, and i've read the instructions... I proceeded with the upload and got this:

 

File uploaded.

Temporary filename: /tmp/phpmgrifC

User filename: export121205.txt

Size: 10107665

 

Brilliant! I thought, but when I examined the product table, there was nothing in it. I expected it to throw an error, so to find this message and nothing in the product table was surpising. Has anyone had anything like this before?

 

thanks in advance.

 

John

Link to comment
Share on other sites

Thanks Mibble, that solved the problem!

 

But there's another problem now! :( I open the file okay in Excel but when I have added to it and saved it - and then uploaded it again, it just says:

 

File uploaded.

Temporary filename: /tmp/phpM2tUwK

User filename: EP2005Dec13-1604.txt

Size: 52616

 

And when I click on the store nothing has been updated!

 

What am I doing wrong? :(

Edited by mystifier_uk
Link to comment
Share on other sites

did you first try exporting data to see what you get?

what is your temp file setting?

what is document_root set to in your admin/includes/configure.php? this one is critical.

 

John

 

When I choose "Download Complete tab-delimited .txt file to edit" (I think that's what you meant)

I get a string of comma separated fields, but no data:

 

v_products_model,v_products_image,v_products_name_1,v_products_description_1,v_p

roducts_url_1,v_products_price,v_products_weight,........,EOREOR

 

My temp setting in easypopulate.php is now the complete path from the root of my server to the /catalog/temp/ directory. It was just /catalog/temp/ but after this didn't work and I read someone's notes advising this, I changed it.

 

There doesn't appear to be a document_root variable in /catalog/admin/includes/configure.php just lines like the following:

 

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/');

 

Thanks

 

john

Link to comment
Share on other sites

check your easypopulate.php file, see if it is set for semicolon delimited or tab delimited, needs to be tab delimited.

 

Thanks Mibble, that solved the problem!

 

But there's another problem now! :( I open the file okay in Excel but when I have added to it and saved it - and then uploaded it again, it just says:

 

File uploaded.

Temporary filename: /tmp/phpM2tUwK

User filename: EP2005Dec13-1604.txt

Size: 52616

 

And when I click on the store nothing has been updated!

 

What am I doing wrong? :(

Link to comment
Share on other sites

the configure.php will look like this:

<?php

/*

$Id: configure.php,v 1.14 2003/02/21 16:55:24 dgw_ Exp $

 

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Copyright © 2002 osCommerce

 

Released under the GNU General Public License

*/

 

// define our webserver variables

// FS = Filesystem (physical)

// WS = Webserver (virtual)

define('HTTP_SERVER', ''); // eg, http://localhost or - https://localhost should not be NULL for productive servers

define('HTTP_CATALOG_SERVER', '');

define('HTTPS_CATALOG_SERVER', '');

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

define('DIR_FS_DOCUMENT_ROOT', $DOCUMENT_ROOT); // where your pages are located on the server. if $DOCUMENT_ROOT doesnt suit you, replace with your local path. (eg, /usr/local/apache/htdocs)

define('DIR_WS_ADMIN', '/admin/');

define('DIR_FS_ADMIN', DIR_FS_DOCUMENT_ROOT . DIR_WS_ADMIN);

define('DIR_WS_CATALOG', '/catalog/');

define('DIR_FS_CATALOG', DIR_FS_DOCUMENT_ROOT . DIR_WS_CATALOG);

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/');

 

// define our database connection

define('DB_SERVER', '');

define('DB_SERVER_USERNAME', 'mysql');

define('DB_SERVER_PASSWORD', '');

define('DB_DATABASE', 'osCommerce');

define('USE_PCONNECT', 'false');

define('STORE_SESSIONS', '');

?>

 

thus until this is corrected no telling what you will get. also check your easypopulate.php file make sure it is set to tab delimited and NOT to semicolon.

 

John

 

When I choose "Download Complete tab-delimited .txt file to edit" (I think that's what you meant)

I get a string of comma separated fields, but no data:

 

v_products_model,v_products_image,v_products_name_1,v_products_description_1,v_p

roducts_url_1,v_products_price,v_products_weight,........,EOREOR

 

My temp setting in easypopulate.php is now the complete path from the root of my server to the /catalog/temp/ directory. It was just /catalog/temp/ but after this didn't work and I read someone's notes advising this, I changed it.

 

There doesn't appear to be a document_root variable in /catalog/admin/includes/configure.php just lines like the following:

 

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/');

 

Thanks

 

john

Link to comment
Share on other sites

John

 

The middle part of the configure.php file now looks like this:

 

// Define the webserver and path parameters

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

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

define('HTTP_SERVER', 'http://oscommerce.tagish.net'); // eg, http://localhost - should not be empty for productive servers

define('HTTP_CATALOG_SERVER', 'http://oscommerce.tagish.net');

define('HTTPS_CATALOG_SERVER', '');

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

define('DIR_FS_DOCUMENT_ROOT', '/usr/local/apache/home/oscommerce.tagish.net/htdocs/'); // where the pages are located on the server

define('DIR_WS_ADMIN', '/catalog/admin/');

define('DIR_FS_ADMIN', DIR_FS_DOCUMENT_ROOT . DIR_WS_ADMIN);

define('DIR_WS_CATALOG', '/catalog/');

define('DIR_FS_CATALOG', DIR_FS_DOCUMENT_ROOT . DIR_WS_CATALOG);

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/');

 

Unfortunately, I still can't upload my CSV file.

 

Regards

 

John

Link to comment
Share on other sites

most likely because of this:

define('DIR_FS_DOCUMENT_ROOT', '/usr/local/apache/home/oscommerce.tagish.net/htdocs/'); // where the pages are located on the server

should be as stated in the docs:

define('DIR_FS_DOCUMENT_ROOT', $DOCUMENT_ROOT)

 

your temp still needs to be /catalog/temp/

 

on another note, why are you using a subweb? you will get more responses from the main web (tagish) than you will oscommerce.tagish

Edited by Mibble
Link to comment
Share on other sites

check your easypopulate.php file, see if it is set for semicolon delimited or tab delimited, needs to be tab delimited.

 

I've done that and it seems to work - you've done it again Mibble!

 

Now I am assuming that you just have to insert information into the columns of the empty fields and save it as a text file (delimited) when in Excel? Because when I do that and upload it again nothing happens! :blink:

Link to comment
Share on other sites

Hello,

 

I just installed Easy Populate 2.76b and it works perfect! It's really usefull. But i have a problem, i've installated a stock contribution, all my stock depends on every size and some attributes. For example, i've a 42 size shoe with attribute x=2,y=3 and every one the same. I've installated in my data base a new field called products_stock that depends on product_stock_id, products_id, product_stock_attributes, products_stock_quantity (all primary keys). And i'd like being able to modify that trough easy populate.

 

Anybpody knows the solution?

 

Thanks,

 

ivax23

Link to comment
Share on other sites

most likely because of this:

define('DIR_FS_DOCUMENT_ROOT', '/usr/local/apache/home/oscommerce.tagish.net/htdocs/'); // where the pages are located on the server

should be as stated in the docs:

define('DIR_FS_DOCUMENT_ROOT', $DOCUMENT_ROOT)

 

your temp still needs to be /catalog/temp/

 

on another note, why are you using a subweb? you will get more responses from the main web (tagish) than you will oscommerce.tagish

 

Is '/usr/local/apache/home/oscommerce.tagish.net/htdocs/' not the same as $DOCUMENT_ROOT?

 

We are using a sub-domain as the site is a shared server, it houses many sites. In this case the oscommerce.tagish.net site is simply used as a test to get the site up and running. Eventually, however, the live site will also be on a sub-domain, so it needs to operate in this environment.

Link to comment
Share on other sites

take a look at admin/tools/server info and search for document_root

 

John

 

I've managed to get it working, it's importing everything into the products table just fine... Thanks for your help. It didn't mind having: /usr/local/apache/home/oscommerce.tagish.net/htdocs/ set instead of $DOCUMENT_ROOT, but it didn't like the full path to the temp directory. It started working once I set them back to /catalog/temp/.

 

However, the next problem is that it isn't populating the products_description table. I've tracked the problem to around here (around line 1778):

 

// the following is common in both the updating an existing product and creating a new product

if ( isset($v_products_name)){

foreach( $v_products_name as $key => $name){

 

The condition for the if statement is met, but nothing seems to happen with the iteration of the array, and it drops straight back out of the if statement never running the code to populate the products_description table.

 

has anyone come across this before?

 

John

Link to comment
Share on other sites

it will still hiccup down the road as you have an extra slash at the end. as i stated take a look at admin/tools/server info and search for document root, compate the path there with what you have. it is different.

Link to comment
Share on other sites

it will still hiccup down the road as you have an extra slash at the end. as i stated take a look at admin/tools/server info and search for document root, compate the path there with what you have. it is different.

 

DOCUMENT_ROOT=/usr/local/apache/home/oscommerce.tagish.net/htdocs

 

I have now altered the 'DIR_FS_DOCUMENT_ROOT' in configure.php to reflect this.

 

I can now update data to populate the products table, but it will not populate the products_description table.

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