Contributions

Customer Export

Full package with french
Multi languages

Screenshots visible at: http://www.oscommerce-screenshots.com/customer-export-p-41.html

***********************************

Pack complet avec français
Multi langages

Copies d'écrans visible à : http://www.oscommerce-screenshots.com/customer-export-p-41.html

It's bjornlarsen package with full multilingual support:
+ no hardcoded lang dependant words
+ added english lang file
+ added polish lang file
Enjoy

This file includes all the fixes outlined below.

Possilby only with the latest package, but there is an inherit programming flaw in the query that generates the content for the txt file.

[code]Line 181
order by c.customers_lastname, c.customers_firstname limit 20";
should be
order by c.customers_lastname, c.customers_firstname";[/code]

This will produce all results no matter what your paging is setup to display.

Rob

NOTE: DUMMY FILE - DOWNLOAD PACKAGES BELOW AND APPLY THE FIX

Install Text Typo:

Step2 in the install file is missing a letter it reads:

define('FILENAME_CUSTOMER_EXPORT', 'customer_export.php');

But it should read:

define('FILENAME_CUSTOMERS_EXPORT', 'customer_export.php');

[NOT FULL PACKAGE - Download the Package below Posted by mnk]

Update to version 1.3 upload by Sanquinarius.




NOTE: This is improvement to previous updates. Added ability choose separator .

FULL PACKAGE

Enjoy!


MNK

Update to version 1.3 upload by Sanquinarius.




NOTE: This is improvement to previous updates. Added ability choose separator .

Enjoy!

MNK

Update to version 1.3 upload by Sanquinarius.

INSTRUCTIONS:
Upload the attached file to catalog/admin/

NOTE: This only the customer_export.php file and will replace the file included in previous updates.

NOTE: This is only a modification to previous updates. You must install version 1.3 before this one. Follow instructions from previous contributions.


Changelog:

* Export to MS Excel (2002 and above compatible)
* Excel sheet is dated to maintain download history
* alternate row bg colors
* excel sheet has store title and download date
* row headers are highlighted
* cells are formatted

**** It works for me. Use at your own risk! **
Enjoy!

John
Pepie LLC

Changelog:

v. 1.3:

* Combined or made sure all previous fixes were included in this version:
'Export Customers' issue
State Field Fix
Code to export the state
GetsCode to show the zone name.
Tab-delimited version
* Included customer_export.php versions for either a comma-delimited .csv file or a tab-delimited .txt file (take your pick).
* Updated the install instructions to reflect the txt or csv option.

Support thread is at: http://forums.oscommerce.com/index.php?showtopic=142447

We had a problem with customers adding commas to some of the address fields. This in turn was messing up the csv file.

This version outputs a tab de-limited export.txt file. I have also added a newsletter column in the output. Not full package - ONLY customer_export.php - just replace this file.

Open the tab-delimited file with excel once downloaded.

A modification to Stacey Tipton's file to add the zone name. It's added as County, as I'm from the UK.

Just the customer_export.php file, so you'll need the full package.

I added the code to export the state with this. Enclosed is the entire package.

The state field is still left blank for US orders - I only have the state field listed for the UK - does anyone have a fix? I added the 2nd address line - which is called suburb in the english.php file - should be renamed to address line 2 for US based shops.

Here is my updated file for customer_export.php - but it doesn't contain the original instructions or anything, and the state is still missing from the .csv files as mentioned above.

Corrects a language mistake that prevented the State field from being loaded into the exported files.

A quick fix.

in the field that was copied add a space in :
"menuBoxContentLink">' . 'Export Customers' . '</a>' .

Before:
'Export Customers'

After:
'Export Customers '

THis way it creates its own field in admin, instead of:

Export CustomersMonthly Sales/Tax

where two fields are on top of each other.

Released due to great demand, this contribution exports all customer data into an excel spreadsheet which is saved to the
area that you designate. This permits a store owner to download his customer data and view it in Excel.