Search found 117 matches

by keats76
Fri Jan 08, 2010 9:29 am
Forum: Feature Requests
Topic: Automation/Scheduler for tasks needed
Replies: 10
Views: 12200

Re: Automation/Scheduler for tasks needed

gunter
Any update on the scheduler front? I'm interested ... !
by keats76
Mon Nov 09, 2009 9:54 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Coupon for a kit component
Replies: 0
Views: 1563

Coupon for a kit component

All, I searched on this, but couldn't seem to find an answer. I'd like to create a coupon that will allow our customers to receive a free item if they add a kit option to their order. e.g. 1) Buy a shirt with one logo, get a second logo free So the shirt would the the parent product and the logo wou...
by keats76
Tue Oct 06, 2009 6:30 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: BasketItems Are Killing Me!! Help!
Replies: 7
Views: 4080

Re: BasketItems Are Killing Me!! Help!

I reverted to version 7.0. It handled my ~4000 tax rules with ease. I finally got it working in 7.0.3 only to realize that my customers can't wait 10 minutes to check out while Able calculates tax. Someone really needs to take a look at this. Either there should be some stock 3rd party tax provider ...
by keats76
Sat Oct 03, 2009 8:29 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: BasketItems Are Killing Me!! Help!
Replies: 7
Views: 4080

Re: BasketItems Are Killing Me!! Help!

Ahhh crap ... it looks like the upgrade from 7 to 7.0.1 completely changed how the postal code filter was used. Someone please correct me if I'm wrong, but I guess now I need to rewrite my tax rules so that each old "postalcodefilter" is now a region or zone, and then the tax rule has to tie back to...
by keats76
Sat Oct 03, 2009 7:59 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: BasketItems Are Killing Me!! Help!
Replies: 7
Views: 4080

Re: BasketItems Are Killing Me!! Help!

I have 3896 tax rules. Perhaps my problem is not understanding the new tax changes from AC7 to 7.0.3. It appears that when OnePageCheckout calls: basket.Recalculate(); the system is creating basketitems for each tax rule in my database (so far as I can tell). Is there a reason why the Postal Code Fi...
by keats76
Sat Oct 03, 2009 6:58 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: BasketItems Are Killing Me!! Help!
Replies: 7
Views: 4080

Re: BasketItems Are Killing Me!! Help!

Yeah, I have many thousands of rows (to accommodate every state in the USA ... although not perfectly). It appears when the OnePageCheckout is called for taxable orders the DB gets hammered and the system locks up. Able pumps row after row of tax records into the basketitems table. Can anyone help? ...
by keats76
Sat Oct 03, 2009 2:28 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: BasketItems Are Killing Me!! Help!
Replies: 7
Views: 4080

BasketItems Are Killing Me!! Help!

Ok now this is just plain odd ... we just went live with our new 7.0.3 site yesterday and we found that almost no one was able to checkout. I ran across some posts that mentioned the lack of indexes on the database and that led me to look at the sql server. It was pegged at 100%. I kicked off the pr...
by keats76
Wed Sep 30, 2009 6:26 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: AC 7.0.3 Email Content Templates
Replies: 4
Views: 3411

Re: AC 7.0.3 Email Content Templates

I downloaded a self extracting exe that unzipped to a directory. I had all of the other files and the install completed without issues, but there weren't any content templates (unless they are in a different location). Does anyone have a zip of the default templates that I could download? Thanks, Mike
by keats76
Tue Sep 29, 2009 6:30 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: AC 7.0.3 Email Content Templates
Replies: 4
Views: 3411

AC 7.0.3 Email Content Templates

OK, just updated to 7.0.3 (started with a fresh install then merged my changes in) and I am having trouble with the email templates. Their is a new field for email "content" template which is blank. The templates won't allow for changes if the field is empty, but I see no way of populating it. Also,...
by keats76
Mon Sep 14, 2009 9:21 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Intergration Senario
Replies: 4
Views: 2728

Re: Intergration Senario

Haven't looked into it in a while, but you could always purchase the source and then roll your own user authentication. I'm not sure if they allow you to do that out of the box though.
by keats76
Tue Sep 08, 2009 8:25 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: 7.0.3 Order# different from OrderId
Replies: 21
Views: 25978

Re: 7.0.3 Order# different from OrderId

Is there anyway to change the OrderID and OrderNumber to be the same? I have full access to the SQL database and can do what is needed. The change to 7.0.3 has been a nightmare and cause numerous issues with OrderID and Order Number now The short answer is "Yes", but be prepared to go through your ...
by keats76
Tue Sep 08, 2009 6:14 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Cannot Insert NULL into column 'UserId'
Replies: 5
Views: 5286

Re: Cannot Insert NULL into column 'UserId'

Nevermind, as is usually the case with this type of problem, the issue was behind the keyboard, not with AC. I removed the identity portion of the index on the ac_users table to copy over my user list. I subsequently forgot to re-enable the identity specification (and bump up the seed). Once complet...
by keats76
Mon Sep 07, 2009 6:22 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Cannot Insert NULL into column 'UserId'
Replies: 5
Views: 5286

Re: Cannot Insert NULL into column 'UserId'

Hmmm, yeah I've tried a number of different methods (data migration tool) for the appropriate versions as well as a manual database migration. Both resulted in the same problem. The problem with the page file update is that there are a number of steps between pre 7 to 7.0.3. I have hundreds of custo...
by keats76
Fri Sep 04, 2009 2:40 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Cannot Insert NULL into column 'UserId'
Replies: 5
Views: 5286

Re: Cannot Insert NULL into column 'UserId'

The error happens whenever I try to load a page in AC, doesn't matter which page.
by keats76
Fri Sep 04, 2009 2:39 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Cannot Insert NULL into column 'UserId'
Replies: 5
Views: 5286

Re: Cannot Insert NULL into column 'UserId'

Oops, would help if I posted the full message: Cannot insert the value NULL into column 'UserId', table 'AC.dbo.ac_Users'; column does not allow nulls. INSERT fails. The statement has been terminated. Description: An unhandled exception occurred during the execution of the current web request. Pleas...
by keats76
Fri Sep 04, 2009 2:38 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Cannot Insert NULL into column 'UserId'
Replies: 5
Views: 5286

Cannot Insert NULL into column 'UserId'

Anyone ever see this? I'm upgrading an older Pre 7 release to 7.0.3. I've tried a few different methods of upgrading, and I'm pulling my hair out at the moment :). I brought up a fully working 7.0.3 instance (demo) and then I started to migrate data over. This error started happening after I moved o...
by keats76
Fri Aug 28, 2009 6:18 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Database upgrade 7.0 Pre Release to 7.03
Replies: 7
Views: 3835

Re: Database upgrade 7.0 Pre Release to 7.03

Good timing on this question ... I'm migrating a heavily customized 7.0 pre release to 7.03 as we speak. I started off with a fresh 7.0.3 install and now I'm merging in the customizations ... file comparison is very tedious, but necessary. I use a tool called WinMerge which is open source and freely...
by keats76
Wed Jul 22, 2009 8:17 am
Forum: International Questions and Topics
Topic: Multilingual support customization
Replies: 10
Views: 30318

Re: Multilingual support customization

Any hope of joining forces and migrating this solution to the core product? I toyed with localization a while back but I kept running into problems. A localized product with a standard set of resource bundles would be Awesome! If not able to merge into core, mike_f, would you be willing to share/sel...
by keats76
Wed Jul 22, 2009 6:16 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Passing local currency amounts to Payment Gateway and report
Replies: 11
Views: 7805

Re: Passing local currency amounts to Payment Gateway and report

Any update on this? I may have to implement a similar solution in the near future.

Thanks!
Mike
by keats76
Fri Jan 30, 2009 4:21 pm
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Shipping weight problem
Replies: 13
Views: 11008

Re: Shipping weight problem

I had this problem as well. My products are auto generated. I noticed that every once in a while the shipping service would bomb for certain quotes and that my users were not presented with any shipping options (effectively ending their ability to place an order). I tracked it down to the shipping w...
by keats76
Fri Dec 12, 2008 7:41 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: AC7 Job Scheduler screenshot
Replies: 56
Views: 52153

Re: AC7 Job Scheduler screenshot

Ironic that I just stopped by the forums to figure out how to tie into the existing scheduler ...

Now to convince the powers that be that they should lift the spending freeze :(

Thanks!
by keats76
Wed Nov 19, 2008 9:02 am
Forum: Feature Requests
Topic: Add Some Open Fields To The User Profile
Replies: 4
Views: 4822

Re: Add Some Open Fields To The User Profile

My problem was the integration of nVelocity and the data from the UserSettings. I tried everything I could think of, but I couldn't convert a string to a number (of any type) via the nVelocity engine. I ended up using a large switch statement to test for string values of the numbers I needed. It was...
by keats76
Fri Nov 14, 2008 7:45 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Show OrderNote in order confirmation Email?
Replies: 8
Views: 4197

Re: Show OrderNote in order confirmation Email?

Something like this would probably work:

#foreach($note in $order.Notes)
$note.Comment <br/>
#end

I think the $order object is available to most nVelocity templates. Give it a shot and see if it works.

the note object is of type OrderNote if you want to look it up in the API.
by keats76
Tue Nov 04, 2008 11:27 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Banning ALL IP addresses from Africa
Replies: 3
Views: 2680

Re: Banning ALL IP addresses from Africa

Those IPs are real :) They're just listed in Hex. That's how they're stored in the database. I created an excel spreadsheet to do the conversions for me, then I inserted the records in the db. I'll attach another spreadsheet. This one takes the typical IP range (i.e. 0.0.0.0 to 255.255.255.255) and ...
by keats76
Mon Nov 03, 2008 10:48 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: Banning ALL IP addresses from Africa
Replies: 3
Views: 2680

Re: Banning ALL IP addresses from Africa

This feature already exists (see below). I haven't had any problems with Africa, but I've had my fair share with China and Korea. Here is a list of my Banned IPs. Feel free to insert them into your ac_BannedIPs table in your database. These IPs were pulled from various websites as well as specific a...