Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Customer Export 1.0 problem


Ninalune

Recommended Posts

I installed contribution to export customer data (Contribution Name: Customer Export 1.0 by Robert Heath). It all worked fine until the number of customers grew to above 20.

 

I can see them all in admin area, but when I am exporting data, only the first 20 records are saved - just what you see on the first page in admin area. It does not matter from which page I am saving - first or second - it saves only 20.

 

How do I fix it?

 

Thanks!

Link to comment
Share on other sites

  • 2 weeks later...

Hi having the same problem!

Did you manage to get this fixed?

 

Cheers

 

 

I installed contribution to export customer data (Contribution Name: Customer Export 1.0 by Robert Heath). It all worked fine until the number of customers grew to above 20.

 

I can see them all in admin area, but when I am exporting data, only the first 20 records are saved - just what you see on the first page in admin area. It does not matter from which page I am saving - first or second - it saves only 20.

 

How do I fix it?

 

Thanks!

Link to comment
Share on other sites

  • 2 weeks later...

There is an inherit programming flaw in the query that generates the content for the txt file.

 

Line 181
							   order by c.customers_lastname, c.customers_firstname limit 20";
should be
							   order by c.customers_lastname, c.customers_firstname";

 

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

 

Rob

Edited by shooter-boy

Rob Bell - Inspired Graphix

Customising osCommerce in Australia, and the world!

View my profile for web and email links.

 

I'm sorry, but i cannot offer Free support via PM etc, and osCommerce forums prohibit me from putting any reference to paid support in my signauture.

However viewing my profile may provide links to my website or something like that which you may find useful.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...