Issue exporting filtered order list

For general questions and discussions specific to the AbleCommerce GOLD ASP.Net shopping cart software.
Post Reply
corgalore
Lieutenant, Jr. Grade (LT JG)
Lieutenant, Jr. Grade (LT JG)
Posts: 32
Joined: Thu Nov 08, 2012 2:57 pm

Issue exporting filtered order list

Post by corgalore » Thu Jan 18, 2018 2:15 am

We needed to export a list of all orders where products in the order contained a word. We used Data > Export > Orders, then searched for orders, selected the ones we wanted, then used the dropdown to select export. It resulted in this url, which gives a 404:


https://www.domain.com/shop/Admin/DataE ... 22%3A16%7D

If I remove the 'filter' query param, then the page loads, but removes the order filter. Can you please let me know what I'm doing wrong?

Thanks!

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

Re: Issue exporting filtered order list

Post by Katie » Thu Jan 18, 2018 2:32 am

What version and build are you using? I just tested on Gold R11 and it works fine. I wouldn't expect a 404 error. Have you made any customizations to these pages?

Thanks
Katie
Thank you for choosing AbleCommerce!

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

corgalore
Lieutenant, Jr. Grade (LT JG)
Lieutenant, Jr. Grade (LT JG)
Posts: 32
Joined: Thu Nov 08, 2012 2:57 pm

Re: Issue exporting filtered order list

Post by corgalore » Thu Jan 18, 2018 2:41 am

AbleCommerce GoldR12SR1 (build 9266)

The file was unchanged from the original install.

I checked the Event Viewer. No errors recorded. Nothing in Error Log either.

Any ideas? Maybe a security rule on the url length or a rewrite url that's getting triggered?

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

Re: Issue exporting filtered order list

Post by Katie » Thu Jan 18, 2018 4:26 am

I can try another test. Maybe there is something different in how we are doing the export.

Just post the exact steps you are taking, and what info and settings are being selected for the search.
Thank you for choosing AbleCommerce!

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

corgalore
Lieutenant, Jr. Grade (LT JG)
Lieutenant, Jr. Grade (LT JG)
Posts: 32
Joined: Thu Nov 08, 2012 2:57 pm

Re: Issue exporting filtered order list

Post by corgalore » Thu Jan 18, 2018 4:44 am

Sure.

I'm going to the Data > Export > Orders, then hit Filter Orders button.

Fill in Find Keyword with 'AR' and change dropdown to Product Name and hit Search.

Hit top checkbox to select all, then accept prompt to expand selection to all pages.

Go to bottom and choose Export from dropdown, then hit Go.

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

Re: Issue exporting filtered order list

Post by Katie » Thu Jan 18, 2018 5:00 am

Tried again and it still works. I'm not surprised though. Gold doesn't have any major issues, so this seems to be related to your installation. Maybe even at the server level since you are getting a page not found error. The URL you posted looks properly formatted. It's the same as mine except for the /shop/ folder.

How many orders are you selecting? I tried with about 20,000.
Thank you for choosing AbleCommerce!

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

corgalore
Lieutenant, Jr. Grade (LT JG)
Lieutenant, Jr. Grade (LT JG)
Posts: 32
Joined: Thu Nov 08, 2012 2:57 pm

Re: Issue exporting filtered order list

Post by corgalore » Thu Jan 18, 2018 5:05 am

Not nearly that many orders...maybe 4,000.

It could be some rewrite urls in the top-level application. Able is installed as a child app.

Okay, thanks for testing that out.

User avatar
AbleMods
Master Yoda
Master Yoda
Posts: 5170
Joined: Wed Sep 26, 2007 5:47 am
Location: Fort Myers, Florida USA

Re: Issue exporting filtered order list

Post by AbleMods » Fri Jan 19, 2018 1:20 am

Could also simply be a page timeout error because the process is taking too long to complete. I've seen browsers throw a 404 when the page doesn't respond within a set time period. Does the 404 come up right away, or does it take a few minutes to happen?
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

corgalore
Lieutenant, Jr. Grade (LT JG)
Lieutenant, Jr. Grade (LT JG)
Posts: 32
Joined: Thu Nov 08, 2012 2:57 pm

Re: Issue exporting filtered order list

Post by corgalore » Fri Jan 19, 2018 1:47 am

The 404 is immediate. It's as if the query string params are triggering some kind of a url rewrite.

I'll post back if I find a solution.

User avatar
AbleMods
Master Yoda
Master Yoda
Posts: 5170
Joined: Wed Sep 26, 2007 5:47 am
Location: Fort Myers, Florida USA

Re: Issue exporting filtered order list

Post by AbleMods » Fri Jan 19, 2018 1:55 am

Ah ok, rules out the timeout theory then :D
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

corgalore
Lieutenant, Jr. Grade (LT JG)
Lieutenant, Jr. Grade (LT JG)
Posts: 32
Joined: Thu Nov 08, 2012 2:57 pm

Re: Issue exporting filtered order list

Post by corgalore » Fri Jan 19, 2018 6:03 am

Found the problem. There was a <requestLimits maxQueryString="255" /> in the root application that was getting inherited in Able.

I bumped it up and now it's working. I'll probably just override it in the Able web.config.

Sorry for the trouble.

User avatar
AbleMods
Master Yoda
Master Yoda
Posts: 5170
Joined: Wed Sep 26, 2007 5:47 am
Location: Fort Myers, Florida USA

Re: Issue exporting filtered order list

Post by AbleMods » Fri Jan 19, 2018 6:52 am

LOL I know that feeling. That whole config-inheritance thing is quite unforgiving. Glad you figured it out :)
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

Post Reply