bottlerocket Posted September 26, 2003 Share Posted September 26, 2003 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? Quote Link to comment Share on other sites More sharing options...
bottlerocket Posted September 26, 2003 Author Share Posted September 26, 2003 (edited) 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 September 26, 2003 by bottlerocket Quote Link to comment Share on other sites More sharing options...
kagg Posted September 26, 2003 Share Posted September 26, 2003 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! Quote Link to comment Share on other sites More sharing options...
bottlerocket Posted September 30, 2003 Author Share Posted September 30, 2003 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. Quote Link to comment Share on other sites More sharing options...
kagg Posted September 30, 2003 Share Posted September 30, 2003 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. Quote Link to comment Share on other sites More sharing options...
bottlerocket Posted September 30, 2003 Author Share Posted September 30, 2003 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. :( Quote Link to comment Share on other sites More sharing options...
loxly Posted September 30, 2003 Share Posted September 30, 2003 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 Quote [no external urls in signatures please, kthanks] Link to comment Share on other sites More sharing options...
nitchimon Posted October 2, 2003 Share Posted October 2, 2003 (edited) 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 October 2, 2003 by nitchimon Quote ------------------------------------------ Nitchimon Motto for today: I went to school to become a wit. But I only made it half way. Link to comment Share on other sites More sharing options...
loxly Posted October 29, 2003 Share Posted October 29, 2003 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 :) Quote [no external urls in signatures please, kthanks] Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.