[ic] Lost most items in my products.txt after export viaUI!

[Joachim Leidinger]

Dan Browning wrote:
[DEL]
> > > >i try to find out the cause of the wrong products.txt after using the
> > > >export in UI.
> > > >I've for example 1000 products and I get 15 products after export (UI)
> > > >suddenly!
> > > >Why? How can I find the wrong products, which makes my products.txt mad?
> > > >Any tips, helps and suggestions are very welcome.
[DEL]
> >I've a backup and I've exported the database into another file and get
> >the same result. :-(
> >There are different behavior between the normal shop and  the UI. If i
> >search for "e", the shop find 1330 products. This is my whole database.
> >If i click the "items" in my UI, UI can only found 15 products. If i
> >search for "Beer", the shop can list all items with "Beer". If I search
> >for "Beer" in UI, UI can't found that items. Very strange!
> >
> >What ist the cause?
> >Maybe, there are some Codes from Windows via Copy & Paste? How can I
> >find this Codes?
[DEL]
> I'm not sure if Windows carriage returns are your problem (\r\n), but I can
> tell you how to search for and remove them:
> 
> od -a products.txt | grep <cr>
> 
> If anything shows up on your screen, you have windows line endings.  You
> can remove them pretty easily in a variety of ways:
> 
> 1. Use tr
> 
> $tr -d "\r" < oldfile > newfile
> 
> 2. Perl oneliner:
> 
> $perl -pi -e 's/\r//g'
[DEL]

I've found two items with carriage return. But that was not the cause of
broken products.txt. I'm wondering, why is the normal shop/catalog able
to show the whole database and UI not? Why is the shop/catalog able to
show the whole 1330 items and why is UI able to show 15 items only and
not the whole 1330 items?

What can I do to find the cause?

Thanks!

Joachim

-- 
------------------------------------------------------------------
 Hans-Joachim Leidinger | Entwicklung eCommerce | Dipl.-Phys.Ing.
             Black Point Arts Internet Solutions GmbH
   [Hans-Joachim.leidinger@bpanet.de]  w w w . b p a n e t . d e