Community Add-Ons

Makes live easier ;)


(I hope this one is working)

I installed the most recent version of this add-on but wasn't being prompted to download a CSV file after clicking 'Export to CSV'. I know little about PHP but I showed my expert brother and he said:

"There was a bug in the code - it used an old rarely supported PHP feature, of turning form fields directly into variables."

He modified the file for me and now it works. So hopefully it will work for you too :)

(only contains the modified file i.e. exportorders.php)

Changed text input to pull down menu populated with the orders id's

(only contains the modified file i.e. exportorders.php)

Fixes a small error in /catalog/admin/includes/boxes/customers.php which causes the word 'Orders' to be shown twice in the Customers/Orders panel, with the bottom one activating the Export Orders function.

Replace

// BOF Export Orders to CSV
$contents[] = array('text' => '<a href="' . tep_href_link(FILENAME_CUSTOMERS, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_CUSTOMERS_CUSTOMERS . '</a><br>' .
'<a href="' . tep_href_link(FILENAME_ORDERS, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_CUSTOMERS_ORDERS . '</a><br>' .
'<a href="' . tep_href_link(FILENAME_EXPORTORDERS, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_CUSTOMERS_ORDERS . '</a>');
// EOF Export Orders to CSV

with

// BOF Export Orders to CSV
$contents[] = array('text' => '<a href="' . tep_href_link(FILENAME_CUSTOMERS, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_CUSTOMERS_CUSTOMERS . '</a><br>' .
'<a href="' . tep_href_link(FILENAME_ORDERS, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_CUSTOMERS_ORDERS . '</a><br>' .
'<a href="' . tep_href_link(FILENAME_EXPORTORDERS, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_CUSTOMERS_EXPORTORDERS . '</a>');
// EOF Export Orders to CSV

Hi all, because some of you have some problems with this contrib and that I might not have the solution straight, I created a topic on the forums that you can find here : http://forums.oscommerce.com/index.php?showtopic=275481

Just a small change to make it work wit v2.2 RC1:

find line (68):

<form method="GET" action="<?php echo $PHP_SELF; ?>">

REPLACE with:
<?php echo tep_draw_form('exportorders', FILENAME_EXPORTORDERS); ?>

Same text in attached file

English :

I republish the files as there was an error in the previous package.

- I added a link in the admin pannel to open the exportorder.php (in category customer/orders).
- Now supports languages (French and English but it is now easy to add another language).
- You can leave the fields empty if you want to export all orders or you can fill only one of the fields if you want all orders from number X or all orders to number X.
- A bug has been corrected in the select query.

Français :

Je republie les fichiers car il y avait une erreur dans le package précédent.

- Ajout dans le panneau d'admin d'un lien vers exportorder.php (dans la catégorie client/commandes).
- Support des langues (Français et Anglais, on peut facilement ajouter d'autres langues).
- Possibilité de laisser les champs vides pour sélectionner toutes les commander ou de ne laisser qu'un des deux champs vides pour sélectionner soit les commandes commençant par le numéro X soit les commandes allant jusqu'au numéro X.
- Correction d'un bug sur la requète de sélection des commandes.

English :

- I added a link in the admin pannel to open the exportorder.php (in category customer/orders).
- Now supports languages (French and English but it is now easy to add another language).
- You can leave the fields empty if you want to export all orders or you can fill only one of the fields if you want all orders from number X or all orders to number X.
- A bug has been corrected in the select query.

Français :

- Ajout dans le panneau d'admin d'un lien vers exportorder.php (dans la catégorie client/commandes).
- Support des langues (Français et Anglais, on peut facilement ajouter d'autres langues).
- Possibilité de laisser les champs vides pour sélectionner toutes les commander ou de ne laisser qu'un des deux champs vides pour sélectionner soit les commandes commençant par le numéro X soit les commandes allant jusqu'au numéro X.
- Correction d'un bug sur la requète de sélection des commandes.

FIxed some bugs:
Date formats fixed.
FIle save was working only in Firefox, not in IE. added the fix for that.

Changes for Upgrade:
1- Look for the way my dates are getting $Date and $Time

2- Look for sql query for $orders (Added order by)

3- Look for $headers in bottom. 2 lines added.

Again.
Just add/replace the file in /admin/

Hi, Just add the file in /admin/

NOthing changed as of now from the previouos load.

This module was developed for ideal accounting software. This creates a csv file based on their requirements with both order and products info on one line.

This module can easily be modified. Only one file. In my first test version i am asking a start order number and end order no. in version two, i will add db field to set a flag so the data which is exported before, wont show up again.

its very simple program. I have limited knowlege of php and i just scrambled some thoughts. If someone wishes to fix it, they can.

overall everything works just fine.