BUG IN EASY POPULATE

[FINEGIFTS]

I have found a bug in easy populate when you go to update a file with over 600 products in it the file with not go into the data base with 1 new update i have tried several thing and well i made a new file with no products in it and walla i added 75 new products into the database i have not been able to get a file with over 300 to go either i have to break it into serveral files myself for the splitter on the mod does not split the file into 2 pieces. :roll: I dont know if any others are having this trouble if so please let me know so i am not feeling alone

[Qbaze]

Hi, this can be read in installation instructions for easy populate.

 

 

IMPORTANT: If you have more than 300 items to upload, READ THIS:

 

If you have more than 300 items, there is a good chance that php

will hit the 30 second time limit for script execution as

defined in the php.ini file. Those with their own server can edit the php.ini

file to allow longer run times. Figure 30 seconds per 300 items, more or less.

Those on shared servers where php.ini cannot be changed, don't dispair.

 

On the Easy Populate page, in the lower file browse box, hit browse and

get your file name in there. Then click the button marked "Upload and Split File".

 

This will upload the large file, and split it into smaller files of 300 records each.

 

These new files will be saved in the /catalog/temp directory, and will be named like this:

EP_Split1.txt, EP_Split2.txt, etc. You can download these, then upload them one at a time

in the normal way. No need to manually split the file.

 

If these files are still to large, you can change the $maxrecs in easypopulate.php to a smaller number.

This controls how many records are put into a single file when you Split it.

----------------------------------

 

 

Have you tryed that ? :roll:

 

Regards

Andreas

[FINEGIFTS]

yes i have tried that it will not work it just comes back to the screen realy fast it does not even give the file a chance

[Guest]

You may find that the problem is no the amount of records that you are trying to upload but more likely to be the size of the split file!!

 

I have found that if it is any larger than say about 45k then you may have problems, the server will breach the 30sec timeout limit set on it and the script will not fully execute.

 

try something that andreas suggested and alter your $maxrecs in easypopulate.php to a more manageable number to bring the filesixe down.

 

The reason i found this to be a problem was due to the length of some of my product descriptions.

 

there are a couple of threads on this in the contributions forum.

 

cheers

barry

[FINEGIFTS]

i have tried both methods now i set my php.ini to timeout to

max_execution_time = 60    ; Maximum execution time of each script, in seconds

and set the max when spliting to this

// if you are splitting files, this will set the maximum number of records to put in each file.

// if you set your php.ini to a long time, you can make this number bigger

//$maxrecs = 4; // for testing

$maxrecs = 300; // default, seems to work for most people.  Reduce if you hit timeouts

and it still does not work it just acts like it uploads and then loops me back to the page were i do to upload without no errors on the page or anything it sits there as if it were wanting me to upload the file?

[FINEGIFTS]

and when splitting it splits the files and still the files have 615 products each in them as well it makes the 2 files but the 2 files are identical it does not put 300 in each

[Guest]

what size is your tab delimited text file on your local machine?

 

cheers

barry

[FINEGIFTS]

the size of the text file is 150kb

[Guest]

splitting the file into 2 parts gives you 75k each so there may be a problem with the size of the file.

 

I found that a file size of around 40k was imported no problem.

 

As i did not write the code nor am i very experienced in php, i am unable to comment on what is going wrong. The only thing i can suggest is that you set the $maxrecs to either 100 or 150.

 

I assume that you are using easy populate 2.1 and that you know that the 2 buttons on easy populate do 2 different things entirely. The upload and split file only splits the file and leaves it in the temp directory, it does not import into the database. The other button does import into the database.

 

Due to the size of the descriptions i was using i could only have about 30 to 40 records in each file.

 

cheers

barry

[FINEGIFTS]

i can import around 300 products fine i will contrinue to do it the way i have now for the last few days i was just wondering if it was just me or not

[wasson65]

i can import around 300 products fine i will contrinue to do it the way i have now for the last few days i was just wondering if it was just me or not

 

There was a bug (it would upload but always produce one file) in the splitting code in 2.0 that was fixed in 2.1. You might try upgrading and see if that helps.

 

There is also some absolute limit that the split code will handle because of the max upload size that your server is set to handle, but that's generally on the order of a meg or 2, so isn't really a problem.

 

Sorry I missed your post until now, I try to get out to the forums every day and see what's up with EP.

 

Tim

[FINEGIFTS]

i am using 2.1 and it still makes 2 files but both files are the same both have the same products in them all 615 of them

[wasson65]

i am using 2.1 and it still makes 2 files but both files are the same both have the same products in them all 615 of them

 

Hmm, odd. Can you send me the file, or at least the top few lines? I'll try importing it and see what gives...

Tim