HELP!! Getting Errors When Trying To Use Easy Populate...

[mxtc]

HELP!!

I've got tons of products that I need to upload like yesterday, and when I try to download my test product using Easy Populate (so I have a template to work from when uploading new products), it says Internet Explorer cannot open site.

So, I tried just using the "Open In TEMP File" option, and I get the following errors on an error page:

Warning: fopen(/home/motocros/public_html/members/teststore//temp/EP2004Dec01-1402.txt): failed to open stream: No such file or directory in /home/motocros/public_html/members/teststore/admin/easypopulate.php on line 590

Warning: fwrite(): supplied argument is not a valid stream resource in /home/motocros/public_html/members/teststore/admin/easypopulate.php on line 591

Warning: fclose(): supplied argument is not a valid stream resource in /home/motocros/public_html/members/teststore/admin/easypopulate.php on line 592
You can get your file in the Tools/Files under /temp/EPEP2004Dec01-1402.txt

Please can someone help me out? I'm about to go crazy, because I've got time restrictions and need to get the store up (needed it up by today).

Thanks a Million,
MxTC

[red_fraggle]

problem is either:

A: you have 2 "//" in the url which tells me in your configure.php file you have 2 "//" where there should only be one. see > /teststore//temp/EP2004Dec01

B: chmod the temp folder to 777 so the easypopulate script can write the file to it before opening.

[groggory]

I have the same problem. Ever since my catalog has grown to about 1100 items, I have problems downloading from easy populate.

The only fix I've found is to move from IE to firefox. For some reason firefox handles it but IE won't

Give it a try, might work for you. Don't know why, but it works.

GL!

[inmotion]

I have found a fix for this. I too was having the problem where IE would error upon trying to download the easy populate csv. It seems Internet Explorer needs a different block of code for handling the creation of downloadable csv files:

Here's the fix:

Open /catalog/admin/easypopulate.php

REPLACE:

//*******************************
// STREAM FILE
//*******************************
header("Content-type: application/vnd.ms-excel");
header("Content-disposition: attachment; filename=$EXPORT_TIME.txt");
header("Pragma: no-cache");
header("Expires: 0");
echo $filestring;
die();

WITH:

//*******************************
// STREAM FILE
//*******************************
$imh_filename = $EXPORT_TIME.'.csv';
$imh_mime_type = 'text/x-csv';
header('Content-Type: ' . $imh_mime_type);
header('Expires: 0');
if (strpos($_SERVER["HTTP_USER_AGENT"],'MSIE')!==false)
{
header('Content-Disposition: inline; filename="' . $imh_filename . '"');
header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
header('Pragma: public');
} else
{
header('Content-Disposition: attachment; filename="' . $imh_filename . '"');
header('Pragma: no-cache');
echo $filestring;
die();

Hope this helps.

[inmotion]

Doing a bit more digging aroun, it seems there is an even easier fix for this. Download the new version of easy populate 2.76c from the osCommerce main site, and it has a fix in it that is only a few lines long.

Basically, replace:

//*******************************
// STREAM FILE
//*******************************
header("Content-type: application/vnd.ms-excel");
header("Content-disposition: attachment; filename=$EXPORT_TIME.txt");
header("Pragma: no-cache");
header("Expires: 0");
echo $filestring;
die();

with:

//*******************************
// STREAM FILE
//*******************************
header("Content-type: application/vnd.ms-excel");
header("Content-disposition: attachment; filename=$EXPORT_TIME.txt");
// Changed if using SSL, helps prevent program delay/timeout (add to backup.php also)
//      header("Pragma: no-cache");
if ($request_type== 'NONSSL'){
header("Pragma: no-cache");
} else {
header("Pragma: ");
}
header("Expires: 0");
echo $filestring;
die();

Man do I love wild goose chases! But if anyone is having trouble getting some other CSV download code to work, take a look above, becuase that is a sure fire fix.