New problem with Google Feeds in 7.0.7

For general questions and discussions specific to the AbleCommerce 7.0 Asp.Net product.
Post Reply
User avatar
AbleMods
Master Yoda
Master Yoda
Posts: 5170
Joined: Wed Sep 26, 2007 5:47 am
Location: Fort Myers, Florida USA

New problem with Google Feeds in 7.0.7

Post by AbleMods » Thu Oct 06, 2011 7:39 am

Google has once again increased the required files for the Google Feed.

Now they're kicking the AC 7.0.7 google feed file back out stating 'Missing required field: Availability'

Is AbleCommerce going to release an update for this?

I didn't even notice it until my sales dropped dramatically over the last few weeks. I get automated emails every day from my feed upload, and it would clearly state '20992 out of 21032 Items Inserted'

However that is NOT the real story. Log into your Google Merchant Dashboard and you'll see:
Capture.JPG
Well what the heck good is the feed if it's not going to be Product Search or Search API ?!?!?
Joe Payne
AbleCommerce Custom Programming and Modules http://www.AbleMods.com/
AbleCommerce Hosting http://www.AbleModsHosting.com/
Precise Fishing and Hunting Time Tables http://www.Solunar.com

User avatar
napacabs
Lieutenant, Jr. Grade (LT JG)
Lieutenant, Jr. Grade (LT JG)
Posts: 45
Joined: Mon Jan 14, 2008 2:58 pm
Location: Chino, California
Contact:

Re: New problem with Google Feeds in 7.0.7

Post by napacabs » Fri Oct 07, 2011 8:17 pm

Any fix yet?

combra
Lieutenant Commander (LCDR)
Lieutenant Commander (LCDR)
Posts: 98
Joined: Thu Jul 31, 2008 7:09 pm

Re: New problem with Google Feeds in 7.0.7

Post by combra » Sun Oct 09, 2011 2:01 pm

I would like to know if there is a fix for this as well.

-Brandon
AC 7.0.7 build 14600

User avatar
Katie
AbleCommerce Admin
AbleCommerce Admin
Posts: 2651
Joined: Tue Dec 02, 2003 1:54 am
Contact:

Re: New problem with Google Feeds in 7.0.7

Post by Katie » Sun Oct 09, 2011 5:13 pm

We'll have a patch available Monday (tomorrow).
Thank you for choosing AbleCommerce!

http://help.ablecommerce.com - product support
http://wiki.ablecommerce.com - developer support

User avatar
Katie
AbleCommerce Admin
AbleCommerce Admin
Posts: 2651
Joined: Tue Dec 02, 2003 1:54 am
Contact:

Re: New problem with Google Feeds in 7.0.7

Post by Katie » Mon Oct 10, 2011 5:47 pm

Here you go....

http://help.ablecommerce.com/index.htm# ... _patch.htm

Thanks for waiting.
Katie
Thank you for choosing AbleCommerce!

http://help.ablecommerce.com - product support
http://wiki.ablecommerce.com - developer support

kwikstand
Commodore (COMO)
Commodore (COMO)
Posts: 410
Joined: Mon Feb 19, 2007 8:12 pm
Contact:

Re: New problem with Google Feeds in 7.0.7

Post by kwikstand » Mon Oct 10, 2011 8:35 pm

I just applied the patch and it still doesn't work. Google still tells me that my items are missing the "availability" attribute. Even though I looked at it and it shows "in stock" for every item.
Contractor's Solutions
www. contractors-solutions.net

User avatar
jmestep
AbleCommerce Angel
Posts: 8164
Joined: Sun Feb 29, 2004 8:04 pm
Location: Dayton, OH
Contact:

Re: New problem with Google Feeds in 7.0.7

Post by jmestep » Tue Oct 11, 2011 8:11 am

We are adding new features to our Googlebase Feed AddOn regularly.
http://www.web2market.com/Google-Produc ... 61C77.aspx

Some of the newer enhancements are:
Availability can be based on three options in it.
It generates a Google product category field - a requirement for apparel products in the US, recommended attribute for all.
If a product has variants and the sku, price or weight are in the variants and not the product, it picks up the first variant.

Features in development include
Feed will show all variants of a product
Adding code to handle apparel products size,color, gender, age group- this is a new requirement for US.

It is open to customization. For example, we have one client who has a template field called ISBN_UPC, so we use that to populate both of those fields.
It includes one year of free updates- Google keeps changing requirements.
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx

User avatar
Katie
AbleCommerce Admin
AbleCommerce Admin
Posts: 2651
Joined: Tue Dec 02, 2003 1:54 am
Contact:

Re: New problem with Google Feeds in 7.0.7

Post by Katie » Tue Oct 11, 2011 10:37 am

I just applied the patch and it still doesn't work.
How did you tell Google about the new feed file? Did you reconfigure your Google Account to use the new file, or did you use the Test Feed feature?

The new file is located in the root of the install..

e.g. http://your_store_domain/googlefeed.txt

When I tested the new file, it worked for me.

Thanks,
Katie
Thank you for choosing AbleCommerce!

http://help.ablecommerce.com - product support
http://wiki.ablecommerce.com - developer support

plugables
Captain (CAPT)
Captain (CAPT)
Posts: 276
Joined: Sat Aug 15, 2009 4:04 am
Contact:

Re: New problem with Google Feeds in 7.0.7

Post by plugables » Wed Oct 12, 2011 4:42 am

Hi Katie,

I am a bit confused the way new patch has been applied/released. Now there are two separate implementations of Google Base feed in the system. One is useless and invalid. The other is updated and valid. A big source of confusion for end users.

The Google base feed accessible from Marketing->Feeds->Google Base Feed is meaningless now. The settings and configuration over there and the feed generated from there is pointless. But this very key information does not get communicated to the users once they apply the patch.

The valid feed now is the feed implemented in new App_Code/GoogleBaseFeed.cs file and invoked from Global.ashx. There is no user interface for this feed. It gets generated automatically after 6 hours. Users should not be expecting to see any UI and configuration settings corresponding to this feed implementation. This is another important piece of information that is somehow not communicated very well.

Another thing that adds to further confusion, and some inconvenience, is that the new patch chose to put the new feed file in store home directory instead of the Feeds folder. In many cases the home directory of the store is not write-able especially for those in sahred hosting environments with strict controls. Feeds folder was already write-able. If avoidance of conflict with existing feed implementation was needed, a different filename could have been chosen.

Thanks

User avatar
jmestep
AbleCommerce Angel
Posts: 8164
Joined: Sun Feb 29, 2004 8:04 pm
Location: Dayton, OH
Contact:

Re: New problem with Google Feeds in 7.0.7

Post by jmestep » Wed Oct 12, 2011 6:59 am

I think maybe the reason they switched to the root of the site is because that way you can set up Google to fetch it on a schedule. Google wouldn't be able to access it where it was before and that has been a complaint in the past.
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx

User avatar
Katie
AbleCommerce Admin
AbleCommerce Admin
Posts: 2651
Joined: Tue Dec 02, 2003 1:54 am
Contact:

Re: New problem with Google Feeds in 7.0.7

Post by Katie » Wed Oct 12, 2011 7:39 am

We did this because it allows us to release a working version of the feed for all versions of AbleCommerce. Otherwise, we would have had to distribute a new DLL for each and every 7.x release. This is only intended to be a patch, or work-around, until a better implementation can be put into a future version.

The documentation does mention (in bold) that the patch is a replacement to the existing feed within the Merchant Menu. I'm not sure what else we could have done to make this easier, except maybe change the placement of the feed file. The new feed generator can also be customized. This was another major complaint that's been taken care of as well.

Thanks,
Katie
Thank you for choosing AbleCommerce!

http://help.ablecommerce.com - product support
http://wiki.ablecommerce.com - developer support

plugables
Captain (CAPT)
Captain (CAPT)
Posts: 276
Joined: Sat Aug 15, 2009 4:04 am
Contact:

Re: New problem with Google Feeds in 7.0.7

Post by plugables » Wed Oct 12, 2011 8:24 am

Here is what could have been done.

1. Include with the patch new file(s) for Admin/Marketing/Feeds/GoogleBase.aspx(.cs). The new files, when accessed via Marketing->Feeds->Google Base Feed, should simply inform the user how the new google base feed is generated now.

2. No 1 would have been enough to eliminate any confusions. To make it more friendly, the settings on Marketing->Feeds->Google Base Feed could still have been respected by the new implementation in App_Code... and the path issue confusion of-course would not have arisen.

3. To take it a step further, the settings which can now be configured, and which have been explained for technical persons in readme.txt file, could have been made available at Marketing->Feeds->Google Base Feed.

All the above would not require distributing a new DLL for each 7.x release. The patch only needed to include modified Admin/Marketing/Feeds/GoogleBase.aspx(.cs).

User avatar
Katie
AbleCommerce Admin
AbleCommerce Admin
Posts: 2651
Joined: Tue Dec 02, 2003 1:54 am
Contact:

Re: New problem with Google Feeds in 7.0.7

Post by Katie » Thu Oct 13, 2011 3:49 pm

If you would like to change the location of the feed file, then open the global.asax file and modify the following line -

Code: Select all

    // This is the relative path of where the feed file will generate
    private string googleFeedFile = "~/GoogleFeed.txt";
The file needs to be in a web accessible folder.

Thanks,
Katie
Thank you for choosing AbleCommerce!

http://help.ablecommerce.com - product support
http://wiki.ablecommerce.com - developer support

User avatar
napacabs
Lieutenant, Jr. Grade (LT JG)
Lieutenant, Jr. Grade (LT JG)
Posts: 45
Joined: Mon Jan 14, 2008 2:58 pm
Location: Chino, California
Contact:

Re: New problem with Google Feeds in 7.0.7

Post by napacabs » Thu Oct 27, 2011 1:43 pm

Katie wrote:Here you go....

http://help.ablecommerce.com/index.htm# ... _patch.htm

Thanks for waiting.
Katie
Would it be possible to create a page that would list this fix and others, Instead of having to search the forum. It would be nice to have these fixes added to the news feeds that appear in the admin dashboard.

User avatar
Katie
AbleCommerce Admin
AbleCommerce Admin
Posts: 2651
Joined: Tue Dec 02, 2003 1:54 am
Contact:

Re: New problem with Google Feeds in 7.0.7

Post by Katie » Thu Oct 27, 2011 4:11 pm

We are working on other ways to communicate the hot patches, but if you go to help.ablecommerce.com and look in the right column, you'll see the latest announcements listed here.

The critical patches should always be posted at the help site soon after release. Any service pack or full upgrade announcement for AbleCommerce will appear in the Dashboard feed. I'm not certain if we will post each and every hot patch here, as not all of them are impacting all customers.

Thanks for your feedback though! We realize that communication is a vital part of support, and we're working on improvements.

Katie
Thank you for choosing AbleCommerce!

http://help.ablecommerce.com - product support
http://wiki.ablecommerce.com - developer support

elamj1
Ensign (ENS)
Ensign (ENS)
Posts: 1
Joined: Wed Oct 26, 2011 4:31 am

Re: New problem with Google Feeds in 7.0.7

Post by elamj1 » Wed Nov 02, 2011 1:50 am

Hey guys,

I installed the patch as mentioned above, replaced global.asax and uploaded the .cs file, etc. but the googlefeed.txt is never being generated it seems. Does the patch require a server restart, or any sort of additional action to cause the first feed to be generated?

Thanks!

User avatar
hassonmike
Lieutenant (LT)
Lieutenant (LT)
Posts: 76
Joined: Tue Apr 19, 2011 2:13 pm
Contact:

Re: New problem with Google Feeds in 7.0.7

Post by hassonmike » Wed May 02, 2012 1:20 pm

I am trying to apply this patch, but when I update Global.asax with the custom code as specified in the readme, it brings my site down, with the following error:

Code: Select all

Compilation Error

Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately. 

Compiler Error Message: CS0111: Type 'ASP.AcApp' already defines a member called 'Application_Start' with the same parameter types

Source Error:


Line 105:    private string googleFeedFile = "~Feeds/GoogleFeed.txt";
Line 106:
Line 107:    protected void Application_Start(Object sender, EventArgs e)
Line 108:    {
Line 109:        // start the monitor

Source File: d:\Internet\TrickConcepts.com\Global.asax    Line: 107 


Show Detailed Compiler Output:


c:\windows\system32\inetsrv> "C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\csc.exe" /t:library /utf8output /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\84b2873e\003e5090_4be3c901\CyberSource.Base.DLL" /R:"C:\WINDOWS\assembly\GAC_MSIL\System.Drawing\2.0.0.0__b03f5f7f11d50a3a\System.Drawing.dll" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\b4db4374\003e5090_4be3c901\CommerceBuilder.Protx.DLL" /R:"C:\WINDOWS\assembly\GAC_MSIL\System.Configuration\2.0.0.0__b03f5f7f11d50a3a\System.Configuration.dll" /R:"C:\WINDOWS\assembly\GAC_MSIL\System.WorkflowServices\3.5.0.0__31bf3856ad364e35\System.WorkflowServices.dll" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\f10a5d88\003e5090_4be3c901\CommerceBuilder.InternetSecure.DLL" /R:"C:\WINDOWS\assembly\GAC_MSIL\System.Xml\2.0.0.0__b77a5c561934e089\System.Xml.dll" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\43024084\003e5090_4be3c901\CommerceBuilder.DHLInternational.DLL" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\eb62a01d\003e5090_4be3c901\CommerceBuilder.BankOfCanada.DLL" /R:"C:\WINDOWS\assembly\GAC_MSIL\System.Design\2.0.0.0__b03f5f7f11d50a3a\System.Design.dll" /R:"C:\WINDOWS\assembly\GAC_32\System.Data\2.0.0.0__b77a5c561934e089\System.Data.dll" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\b76f3dde\003e5090_4be3c901\CommerceBuilder.AuthorizeNet.DLL" /R:"C:\WINDOWS\assembly\GAC_MSIL\System.ServiceModel\3.0.0.0__b77a5c561934e089\System.ServiceModel.dll" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\mscorlib.dll" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\02159117\003e5090_4be3c901\CommerceBuilder.Paradata.DLL" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\7efc1007\003e5090_4be3c901\Microsoft.Web.Preview.DLL" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\c9838022\003e5090_4be3c901\PaygatewayNET.DLL" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\f517bd95\003e5090_4be3c901\CommerceBuilder.CyberSource.DLL" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\51ac1dd8\003e5090_4be3c901\CommerceBuilder.LinkPoint.DLL" /R:"C:\WINDOWS\assembly\GAC_MSIL\System.Windows.Forms\2.0.0.0__b77a5c561934e089\System.Windows.Forms.dll" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\26c76c7d\003e5090_4be3c901\CybsWSSecurityIOP.DLL" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\a42fb350\003e5090_4be3c901\Microsoft.Practices.EnterpriseLibrary.Data.DLL" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\b099edd0\57fcecff_1026cc01\CommerceBuilder.AbleCommerceTax.DLL" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\cd2614e9\003e5090_4be3c901\CommerceBuilder.Data.DLL" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\cc5a556c\003e5090_4be3c901\CommerceBuilder.FedEx.DLL" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\be98f694\003e5090_4be3c901\CyberSource.Clients.XmlSerializers.DLL" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\5822299b\003e5090_4be3c901\log4net.DLL" /R:"C:\WINDOWS\assembly\GAC_MSIL\System\2.0.0.0__b77a5c561934e089\System.dll" /R:"C:\WINDOWS\assembly\GAC_MSIL\System.ServiceModel.Web\3.5.0.0__31bf3856ad364e35\System.ServiceModel.Web.dll" /R:"C:\WINDOWS\assembly\GAC_MSIL\System.Web.Services\2.0.0.0__b03f5f7f11d50a3a\System.Web.Services.dll" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\7747fcb0\00e5d50a_a3abcb01\CommerceBuilder.USPS.DLL" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\9ee903d6\003e5090_4be3c901\CommerceBuilder.Web.DLL" /R:"C:\WINDOWS\assembly\GAC_MSIL\System.Runtime.Serialization\3.0.0.0__b77a5c561934e089\System.Runtime.Serialization.dll" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\b78c6028\003e5090_4be3c901\wwHoverPanel.DLL" /R:"C:\WINDOWS\assembly\GAC_MSIL\System.Management\2.0.0.0__b03f5f7f11d50a3a\System.Management.dll" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\3daeab97\003e5090_4be3c901\paypal_base.DLL" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\d7324127\003e5090_4be3c901\CommerceBuilder.Configuration.DLL" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\5640ffb1\003e5090_4be3c901\PFProdotNET.DLL" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\ce173d37\003e5090_4be3c901\Microsoft.Practices.ObjectBuilder.DLL" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\af46df05\c1f1b375_a3f8cc01\W2MReferrals.DLL" /R:"C:\WINDOWS\assembly\GAC_MSIL\System.IdentityModel\3.0.0.0__b77a5c561934e089\System.IdentityModel.dll" /R:"C:\WINDOWS\assembly\GAC_MSIL\System.Web.Mobile\2.0.0.0__b03f5f7f11d50a3a\System.Web.Mobile.dll" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\96073e1d\003e5090_4be3c901\Microsoft.Practices.EnterpriseLibrary.Common.DLL" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\c94f6123\54671929_1126cc01\CommerceBuilder.UPS.DLL" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\ea8ea6d0\003e5090_4be3c901\LinkPointTransaction.DLL" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\7ac66d49\e6bef6e8_fbe4cb01\Solunar.DLL" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\d3e34827\003e5090_4be3c901\CommerceBuilder.AustraliaPost.DLL" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\e7fc6295\3ecc83a6_fbe4cb01\CommerceBuilder.FRBNY.DLL" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\e042fc28\1eb3798c_fbe4cb01\CommerceBuilder.CCH.DLL" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\e4beff81\003e5090_4be3c901\CommerceBuilder.PayFlowPro.DLL" /R:"C:\WINDOWS\assembly\GAC_MSIL\System.Configuration.Install\2.0.0.0__b03f5f7f11d50a3a\System.Configuration.Install.dll" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\52b6f6c1\4eba53e9_fbe4cb01\Solunar.QBWebService.DLL" /R:"C:\WINDOWS\assembly\GAC_32\System.Data.OracleClient\2.0.0.0__b77a5c561934e089\System.Data.OracleClient.dll" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\823f6039\003e5090_4be3c901\CommerceBuilder.PayJunction.DLL" /R:"C:\WINDOWS\assembly\GAC_32\System.EnterpriseServices\2.0.0.0__b03f5f7f11d50a3a\System.EnterpriseServices.dll" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\App_Code.idnebeuw.dll" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\a50d87c8\003e5090_4be3c901\NVelocity.DLL" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\a2c7298f\003e5090_4be3c901\PFProCOMLib.DLL" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\a7cc42ff\003e5090_4be3c901\AjaxControlToolkit.DLL" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\c0d2688b\86b6fd93_fbe4cb01\CommerceBuilder.DHL.DLL" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\cd4b69cd\fc71f41c_1126cc01\CommerceBuilder.GoogleCheckout.DLL" /R:"C:\WINDOWS\assembly\GAC_MSIL\System.Web.Extensions\3.5.0.0__31bf3856ad364e35\System.Web.Extensions.dll" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\cd91d1d4\003e5090_4be3c901\Validators.DLL" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\e28a8ef3\003e5090_4be3c901\CommerceBuilder.ECB.DLL" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\a0a8f1e7\003e5090_4be3c901\ComponentArt.Web.UI.DLL" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\12f7e956\36dbd6e9_fbe4cb01\StructuredSolutions.ShippingAgent.AbleCommerce7.DLL" /R:"C:\WINDOWS\assembly\GAC_32\System.Web\2.0.0.0__b03f5f7f11d50a3a\System.Web.dll" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\8f46e7cc\00e8cbc9_ea7aca01\CommerceBuilder.PaymentechOrbital.DLL" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\d81d992c\003e5090_4be3c901\WebChart.DLL" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\47de444f\003e5090_4be3c901\CyberSource.WSSecurity.DLL" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\8c826d95\00c7e46d_22f2ca01\CommerceBuilder.DataClient.Csv.DLL" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\0a357c31\003e5090_4be3c901\CommerceBuilder.AcTestProvider.DLL" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\a0eb8f79\003e5090_4be3c901\CommerceBuilder.CanadaPost.DLL" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\e7091f3b\067a5924_1126cc01\CommerceBuilder.Services.DLL" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\9392cfac\42abe119_1126cc01\CommerceBuilder.DLL" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\60b24386\003e5090_4be3c901\CommerceBuilder.SkipJack.DLL" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\30dc528e\003e5090_4be3c901\CyberSource.Clients.DLL" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\056f2326\00aaeef6_5903cb01\CommerceBuilder.DataClient.Api.DLL" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\eef286bb\8684a7c6_fbe4cb01\edtFTPnet.DLL" /R:"C:\WINDOWS\assembly\GAC_32\System.Transactions\2.0.0.0__b77a5c561934e089\System.Transactions.dll" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\d80a6f48\003e5090_4be3c901\ICSharpCode.SharpZipLib.DLL" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\7913b7f1\00c7e46d_22f2ca01\DataPort.Framework.DLL" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\b091438a\af128721_1126cc01\CommerceBuilder.PayPal.DLL" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\abf800e7\003e5090_4be3c901\FredCK.FCKeditorV2.DLL" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\assembly\dl3\4d471719\b0f200ca_8797cb01\AbleCRM.DLL" /R:"C:\WINDOWS\assembly\GAC_MSIL\System.Web.Extensions.Design\3.5.0.0__31bf3856ad364e35\System.Web.Extensions.Design.dll" /out:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\App_global.asax.-u9koeb5.dll" /debug- /optimize+ /w:4 /nowarn:1659;1699;1701  "C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\App_global.asax.-u9koeb5.0.cs" "C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a11c95f2\1ad1f81a\App_global.asax.-u9koeb5.1.cs"


Microsoft (R) Visual C# 2005 Compiler version 8.00.50727.3053
for Microsoft (R) Windows (R) 2005 Framework version 2.0.50727
Copyright (C) Microsoft Corporation 2001-2005. All rights reserved.

d:\Internet\TrickConcepts.com\Global.asax(107,20): error CS0111: Type 'ASP.AcApp' already defines a member called 'Application_Start' with the same parameter types
d:\Internet\TrickConcepts.com\Global.asax(69,20): (Location of symbol related to previous error)
d:\Internet\TrickConcepts.com\Global.asax(116,20): error CS0111: Type 'ASP.AcApp' already defines a member called 'Application_End' with the same parameter types
d:\Internet\TrickConcepts.com\Global.asax(78,20): (Location of symbol related to previous error)

The code i am trying to add is:

Code: Select all

    // This runs the automatic feed generator
    private System.Threading.Timer googleFeedMonitor;
    
    // This determines how often the feed will be refreshed (in milliseconds)
    private int googleFeedGenerationFrequency = 21600000; // 21600000ms = 6 HOURS
    
    // This is the relative path of where the feed file will generate
    private string googleFeedFile = "~Feeds/GoogleFeed.txt";

    protected void Application_Start(Object sender, EventArgs e)
    {
        // start the monitor
        googleFeedMonitor = new System.Threading.Timer(new System.Threading.TimerCallback(GenerateGoogleFeed), null, 0, googleFeedGenerationFrequency);

        // check the feed immediately to make sure it's current
        GenerateGoogleFeed(null);
    }

    protected void Application_End(Object sender, EventArgs e)
    {
        if (googleFeedMonitor != null) googleFeedMonitor.Dispose();
    }

    private void GenerateGoogleFeed(object stateInfo)
    {
        // figure out if we should generate the feed
        string feedFile = System.Web.Hosting.HostingEnvironment.MapPath(googleFeedFile);
        if (!GoogleFeedWasRecentlyGenerated(feedFile))
        {
            GoogleBaseFeed.LaunchFeedGenerator(feedFile, null, null);
        }
    }

    private bool GoogleFeedWasRecentlyGenerated(string feedFile)
    {
        // if file is missing, it was not recently generated
        if (!System.IO.File.Exists(feedFile)) return false;

        // file is present, see if the write time is within the regeneration interval
        System.IO.FileInfo fileInfo = new System.IO.FileInfo(feedFile);
        DateTime lastScheduledGenerationTime = DateTime.Now.AddMilliseconds(-1 * googleFeedGenerationFrequency);

        // file was recently generated if it's newer than the last scheduled regeneration
        return fileInfo.LastWriteTime > lastScheduledGenerationTime;
    }

and my current Global.asax looks like:

Code: Select all

<%@ Application Classname="AcApp" Language="C#" %> 
<script runat="server">
    protected void Application_BeginRequest(object sender, EventArgs e)
    {
        //TERMINATE SQL INJECTION ATTEMPTS
        int maxQueryLength = 500;
        string rawUrl = Request.RawUrl;
        int qIndex = rawUrl.IndexOf("?");
        if (qIndex > -1)
        {
            string query = Request.RawUrl.Substring(qIndex).ToUpperInvariant();
            if (query.Length > maxQueryLength || query.Contains("DECLARE%20"))
            {
                //POTENTIAL ATTACK
                Response.Clear();
                Response.Write("INVALID REQUEST");
                Response.Flush();
                Response.End();
            }
        }
        //CHECK FOR "NEW COOKIE PLEASE" INDICATOR
        string ncp = Request.QueryString["NCP"];
        if (ncp != null)
        {
            HttpCookie authCookie = Response.Cookies["AC7.ASPXAUTH"];
            if (authCookie != null) authCookie.Expires = DateTime.Now.AddYears(-1);
            HttpCookie anonCookie = Response.Cookies["AC7.ASPXANONYMOUS"];
            if (anonCookie != null) anonCookie.Expires = DateTime.Now.AddYears(-1);
            HttpCookie sessionCookie = Response.Cookies["AC7.SESSIONID"];
            if (sessionCookie != null) sessionCookie.Expires = DateTime.Now.AddYears(-1);
            Response.Redirect(Request.Url.AbsolutePath);
        }
    }

    protected void Session_OnStart()
    {
        //SAVE THE REFERRER FOR USE BY THE ORDER MODULE
        if (Request.UrlReferrer != null) Session["SessionReferrerUrl"] = StringHelper.Truncate(Request.UrlReferrer.ToString(), 255);
    }

	protected void Application_Error(Object sender, EventArgs e)
	{
        // ENABLE ERROR LOGGING FOR SCRIPTS OUTSIDE OF THE INSTALL DIRECTORY
        if (!HttpContextHelper.IsInstallRequest())
        {
            // RECORD THE DETAILS TO THE AC ERROR LOG
            HttpContext ctx = HttpContext.Current;
            Exception exception = ctx.Server.GetLastError();
            
            // IGNORE INVALID VEIW STATE ERRORS
            if (IsViewStateException(exception)) return;
            
            string errorInfo = "An error has occured at " + ctx.Request.Url.ToString();
            Logger.Error(errorInfo, exception);
        }
	}

    private bool IsViewStateException(Exception exception)
    {
        if (exception == null) return false;
        if (exception is ViewStateException) return true;
        return IsViewStateException(exception.InnerException);
    }
	   //****************************************************
    // W2M JME START OF REFERRAL CODE POINTS PROCESSING
    // THIS VARIABLE HOLDS THE TIMER
    private System.Threading.Timer timer;

    protected void Application_Start(object sender, EventArgs e)
    {
        Logger.Info("Application Starting");
        // SPECIFY THE NUMBER OF MILLISECONDS THAT THE TIMER WILL REPEAT
        int intervalMilliseconds = 12960000;//Six hours 36000;//EVERY MINUTE
        // THIS SETS UP THE TIMER
        timer = new System.Threading.Timer(new System.Threading.TimerCallback(TimedEvent), null, intervalMilliseconds, intervalMilliseconds);
    }

    protected void Application_End(object sender, EventArgs e)
    {
        Logger.Info("Application Ending");
        if (timer != null) timer.Dispose();
    }

    private void TimedEvent(object stateInfo)
    {
        Store store = StoreDataSource.Load(1);
        // INITIALIZE THE TOKEN FOR THIS STORE
        Token.Instance.InitStoreContext(store);
        W2MCustomClasses.Referrals.ReferralProgramCalculations.ScheduledCreatePoints(Token.Instance.Store);
        W2MCustomClasses.Referrals.ReferralProgramCalculations.GenerateGiftCertificates(Token.Instance.Store);
        Token.ResetInstance();
    }
    //************************
    //END OF REFERRAL POINTS PROCESSING
	
	
	

</script>
I assume its interfering with the Referral Code timer, but I can't seem to figure out how to get them to work together. Does anyone have any idea I could get this to work?

User avatar
jmestep
AbleCommerce Angel
Posts: 8164
Joined: Sun Feb 29, 2004 8:04 pm
Location: Dayton, OH
Contact:

Re: New problem with Google Feeds in 7.0.7

Post by jmestep » Wed May 02, 2012 1:35 pm

Yes, it is because the Referral timer. You can add a new timer and use that, or you can try putting your google code inside the referral code. You don't want to add the App_Start and App_End again. You can try putting the google code right after the referral code.

Token.Instance.InitStoreContext(store);
W2MCustomClasses.Referrals.ReferralProgramCalculations.ScheduledCreatePoints(Token.Instance.Store);
W2MCustomClasses.Referrals.ReferralProgramCalculations.GenerateGiftCertificates(Token.Instance.Store);
///add google code here, but you have to know what parts to add.

Token.ResetInstance();

Or you could take the referral code out, put the google code in, then add these two lines inside the google code
W2MCustomClasses.Referrals.ReferralProgramCalculations.ScheduledCreatePoints(Token.Instance.Store);
W2MCustomClasses.Referrals.ReferralProgramCalculations.GenerateGiftCertificates(Token.Instance.Store);
inside the google code, after the following
if (!GoogleFeedWasRecentlyGenerated(feedFile))
{
GoogleBaseFeed.LaunchFeedGenerator(feedFile, null, null);
}

Or something similar
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx

User avatar
hassonmike
Lieutenant (LT)
Lieutenant (LT)
Posts: 76
Joined: Tue Apr 19, 2011 2:13 pm
Contact:

Re: New problem with Google Feeds in 7.0.7

Post by hassonmike » Thu May 03, 2012 9:20 am

So I went with the second method, and it brought my whole store down. No error page or anything. I restored the orginal global.asax, and now i just a get a blank page that sais "SERVICE UNAVAILABLE"


...any ideas?

User avatar
hassonmike
Lieutenant (LT)
Lieutenant (LT)
Posts: 76
Joined: Tue Apr 19, 2011 2:13 pm
Contact:

Re: New problem with Google Feeds in 7.0.7

Post by hassonmike » Thu May 03, 2012 9:50 am

Site is back up, and this is the last time I mess with the global.asax file. Leavin' this one to the pros, but thanks anyway for your help.

Post Reply