Jump to content
Sign in to follow this  
wasson65

EasyPopulate 2.4, now with Froogle support!

Recommended Posts

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites

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]

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites
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)

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

I wondered where the blank manufacturer came from! :lol:

 

Debbie


[no external urls in signatures please, kthanks]

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites
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.....?

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites
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;

 }

}

Share this post


Link to post
Share on other sites
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:

Share this post


Link to post
Share on other sites
....

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.

...

Share this post


Link to post
Share on other sites

Heh - The new EP won't work when you put it in /catalog

 

Darn it.

 

Sorry. It works fine. :D

/idiot

Share this post


Link to post
Share on other sites
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 :!:

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  

×