Jump to content
VJ

Easy Populate & Products Attributes

Recommended Posts

When trying to import new updates, i get this error:

 

User filename: summer2005 update.txt

Size: 7254

| 10 | 10.jpg | Harem - Ea | | 179 | 0,1 | 2005-05-01 | LR Interna | Summer 200 | Dufte | Summer Wom | Moms | Active Updated

| 11 11.jp | 12 12.jp | 13 13.jp | 181 181. | 2460 246 | 2461 246 | 2463 246 | 2464 246 | 78 78.jp | 79 79.jp | 80 80.jp | 81 81.jp | 82 82.jp | 2191 219 | 2304 230 | 2465 246 | 2466 246 | 2467 246 | 2469 246 | 4374 437 | 4378 437 | 4379 437 | 4402 440 | 4423 442 | 1931 193 | 1932 193 | 1934 193 | 1935 193 | 1936 193 | 1938 193 | 1940 194 | 1948 194 | 1949 194 | 1954 195 | 1293 129 | 4418 441 | 4419 441 | 4420 442 | 4421 442 | 4403 440 | 4404 440 | 4405 440 | 4406 440 | 4417 441 | 4424 442 | 844 844. | 843 843. | 1059 105 | 1061 106 | 1042 104 | 845 845. | 1258 125 |

 

Data file: datafile

 

My easypopulate is the newest full package from contribs. (v2.76)


Timo Jensen

Share this post


Link to post
Share on other sites

I am having trouble with inserting an updated file using Easy Populate. I have read through about 30 pages of threads. Thread 1367 was having the same issue as me. They responded as fixing the issue with two patches (thread 1379), but did not specify which ones.

 

Steps to reproduce problem:

(1) download complete tab-deblimited file -- contains only one product for testing

(2) make change to one product and add a few more

(3) insert into db using Easy Populate

 

Result:

The change in the first product is recorded, but the second product is not added in. Here is the easy populate insert message:

 

File uploaded.

Temporary filename: C:\DOCUME~1\Deke\LOCALS~1\Temp\phpE7.tmp

User filename: EP2005May09-1503.txt

Size: 2819

| 0501S1 | | Monday, Ma | Please pic | | | | | | | | 212.93 | 0 | | 0000-00-00 | 12 | 1 | Entree 1 | | | 1 | Cakes | | | 0 | 2 | Chips | | | 0 | 2 | Entree 2 | | | 5 | Cakes | | | 0 | 6 | Chips | | | 0 | 3 | Entree 3 | | | 4 | Entree 4 | | | 5 | Entree 5 | | | 6 | | | | | DBD Sessio | May Sessio | | Taxable Go | Active Updated

| 0501S1 | 0501S1 | 0508S1 |

 

Steps taken to fix this problem:

(1) check temp directory -- placed under catalog

(2) check temp variable in configure.php -- points to /catalog/temp/

(3) ensure temp folder is not read-only

(4) ensure EOREOR is at end of each excel row

 

Any help is much appreciated. I am using osCommerce 2.2, EP 2.76 - PHP 5.0.3.

 

Thanks,

Marty

Share this post


Link to post
Share on other sites

Can any one help!!

 

After seraching hi and lo found some info on it in the posts:

http://forums.oscommerce.com/index.php?sho...c=64945&st=1680

 

I have tried to add my new fields using this mannor and updated the easypopulate.php page, but every time I try to update a test range of products it just reverts back to my home page.

 

No errors displayed, just pushes to home page.

Also wanted to check the new fields I have created are called Brightness, Resolution and Lamp Life.

 

Does that mean I have to write the code in

products_brightness,
products_resolution,
products_lamp_life,

or

brightness,
resolution,
lamp_life,

Which is the right way 1st or the 2nd one?

 

Hope you can help!!!

Kunal

Share this post


Link to post
Share on other sites
Can any one help!!

I havea problem.

 

I can download the database to my temp directory but on uploading, using Easypopulate I get message -

File uploaded

40,000 bytes

 

(I can't remember the exact message from last night and the server is down this morning!)

 

I can find the uploaded file on the temp directory, but the database prices haven't changed.

 

Any ideas?

Share this post


Link to post
Share on other sites
OK Server back. The actual message is below-

 

File uploaded.

Temporary filename: /tmp/phpcxw2ap

User filename: totals.txt

Size: 41050

 

I can find totals.txt on the temp directory, not phpcxw2ap, and the database prices haven't changed.

 

Any ideas?

Share this post


Link to post
Share on other sites

I got an error because my temp file had two // so I went and deleted the temp file in in my file manager and tried to create a new temp file hoping that this will solve the problem but no such luck. So how do I get rid of the // ?? :'(

I really need some urgent help with this so any ideas would really be appreciated!


Pixy

One day at a time - we all have to learn

Share this post


Link to post
Share on other sites

Wow, I just came across this thread and it sounds like this tweak/mod would be very useful. Is this tweak/mod listed at a contrib? If so, where? If not, where can I get the most recent install instructions. I know the quick answer is this thread, but this thread has almost 1800 posts. If someone could point me to the right post or post the instructions again, I would greatly appreciate it.

 

Thanks in advance.

Share this post


Link to post
Share on other sites

I just copied it

 

<?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://papercrazy.co.za'); // eg, http://localhost - should not be empty for productive servers

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

define('ENABLE_SSL', false); // secure webserver for checkout procedure?

define('HTTP_COOKIE_DOMAIN', 'papercrazy.co.za');

define('HTTPS_COOKIE_DOMAIN', '');

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

define('HTTPS_COOKIE_PATH', '');

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

define('DIR_WS_HTTPS_CATALOG', '');

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

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

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

define('DIR_FS_CATALOG', '/usr/www/users/paperc/catalog/');

define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');

define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/');

 

// define our database connection

 

define('DB_SERVER', 'dedi4a.your-server.co.za'); // eg, localhost - should not be empty for productive servers

define('DB_SERVER_USERNAME', 'paperc_nos');

define('DB_SERVER_PASSWORD', 'XAbBbJXz');

define('DB_DATABASE', 'paperc_paperc_newoscomm');

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

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

 

/*

define('DB_SERVER', 'dedi4a.your-server.co.za');

define('DB_SERVER_USERNAME', 'paperc_os');

define('DB_SERVER_PASSWORD', 'XAbBbJXz');

define('DB_DATABASE', 'paperc_oscommerce');

define('USE_PCONNECT', 'false');

define('STORE_SESSIONS', '');

*/

?>


Pixy

One day at a time - we all have to learn

Share this post


Link to post
Share on other sites

that is not the correct one, need the admin/includes/configure.php

if those are you actual db name, password, etc you will now need to change them since you posted them

also, in store_sessions set that to 'mysql'


John Oligario

 

Knowledge Base Contributions

Share this post


Link to post
Share on other sites
click on contributions, it is listed in the right column

 

I have "Easy Populate v2.76 (15 Apr 2005)" already installed. Does this version already have the ability to download all of the attributes of an item, even those made with the "Product Attributes - Option Type Feature v1.71 (17 Nov 2004)" contrib?

Share this post


Link to post
Share on other sites
that is not the correct one, need the admin/includes/configure.php

if those are you actual db name, password, etc you will now need to change them since you posted them

also, in store_sessions set that to 'mysql'

 

I hope this is it?

 

<?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://papercrazy.co.za'); // eg, http://localhost - should not be empty for productive servers

define('HTTP_CATALOG_SERVER', 'http://papercrazy.co.za');

define('HTTPS_CATALOG_SERVER', '');

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

define('DIR_FS_DOCUMENT_ROOT', '/usr/www/users/paperc/catalog/'); // where the pages are located on the server

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

define('DIR_FS_ADMIN', '/usr/www/users/paperc/catalog/admin/'); // absolute pate required

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

define('DIR_FS_CATALOG', '/usr/www/users/paperc/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/');


Pixy

One day at a time - we all have to learn

Share this post


Link to post
Share on other sites

define('DIR_FS_DOCUMENT_ROOT', '/usr/www/users/paperc/catalog/'); // where the pages are located on the server

to

define('DIR_FS_DOCUMENT_ROOT', $DOCUMENT_ROOT);


John Oligario

 

Knowledge Base Contributions

Share this post


Link to post
Share on other sites
have you tried to download your products to see?

 

To be honest, on this site I'm still working with the original test database and haven't started uploading actual products yet. I did a test and yes, it already works.

 

Thanks your help.

Share this post


Link to post
Share on other sites
define('DIR_FS_DOCUMENT_ROOT', '/usr/www/users/paperc/catalog/'); // where the pages are located on the server

to

  define('DIR_FS_DOCUMENT_ROOT', $DOCUMENT_ROOT);

 

I do not follow any of that??

Should i go change the code ? can you give me more instructions? Sorry but I am not good with this at all. :blush:


Pixy

One day at a time - we all have to learn

Share this post


Link to post
Share on other sites
I do not follow any of that??

Should i go change the code ? can you give me more instructions? Sorry but I am not good with this at all. :blush:

 

THANK YOU!!!

It worked!! Thank you so much for your time! :thumbsup:


Pixy

One day at a time - we all have to learn

Share this post


Link to post
Share on other sites

Okay the file uploads and gives me this

File uploaded.

Temporary filename: /tmp/phpxdgOj0

User filename: EP2005May10-2008.txt

Size: 350012

But I do not see the products?


Pixy

One day at a time - we all have to learn

Share this post


Link to post
Share on other sites

you have something wrong with the data, post a few lines of your data here so we can see.

also try to do one or to lines of your products, see if it uploads properly.


John Oligario

 

Knowledge Base Contributions

Share this post


Link to post
Share on other sites

The only thing that I thought might be a problem is the images, they are on the system though?

This is from the txt file that I tried to import.

25849 25849.jpg Rub-ons Alphabet Mixed Large Muted "Say just about anything anywhere with the versatile Rub-ons Alphabet. Great for quick titles and more, use the enclosed applicator stick to transfer letters onto whatever surface you desire." 0 0 28/06/2005 00:00 06/06/2005 17:56 1000 1 Color 2 Size 3 Model 5 Value 6 43 mb 4 59 mb 5 Version 10 Download: Windows - English 13 Box: Windows - English Making Memories "Chalks, Rub-Ons and Paint" --none-- Active EOREOR

25846 25846.jpg Rub-ons Alphabet Mixed Large White "Say just about anything anywhere with the versatile Rub-ons Alphabet. Great for quick titles and more, use the enclosed applicator stick to transfer letters onto whatever surface you desire." 0 0 29/06/2005 00:00 07/06/2005 17:56 1000 1 Color 2 Size 3 Model 5 Value 6 44 mb 4 60 mb 5 Version 10 Download: Windows - English 13 Box: Windows - English Making Memories "Chalks, Rub-Ons and Paint" --none-- Active EOREOR


Pixy

One day at a time - we all have to learn

Share this post


Link to post
Share on other sites

I did and it still does not work


Pixy

One day at a time - we all have to learn

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

×