Jump to content
VJ

Easy Populate & Products Attributes

Recommended Posts

I'm having an issue with easypopulate. I can download just fine edit and upload, but when I upload it says :

 

File uploaded.

Temporary filename: C:\PHP\uploadtemp\php2254.tmp

User filename: EP2006Sep08-1806fix2.xls

Size: 1520128

 

This doesn't look like an error message, but I'm not even sure were that file is stored and when I check OS the products are not there. It seems like it's uploading but not inserting? :blink:

 

I have double and triple checked my folder locations and permissions and even went so far as to force my server guy to make my entire server 100% writeable for a short time with still no luck.

 

Then, I added echos throughout the function to try and see where the hold up is as I am not getting any errors. I made it all the way to the last echo but the data is still not being inserted. I'm even having trouble locating were in the code the insert is, I'm assuming that it is in the walk function.

 

So it generally seems that everything is ok, there just is't anything being written to the database and no errors to tell me what's wrong. Anyone have anything on this?? at all?? I know I've seen others with the same problem but the ones that got fixed all seem to be folder related and I've eliminated this as a possibility, unless there is some hidden folder crazyness that I'm not thinking of.

 

double check you are not trying to upoad an EXCEL format file: I see an xls extension, and it should be a .txt

Share this post


Link to post
Share on other sites
double check you are not trying to upoad an EXCEL format file: I see an xls extension, and it should be a .txt

 

The example was a EXCEL format but I caught that and I am having the same problem with .txt.

Share this post


Link to post
Share on other sites
The example was a EXCEL format but I caught that and I am having the same problem with .txt.

 

 

could you post a few lines of your txt file?

Share this post


Link to post
Share on other sites
could you post a few lines of your txt file?

 

 

v_products_model v_products_image v_products_name_1 v_products_description_1 v_products_url_1 v_categories_name_1 v_categories_name_2 v_categories_name_3 v_categories_name_4 v_categories_name_5 v_categories_name_6 v_categories_name_7 v_tax_class_title v_status EOREOR

DDD0405 optv1.JPG "Option DVD Volume 1: ""Official D1 Round 1 at Irwindale USA""" "<b>Option Volume 1</b> <br><br> Features: <br><br> JDM Option: The D1 Grand Prix Professional Series Official Round 1 - Irwindale USA. The official D1 Grand Prix finally hits US shores. Round 1 of the 2004 Season, the intense battle for Series Points! Witness the spectacle of Japans pro drifters battle it out against Americas best pro drifters. This is the collectors edition of the event that stunned over 10 000 fans! Also includes a course introduction on board Katsuhiro Ueo's AE86. GM Factory Works Car: Pontiac GTO with Rhys Millen. Nomu-ken's crazy PIT WALK report. <br><br>english subtitles. <br><br>Run time: 60 minutes <br><br>Free Option sticker with purchase: <br><br><img src=""http://www.driftfactory.com/optionstick.jpg""> <br><br> Ships USPS 2 Day Priority Mail with delivery confirmation. <br><br> Shipping is only $2.00 for each additional DVD." Books & Videos DVDs - Videos JDM Option Option DVD Series Taxable Goods Active EOREOR

56012 lmfilters13.jpg Blitz LM Filter Kit Nissan 240SX S13 "<center>The BLITZ LM Intake System was design to reduce intake restriction and provide maximum filtration. The LM intake system was design to filter without any assistance of oil. (Oil can gradually disperse into the inlet tracks and coat walls of the air flow meter which can slowly reduce the performance of your vehicle.) <br><br>The LM system was also design with a replaceable filter element. Unlike any other conventional one piece filter, the LM intake's filter element can be replaced at any time. The LM filter element comes in 3 colors, black, orange and blue." RWD Nissan S13 Engine Taxable Goods Active EOREOR

14099A BOVhardspring.jpg Blitz Blow Off Valve Hard Spring For High Boost Applications <center>This Blitz BOV hard spring is recommended for up to 30+ pounds of boost. <br><br> Why Wait? Ships USPS 2 Day Priority Mail with delivery confirmation. Clearance Items Taxable Goods Inactive EOREOR

70994 ddsus.jpg Blitz Dual Drive BOV SUS Filter This is the Blitz replacement for the stainless steel SUS filter that goes on the Blitz dual drive blow off valve. Clearance Items Taxable Goods Inactive EOREOR

Share this post


Link to post
Share on other sites

I feel like such a tard. :blink:

 

EXCEL was saving the file as tab delimited but had the config set for semicolon. I am getting an upload error now but at least it is trying to insert. I'm going to review this thread again and see if there is a fix before I post the new error.

Share this post


Link to post
Share on other sites
I have set up a localhost site from scratch and installed a few other needed contributions. The last one I did was EasyPopulate and it went well. The only thing is that when I go to Admin, it doesn't do anything.

 

I have added 2 items to one catagory and tried to download a full db to edit but it doesn't do ANYTHING. I have also tried to upload my db from my live site but it doesn't work either.

 

What could the problem be???

 

I have gone over the installation step by step to confirm I didn't miss anything.

 

Thanks

 

Kelvin

Well it has been almost 3 weeks now since I posted the original request for help on this issue and I have not receive one response. Either it is something that is impossible to fix so no one wants to attempt to help me or I am invisible. lol

 

I have since added a new osCommerce test site to a subdirectory on my server and I have run into the same problem. When I try to download OR upload a txt file, the screen just seems to refresh itself.

 

Can anyone help me with this one PLEEEEAAAASSSSSEEEE.

 

Thank you

 

Kelvin

Edited by everyth5

Share this post


Link to post
Share on other sites
Well it has been almost 3 weeks now since I posted the original request for help on this issue and I have not receive one response. Either it is something that is impossible to fix so no one wants to attempt to help me or I am invisible. lol

 

I have since added a new osCommerce test site to a subdirectory on my server and I have run into the same problem. When I try to download OR upload a txt file, the screen just seems to refresh itself.

 

Can anyone help me with this one PLEEEEAAAASSSSSEEEE.

 

Thank you

 

Kelvin

 

Try to work on a real server, not local host to see if it works.

Share this post


Link to post
Share on other sites

Thank you John for responding. Firstly, I apologize if I sounded negative, but I have been passed over for so long and was getting frustrated. I tried daily to figure this problem out.

 

Anyway, here is the code from the configure.php file.

 

<?php
/*
 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com

 Copyright (c) 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://everything-asian.com'); // eg, http://localhost - should not be empty for productive servers
 define('HTTPS_SERVER', 'https://everything-asian.com'); // eg, https://localhost - should not be empty for productive servers
 define('ENABLE_SSL', false); // secure webserver for checkout procedure?
 define('HTTP_COOKIE_DOMAIN', 'everything-asian.com');
 define('HTTPS_COOKIE_DOMAIN', 'everything-asian.com');
 define('HTTP_COOKIE_PATH', '/aa-osctestsite/');
 define('HTTPS_COOKIE_PATH', '/aa-osctestsite/');
 define('DIR_WS_HTTP_CATALOG', '/aa-osctestsite/');
 define('DIR_WS_HTTPS_CATALOG', '/aa-osctestsite/');
 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', '/home/everyth5/public_html/aa-osctestsite/');
 define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');
 define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/');

 

And this is the temp settings in the easypopulate.php file.

 

$tempdir = "/public_html/aa-osctestsite/temp/";

$tempdir2 = "/public_html/aa-osctestsite/temp/";

 

 

Thank you so much for your help

 

Kelvin

Share this post


Link to post
Share on other sites
Try to work on a real server, not local host to see if it works.

 

This is on both a local server and a live server. Same results.

Share this post


Link to post
Share on other sites
Well it has been almost 3 weeks now since I posted the original request for help on this issue and I have not receive one response. Either it is something that is impossible to fix so no one wants to attempt to help me or I am invisible. lol

 

I have since added a new osCommerce test site to a subdirectory on my server and I have run into the same problem. When I try to download OR upload a txt file, the screen just seems to refresh itself.

 

Can anyone help me with this one PLEEEEAAAASSSSSEEEE.

 

Thank you

 

Kelvin

 

 

The file may be too big. Try turning off attributes and splitting the file before uploading. Otherwise, place some markers in the code next to the seperate functions and see how far along you get before it fails.

Edited by dfrb26dett

Share this post


Link to post
Share on other sites

I have to post again about my error. :( I got the file to attempt to upload but now it is telling me that the model number field is not in record.

 

No products_model field in record. This line was not imported

 

| | 369601VB | cusco_coil | | | | Accessorie | | | | | | | Taxable Go | Inactive

 

 

I have opened up the file and it appears to be ok.

 

 

v_products_model;v_products_image;v_products_name_1;v_products_description_1;v_p

roducts_url_1;v_categories_name_1;v_categories_name_2;v_categories_name_3;v_categ

ories_name_4;v_categories_name_5;v_categories_name_6;v_categories_name_7;v_tax_cl

ass_title;v_status;EOREOR;

90060GA;cusco_comp-s.jpg;;;;Accessories;;;;;;;Taxable Goods;Inactive;EOREOR;

369601VB;cusco_coiloverswagon1.jpg;;;;Accessories;;;;;;;Taxable Goods;Inactive;EOREOR;

36960EVL;cusco_coiloverswagon1.jpg;;;;Accessories;;;;;;;Taxable Goods;Inactive;EOREOR;

36960GA;cusco_coiloverscomps1.jpg;;;;Accessories;;;;;;;Taxable Goods;Active;EOREOR;

 

 

 

Does anyone know why this might be happening?

Share this post


Link to post
Share on other sites
I have to post again about my error. :( I got the file to attempt to upload but now it is telling me that the model number field is not in record.

 

No products_model field in record. This line was not imported

 

| | 369601VB | cusco_coil | | | | Accessorie | | | | | | | Taxable Go | Inactive

I have opened up the file and it appears to be ok.

v_products_model;v_products_image;v_products_name_1;v_products_description_1;v_p

roducts_url_1;v_categories_name_1;v_categories_name_2;v_categories_name_3;v_categ

ories_name_4;v_categories_name_5;v_categories_name_6;v_categories_name_7;v_tax_cl

ass_title;v_status;EOREOR;

90060GA;cusco_comp-s.jpg;;;;Accessories;;;;;;;Taxable Goods;Inactive;EOREOR;

369601VB;cusco_coiloverswagon1.jpg;;;;Accessories;;;;;;;Taxable Goods;Inactive;EOREOR;

36960EVL;cusco_coiloverswagon1.jpg;;;;Accessories;;;;;;;Taxable Goods;Inactive;EOREOR;

36960GA;cusco_coiloverscomps1.jpg;;;;Accessories;;;;;;;Taxable Goods;Active;EOREOR;

Does anyone know why this might be happening?

 

it looks like you have a semi-colon delimited file, double check that this is also the separator for your EP file

Edited by pixclinic

Share this post


Link to post
Share on other sites
it looks like you have a semi-colon delimited file, double check that this is also the separator for your EP file

 

I have the delimiter set to semicolon. Just verified again to make sure.

Share this post


Link to post
Share on other sites
I have the delimiter set to semicolon. Just verified again to make sure.

 

your product model data seems to go in the next field with EP, double check that you don't have an empty column 1 in your excel file

Share this post


Link to post
Share on other sites

Nope the column is full of model numbers. I've even counted the rows in the delimited file and hand checked that the eoreor is in place for each.

 

This is really tripping me out. It seems that there is no reason that it shouldn't work. I've even double checked my file to make sure that nothing got changed when I was trying to fix the other issue. It does seem as though there is an extra space in the first column after upload but I can figure why it's there as it doen't appear in the raw txt file.

Share this post


Link to post
Share on other sites
Nope the column is full of model numbers. I've even counted the rows in the delimited file and hand checked that the eoreor is in place for each.

 

This is really tripping me out. It seems that there is no reason that it shouldn't work. I've even double checked my file to make sure that nothing got changed when I was trying to fix the other issue. It does seem as though there is an extra space in the first column after upload but I can figure why it's there as it doen't appear in the raw txt file.

 

try to change your delimiter to tabs (\t) and see if things improve

Share this post


Link to post
Share on other sites
The file may be too big. Try turning off attributes and splitting the file before uploading. Otherwise, place some markers in the code next to the seperate functions and see how far along you get before it fails.

Why would the file be too big for my test sites (both online and locally) when it works fine on my live site???

Share this post


Link to post
Share on other sites

LAst I heard 2.76 was the last stable version. Overall the contribution has turned into a mess. I tried several but 2.76 was the latest one that worked.

Share this post


Link to post
Share on other sites
LAst I heard 2.76 was the last stable version. Overall the contribution has turned into a mess. I tried several but 2.76 was the latest one that worked.

 

It really depends on what mods you have installed in yoru store. (separate price per customer, multiple image, custom meta tags, etc...)

 

I personally use several versions depending on the site I'm working on, even a 3.0 can work when correctly configured :-)

Share this post


Link to post
Share on other sites

Im having a problem uploading Model/Price/Qty txt files after they are downloaded with EasyPopulate in the first place. I make 1 change to a price to see if it works and it doesnt change anything... Here's the error:

 

File uploaded.

Temporary filename: C:\PHP\uploadtemp\php2124.tmp

User filename: EP2006Sep15-1605.txt

Size: 11222

| 111113 | 10.95 | 1000 !New Product!

1136 - Column count doesn't match value count at row 1

 

INSERT INTO products ( products_image, products_image_med, products_image_lrg, products_image_sm_1, products_image_xl_1, products_image_sm_2, products_image_xl_2, products_image_sm_3, products_image_xl_3, products_image_sm_4, products_image_xl_4, products_image_sm_5, products_image_xl_5, products_image_sm_6, products_image_xl_6, 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 ( '',", "", "", "", "", "", "", "", "", "", "", "", "", "", " '111113', '10.95', '1', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, NULL, '', '', '1000', 'NULL')

 

[TEP STOP]

 

I have a few mods installed including Some 6 image mod with htmlarea, Linkmatics Attribute Sets, Who's Online Enhancement, Skype Us mod, CVV mod, plus a couple of others that i cant remember right now...

 

Anyone got any ideas? It's not tab based, not eoreor based, not permissions based or any of those other simple solutions... would a Windows Server be at fault here? Im so sick of them now, im changing to Linux at the next problem that arises...

Edited by sonictrip.net

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

×