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

Joachim Leidinger interchange-users@lists.akopia.com
Tue Jul 31 15:44:01 2001


Ed LaFrance wrote:
> 
> At 03:31 PM 07/31/2001 +0200, you wrote:
> >Hi List,
> >
> >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.
> >
> >Thanks!
> >
> >Joachim
> 
> It sounds like you are using the default database (db, gdbm) and you
> exported to the default file name, which is the source text file name for
> the table.  Given that, something broke in the process and truncated your
> file, which was then imported back into the products binary file on the
> next access.  Do you have a backup?  Use it.  When exporting binary tables,
> supply an alternate name for the text file (i.e.: products.exp) so that
> your database is not jeopardized.

Thanks for your fast reaction. 
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?

Thanks!

Joachim

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