Easy Populate 1.2.5.4 support

[Soniccc]

Hi! Does anyone know if Easy Populate is able to handle Swedish language signs like å ä ö ???

//Jacob

[chadderuski]

Hi! Does anyone know if Easy Populate is able to handle Swedish language signs like å ä ö ???

//Jacob

Technically, yes. But you should check the collation of your databases. If you use OpenOffice, and export your txt file (Save As "Text CSV") and then check "Edit Filter Settings" before pressing the save button, then you will get the option to choose your Character Set.

Perhaps the best way to test this is to add a test product with the charaters you need to support, export that via EP, and open with OO. USE OO and excel tends to mess things up my experience. Export from OO with a compatible character set (UTF-8?) and then re-import via EP.

Let us know how that worked.

[paulcreedy]

Easypopulate stopped working.

I upload the cvs
It tells me it's uploaded, but doesn't show on screen that it's done any updates.
No products get updated or added.

Any idea as to what that could be?

[dropbop]

Hey guys,

I need to be able to export a file to the temp folder, but i need the file to be the same name each time becuase I want it to be downloaded by ftp each day. FTP will be set to run at a specific time every day to download a file of a particular name.

I was looking in the admin/easypopulate.php file to see if there was somehting there to give me a clue as to how/where the filename is generated.

I found this line of code..

header("Content-disposition: attachment; filename=$EXPORT_TIME.txt");

on line 1072, which gets its info from this..

	//$EXPORT_TIME=time();
	$EXPORT_TIME = strftime('%Y%b%d-%H%I');
	switch ($ep_dltype) {
		case 'full':
		$EXPORT_TIME = "Full-EP" . $EXPORT_TIME;
		break;
		case 'priceqty':
		$EXPORT_TIME = "PriceQty-EP" . $EXPORT_TIME;
		break;
		case 'category':
		$EXPORT_TIME = "Category-EP" . $EXPORT_TIME;
		break;
		case 'froogle':
		$EXPORT_TIME = "Froogle-EP" . $EXPORT_TIME;
		break;
		case 'attrib':
		$EXPORT_TIME = "Attributes-EP" . $EXPORT_TIME;
		break;
	}

online 1046 to 1064.

If I was to change

 $EXPORT_TIME = "Full-EP" . $EXPORT_TIME;

to

$EXPORT_TIME = "myfilename";

would that work without screwing anything up.

Or am I way off the mark completly @@

Cheers

DB

[Soniccc]

K. Thanks, I'll try that!

Technically, yes. But you should check the collation of your databases. If you use OpenOffice, and export your txt file (Save As "Text CSV") and then check "Edit Filter Settings" before pressing the save button, then you will get the option to choose your Character Set.

Perhaps the best way to test this is to add a test product with the charaters you need to support, export that via EP, and open with OO. USE OO and excel tends to mess things up my experience. Export from OO with a compatible character set (UTF-8?) and then re-import via EP.

Let us know how that worked.

[NiallO58]

Hi, been using easy populate for only a day now. Ive installed it fine and I populated my database once using it and everything went perfectly. But now when ever I try populate it again it doesn't work, when I upload the file it says that it has been uploaded successfully but nothing seems to upload when you go to the webpage!

Can anybody help me with this please?

[dropbop]

Hi Niall058,

Ar eyou sure you are using the right file format.. EP 1.2.5.4 uses Tab Delimited .txt files. If you using a newer version of EP then you need to save your files as Comma Delimited .csv format.

Sometimes thats overlooked, so thought I woul dmention it.

If your still having trouble with it, download one the the newer versions of EP and install it. Make sure to change the temp directory name in ADMIN > CONFIGURATION > EASY POPULATE.

Another thing you shoudl check is the size of the file your trying to imort, if it has a ton of products in it, it may be taking a long time ro import and timing out.. Maybe break the file down into 2 files if this is the case.

OR... You could try using ftp to upload the file to the temp directory public_html/temp/ and import it from there by typing in the filename into the last input box on the EP page in admin.

Also, just to be on the safe side you could check th error logs and see if they can tell you anything.

[dropbop]

For anyone wondering something similar, just do as below and that way you can edit the export file name to one of your choosing.. great if you need to have same file name all the time if linking with other scripts/programs.

:)

Hey guys,

I need to be able to export a file to the temp folder, but i need the file to be the same name each time becuase I want it to be downloaded by ftp each day. FTP will be set to run at a specific time every day to download a file of a particular name.

I was looking in the admin/easypopulate.php file to see if there was somehting there to give me a clue as to how/where the filename is generated.

I found this line of code..

header("Content-disposition: attachment; filename=$EXPORT_TIME.txt");

on line 1072, which gets its info from this..

	//$EXPORT_TIME=time();
	$EXPORT_TIME = strftime('%Y%b%d-%H%I');
	switch ($ep_dltype) {
		case 'full':
		$EXPORT_TIME = "Full-EP" . $EXPORT_TIME;
		break;
		case 'priceqty':
		$EXPORT_TIME = "PriceQty-EP" . $EXPORT_TIME;
		break;
		case 'category':
		$EXPORT_TIME = "Category-EP" . $EXPORT_TIME;
		break;
		case 'froogle':
		$EXPORT_TIME = "Froogle-EP" . $EXPORT_TIME;
		break;
		case 'attrib':
		$EXPORT_TIME = "Attributes-EP" . $EXPORT_TIME;
		break;
	}

online 1046 to 1064.

If I was to change

 $EXPORT_TIME = "Full-EP" . $EXPORT_TIME;

to

$EXPORT_TIME = "myfilename";

would that work without screwing anything up.

Or am I way off the mark completly @@

Cheers

DB

[Serious]

ZC v1.39H
ER v1.2.5.4

I updated my tab delimited txt file (excel '07). and saved the work I did (deleted 3 characters from a product description, that's it).
Uploaded to my host (temp/) and tried to import and insert via the admin panel.

I get this:

Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, [email protected] and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

After trying uploading a copy that I confirmed was good by using it on my local host I got the same result.

Debug file reads as follows:

[26-Feb-2011 15:55:35] PHP Warning: file(/home/seriouso/public_html/temp/SOPMasterv2) [<a href='function.file'>function.file</a>]: failed to open stream: No such file or directory in /home/seriouso/public_html/SeriousAdmin/easypopulate.php on line 1201
[26-Feb-2011 15:55:35] PHP Warning: Invalid argument supplied for foreach() in /home/seriouso/public_html/SeriousAdmin/easypopulate.php on line 1279

So I download a copy of the file and compared it to the same file on my PC, the two lines listed in the Debug report are identical.

So know i turn yo you good people for a compass, a mile marker, a Town Cryer......

What do I check next?

[Serious]

Can anyone please offer some insight.

I'm still having the same problem and really could use a little (or a lot) of help.