Re: [Health] migrating to gnu health

[Luis Falcon]

Hi Islam Ezzat
On Thu, 28 Aug 2014 19:27:37 +0300
islam ezzat <address@hidden> wrote:

> Hello Everyone
> 
> I'm trying to import product templates into the system
> but there is no column for the price or the cost in the
> product_template table
> so where should I import the price and cost

Both list_price and cost_price fields in product.template are type
fields.Property [1], and they - like Functional fields - don't have a
corresponding entry at DB level.

Please check this example on how we use those fields on the WHO
essential list of medicines module ("health_who_essential_medicines")

You can do something similar using CSV or proteus.

<record model="product.template" id="templ_em1"> <field
name="name">halothane</field> <field name="category"
model="product.category" ref="prod_medicament_WHO"/> 
    <field name="default_uom" model="product.uom"
ref="product.uom_unit"/>
    <field name="list_price" eval="0.0"/> 
    <field name="cost_price" eval="0.0"/> 
</record>


1 .- http://doc.tryton.org/3.2/trytond/doc/ref/models/fields.html

Best,

> 
>                                       Table "public.product_template"
> 
>   Column   |           Type           |
> Modifiers
> 
> 
> ------------------+--------------------------------+---------------------------------------------------------------
> 
> id            | integer                     | not null default
> nextval('product_template_id_seq'::regclass)
> 
> create_date   | timestamp(6) without time zone |
> 
> write_date    | timestamp(6) without time zone |
> 
> create_uid    | integer                     |
> 
> write_uid     | integer                     |
> 
> category      | integer                     |
> 
> name          | character varying           | not null
> 
> default_uom   | integer                     | not null
> 
> active        | boolean                     | default false
> 
> consumable    | boolean                     | default false
> 
> type          | character varying           | not null
> 
> taxes_category   | boolean                     | default false
> account_category | boolean                     | default false
> thank you for your help
> 
> Best regards