Jump to content
VJ

Easy Populate & Products Attributes

Recommended Posts

My actual problem is that I can't upload using my version of 2.76 EP with QTpro support. I recently switched hosting company and my new host uses php5/mysql5. I've been encountering a lot of problems trying to figure out what will work on php5/mysql5. All of my installed contributions have been giving me errors and warning messages since I switched. So I was trying to figure out what my best course of action would be to get everything back to normal.

Share this post


Link to post
Share on other sites
I've looked and haven't been able to find a solution to what I think is a pretty basic problem regarding CSV imports and attributes.

 

If I download a CSV file using EP, then change the price of a product option (attribute) and import the CSV back in, everything seems to go fine. I get no errors and the message tells me that the product has been updated. I can even see the new price in the appropriate field on the admin page after the import. When I go to the store however, the old price is still there - no change.

This happens with new products as well. On import, everything appears to be fine and I can see all the appropriate fields on the admin page. When I go to the store, the new product is there but no attributes.

I think this is the last piece I need to make my 3000+ item store run silky smooth. Can anyone help?

 

Here's what my settings say:

EP vers: 2.76f-MS2 r1

Temp Dir:

/home/.ruri/lichius/stfrancisdesales.com/newsite/catalog/temp/

Temp Dir is Writable

Magic Quotes is: off

register_globals is: off

Split files on: 300 records

Model Num Size: 12

Price with tax: false

Calc Precision: 2

Replace quotes: false

Field seperator: comma

Excel safe output: true

Preserve tab/cr/lf: false

Category depth: 7

Enable attributes: true

SEF Froogle URLS: false

More Pics: false

Unknown Pics: false

HTC: false

SPPC: false

Extra Fields: false

 

I am using the Option-Type contrib as well. Could that be having an effect?

Thanks!

 

I'm not sure exactly how I did it, but I did manage to get this working. For anyone else having the same trouble, I deleted all of the options, option values, and attributes via the admin panel and re-uploaded everything using the CSV file. It didn't work at first but once I started recreating the options on the admin side (being sure to match all the ID numbers with those in my CSV file), subsequent uploads started populating products and options the way I was expecting them to.

Eh- I think i just got lucky this time...

Share this post


Link to post
Share on other sites
Hi,

 

Is there already a solution for the 'move product' issue?

I still cannot find Easy Populate very useful when there is no such thing as a 'move product' feature.

 

When I move my product on my sheet Easy Populate will duplicate this product into the new assigned category.

if you are using one of my latest versions, you can use a delete status to remove from one cat, then on a second line, or subsequent import, add back the product to the moved-to cat.

Share this post


Link to post
Share on other sites
Hi could one of you point me to the version of easy populate that will work with ms2.2 rc2a please.

I don't see any significant changes in the database, any version that suits your contribution updates should be fine.

my latest version seems to be the most stable.

Share this post


Link to post
Share on other sites
I've installed EP 2.76 sucsessfully, but the exported .csv file is not "tabbed" into columns. What's the problem?

 

v2.76 doesn't have .csv support, you must have meant one of the sub-versions. CSV is Comma Separated Values. No tabs. should open with excel in columns. please see the manual if you would like to change the settings to tab separators.

Share this post


Link to post
Share on other sites

I've installed 2.76, and working the export and import function, BUT when I import data (the changed Pric)e , the message is

 

"Array Updated"

 

but no change in the database !!!!! what's the problem?

Share this post


Link to post
Share on other sites
if you are using one of my latest versions, you can use a delete status to remove from one cat, then on a second line, or subsequent import, add back the product to the moved-to cat.

The biggest problem is that the product will get a new ID. That means that Google cannot find the product anymore.

When I use the move function that is in osCommerce my SEO will notice that the product is moved and redirects

to the correct category.

 

So.. Is it possible to integrate the move function of osCommerce into you're code?

Share this post


Link to post
Share on other sites

I have been using EP 1.76f for a while now. Since I have added more products to my store I have found a problem. It seems the maximum file size I can download is 146 KB (149,567 bytes). It doesn't matter what options I choose. Every time I try to "download on the fly" I get a file that is 146 KB (149,567 bytes) in size.

 

Any ideas?

 

I get a 404 error if I try to create the file in the temp directory first.

Share this post


Link to post
Share on other sites
The biggest problem is that the product will get a new ID. That means that Google cannot find the product anymore.

When I use the move function that is in osCommerce my SEO will notice that the product is moved and redirects

to the correct category.

 

So.. Is it possible to integrate the move function of osCommerce into you're code?

 

I'm sure it is possible with any of the versions.

Share this post


Link to post
Share on other sites
I have been using EP 1.76f for a while now. Since I have added more products to my store I have found a problem. It seems the maximum file size I can download is 146 KB (149,567 bytes). It doesn't matter what options I choose. Every time I try to "download on the fly" I get a file that is 146 KB (149,567 bytes) in size.

 

Any ideas?

 

I get a 404 error if I try to create the file in the temp directory first.

 

ask you host about a time limit on your web space for PHP scripts. you may be able to circumvent that with this code near the top of the easypopulate file:

 

// set_time_limit(330);

 

change it to

 

set_time_limit(0);

 

for future help, please see the Support section of the EP manual that came with that version on how to ask for help. If you can't provide that information, I can't help much.

Share this post


Link to post
Share on other sites
I'm sure it is possible with any of the versions.

Ok.. added to the Feature list? (I am not that good in programming PHP) :thumbsup:

Edited by grijo

Share this post


Link to post
Share on other sites
ask you host about a time limit on your web space for PHP scripts. you may be able to circumvent that with this code near the top of the easypopulate file:

 

// set_time_limit(330);

 

change it to

 

set_time_limit(0);

 

for future help, please see the Support section of the EP manual that came with that version on how to ask for help. If you can't provide that information, I can't help much.

 

I have uncommented the line and have also tried I tried setting it to 3300. MY server is not in PHP safe mode. I also tried changing the php.ini file to 3300. I also tried increasing the memory from 32M to 64M using php.ini. Besides, it only takes about 3 seconds to reach 149KB, not 330 seconds or even 3300 seconds.

 

I also noticed that the error only occurs on my sub domain. For example, when I go to newstore.mysite.com/admin/easypopulate.php I can only download 149kb. When I go to mysite.com/easypopulate.php I can download at least 700K. I can probably do more than 700K but as it is a live store I can't test that theory.

Share this post


Link to post
Share on other sites
I've installed 2.76, and working the export and import function, BUT when I import data (the changed Pric)e , the message is

 

"Array Updated"

 

but no change in the database !!!!! what's the problem?

 

 

nobody? PLS!

Share this post


Link to post
Share on other sites

<_< Im puzzled an need help.. 1st want to say that i love the contrib :thumbsup: the problem that im having is that when i import using EP_v2_76e about the second category is starts to make the category over and over... example I have a category called "appliance" and withing that category i have 2 more "appliance 2" and "appliance 3" but when i import i creates like 70 of "appliance" categories and it places a product in each one. All my products have a unique product number i even tried using tab vs CSV and it does the came thing. Another problem that i have is that the icons in the sub menus that usually apear on top disappear on most of the subcategories. Im using im using OSC 2.2RC2a Thanx in advance for help

Share this post


Link to post
Share on other sites
nobody? PLS!

you might want to look at the forum rules.... Bumping postings to the top of the forum channel listing, made to get more attention to the post, is not allowed. When no one has replied to a posting you have made it is recommended to reply in the same thread with more information that may help in resolving the issue.

 

You might also look at the EP manual's support section about "how to ask for help" since I suspect you are using one of the version I added that section to. I don't think you have even given the full version number of the version you are using, as I elluded to in a reply to your other post at the bottom of the last page.

 

And, as I suggested to rs2k above... for future help, please see the Support section of the EP manual that came with that version on how to ask for help. If you can't provide that information, I can't help much. How's that for a reply? ;)

Share this post


Link to post
Share on other sites
<_< Im puzzled an need help.. 1st want to say that i love the contrib :thumbsup: the problem that im having is that when i import using EP_v2_76e about the second category is starts to make the category over and over... example I have a category called "appliance" and withing that category i have 2 more "appliance 2" and "appliance 3" but when i import i creates like 70 of "appliance" categories and it places a product in each one. All my products have a unique product number i even tried using tab vs CSV and it does the came thing. Another problem that i have is that the icons in the sub menus that usually apear on top disappear on most of the subcategories. Im using im using OSC 2.2RC2a Thanx in advance for help

welcome to the osC forums! post a link to a segment of your upload file. don't just paste the data into a post. you should try the latest version I have uploaded. the images issue may be a bug that was fixed.

Share this post


Link to post
Share on other sites
And, as I suggested to rs2k above... for future help, please see the Support section of the EP manual that came with that version on how to ask for help. If you can't provide that information, I can't help much. How's that for a reply? ;)

 

 

readme.txt

III. SUPPORT
-------------------------------------------------

See the /docs/EasyPopulate_Manual.txt file for the support location.

 

 

EasyPopulate_Manual.txt

Remember that this was written by volunteers, if you have questions, post in the 
forums, don't email any of the authors involved, since they may not be supporting 
the script any longer!  Lives change and people contribute and move on :)

Before you ask a question in the support thread, please, please, 
read the entire docs AND at least the last 4-5 pages of the 
support thread. Then, search the the thread for your answer.
If you don't understand what a setting is or does, please ask.

Only after that, should you ask for help with an error or problem 
USING this contribution.  If it isn't obvious you have exhausted 
all resources to find a solution, you may not get an answer. 
(please make a little effort)

Support for this release is provided in this thread:
http://forums.oscommerce.com/index.php?showtopic=162244

 

 

Am I missing something here? I have completed all of these steps listed in the code boxes above. I have read a lot more than the last 4-5 pages and have tried at least 20 different search strings. In fact, I was able to learn so much about easy populate while trying to fix it that I was able to modify it to add 5 other fields to my database. (Both the original code and my modified one have the same problem.) What other information would you like me to provide? I am happy to help you help me.

 

Thanks.

Edited by rs2k

Share this post


Link to post
Share on other sites
welcome to the osC forums! post a link to a segment of your upload file. don't just paste the data into a post. you should try the latest version I have uploaded. the images issue may be a bug that was fixed.

 

Thanx for the reply here is the link to the csv file http://www.globecomtechnologiesinc.com/csv.csv the latest version i found is Easy Populate 2.76f-MS2 (with attributes) r1 is this correct?? if so i have upgraded from 76e and im still having the same problem with the images and the importing. Only changes i have made to EP.php is model to 18 from 12 (changed in mysql table as well) and sub cat to 3 from 7. thanx again :rolleyes:

Share this post


Link to post
Share on other sites

I have installed this and can download the csv no problem but when I try to upload it and select insert into db - nothing happens, I get no messages and any changes do not occur. I have spent a few days reading through the 300+ pages on this support thread but I'm just getting increasingly confused.

Share this post


Link to post
Share on other sites
I have installed this and can download the csv no problem but when I try to upload it and select insert into db - nothing happens, I get no messages and any changes do not occur. I have spent a few days reading through the 300+ pages on this support thread but I'm just getting increasingly confused.

I've had my hosting company track the error logs and this is what they get:

 

[sun Mar 2 17:55:27 2008] [error] [client 74.6.28.18] mod_security: Access denied with redirect to [/]. Pattern match "<(.|\\\\n)+>" at REQUEST_URI [id "XSS_Check"] [severity "EMERGENCY"] [hostname "www.skatevid.net "] [uri "/upload/uu_finished.php?tmp_sid=599044c507e118dca00c8c620a8d91e3&temp_dir=<marquee><h1><hr><i><u>pwnd</u></i><br>by<br>agentsteal<h3><hr><img><hr><input%20value=pwnd_by_agentsteal><hr><select><option>pwnd<option>by<option>agentsteal</select><hr><iframe%20src="]

 

But this references a site which is not even mine! - www.skatevid.net

 

Any ideas?

Share this post


Link to post
Share on other sites
Am I missing something here? I have completed all of these steps listed in the code boxes above. I have read a lot more than the last 4-5 pages and have tried at least 20 different search strings. In fact, I was able to learn so much about easy populate while trying to fix it that I was able to modify it to add 5 other fields to my database. (Both the original code and my modified one have the same problem.) What other information would you like me to provide? I am happy to help you help me.

I congratulate you for doing the reading! :thumbsup: What I am trying to point out is that section called "how to ask for help" that you have conveniently clipped from your post. I had to download the v2.76f again just to make sure its not just me going loosing my mind. :blink: Obviously since you have a download problem, #4 can be omitted.

 

Maybe you can help me. What would make that section clearer?

Clearly its not clear since 1 in 1000 actually follows through. :blush: As if I'm psychic and I know how everyone has there server and settings setup !! :lol:

 

At the moment I can't come up with any scenario in which the problem you are reported would develop, which of course it the main reason you didn't get a further reply. If it only happens on your subdomains, you should be talking to your host about apache/php restrictions that may be causing this. That is, if it works in one place, but not another, on the same host with the same data, I'd be talking with the host.

Share this post


Link to post
Share on other sites
Thanx for the reply here is the link to the csv file http://www.globecomtechnologiesinc.com/csv.csv the latest version i found is Easy Populate 2.76f-MS2 (with attributes) r1 is this correct?? if so i have upgraded from 76e and im still having the same problem with the images and the importing. Only changes i have made to EP.php is model to 18 from 12 (changed in mysql table as well) and sub cat to 3 from 7. thanx again :rolleyes:

What I see when I try to import this is that you are using really long category names. Only the long names are being duplicated when I try the import. The reason is that the default osC shop has a limit of 32 chars for cat names. So if a cat name is truncated when it is created, then any subsequent import for that cat won't be found since the database now contains a truncated cat name. You should be able to fix this by increasing the length of the categories_name field of the categories_description table of your database.

Share this post


Link to post
Share on other sites
I've had my hosting company track the error logs and this is what they get:

 

[sun Mar 2 17:55:27 2008] [error] [client 74.6.28.18] mod_security: Access denied with redirect to [/]. Pattern match "<(.|\\\\n)+>" at REQUEST_URI [id "XSS_Check"] [severity "EMERGENCY"] [hostname "www.skatevid.net "] [uri "/upload/uu_finished.php?tmp_sid=599044c507e118dca00c8c620a8d91e3&temp_dir=<marquee><h1><hr><i><u>pwnd</u></i><br>by<br>agentsteal<h3><hr><img><hr><input%20value=pwnd_by_agentsteal><hr><select><option>pwnd<option>by<option>agentsteal</select><hr><iframe%20src="]

 

But this references a site which is not even mine! - www.skatevid.net

 

Any ideas?

good call to have your host track the error.

 

If in fact that error is referring to the upload, they should have been able to tell you it is a problem with their mod_security rules. The only way to rectify this is to ask your host to make an exception for easypopulate.php script in their mod_security rules. promise them that this script is safely behind a login/password in your admin and would never be abused from public exposure.

 

you can circumvent this problem by uploading your import to your temp folder via FTP and doing the "Import EP file from Temp Dir". If it works this way, the problem is definitely the error you've posted and only your host can fix it by setting an exception for the EP script file.

Share this post


Link to post
Share on other sites
Another problem that i have is that the icons in the sub menus that usually apear on top disappear on most of the subcategories.

define "most". specifically which? (in reference to the import file you posted)

Share this post


Link to post
Share on other sites
What I see when I try to import this is that you are using really long category names. Only the long names are being duplicated when I try the import. The reason is that the default osC shop has a limit of 32 chars for cat names. So if a cat name is truncated when it is created, then any subsequent import for that cat won't be found since the database now contains a truncated cat name. You should be able to fix this by increasing the length of the categories_name field of the categories_description table of your database.

 

Thanx I will try that.. In the meantime i just downloaded the .sql file and imported the data to the tables manualy and yes i did notice the 32 character limit and I have changed it. next time i need to update iwl use the EP app again and see what happens but anyhow my 10074 product store is finally up and running. As far as the immage thing i think its a problem with OSC in general cause even after i imported the data to the tables manually im having the same symptoms but thats not that important to me. Anyhow thanx a lot for your time and help :thumbsup:

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×