8796 replies to this topic

[asher1981]

Hello Everybody,

I have installed Easy Populate v 2.76i 2009/08/02 everything is working fine.
The only Problam I have is, that additional Images and the corresponding html_descriptions are not shown in the CSV file.
Only the first product image is listed for every product.

EP_Products_Images is true;
EP_Products_Images_MAX is 6;

What´s wrong?

[mmeachm]

Settings & Info

EP vers: 2.76i-231
osCommerce Online Merchant v2.3
OS: Array
HTTP:
DB:
PHP: Array (Zend: )

Temp Directory:
/home/hitechpo/public_html/temp/
Temp Dir is Writable
Magic Quotes is: off
register_globals is: off
Split files on: 300 records
Model Num Size: 16
Price with tax: false
Calc Precision: 2
Replace quotes: false
Field seperator: comma
Excel safe output: true
Preserve tab/cr/lf: false
Category depth: 7
Enable attributes: true
SEF Froogle URLS: false

Other Support:
MVS Support: false
Products Images: false
Additional Images: false
Additional Images: false
More Pics: false
UltraPics Pics: false
HTC: false
SPPC: true
Extra Fields: true
PDF Upload: false
Master Products: false
HTTP Server: Apache/2.2.20 (Unix) mod_ssl/2.2.20 OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 PHP Version: 5.3.6 (Zend: 2.3.0)
Server OS: Linux 2.6.18-194.11.4.el5PAE Database: MySQL 5.0.92-community


The error message I keep receiving on uploads is:
File uploaded.
Temporary filename: /tmp/phphylNPC
User filename: technology2.csv
Size: 606585
1062 - Duplicate entry '3778-1' for key 1

INSERT INTO manufacturers_info( manufacturers_id, manufacturers_url, languages_id ) VALUES ( 3778, '', '1' )

[TEP STOP]

This began when I implemented extra fields in the products_description table. The uload seemed to work fine for a while, then this error message began.


Any help appreciated.

[geoffreywalton]

Have you got 2 manufacturers in your input file where the first 32 characters are the same and then after that there is a difference?

That would cause that I suspect.

HTH

G

[offie]

Hi, I see many people are asking the same question without much of a reply.

Basically I also have just noticed that if I load my items with lots of attributes only the item gets loaded and no attributes at all.

I have run a test with only one item. I gave it lots of attributes via admin and saved them. I then downloaded that item to my computer with all attributes in place. I checked the downloaded CSV file to make sure everything was there, it was. I then deleted the item from my store. I then uploaded the item again via Easy Populate with all the attributes on the CSV file but it loaded without 1 single attribute.

When I click "Insert into database" I get the file uploaded message and it also shows all the attributes in the list below this but they have not loaded.

Does anybody know why this may happen?

What does load is the item title, the price, the description if any and the image but no attributes.

Thanks and fingers crossed.

Michael

[mmeachm]

No, I am loading files with several manufacturers, but having the first 32 characters match with the balance different doesn't appear to be the case. I will get this message on the first upload entry. If I wait 30 seconds and try again, it will upload a number of items before the error message is repeated. I have confirmed my space allocated in the tables is large enough. The problem began when I created extra fields to upload. I would have thought the error message would be related to that, but it isn't the case. I've checked my syntax in the easypopulate.php file around line 298, I believe, where the upload logic occurs and it seems fine. All my php is properly terminated, etc., so I'm baffled. One other thing to consider is that I originally created two extra fields. This worked fine as well. When I decided to consolidate them into one field, handling the concatentaion via Excel prior to the upload, the error began. However, I deleted the unneeded field from my SQL files, redid the ine in easypopulate.php, and changed the settings in Administrator. Since that's when the error first occurred, I assumed I had done something wrong there, but I've rechecked my work a dozen times, and it all seems right.

[geoffreywalton]

The error is around code like this

		    // 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 = '" . tep_db_input($v_manufacturers_name) . "'";
			    $result = tep_db_query($sql);

If your manufactures name field is 32 you could try trim ing the field and restricting the length of tep_db_input($v_manufacturers_name) to that length cos it aint finding it in the db.

HTH

G

[offie]

geoffreywalton, on 19 November 2011, 12:44, said:

The error is around code like this

			// 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 = '" . tep_db_input($v_manufacturers_name) . "'";
				$result = tep_db_query($sql);

If your manufactures name field is 32 you could try trim ing the field and restricting the length of tep_db_input($v_manufacturers_name) to that length cos it aint finding it in the db.

HTH

G

Hi GeoffreyWalton, sorry to trouble you like this but I have been reading through the posts again today and you seem to be the only person who is helping out others at the moment so I was wondering if you knew of an answer to the post I sent a couple of messages back? #8644.

I have a whole load of footwear items to load to my store with many colour and size attributes so I really need to get to the bottom of my attributes not loading correctly and any help would be a massive favour.

Thanks

Michael

[geoffreywalton]

Michael

I guess you are using a version that does not load attributes, sorry don't know one that does. With a bit of work I am sure they can be repaired.

Wish I could be more encouraging.

Cheers

G

[offie]

geoffreywalton, on 21 November 2011, 13:05, said:

Michael

I guess you are using a version that does not load attributes, sorry don't know one that does. With a bit of work I am sure they can be repaired.

Wish I could be more encouraging.

Cheers

G

Thanks for the quick reply, I knew you would be helpful.

I am sure myself that I have used an earlier version which worked so I guess I will have to do a trial and error sequence until I get there. I will update here if I do manage it so it will help others.

Thanks again for your help

Michael

[gaspower]

Hello,
Sorry, have tried to locate a resolve for this issue on this topic forum, but could not find one. I am getting the following error. Also I have below the error put all my details. If someone could give me some help, I would appreciate it.

Size: 489
| 10135 | Engine Mou | Engine Mou | 10135.jpg | 7.95 | 3.98 | 1 | 0.3 | 11/24/2011  10:06:00 PM | 34040.jpg | Car Parts | 34328.jpg | 2011 Series | DBBA | Taxable Go | Active Updated
1136 - Column count doesn't match value count at row 1
INSERT INTO products_groups VALUES ( 1, 3.98, 301 )

Below are my details:

Settings & Info
EP vers: 2.77a
osCommerce Online Merchant v2.3
OS: Array
HTTP:
DB:
PHP: Array (Zend: )

Temp Directory:
/home/virtual/site1/fst/var/www/html/temp/
Temp Dir is Writable
Magic Quotes is: off
register_globals is: on
Split files on: 300 records
Model Num Size: 12
Price with tax: false
Calc Precision: 2
Replace quotes: false
Field seperator: tab
Excel safe output: false
Preserve tab/cr/lf: false
Category depth: 4
Enable attributes: false
SEF Froogle URLS: false

Other Support:
MVS Support: false
Additional Images: false
More Pics: false
UltraPics Pics: false
Unlimited Images: false
HTC: false
SPPC: true
Extra Fields: false
PDF Upload: false
Quick Backup Enabled: true

----------
Operating System: Windows 7 Home / Excel 2010

-----------

Upload File Attached

Thanks Jr

Attached Files

•  upload_sample.zip   434bytes   0 downloads

[gaspower]

Hello,

I think I have found my issue. Current table layout for products_groups is,

customers_group_id | smallint(5) unsigned | NO | PRI | 0 | |
| customers_group_price | decimal(15,4) | NO | | 0.0000 | |
| products_id | int(11) | NO | PRI | 0 | |
| products_qty_blocks | int(4) | YES | | 1 | |
| products_min_order_qty

I no longer have SPPC quantity discounts installed. So I believe I need to drop from table products_qty_blocks, and products_min_order_qty columns. Is this correct?

Thanks Jr

[TheJackal]

Hi All,

Need to ask for some ideas as I am stumped.

My installation worked for over 5 years..and for some reason, it throws up an upload error. After I choose the file, and click insert, it says

File uploaded.
Temporary filename:
User filename: EPBAC111.txt
Size: 0

The file just won't upload. I've checked the epconfigure.php settings and temp folder and the file is not there. The temp folder is 777 permission. If I ftp manually, everything is good to go. Would be grateful if anyone has any idea to solve the upload error.

[AronJeney]

I receive an error message when switching any of the "Other Contributions Support" from false to true:

1054 - Unknown column 'p.products_image_description' in 'field list'

SELECT p.products_id as v_products_id, p.products_model as v_products_model, p.products_image as v_products_image, p.products_image_description as v_products_image_description, p.products_price as v_products_price, p.products_weight as v_products_weight, p.products_date_available as v_date_avail, 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 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

[TEP STOP]



Do I have to adjust anything or add to my DB? Apologies if this is answered somewhere, I have read through the documentation and searched through all relative forum posts but can not find anything like this issue. Thanks in advance!

[GoTTi]

hi i am having a issue....

i installed a fresh copy of the oscommerce 2.3 and EP. when i go to import the products, it seems to be doing them fine. but it is not adding the items to the item list, either on the front or admin area of the cart.

the items show up however on the main page of the store, but they arent listed at all in a category on the left panel, or inside admin under products.

how do i get them to show up? what did i do wrong? thanks.

[FloridaAquaFarm]

I am having an issue where whenever I upload my CSV file it seems the v_products_image does not load the link.

It takes me to /images/ folder.

Any suggestions?

[velvetpixel]

FloridaAquaFarm, on 27 December 2011, 01:02, said:

I am having an issue where whenever I upload my CSV file it seems the v_products_image does not load the link.

It takes me to /images/ folder.

Any suggestions?

Did you upload your image files via FTP the /catalog/images directory?
If so are premissions correct on them?

Did you put references to those images in the v_products_image column?

v_products_image
someimage.jpg
otherimage.jpg
prettypicture.jpg

Edited by velvetpixel, 27 December 2011, 01:11.

[finskaus]

Hello all,

I am not so experienced in working with the OSC, but still manage to make it what I intended:)

Now I have a problem, I do not know if it is possible through the "Excel populate" and insert the special prices in addition to the ordinary price.

I need just to insert following data:

Name
Picture
Regular price
Special price

Thanks in advance.

Boki

[gotboost350z]

Hey guys,

for some reason i have a csv that works but when i use the exact same format i get a weired error on this. an i havent done anything different from any other time should this be reinstalled?

here is the error

No products_model field in record. This line was not imported: | que Soluti | 05,,,24,1, | SCB | 508,Inacti | 05,,,24,1, | SCB | 510,Inacti | SCB | 511,Inacti | 07,,,24,1, | SCB | 512,Inacti | 02,,,24,1, | SCB | 600,Inacti | 11,,,24,1, | SCB | 601,Inacti | SCB | 602,Inacti | 99,,,24,1, | SCB | 603,Inacti | SCB | 604,Inacti | 10,,,24,1, | SCB | 605,Inacti | 06,,,24,1, | SCB | 606,Inacti | 06,,,24,1, | SCB | 700,Inacti | 05,,,18,1, | SCB | 701,Inacti | 03,,,18,1, | SCB | 800,Inacti | 99,,,18,1, | SCB | 801,Inacti | 00,,,18,1, | SCB | 802,Inacti | 00,,,18,1, | SCB | 803,Inacti | 05,,,18,1, | SCB | 804,Inacti | 11,,,18,1, | SCB | 900,Inacti | 11",,,24,1 | SCB | 901,Inacti | 11,,,24,1, | SH | 001,Inacti | SR | 012,Inacti | 07,,,199,2 | SR | 012F,Inact | 07,,,112,3 | SR | 012R,Inact | 07,,,112,1 | SS | 001,Inacti | 11,,,99,2, | SS | 002,Inacti | 08,,,90,2, | SS | 003,Inacti | 11,,,90,2, | SS | 004,Inacti | 2009,,,90, | SS | 005,Inacti | 11,,,99,2, | SS | 006,Inacti | 11,,,99,2, | SS | 007,Inacti | 11,,,117,2 | SS | 008,Inacti | 11,,,117,2 | SS | 009,Inacti | 11,,,99,2, | SS | 010,Inacti | 07,,,72,2, | SS | 011,Inacti | 2001 Impre | SS | 012,Inacti | IX 2001 | 2006,,,99, | SS | 013,Inacti | 2007,,,99, | SS | 014,Inacti | 08,,,99,2, | SS | 015,Inacti | SS | 016,Inacti | SS | 017,Inacti | 2008,,,31, | SSBB | 017,Inacti | 2008,,,45, | SSK | 001,Inacti | 11,,,143,1 | SU | 006,Inacti | SU | 011,Inacti | SU | 012,Inacti | 2011 WRX / | 2009 Legac | SU | 0124,Inact | 11,,,29,1, | SU | 0125,Inact | 11,,,36,2, | SU | 012L,Inact | 2011 WRX / | 2009 Legac | SU | 015,Inacti | 2007 Impre | SU | 0154,Inact | SU | 015L,Inact | 2007 Impre | SU | 111,Inacti | SU | 123,Inacti | 2011,,,436 | SU | 200,Inacti | 11,,,202,4 | SU | 250,Inacti | 2011,,,364 | SU | 300,Inacti | 2011,,,162 | SU | 500,Inacti | 2011 WRX), | SU | 501,Inacti | SU | 502,Inacti | SU | 503,Inacti | SU | 504,Inacti | SU | 507,Inacti | SU | 600,Inacti | 2007 , For | 08",,,35,1 | SU | 666,Inacti | 11,,,27,1, | SU | DSB,Inacti | SU | PSK,Inacti | 2007, Suba | 2007",,,31 | SU | PSK2,Inact | 2011,,,31, | SU | Rear,Inact | 2011 WRX / | TC | 001,Inacti | 10,,,117,1 | TC | 002,Inacti | 12,,,117,3 | TM | 350,Inacti | 2009 Nissa | UNI | 001,Inacti | UNI | 002,Inacti | UNI | 003,Inacti | UNI | 004,Inacti | UNI | 005,Inacti | XB | 002,Inacti | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |

[geoffreywalton]

gotboost350z, on 04 January 2012, 00:43, said:

Hey guys,

for some reason i have a csv that works but when i use the exact same format i get a weired error on this. an i havent done anything different from any other time should this be reinstalled?

here is the error

No products_model field in record. This line was not imported: | que Soluti | 05,,,24,1, | SCB | 508,Inacti | 05,,,24,1, | SCB | 510,Inacti | SCB | 511,Inacti | 07,,,24,1, | SCB | 512,Inacti | 02,,,24,1, | SCB | 600,Inacti | 11,,,24,1, | SCB | 601,Inacti | SCB | 602,Inacti | 99,,,24,1, | SCB | 603,Inacti | SCB | 604,Inacti | 10,,,24,1, | SCB | 605,Inacti | 06,,,24,1, | SCB | 606,Inacti | 06,,,24,1, | SCB | 700,Inacti | 05,,,18,1, | SCB | 701,Inacti | 03,,,18,1, | SCB | 800,Inacti | 99,,,18,1, | SCB | 801,Inacti | 00,,,18,1, | SCB | 802,Inacti | 00,,,18,1, | SCB | 803,Inacti | 05,,,18,1, | SCB | 804,Inacti | 11,,,18,1, | SCB | 900,Inacti | 11",,,24,1 | SCB | 901,Inacti | 11,,,24,1, | SH | 001,Inacti | SR | 012,Inacti | 07,,,199,2 | SR | 012F,Inact | 07,,,112,3 | SR | 012R,Inact | 07,,,112,1 | SS | 001,Inacti | 11,,,99,2, | SS | 002,Inacti | 08,,,90,2, | SS | 003,Inacti | 11,,,90,2, | SS | 004,Inacti | 2009,,,90, | SS | 005,Inacti | 11,,,99,2, | SS | 006,Inacti | 11,,,99,2, | SS | 007,Inacti | 11,,,117,2 | SS | 008,Inacti | 11,,,117,2 | SS | 009,Inacti | 11,,,99,2, | SS | 010,Inacti | 07,,,72,2, | SS | 011,Inacti | 2001 Impre | SS | 012,Inacti | IX 2001 | 2006,,,99, | SS | 013,Inacti | 2007,,,99, | SS | 014,Inacti | 08,,,99,2, | SS | 015,Inacti | SS | 016,Inacti | SS | 017,Inacti | 2008,,,31, | SSBB | 017,Inacti | 2008,,,45, | SSK | 001,Inacti | 11,,,143,1 | SU | 006,Inacti | SU | 011,Inacti | SU | 012,Inacti | 2011 WRX / | 2009 Legac | SU | 0124,Inact | 11,,,29,1, | SU | 0125,Inact | 11,,,36,2, | SU | 012L,Inact | 2011 WRX / | 2009 Legac | SU | 015,Inacti | 2007 Impre | SU | 0154,Inact | SU | 015L,Inact | 2007 Impre | SU | 111,Inacti | SU | 123,Inacti | 2011,,,436 | SU | 200,Inacti | 11,,,202,4 | SU | 250,Inacti | 2011,,,364 | SU | 300,Inacti | 2011,,,162 | SU | 500,Inacti | 2011 WRX), | SU | 501,Inacti | SU | 502,Inacti | SU | 503,Inacti | SU | 504,Inacti | SU | 507,Inacti | SU | 600,Inacti | 2007 , For | 08",,,35,1 | SU | 666,Inacti | 11,,,27,1, | SU | DSB,Inacti | SU | PSK,Inacti | 2007, Suba | 2007",,,31 | SU | PSK2,Inact | 2011,,,31, | SU | Rear,Inact | 2011 WRX / | TC | 001,Inacti | 10,,,117,1 | TC | 002,Inacti | 12,,,117,3 | TM | 350,Inacti | 2009 Nissa | UNI | 001,Inacti | UNI | 002,Inacti | UNI | 003,Inacti | UNI | 004,Inacti | UNI | 005,Inacti | XB | 002,Inacti | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |

This indicates the product model field is blank so it cant find which product to update.

Check your input file.

HTH

G

Edited by geoffreywalton, 04 January 2012, 09:11.

[gotboost350z]

my csv file has the v_product_model field an for some unknown reason it just wont populate, i can build files and an it works jus fine, but when i go to import is jus says that there is No products_model field in record. which makes no sense like there is an issue with permissions or something.

here is a link to a a csv file

http://workaholicstudios.com/trans/csv.jpg