Easy Populate 1.2.5.4 support

[apinkpony11]

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...

[lcoombes]

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!

[TheSpunkyLobster]

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.

[Woodymon]

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/e...te.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

[Woodymon]

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,

[langer]

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>

[Woodymon]

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

[Woodymon]

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

[Woodymon]

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

[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