Issue exporting filtered order list
Issue exporting filtered order list
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!
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!
Re: Issue exporting filtered order list
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
Thanks
Katie
Thank you for choosing AbleCommerce!
http://help.ablecommerce.com - product support
http://wiki.ablecommerce.com - developer support
http://help.ablecommerce.com - product support
http://wiki.ablecommerce.com - developer support
Re: Issue exporting filtered order list
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?
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?
Re: Issue exporting filtered order list
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.
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
http://help.ablecommerce.com - product support
http://wiki.ablecommerce.com - developer support
Re: Issue exporting filtered order list
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.
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.
Re: Issue exporting filtered order list
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.
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
http://help.ablecommerce.com - product support
http://wiki.ablecommerce.com - developer support
Re: Issue exporting filtered order list
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.
It could be some rewrite urls in the top-level application. Able is installed as a child app.
Okay, thanks for testing that out.
Re: Issue exporting filtered order list
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
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
Re: Issue exporting filtered order list
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.
I'll post back if I find a solution.
Re: Issue exporting filtered order list
Ah ok, rules out the timeout theory then
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
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
Re: Issue exporting filtered order list
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.
I bumped it up and now it's working. I'll probably just override it in the Able web.config.
Sorry for the trouble.
Re: Issue exporting filtered order list
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
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