Orders Exporter Module

[gjh42]

The /oexport/ folder is just a place for downloaded files to be saved to by the export page.

[giftmeister]

Do you have a timetable for the revamped mod? The current one and a similar one (Export Shipping Information) do some good things, but not everything I need and the date function would make this one perfect.

Thanks for all your contributions!

[gjh42]

I got the changes partly functional, but time ran out for me on the urgent application, and I have been busy with other things since June. When I get time to concentrate, I do want to finish debugging and making the modest upgrade work, and make it available. Getting that base functional should make it easier to do the major overhaul.

[gjh42]

My big obstacle with dates, oddly enough, has been making the "between" function of MySQL operate. The manual indicates that it should work exactly as I used it, but it gives no output. If I knew SQL debugging tools I might be able to figure out what it doesn't like. Alternately I could use a more verbose but maybe more reliable ">" and "<" set of filters.

[giftmeister]

Wish I could help. The other mod, Export Shipping Information, does date ranges.

[gjh42]

Update: I have completed the major rewrite of this mod and have it functioning perfectly in my local test site. I next need to transfer it to my live site and ensure that it works there, do some more overhaul of the readme, and then it will be ready for release. I can package it soon for anyone who would like to test it and give feedback before official release. It works on v1.5.0 and v1.5.1, and I know of no reason it should not work on v1.5.3 (I will test this before release).

The new version has all new code except for the actual download/save functionality, and allows you to select a range of days ago, from/to dates, or from/to order ids, and then the original choice of download styles, plus the ability to download all of any one order status within the specified range. You can set in the defines the fields to export and their order in the file. The tab-delimited file will have customizable field titles, and basic info like customer name, date, etc. only appears once for orders with multiple products or attributes. Total cost and order comments can be included in the output, and other fields can be added by following the format of existing ones.

[RixStix]

TNX Glenn,

I am testing v1.5.3 in my sandbox and am expecting to go live early next week. We use orders exporter on a daily basis, so I have the time to give it a workout in v1.53.

153bugs(at)chainweavers.com if you need an email address

[gjh42]

Here is a zip of RC1 for testing. Please let me know of any issues, and what environments you have tested on.
I still need to figure out an uninstall SQL for this; the file included is a stub from another mod. Any examples for uninstalling from the Tools menu would be appreciated.

[gjh42]

This shows the options on the admin page:

[RixStix]

My schedule for tonight was just redirected to a different priority, so I'll look more tomorrwo.

First run. Minor issue, browser title
Attachment 14288

First couple of reports run included the contents of the "Keep alive session" file above the expected data.

Below that keep-alive code was the expected data for orders in the processing status.

You certainly have expanded the options.

zen v1.5.3 installed one folder inside server root.

<!-- BOF: Keepalive for Session -->
<!-- timeout warning alert -->
<div id="keepalivetimer" title="Your session is about to expire!" style="display: none">
<p class="ui-state-error-text">
<span class="ui-icon ui-icon-alert" style="float:left; margin:0 7px 50px 0;"></span>
You will be logged off in <span id="keepalivetimer-countdown" style="font-weight:bold"></span> minutes.
</p>
<p>Do you want to continue your session?</p>
</div>
<link href="//ajax.googleapis.com/ajax/libs/jqueryui/1.10.1/themes/base/jquery-ui.css" type="text/css" rel="stylesheet" />
<script type="text/javascript">
if (typeof jQuery == "undefined") {//no jquery yet
document.write('<scr'+'ipt type="text/javascript" src="//ajax.googleapis.com/ajax/libs/jquery/1/jquery.min.js">');
document.write('</scr' + 'ipt>');
}
</script>
<script type="text/javascript">
if (!jQuery.ui) {
document.write('<scr'+'ipt type="text/javascript" src="//ajax.googleapis.com/ajax/libs/jqueryui/1/jquery-ui.min.js">');
document.write('</scr' + 'ipt>');
}
</script>
<script src="includes/javascript/jquery.idletimer.js?t=1405472253" type="text/javascript"></script>
<script src="includes/javascript/jquery.idletimeout.js?t=1405472253" type="text/javascript"></script>
<style type="text/css">
a.ui-dialog-titlebar-close {display:none;}
.ui-widget-overlay { background: green; opacity: .40;filter:Alpha(Opacity=40); }
</style>
<script type="text/javascript">
//setup the dialog
$("#keepalivetimer").dialog({
autoOpen: false,
modal: true,
width: 430,
height: 250,
closeOnEscape: false,
draggable: false,
resizable: false,
position: "top",
buttons: {
'Yes, Keep Working': function(){
$(this).dialog('close');
},
'No, Logoff': function(){
$.idleTimeout.options.onLogoffClick.call(this);
}
}
});
// start the idle timer monitor
var $countdown = $("#keepalivetimer-countdown");
$.idleTimeout('#keepalivetimer', 'div.ui-dialog-buttonpane button:first', {
idleAfter: 600, // 600 user is considered idle after 10 minutes of no movement in this browser window/tab
warningLength: 250, // 250 countdown timer starts at this many seconds (250sec=4:50min)
pollingInterval: 60, //60 check for server connection every minute; if it fails or user is logged out, keepalive scripts will abort
keepAliveURL: 'keepalive.php', serverResponseEquals: 'OK',
titleMessage: 'Warning: %s seconds until log out | ',
onTimeout: function(){
document.title = '!!Expired Session';
$(this).html('<p class="ui-state-error-text"><span class="ui-icon ui-icon-alert" style="float:left; margin:0 7px 50px 0;"></span>Sorry, you have been logged out due to inactivity.</p><p>Any unsaved work was lost. If you were composing content which you wish to save, click Close and copy that content to your clipboard. Then refresh the page to login again.</p><p>To continue, please login again.</p>');
$(this).dialog("option", "title", 'Your session has expired');
$(this).dialog("option", "minWidth", "450");
$(this).dialog("option", "buttons", {'Close': function(){$(this).dialog('close');},'Login': function(){window.location.reload();}});
//$(this).dialog("option", "buttons", {'Login': function(){window.location.reload();} });
},
onAbort: function(){
// TODO: another modal dialog would be more friendly
alert('We are unable to connect to the server. Your work may be lost. Please review your work and perhaps copy information to your clipboard if you had any work in progress which you do not wish to lose.');
},
onIdle: function(){
$(this).dialog("open");
},
onLogoffClick: function(){
window.location = "logoff.php";
},
onCountdown: function(counter){
var sec = counter % 60;
var min = Math.floor(counter/60);
if (sec < 0) {
sec = 59;
min = min - 1;
}
if (sec<=9) { sec = "0" + sec; }
var time = (min<=9 ? "0" + min : min) + ":" + sec;
$countdown.html(time);
}
});
</script>
<!-- EOF: Keepalive for Session -->
Status	OID	Date purchased	Name	E-mail	Product name	Qty	Options	Values	Comments	ENDOFROW
Processing	EDITED	########	EDITED	Bronze	0.5	Wire	Square		ENDOFROW
					0.5	Mandrel	3.50		ENDOFROW