Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

EasyPopulate 2.4, now with Froogle support!


wasson65

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

Link to comment
Share on other sites

  • Replies 285
  • Created
  • Last Reply

Top Posters In This Topic

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

Link to comment
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

Link to comment
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]

Link to comment
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.

Link to comment
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)

Link to comment
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.

Link to comment
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.

Link to comment
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?

Link to comment
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.....?

Link to comment
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

Link to comment
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

Link to comment
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

Link to comment
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;

 }

}

Link to comment
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:

Link to comment
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.

...

Link to comment
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 :!:

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...