Re: [LemonPOS-general] bulk load

[Miguel C. G. <mi...@le...>]

Ensure that every field has a value.. most problems related to not found
products is that some related field is missing, causing the join query to
fail (at azahar::getProductInfo() method). There was a common problem when
the "Tax Model" and "Tax Elements" tables are not populated or missing
information (due to not running the OLD mexico_taxes.sql script when
installing (now -version 0.9.5- the content of this script is included
inside the lemon_mysql.sql script).

It is not enough to set any value on a field that refers to other table, it
is also required to exists such record on the related table. For example,
if a product has a "100" Category, at the Categories table must exist the
category with ID=100.


On Mon, Aug 12, 2013 at 12:10 PM, <dan...@co...>wrote:

> Not trying to hijack, but I suspect our problems require the same
> solution.
>
> I am struggling with something similar; I'm wrapping a web service around
> the database.
>
> If you haven't already, you could take a look at lemon_mysql.sql inside
> the database_resources directory.
>
> I've used the structure from it to create & edit products.  Editing works
> well, but the creation only partially works.  It creates a product which is
> visible in squeeze.  When I double-click the product to view information,
> however, it doesn't exist.  In lemon itself, it shows "{n} products", but
> any I've created aren't there.
>
>
> I looked through the azahar code and I *think* I'm replicating it
> correctly.  Is there some step missing to add products?
>
>
> Cheers.
>
>
> ------------------------------------------------------------------------------
> Get 100% visibility into Java/.NET code with AppDynamics Lite!
> It's a free troubleshooting tool designed for production.
> Get down to code-level detail for bottlenecks, with <2% overhead.
> Download for free and get started troubleshooting in minutes.
> http://pubads.g.doubleclick.net/gampad/clk?id=48897031&iu=/4140/ostg.clktrk
> _______________________________________________
> Lemonpos-general mailing list
> Lem...@li...
> https://lists.sourceforge.net/lists/listinfo/lemonpos-general
>



-- 
*Miguel Chavez Gamboa*
*LemonPOS, an opensource point of sale.*
http://www.lemonpos.org/

Do you want to support the development?

Donations accepted via paypal:
https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=5650578