Jump to content
VJ

Easy Populate & Products Attributes

Recommended Posts

yours is answered 2 or 3 pages back, look for document_root, it needs to be changed in your admin/includes/configure.php

 

Can anyone help me figure out how to get my products loaded?

I am getting the following error message when using EP:

 

Warning: move_uploaded_file(/home/allaudio/public_html/catalog//catalog/temp/megagoods1.txt): failed to open stream: No such file or directory in /home/allaudio/public_html/catalog/admin/easypopulate_functions.php on line 32

 

Warning: move_uploaded_file(): Unable to move '/tmp/phpAzqyHJ' to '/home/allaudio/public_html/catalog//catalog/temp/megagoods1.txt' in /home/allaudio/public_html/catalog/admin/easypopulate_functions.php on line 32

File uploaded.

Temporary filename: /tmp/phpAzqyHJ

User filename: megagoods1.txt

Size: 248372

 

Warning: file(/home/allaudio/public_html/catalog//catalog/temp/megagoods1.txt): failed to open stream: No such file or directory in /home/allaudio/public_html/catalog/admin/easypopulate.php on line 666

 

Warning: Invalid argument supplied for foreach() in /home/allaudio/public_html/catalog/admin/easypopulate.php on line 689


John Oligario

 

Knowledge Base Contributions

Share this post


Link to post
Share on other sites

okay, I changed document_root in admin/includes/configure.php.

 

I get same error:

 

Warning: move_uploaded_file(/home/allaudio/public_html/catalog//catalog/temp/megagoods1.txt): failed to open stream: No such file or directory in /home/allaudio/public_html/catalog/admin/easypopulate_functions.php on line 32

 

Warning: move_uploaded_file(): Unable to move '/tmp/php8t3vfH' to '/home/allaudio/public_html/catalog//catalog/temp/megagoods1.txt' in /home/allaudio/public_html/catalog/admin/easypopulate_functions.php on line 32

 

 

File uploaded.

Temporary filename: /tmp/php8t3vfH

User filename: megagoods1.txt

Size: 248372

 

Warning: file(/home/allaudio/public_html/catalog//catalog/temp/megagoods1.txt): failed to open stream: No such file or directory in /home/allaudio/public_html/catalog/admin/easypopulate.php on line 666

 

Warning: Invalid argument supplied for foreach() in /home/allaudio/public_html/catalog/admin/easypopulate.php on line 689

Share this post


Link to post
Share on other sites

If I attempt to import from temp dir(/catalog/temp/) I get this error:

 

Filename: megagoods1.txt

 

Warning: file(/home/allaudio/public_html/catalog//catalog/temp/megagoods1.txt): failed to open stream: No such file or directory in /home/allaudio/public_html/catalog/admin/easypopulate.php on line 684

 

Warning: Invalid argument supplied for foreach() in /home/allaudio/public_html/catalog/admin/easypopulate.php on line 689

Share this post


Link to post
Share on other sites
post your admin/includes/configure.php file here, with what you are giving for a message there is no way it is right

<?php

/*

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Copyright © 2003 osCommerce

 

Released under the GNU General Public License

*/

 

// Define the webserver and path parameters

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

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

define('HTTP_SERVER', 'http://all-audio-all-video.com'); // eg, http://localhost - should not be empty for productive servers

define('HTTP_CATALOG_SERVER', 'http://all-audio-all-video.com');

define('HTTPS_CATALOG_SERVER', 'https://all-audio-all-video.com');

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

define('DIR_FS_DOCUMENT_ROOT', '/home/allaudio/public_html/catalog/'); // where the pages are located on the server

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

define('DIR_FS_ADMIN', '/home/allaudio/public_html/catalog/admin/'); // absolute pate required

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

define('DIR_FS_CATALOG', '/home/allaudio/public_html/catalog/'); // 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/');

 

// define our database connection

define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty for productive servers

define('DB_SERVER_USERNAME', 'allaudio_osc1');

define('DB_SERVER_PASSWORD', 'tt8QoZm8J{u3');

define('DB_DATABASE', 'allaudio_osc1');

define('USE_PCONNECT', 'false'); // use persisstent connections?

define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'

?>

Share this post


Link to post
Share on other sites

post your admin/includes/configure.php file, until you do, not much we can do to help. it is looking for an incorrect path is why i asked u to post it.


John Oligario

 

Knowledge Base Contributions

Share this post


Link to post
Share on other sites
post your admin/includes/configure.php file, until you do, not much we can do to help.  it is looking for an incorrect path is why i asked u to post it.

it's posted right above your post, but here it goes again with my changes:

 

<?php

/*

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Copyright © 2003 osCommerce

 

Released under the GNU General Public License

*/

 

// Define the webserver and path parameters

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

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

define('HTTP_SERVER', 'http://all-audio-all-video.com'); // eg, http://localhost - should not be empty for productive servers

define('HTTP_CATALOG_SERVER', 'http://all-audio-all-video.com');

define('HTTPS_CATALOG_SERVER', 'https://all-audio-all-video.com');

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

define('DIR_FS_DOCUMENT_ROOT', '/home/allaudio/public_html'); // where the pages are located on the server

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

define('DIR_FS_ADMIN', '/home/allaudio/public_html/catalog/admin/'); // absolute pate required

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

define('DIR_FS_CATALOG', '/home/allaudio/public_html/catalog/'); // 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/');

 

// define our database connection

define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty for productive servers

define('DB_SERVER_USERNAME', 'allaudio_osc1');

define('DB_SERVER_PASSWORD', 'tt8QoZm8J{u3');

define('DB_DATABASE', 'allaudio_osc1');

define('USE_PCONNECT', 'false'); // use persisstent connections?

define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'

?>

 

I thought this fixed the problem. I tried to load products again, and got a message stating the file had been uploaded. Then I went to the the catalog to view it, and there were no products. Then I went to admin/catalog and sure enough, it had not added a single product.

Share this post


Link to post
Share on other sites

now that you have posted with your db info, you need to change that.

 

this:

define('DIR_FS_DOCUMENT_ROOT', '/home/allaudio/public_html'); // where the pages are located on the server

needs to be:

define('DIR_FS_DOCUMENT_ROOT', $DOCUMENT_ROOT);


John Oligario

 

Knowledge Base Contributions

Share this post


Link to post
Share on other sites
now that you have posted with your db info, you need to change that.

 

this:

define('DIR_FS_DOCUMENT_ROOT', '/home/allaudio/public_html'); // where the pages are located on the server

needs to be:

define('DIR_FS_DOCUMENT_ROOT', $DOCUMENT_ROOT);

Okay, changed that. Here is what I get now:

 

File uploaded.

Temporary filename: /tmp/php3A05Pu

User filename: megagoods5.txt

Size: 57086

 

But, still no products present.

Share this post


Link to post
Share on other sites

That's the same mystery at my easypopulate. I also changed document_root to correct path like posted above, but no database changes.

Share this post


Link to post
Share on other sites

are you getting any errors now?

try loading one line, if it works, then move up a few more. you most likely have an error with the data.


John Oligario

 

Knowledge Base Contributions

Share this post


Link to post
Share on other sites
not really an easy since u didnt back up your db, you can install the attribute sort contribution

 

 

Yeah, I figured that's what I'd have to do. Not really a hassle, but I just like to get things working the way they're supposed to ;)

 

Even with the little quark, this is really one of the greatest contributions written so far :thumbsup:

Share this post


Link to post
Share on other sites
are you getting any errors now?

try loading one line, if it works, then move up a few more.  you most likely have an error with the data.

 

Here is what I am getting this morning with one line of data:

 

File uploaded.

Temporary filename: /tmp/php0oaPXo

User filename: test1.txt

Size: 3874

 

Warning: file(/home/allaudio/public_html/catalog/temp/test1.txt): failed to open stream: No such file or directory in /home/allaudio/public_html/catalog/admin/easypopulate.php on line 666

 

Warning: Invalid argument supplied for foreach() in /home/allaudio/public_html/catalog/admin/easypopulate.php on line 689

Share this post


Link to post
Share on other sites

this is line 666 in /home/allaudio/public_html/catalog/admin/easypopulate.php on line 666:

 

// get the entire file into an array

$readed = file(DIR_FS_DOCUMENT_ROOT . $tempdir . $usrfl_name);

}

 

this is line 689 in /home/allaudio/public_html/catalog/admin/easypopulate.php :

 

// now we string the entire thing together in case there were carriage returns in the data

$newreaded = "";

foreach ($readed as $read){

$newreaded .= $read;

 

Is there an error here, or somewhere else?

Share this post


Link to post
Share on other sites
are your file permissions on the /catalog/temp/ set at 777?

i just reinstalled the easy populate and now it appears to load products, but no data, no products:

 

File uploaded.

Temporary filename: /tmp/phpFLhTmt

User filename: test1.txt

Size: 3874

 

This was the result of attempting to load 1 product. Looks like it was uploaded, but there is no product.

 

Yes, permissions are set.

Edited by allaudio

Share this post


Link to post
Share on other sites

I tried to upload the downloaded file without any changes and a normal message appears. Afterwards I systematically checked for possible reasons for the errors and I found it: When I export the file in Excel like mentioned in the EP-manual as a tab-delimited textfile it doen't work. With the option csv (MS DOS) it works fine.

Reason is that only csv-option inserts semicolons. I hope this will help others too.

Share this post


Link to post
Share on other sites

I am fed up. I have spent 3 days trying to upload products and am no further than I was when I began. I did get 1 product to upload from the list of 28 that came in EP2005May29-2210 file with the EP contrib download. So, if the person that created the contribution can't provide a format that works with his contribution, how am I supposed to make it work on my product database?

Share this post


Link to post
Share on other sites
I am fed up. I have spent 3 days trying to upload products and am no further than I was when I began. I did get 1 product to upload from the list of 28 that came in EP2005May29-2210 file with the EP contrib download. So, if the person that created the contribution can't provide a format that works with his contribution, how am I supposed to make it work on my product database?

Be patient and a littlebit less offensive with the creator. He spent a lot of time here to help others just for "fun".

 

I spent weeks to make it work with all other contributions. It is possible that you have some code that incompatible or interfere with EP or have some configuration problem.

Share this post


Link to post
Share on other sites
Be patient and a littlebit less offensive with the creator. He spent a lot of time here to help others just for "fun".

 

I spent weeks to make it work with all other contributions. It is possible that you have some code that incompatible or interfere with EP or have some configuration problem.

 

Andrew,

 

I appreciate your concern, but I get no software support from my web host. osCommerce doesn't have a "manual" to speak of. And, this EP contribution seems to be just another extension of the nonsense way in which a person has to spend countless hours trying to get things running, when they ought to be spending their time marketing their product/service offerings. I assume everyone here has a product or service to market. Otherwise, why would you need osCommerce to begin with, much less EP. So, in a forum full of so called "business people, entrepreneurs, sales people, etc", why is it that we all want to spend so much time trying to develop and test technology? I am looking for a solution that allows me to plug it in, and get to selling. That's what I am here for. I don't know about the rest of you.

 

And, this EP doesn't work, just like osCommerce doesn't work. So many bugs and so much corruption, all I can do is keep reinstalling. And starting over. And reinstalling. And starting over. And it never works.

 

So, again Andrew, while I appreciate your concern, your energy would be better spent on a solution rather than commenting on my harsh criticisms of the developer of this contribution. After all, what is a contribution for? And what is this forum for? To help those of us poor numbskulls that just want to use the software that just doesn't seem to work.

 

The forum only really has 2 purposes: contribute or complain. Since I can't contribute anything, I'll just stick to complaining. Okay with you?

Share this post


Link to post
Share on other sites
are you getting any errors now?

try loading one line, if it works, then move up a few more.  you most likely have an error with the data.

 

So, how do you fix an error with the data? I tried to upload the sample inventory file that came with EP download. I got 1 product to load.

Share this post


Link to post
Share on other sites

Problem I see with error in data is that the EP doesn't know how to read product descriptions. I notice that my inventory file descriptions are read by Excel as multiple fields. It doesn't appear to matter whether it is saved as tab delimited, csv, or other format. The descriptions simply don't remain in one field, which throws the whole file off. Any fix? Anything I can do in Excel to fix this without manually eliminating tabs, returns, semicolons, etc in every product record? I have several thousand products I need to upload to my cart.

Share this post


Link to post
Share on other sites

What fields are required in the header? If I don't use attributes, etc. can those fields be deleted? Would having no data in certain fields prevent EP from uploading my data?

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×