Jump to content
Sign in to follow this  
bottlerocket

Easy Populate Bugs

Recommended Posts

I've hit a wall with Easy Populate. I'm trying to convert our current store over to osCommerce, and with over 6,000 products, it's a little out of the question to do it by hand!

 

Anyway, the problem is that when inserting new products Easy Populate will often ignore my top-level categories and throw the second or third level categories into the root without any rhyme or reason. Some products it handles just fine, and other ones seem to get a random category that may actually be the product's price, or another product's "active/disabled" field. Everything appears to be setup correctly. Anyone have ideas as to why it may be doing this?

Share this post


Link to post
Share on other sites

Update

 

Hrm, it may have something to do with the XHTML in the product descriptions. Perhaps the quotes...? Does anyone have ideas on how to get around this?

Edited by bottlerocket

Share this post


Link to post
Share on other sites

If you have a single quote in your product description, you may try using a backslash before the quote like \' so as it ignores the actual meaning of quote in php file and takes it as a character.

 

Hope this helps!

Share this post


Link to post
Share on other sites

Jeez, I can't get this to work for the life of me. Removing all the quotes only made matters worse. I told my boss that converting to osCommerce would be a snap, but I just can't get Easy Populate to cooperate.

 

If you want to take a look at my spreadsheet, it's located at http://dev.golfcarcatalog.com/catalog/temp/db.txt. Can anyone please help me with this? It's driving me nuts! My catalog is all set up in the standard directories on a test server, so feel free to take a look at my configurations.

Share this post


Link to post
Share on other sites

As you have saved your file as a text file, use replace command to replace all single quotes (') with (\').

 

Make a copy of your file before modifications.

Share this post


Link to post
Share on other sites

Still no dice. I've tried deleting every single quote and double-quote, putting slashes in front of them, stripping all the HTML, replacing the tabs with various characters, editting the PHP script to strip out all whitespace, and every combination of each. Do you have any other ideas, because I'm all out. :(

Share this post


Link to post
Share on other sites
Update

 

Hrm, it may have something to do with the XHTML in the product descriptions. Perhaps the quotes...? Does anyone have ideas on how to get around this?

Easy Populate is not equipped to handle xhtml. You can enter everything except the product descriptions. Also make sure every line ends with EOREOR


[no external urls in signatures please, kthanks]

Share this post


Link to post
Share on other sites

I banged my head agains the wall a bit today with this. Not 6000 items.. BUT 252. It was skewing the colums and was doing weird things.

This even AFTER reading and making settings changes as per te documentation.

 

But, I finally got it to work. It seems it keys completely off the V_PRODUCTS_MODEL information. If there is nothign there, wham skewing.

If you put in 1 "model" number, wham only 1 item gets inserted/updated.

 

Make sure you have UNIQUE v_products_model information in there for each item!! Once you do this... it "should" work.

 

Great little add on.... wish that there was a "NOTE: be careful about...." in the documentaion!

But a great add on nonetheless

 

 

Enjoy!

 

Nitch

Edited by nitchimon

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

Nitchimon

 

Motto for today:

I went to school to become a wit. But I only made it half way.

Share this post


Link to post
Share on other sites

Well, I have posted and posted and modified the documentation and practically screamed into cyberspace that each product needs a UNIQUE MODEL NUMBER. I can't help it if no oe pays attention :)


[no external urls in signatures please, kthanks]

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
Sign in to follow this  

×