wasson65 Posted January 8, 2003 Share Posted January 8, 2003 OK, EP 2.4 is out, with the much-anticipated Froogle support, thanks to Ted Joffs, who sponsored this development. Get it here: http://www.oscommerce.com/community/contributions,500 You will need to have contacted Google and set up your account, plus you'll have 2 configuration variables to set before you can download a file that will upload into Froogle properly. Enjoy! Tim Quote Link to comment Share on other sites More sharing options...
networkdad Posted January 8, 2003 Share Posted January 8, 2003 Tim - thanks for another excellent upgrade! This makes my life so much easier. YGPP. ~Jason Quote Link to comment Share on other sites More sharing options...
toktas Posted January 8, 2003 Share Posted January 8, 2003 Thanks for the easy update :P Quote Link to comment Share on other sites More sharing options...
wasson65 Posted January 8, 2003 Author Share Posted January 8, 2003 Just a note: I've currently got a 2.41beta that has a few bug fixes already... sorry... You can get the beta here: www.wassons.org/EasyPopulate_v2.41beta.zip I should have called this 3.0, then people would know better than to trust a .0 release! Tim Quote Link to comment Share on other sites More sharing options...
MultiServis.Net Posted January 8, 2003 Share Posted January 8, 2003 In order to listing by froogle I need to this? http://froogle.google.com/froogle/merchants.html#feed Quote Link to comment Share on other sites More sharing options...
Mark Russell Posted January 8, 2003 Share Posted January 8, 2003 Thanks Tim. This is an excellent module. The Frugal feed works great. Mark Quote Link to comment Share on other sites More sharing options...
wasson65 Posted January 8, 2003 Author Share Posted January 8, 2003 Thanks Tim. This is an excellent module. The Frugal feed works great. Mark Well, don't speak too soon! Froogle is apparently about 10 days behind in processing, and Ron Siegel found a bunch of problems with the 2.4 release that would likely result in the upload not being accepted. I've got a beta version that fixes these problems and you can get it at: http://www.wassons.org/EasyPopulate_v2.41beta2.zip Tim Quote Link to comment Share on other sites More sharing options...
Mark Russell Posted January 8, 2003 Share Posted January 8, 2003 Already bagged 2.41. Thanks, Mark Quote Link to comment Share on other sites More sharing options...
Guest Posted January 8, 2003 Share Posted January 8, 2003 Hi thanx for the program.. it worked fine and then I tried uploading again and it gave me this error.. I downloaded again didnt change nothing and uploaded, still same error.. whats up..? File uploaded. Temporary filename: /var/tmp/phpeXuvyh User filename: EP1042049487.txt Size: 836 1017 - Can't find file: './grandsterlingusa_com/tax_class.frm' (errno: 24) select tax_class_id from tax_class WHERE tax_class_title = 'None' [TEP STOP] Quote Link to comment Share on other sites More sharing options...
CC Posted January 8, 2003 Share Posted January 8, 2003 Tim any chance you can upload this update? I cant download from that link. Or email me the updates if you get chance? I have PM'd my email to you. Thanks CC. Quote Link to comment Share on other sites More sharing options...
elari Posted January 8, 2003 Share Posted January 8, 2003 1017 - Can't find file: './grandsterlingusa_com/tax_class.frm' (errno: 24) select tax_class_id from tax_class WHERE tax_class_title = 'None' [TEP STOP] can you tell me which version/snapshot of osc you use there is the same kind of problems on the french osc version that is based on an old snapshot (i think around ~march/june 2002) Quote Link to comment Share on other sites More sharing options...
sfoust Posted January 8, 2003 Share Posted January 8, 2003 I've found a bug in v 2.31 that creates a blank manufactures entry and links all products with out one to the blank manufacture. Dose anyone know if this is fixed in the EasyPopulate_v2.41beta2? (I'm asking becuase It takes me about an hour to modify/test/debug it to work with my modified database structure) BTW, this is a really great contribution, Tim. Thanks for the effort and dedication. Quote Link to comment Share on other sites More sharing options...
loxly Posted January 9, 2003 Share Posted January 9, 2003 I wondered where the blank manufacturer came from! :lol: Debbie Quote [no external urls in signatures please, kthanks] Link to comment Share on other sites More sharing options...
VyReN Posted January 9, 2003 Share Posted January 9, 2003 Greetings, I used 2.41b successfully, everything was awesome...and then -- I added Attribute Sorter and Copier v5.0 by Linda --- I don't see where the two would conflict, but now when I upload my changed file I see: File uploaded. Temporary filename: /tmp/phpu2xLHd User filename: EP1042084984.txt Size: 2383 Deleting product from the database The line "Deleting product......" is repeated for every product in the file. Did I (Don't know where) mess something up or?? Anyone see this before?? Thanks! -Glen P.S. I am only changing prices and re-uploading the same file -- No changes are being made in any way to my database. No price changes, no product deletes...nothing. Quote Link to comment Share on other sites More sharing options...
solarman Posted January 9, 2003 Share Posted January 9, 2003 I'm getting thre same thing here. Nothing added or changed, and thankfully, nothing deleted. It shook me up for a second there... I am having problems with Excel cutting off my descriptions on some of the records. Not sure why? Quote Link to comment Share on other sites More sharing options...
VyReN Posted January 9, 2003 Share Posted January 9, 2003 I'm getting thre same thing here. Nothing added or changed, and thankfully, nothing deleted. It shook me up for a second there... I am having problems with Excel cutting off my descriptions on some of the records. Not sure why? Heh, I know the feeling... First thing I thought was, "CRAP! Did I backup my database?" ...I did. :D It worked fine at first.....? Quote Link to comment Share on other sites More sharing options...
wasson65 Posted January 9, 2003 Author Share Posted January 9, 2003 Sorry for these nasty problems. I've been so focused on the froogle downloads, I haven't been paying enough attention to the normal stuff. I'm troubleshooting this now and will have an answer very soon. Again, I apologize for all this. Tim Quote Link to comment Share on other sites More sharing options...
wasson65 Posted January 9, 2003 Author Share Posted January 9, 2003 I've found a bug in v 2.31 that creates a blank manufactures entry and links all products with out one to the blank manufacture. Dose anyone know if this is fixed in the EasyPopulate_v2.41beta2? (I'm asking becuase It takes me about an hour to modify/test/debug it to work with my modified database structure) BTW, this is a really great contribution, Tim. Thanks for the effort and dedication. I'm testing a fix for this right now, and I'll give you the specifc lines to fix when I have them, so you won't have to redo your config. Tim Quote Link to comment Share on other sites More sharing options...
wasson65 Posted January 9, 2003 Author Share Posted January 9, 2003 I'm getting thre same thing here. Nothing added or changed, and thankfully, nothing deleted. It shook me up for a second there... I am having problems with Excel cutting off my descriptions on some of the records. Not sure why? Heh, I know the feeling... First thing I thought was, "CRAP! Did I backup my database?" ...I did. :D It worked fine at first.....? OK, this problem has been fixed. I had thought about doing a feature that would allow EP to delete items from the database, and had gotten so far as putting in a malfunctioning if statement and the message, but (fortunately) no queries that affected the database. I've released a new beta version of EP: 2.41beta4 It can be found in the contribs at: http://www.oscommerce.com/community/contributions,500 Thanks for your patience with this. Tim Quote Link to comment Share on other sites More sharing options...
wasson65 Posted January 9, 2003 Author Share Posted January 9, 2003 I've found a bug in v 2.31 that creates a blank manufactures entry and links all products with out one to the blank manufacture. Dose anyone know if this is fixed in the EasyPopulate_v2.41beta2? (I'm asking becuase It takes me about an hour to modify/test/debug it to work with my modified database structure) BTW, this is a really great contribution, Tim. Thanks for the effort and dedication. This bug has also been fixed in the 2.41beta4 release. To update your 2.31 release, what you'll need to do is find the code like this: $sql = "SELECT man.manufacturers_id FROM manufacturers as man WHERE man.manufacturers_name = '" . $v_manufacturers_name . "'"; and add an if statement in front of it like this: if ( isset($v_manufacturers_name) && $v_manufacturers_name != '' ){ $sql = "SELECT man.manufacturers_id FROM manufacturers as man WHERE man.manufacturers_name = '" . $v_manufacturers_name . "'"; and then add a closing curly brace after this line $result = tep_db_query($sql); $v_manufacturer_id = $max_mfg_id; } Like this $result = tep_db_query($sql); $v_manufacturer_id = $max_mfg_id; } } Quote Link to comment Share on other sites More sharing options...
VyReN Posted January 9, 2003 Share Posted January 9, 2003 Sorry for these nasty problems. I've been so focused on the froogle downloads, I haven't been paying enough attention to the normal stuff. I'm troubleshooting this now and will have an answer very soon. Again, I apologize for all this. Tim, You have NOTHING to apologize for! We're SOOOO lucky you're doing THIS much work! We should be happy to get a buggy version! Better than nothing at all. :) Thank you! You rock. :lol: Quote Link to comment Share on other sites More sharing options...
wasson65 Posted January 9, 2003 Author Share Posted January 9, 2003 ....I am having problems with Excel cutting off my descriptions on some of the records. Not sure why? Here is some info I found at http://support.crystaldecisions.com/kbase/c2000454.asp ... Microsoft Excel 7.0 (95) ----------------------------------------- ? Maximum Sheet Size: 16,384 rows by 256 columns ? Column Width: 0 to 255 charactersMicrosoft Excel 7.0 (95) ----------------------------------------- ? Maximum Sheet Size: 16,384 rows by 256 columns ? Column Width: 0 to 255 characters ? Maximum length of cell contents (text): 255 chacters Microsoft Excel 8.0 (97) -------------------------------------------- ? Maximum Sheet Size: 65,536 rows by 256 columns ? Column Width: 0 to 255 characters ? Maximum length of cell contents (text): 32,000 characters Microsoft Excel 2000 -------------------------------------------- ? Worksheet size: 65,536 rows by 256 columns ? Column Width: 255 characters ? Length of cell contents (text): 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar. ? Maximum length of cell contents (text): 255 chacters Microsoft Excel 8.0 (97) -------------------------------------------- ? Maximum Sheet Size: 65,536 rows by 256 columns ? Column Width: 0 to 255 characters ? Maximum length of cell contents (text): 32,000 characters Microsoft Excel 2000 -------------------------------------------- ? Worksheet size: 65,536 rows by 256 columns ? Column Width: 255 characters ? Length of cell contents (text): 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar. ... Quote Link to comment Share on other sites More sharing options...
VyReN Posted January 9, 2003 Share Posted January 9, 2003 Uhhh... Still doesn't work... ?? Quote Link to comment Share on other sites More sharing options...
VyReN Posted January 9, 2003 Share Posted January 9, 2003 Heh - The new EP won't work when you put it in /catalog Darn it. Sorry. It works fine. :D /idiot Quote Link to comment Share on other sites More sharing options...
sfoust Posted January 10, 2003 Share Posted January 10, 2003 I've found a bug in v 2.31 that creates a blank manufactures entry and links all products with out one to the blank manufacture. Dose anyone know if this is fixed in the EasyPopulate_v2.41beta2? (I'm asking becuase It takes me about an hour to modify/test/debug it to work with my modified database structure) BTW, this is a really great contribution, Tim. Thanks for the effort and dedication. This bug has also been fixed in the 2.41beta4 release. To update your 2.31 release, what you'll need to do is find the code like this: $sql = "SELECT man.manufacturers_id FROM manufacturers as man WHERE man.manufacturers_name = '" . $v_manufacturers_name . "'"; and add an if statement in front of it like this: if ( isset($v_manufacturers_name) && $v_manufacturers_name != '' ){ $sql = "SELECT man.manufacturers_id FROM manufacturers as man WHERE man.manufacturers_name = '" . $v_manufacturers_name . "'"; and then add a closing curly brace after this line $result = tep_db_query($sql); $v_manufacturer_id = $max_mfg_id; } Like this $result = tep_db_query($sql); $v_manufacturer_id = $max_mfg_id; } } That was it, Tim. Works great now. You rock :!: Quote 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.