Re: [LemonPOS-general] Ignorant MySQL Question
Status: Beta
Brought to you by:
mchavezg
From: Miguel C. G. <mi...@le...> - 2010-12-09 19:09:45
|
On Thu, Dec 9, 2010 at 12:48 PM, John Corbin <joh...@me...> wrote: > Hello all, > > I have an exported quickbooks POS products file, converted to CSV text file > and have exported the lemondb product list using the export feature of > Squeeze. I have changed to column-heads to match lemondb-products and > imported the products into that database successfully in MySQL. > > HOWEVER, the products I have imported do NOT show up in Squeeze or Lemon. I > have rebooted to no avail. > > They do show up in MySQL, all 1,000+ of them. > The new products are inside the lemondb database, and the table name is products? Did you inserted the products into the lemondb.products table or to a new table? It is possible that some fields are missing (from your imported data) and are empty in the lemondb.products table and that could cause the problem. Could you send me one product data? (select * from products where code=X .. where X is the id of some of your products) > > Is there a step I am missing? > > Thanks > JohnC > > > ------------------------------------------------------------------------------ > _______________________________________________ > Lemonpos-general mailing list > Lem...@li... > https://lists.sourceforge.net/lists/listinfo/lemonpos-general > -- Miguel Chavez Gamboa LemonPOS, an opensource point of sale. Want to support the development? Donations accepted via paypal: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=5650578 |