If this is your first visit, check our documentation. To post, register or login.
Forums / Addon Admin Tools / Easy Populate 1.2.5.4 support

Easy Populate 1.2.5.4 support

Started by langer on 9 May 2006, 9:44 PM · Views: 1,303,108

Results 181 to 200 of 3,834
8 Aug 2006, 5:44 PM
#181
langer avatar

langer

Totally Zenned

Join Date:
Aug 2004
Location:
Sydney, Australia
Posts:
1,258
Plugin Contributions:
1

Easy Populate 1.2.5.4 support

it will be the same cause - tabs in your descriptions. Since tabs are the column delimiter, whay Easy Populate "thinks" is the category, and what is the category are not the same. You need to get rid of all tabs in fields.

Tell me, are you using Excel? And do the column headings have a text delimiter (eg double quote) around them?? If not, try saving with a text delimiter. Better yet, do it with openoffice - this may save the day

9 Aug 2006, 2:26 AM
#182
apinkpony11 avatar

apinkpony11

Zen Follower

Join Date:
Aug 2006
Posts:
112
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Hi All...

I was able to upload Easy Populate up to the point of going to /my_admin/easypopulate.php?langer=install ... but it just goes to a blank page!

I tried doing it in both IE and Firefox (my default) to no availability. I know my server should fully support it, so I don't really know whats up. I'm a PHP/server n00b, so, excuse me there, but I at least can usually get fundementals like this done...

9 Aug 2006, 2:50 AM
#183
langer avatar

langer

Totally Zenned

Join Date:
Aug 2004
Location:
Sydney, Australia
Posts:
1,258
Plugin Contributions:
1

Re: Easy Populate 1.2.5.4 support

what EP version is it?

9 Aug 2006, 3:04 AM
#184
apinkpony11 avatar

apinkpony11

Zen Follower

Join Date:
Aug 2006
Posts:
112
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Um... i believe its 2.74a...

9 Aug 2006, 4:12 AM
#185
zenned avatar

zenned

Zen Follower

Join Date:
Dec 2005
Posts:
119
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

how much is easy populate advanced?

Is it FREE??

9 Aug 2006, 4:18 AM
#186
apinkpony11 avatar

apinkpony11

Zen Follower

Join Date:
Aug 2006
Posts:
112
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

No. I think the advanced version is $50 dollars. But I'm sure you could find that out on, a website...

9 Aug 2006, 4:20 AM
#187
apinkpony11 avatar

apinkpony11

Zen Follower

Join Date:
Aug 2006
Posts:
112
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Yeah, I really wish someone had an answer, I'd really like to get started using Easy Populate :-\

9 Aug 2006, 4:25 AM
#188
zenned avatar

zenned

Zen Follower

Join Date:
Dec 2005
Posts:
119
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

50.00 wow!!

9 Aug 2006, 6:04 AM
#189
langer avatar

langer

Totally Zenned

Join Date:
Aug 2004
Location:
Sydney, Australia
Posts:
1,258
Plugin Contributions:
1

Re: Easy Populate 1.2.5.4 support

apinkpony11:

Um... i believe its 2.74a...
This is the buggy osCommerce port and is not supported. Suggest you try 1.2.4.

The problem is probably php 5 or register_globals.

9 Aug 2006, 6:05 AM
#190
langer avatar

langer

Totally Zenned

Join Date:
Aug 2004
Location:
Sydney, Australia
Posts:
1,258
Plugin Contributions:
1

Re: Easy Populate 1.2.5.4 support

zenned:

50.00 wow!!
which means?!?

9 Aug 2006, 6:08 AM
#191
apinkpony11 avatar

apinkpony11

Zen Follower

Join Date:
Aug 2006
Posts:
112
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Hmm...

Well I guess the one i downloaded from modhole.com was the 1.2.5.4, BASED on the 2.74a (sorry, I guess I read that wrong), and the only other one I see is the 2.75 version...

9 Aug 2006, 7:06 AM
#192
lcoombes avatar

lcoombes

New Zenner

Join Date:
Aug 2006
Posts:
7
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

apinkpony11:

Hi All...

I was able to upload Easy Populate up to the point of going to /my_admin/easypopulate.php?langer=install ... but it just goes to a blank page!

I tried doing it in both IE and Firefox (my default) to no availability. I know my server should fully support it, so I don't really know whats up. I'm a PHP/server n00b, so, excuse me there, but I at least can usually get fundementals like this done...

i had a similar problem, but after checking loads of things, it turns out I'd copied the wrong php file in the wrong directory. Try downloading and unzipping again, and copy all the files over really carefully in the directories - it worked for me!

9 Aug 2006, 8:32 AM
#193
thespunkylobster avatar

thespunkylobster

New Zenner

Join Date:
Sep 2005
Posts:
23
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

langer:

it will be the same cause - tabs in your descriptions. Since tabs are the column delimiter, whay Easy Populate "thinks" is the category, and what is the category are not the same. You need to get rid of all tabs in fields.

Tell me, are you using Excel? And do the column headings have a text delimiter (eg double quote) around them?? If not, try saving with a text delimiter. Better yet, do it with openoffice - this may save the day

I've got there now :)

Was already using OpenOffice, but what I've done is take the culprit descriptions, copy/paste them into writer, remove all tabs with find/remove, and paste them back in again, and we're all good once more :)

Thanks for all the help langer.

9 Aug 2006, 10:23 AM
#194
woodymon avatar

woodymon

Totally Zenned

Join Date:
Sep 2004
Posts:
2,309
Plugin Contributions:
1

Re: Easy Populate 1.2.5.4 support

Hi Langer & DrByte-

Thanks for previous follow-ups and explanation of date fields. Still somewhat uncertain about date/time stamp formatting support but decided only way to really find out is to test.

So attempted uploading tab-delimited text file via EP but observing error. My actions and observations follow:

In Admin > Tools > Easy Populate
Attempted to "Upload EP file" from local client
After browsing for file I clicked "insert into db" button

Resulting webpage at:
http://www.mydomain.com/shop/admin/easypopulate.php?split=0

Shows following Error:

406 Not Acceptable
Not Acceptable
An appropriate representation of the requested resource /shop/admin/easypopulate.php could not be found on this server.

Uncertain if the shop being down for "web maintenance" would be issue, so I tested by disabling web maintenance , even though I already have my client IP listed under Down For Maintenance (exclude this IP-Address).

Then atemtpted to upload but with same error.

So via FTP uploaded text file to /temp.
Via Admin > Tools > Easy Populate >
"Import from Temp Dir (temp/)"
I entered just the filename Within edit text box.

Resulting page:
http://www.mydomain.com/shop/admin/easypopulate.php

I received same error as above.

Sidenote: This appears to be same error I observe whenever patching the database via the large text edit box form via Config > Tools > Install SQL patches (admin/sqlpatch.php). However on same form page I can browse for location of my sql patch files and successfully upload and patch the db just fine.

Same error using Firefox 1.5.0.6 and IE6
I've ensured the temp directory and files within are chmod 777
I checked Apache Error log and no errors.

I see in this thread on 3rd June 2006, mooo11 reported similar issue (but he did not follow-up). I see langer reported on 05 June 2006 that mooo11's report was the first on this issue and provided Google search URL. I just searched and so many references to Apache server configuration and not sure where to start.
At http://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html, under Hypertext Transfer Protocol -- HTTP/1.1 -- 10 Status Code Definitions -- 10.4.7 406 Not Acceptable

I see an explanation of "406 Not Acceptable" but unclear how this applies to EP uploads. Potential issue in possibly relates to "response entities which have content characteristics not acceptable according to the accept headers sent in the request" and "The entity format is specified by the media type given in the Content-Type header field. "

Wondering if this might be an .htaccess or mod_security config issue?

I see DrByte posted info below for someone having similar error when attempting a ZC install:

Originally posted by DrByte@Apr 3 2006, 07:42 AM
The faster way to do the same is:

  1. open zc_install folder via FTP
  2. rename the "htaccess_to_disable_mod_security" to ".htaccess"
  3. Try running zc_install again via the browser.

WOuld a similar change of my .htaccess in /shop/admin be recommended for the EP upload situation I am observing?

Running EP 1.2.5.4 (downloaded from modhole)
Zen Cart: 1.3.0.2 (fresh install)
PHP Version: 4.4.2 (Zend: 1.3.0)
MySQL version: 4.1.19-standard

Thanks,
Woody

9 Aug 2006, 10:49 AM
#195
woodymon avatar

woodymon

Totally Zenned

Join Date:
Sep 2004
Posts:
2,309
Plugin Contributions:
1

Re: Easy Populate 1.2.5.4 support

BTW I have tried EP upload with register globals both on and off.

Here's some more info on my server environment:

Linux 2.4.21-37.0.1.EL

Apache/1.3.36 (Unix)

Zend Engine v1.3.0,
ionCube PHP Loader v3.0.2,
Zend Extension Manager v1.0.8,
Zend Optimizer v2.5.10,

9 Aug 2006, 10:50 AM
#196
langer avatar

langer

Totally Zenned

Join Date:
Aug 2004
Location:
Sydney, Australia
Posts:
1,258
Plugin Contributions:
1

Re: Easy Populate 1.2.5.4 support

Woodymon:

406 Not Acceptable
Not Acceptable
An appropriate representation of the requested resource /shop/admin/easypopulate.php could not be found on this server.
This is a server issue. Your host may be able to resolve this.

The follwing in your .htaccess file might work:

<IfModule mod_security.c>
# Turn off mod_security filtering.
SecFilterEngine Off

# The below probably isn't needed, but better safe than sorry.
SecFilterScanPOST Off
</IfModule>
9 Aug 2006, 11:49 AM
#197
woodymon avatar

woodymon

Totally Zenned

Join Date:
Sep 2004
Posts:
2,309
Plugin Contributions:
1

Re: Easy Populate 1.2.5.4 support

langer:

This is a server issue. Your host may be able to resolve this.

The follwing in your .htaccess file might work:

<IfModule mod_security.c> # Turn off mod_security filtering. SecFilterEngine Off

The below probably isn't needed, but better safe than sorry.

SecFilterScanPOST Off
</IfModule>


Langer,

Very awesome. That worked.

So do you suggest this for a permanent solution (disabling mod_sec) or just temporary until my host can configure appropriately/differently?

EDIT: On second thought now I'm unable to access my hosting account. Via www, ftp or domain mail... OOPS!

Thus I cannot even upload my old .htaccess w/o above entries.

Woody
9 Aug 2006, 12:25 PM
#198
woodymon avatar

woodymon

Totally Zenned

Join Date:
Sep 2004
Posts:
2,309
Plugin Contributions:
1

Re: Easy Populate 1.2.5.4 support

Now I have access to www, ftp, pop, etc

But Zen Cart is down. When visitng the catalog home page I see:

http://www.mydomain.com/shop/nddbc.html

Sorry!
There seems to be a problem connecting to our database. Please give us a few minutes to remedy the problem. Thank you.

Then when I vist the admin login page I observe DB errors.

EDIT: OK the db is now connecting and Zen Cart is back up on both catalog and admin side.

Just alerted my host of this issue. So anyone think my change to .htaccess with the following http upload and the immediate thereafter server crash was just a coincidence?

BTW with the server now back up I now see all my new products uploaded successfully with EP!!

Woody

9 Aug 2006, 12:39 PM
#199
woodymon avatar

woodymon

Totally Zenned

Join Date:
Sep 2004
Posts:
2,309
Plugin Contributions:
1

Re: Easy Populate 1.2.5.4 support

langer:

This is a server issue. Your host may be able to resolve this.
As an update all services are normal, and host support just reported they would work with me to resolve mod_security issues. Still wondering if my .htaccess change crashed the server. If so, big oops, on my part. Going down a river which I do not know. ;-)

Woody

9 Aug 2006, 1:59 PM
#200
woodymon avatar

woodymon

Totally Zenned

Join Date:
Sep 2004
Posts:
2,309
Plugin Contributions:
1

Re: Easy Populate 1.2.5.4 support

Woodymon:

As an update all services are normal, and host support just reported they would work with me to resolve mod_security issues.

Final update on this (sorry to take up so much space in this thread on this issue but might help others): Host reported the server has been acting flaky of recent, and server crash was just likely a coincidence. Anyway they removed the mod_security rules affecting easypopulate HTTP POSTs, then had me remove the entries I made in my htaccess. And EP uploading is working well, so time to go back to the grind of loading data into the master spreadsheet.

And just downloaded the "ModSecurity for Apache UsersGuide" so I can learn more.

Thanks for the assist Langer!

Woody