OFBiz › OFBiz - User

Users - Prices import

‹ Previous Topic Next Topic ›
 
classic Classic list List threaded Threaded
♦
♦
 4 messages Options
michal-2
Reply | Threaded
Open this post in threaded view
♦
♦
|

Users - Prices import

michal-2
Hello,
I'm trying to import prices to ofbiz. I have the xml file ready with
following fields:
productId,productPriceTypeId,currencyUomId,productStoreGroupId,fromDate
but when I tried to import xml file I got this error:
What am I doing wrong or what am I missing here ?

ERROR: org.ofbiz.entity.GenericEntityException: Exception while inserting
the following entity: [GenericEntity:ProductPrice][createdStamp,2005-12-14
07:48:14.577(java.sql.Timestamp)][createdTxStamp,2005-12-14
07:47:19.826(java.sql.Timestamp)][currencyUomId,USD(java.lang.String)][fromDate,2003-03-04
18:48:49.113(java.sql.Timestamp)][lastUpdatedStamp,2005-12-14
07:48:14.577(java.sql.Timestamp)][lastUpdatedTxStamp,2005-12-14
07:47:19.826(java.sql.Timestamp)][price,55.0(java.lang.Double)][productId,07829(java.lang.String)][productPriceTypeId,AVERAGE_COST(java.lang.String)][productStoreGroupId,_NA_(java.lang.String)]
(while inserting: [GenericEntity:ProductPrice][createdStamp,2005-12-14
07:48:14.577(java.sql.Timestamp)][createdTxStamp,2005-12-14
07:47:19.826(java.sql.Timestamp)][currencyUomId,USD(java.lang.String)][fromDate,2003-03-04
18:48:49.113(java.sql.Timestamp)][lastUpdatedStamp,2005-12-14
07:48:14.577(java.sql.Timestamp)][lastUpdatedTxStamp,2005-12-14
07:47:19.826(java.sql.Timestamp)][price,55.0(java.lang.Double)][productId,07829(java.lang.String)][productPriceTypeId,AVERAGE_COST(java.lang.String)][productStoreGroupId,_NA_(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
public.PRODUCT_PRICE (PRODUCT_ID, PRODUCT_PRICE_TYPE_ID, CURRENCY_UOM_ID,
PRODUCT_STORE_GROUP_ID, FROM_DATE, THRU_DATE, PRICE, CREATED_DATE,
CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, LAST_MODIFIED_BY_USER_LOGIN,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
(ERROR: insert or update on table "product_price" violates foreign key
constraint "prod_price_prod")))
Got -1 entities to write to the datasource.
 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users
Hans Bakker
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: Users - Prices import

Hans Bakker
On Wednesday 14 December 2005 19:09, [hidden email] wrote:
> Hello,
> I'm trying to import prices to ofbiz. I have the xml file ready with
> following fields:
> productId,productPriceTypeId,currencyUomId,productStoreGroupId,fromDate
> but when I tried to import xml file I got this error:
> What am I doing wrong or what am I missing here ?

Have a closer look at the data below, at the end it says:

(ERROR: insert or update on table "product_price" violates foreign key
constraint "prod_price_prod")))

The constraint is a foreign key you can find the the webtools section under
Entity Reference, go there and with your browser do a search on
'prod_price_prod'. There you can see that is the productId in the price
table.

It is saying you are loading a price with a productId which does not exist in
the Product table... so first load the record in the Product table and
afterwards in the ProductPrice table

hope this helps....

--
Regards,
Hans Bakker
ANT Websystems Co.,Ltd (http://www.antwebsystems.com)

If you want to verify that this message really originates from
from the above person, download the public key from:
http://www.antwebsystems.com/hbakkerAntwebsystems.asc

>
> ERROR: org.ofbiz.entity.GenericEntityException: Exception while inserting
> the following entity: [GenericEntity:ProductPrice][createdStamp,2005-12-14
> 07:48:14.577(java.sql.Timestamp)][createdTxStamp,2005-12-14
> 07:47:19.826(java.sql.Timestamp)][currencyUomId,USD(java.lang.String)][from
>Date,2003-03-04
> 18:48:49.113(java.sql.Timestamp)][lastUpdatedStamp,2005-12-14
> 07:48:14.577(java.sql.Timestamp)][lastUpdatedTxStamp,2005-12-14
> 07:47:19.826(java.sql.Timestamp)][price,55.0(java.lang.Double)][productId,0
>7829(java.lang.String)][productPriceTypeId,AVERAGE_COST(java.lang.String)][p
>roductStoreGroupId,_NA_(java.lang.String)] (while inserting:
> [GenericEntity:ProductPrice][createdStamp,2005-12-14
> 07:48:14.577(java.sql.Timestamp)][createdTxStamp,2005-12-14
> 07:47:19.826(java.sql.Timestamp)][currencyUomId,USD(java.lang.String)][from
>Date,2003-03-04
> 18:48:49.113(java.sql.Timestamp)][lastUpdatedStamp,2005-12-14
> 07:48:14.577(java.sql.Timestamp)][lastUpdatedTxStamp,2005-12-14
> 07:47:19.826(java.sql.Timestamp)][price,55.0(java.lang.Double)][productId,0
>7829(java.lang.String)][productPriceTypeId,AVERAGE_COST(java.lang.String)][p
>roductStoreGroupId,_NA_(java.lang.String)] (SQL Exception while executing
> the following:INSERT INTO
> public.PRODUCT_PRICE (PRODUCT_ID, PRODUCT_PRICE_TYPE_ID, CURRENCY_UOM_ID,
> PRODUCT_STORE_GROUP_ID, FROM_DATE, THRU_DATE, PRICE, CREATED_DATE,
> CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, LAST_MODIFIED_BY_USER_LOGIN,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
> CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
> (ERROR: insert or update on table "product_price" violates foreign key
> constraint "prod_price_prod")))
> Got -1 entities to write to the datasource.
>
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/users
--
Regards,
Hans Bakker
ANT Websystems Co.,Ltd (http://www.antwebsystems.com)

If you want to verify that this message really originates from
from the above person, download the public key from:
http://www.antwebsystems.com/hbakkerAntwebsystems.asc

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users

attachment0 (196 bytes) Download Attachment
michal-2
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: Users - Prices import

michal-2
It was very helpful and you were 100% right. I'm fairly new to ofbiz so
these errors sometimes don't give to many clues.
Also, I have one more question about import of parties. Why when I go to
web tools/Entity Data Maintenance and I cannot click on
PartyAndPostalAddress to view the data. I just want to import company
names and address. Even when I try to export PartyAndPostalAddress I get
this msg
[1] [vvv] PartyAndPostalAddress skipping view entity. What is that about ?
Thanks for your help
Mike

> On Wednesday 14 December 2005 19:09, [hidden email] wrote:
>> Hello,
>> I'm trying to import prices to ofbiz. I have the xml file ready with
>> following fields:
>> productId,productPriceTypeId,currencyUomId,productStoreGroupId,fromDate
>> but when I tried to import xml file I got this error:
>> What am I doing wrong or what am I missing here ?
>
> Have a closer look at the data below, at the end it says:
>
> (ERROR: insert or update on table "product_price" violates foreign key
> constraint "prod_price_prod")))
>
> The constraint is a foreign key you can find the the webtools section
> under
> Entity Reference, go there and with your browser do a search on
> 'prod_price_prod'. There you can see that is the productId in the price
> table.
>
> It is saying you are loading a price with a productId which does not exist
> in
> the Product table... so first load the record in the Product table and
> afterwards in the ProductPrice table
>
> hope this helps....
>
> --
> Regards,
> Hans Bakker
> ANT Websystems Co.,Ltd (http://www.antwebsystems.com)
>
> If you want to verify that this message really originates from
> from the above person, download the public key from:
> http://www.antwebsystems.com/hbakkerAntwebsystems.asc
>>
>> ERROR: org.ofbiz.entity.GenericEntityException: Exception while
>> inserting
>> the following entity:
>> [GenericEntity:ProductPrice][createdStamp,2005-12-14
>> 07:48:14.577(java.sql.Timestamp)][createdTxStamp,2005-12-14
>> 07:47:19.826(java.sql.Timestamp)][currencyUomId,USD(java.lang.String)][from
>>Date,2003-03-04
>> 18:48:49.113(java.sql.Timestamp)][lastUpdatedStamp,2005-12-14
>> 07:48:14.577(java.sql.Timestamp)][lastUpdatedTxStamp,2005-12-14
>> 07:47:19.826(java.sql.Timestamp)][price,55.0(java.lang.Double)][productId,0
>>7829(java.lang.String)][productPriceTypeId,AVERAGE_COST(java.lang.String)][p
>>roductStoreGroupId,_NA_(java.lang.String)] (while inserting:
>> [GenericEntity:ProductPrice][createdStamp,2005-12-14
>> 07:48:14.577(java.sql.Timestamp)][createdTxStamp,2005-12-14
>> 07:47:19.826(java.sql.Timestamp)][currencyUomId,USD(java.lang.String)][from
>>Date,2003-03-04
>> 18:48:49.113(java.sql.Timestamp)][lastUpdatedStamp,2005-12-14
>> 07:48:14.577(java.sql.Timestamp)][lastUpdatedTxStamp,2005-12-14
>> 07:47:19.826(java.sql.Timestamp)][price,55.0(java.lang.Double)][productId,0
>>7829(java.lang.String)][productPriceTypeId,AVERAGE_COST(java.lang.String)][p
>>roductStoreGroupId,_NA_(java.lang.String)] (SQL Exception while executing
>> the following:INSERT INTO
>> public.PRODUCT_PRICE (PRODUCT_ID, PRODUCT_PRICE_TYPE_ID,
>> CURRENCY_UOM_ID,
>> PRODUCT_STORE_GROUP_ID, FROM_DATE, THRU_DATE, PRICE, CREATED_DATE,
>> CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, LAST_MODIFIED_BY_USER_LOGIN,
>> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
>> CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
>> (ERROR: insert or update on table "product_price" violates foreign key
>> constraint "prod_price_prod")))
>> Got -1 entities to write to the datasource.
>>
>> _______________________________________________
>> Users mailing list
>> [hidden email]
>> http://lists.ofbiz.org/mailman/listinfo/users
>
> --
> Regards,
> Hans Bakker
> ANT Websystems Co.,Ltd (http://www.antwebsystems.com)
>
> If you want to verify that this message really originates from
> from the above person, download the public key from:
> http://www.antwebsystems.com/hbakkerAntwebsystems.asc
>
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/users

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users
Jacopo Cappellato
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: Users - Prices import

Jacopo Cappellato
Hi Mike,

PartyAndPostalAddress is not an entity (aka an SQL "table"), it is a view.

In order to import a Company and its address you'll need to populate the
following entries (I hope my memory will help):
- Party (the id of the Company)
- PartyGroup (the Name of the Company)
- ContactMech (the id of the new address)
- PostalAddress (the new address)
- PartyContactMech (this associates the Company witht the contact mech)

Hope this helps,

Jacopo


[hidden email] wrote:

> It was very helpful and you were 100% right. I'm fairly new to ofbiz so
> these errors sometimes don't give to many clues.
> Also, I have one more question about import of parties. Why when I go to
> web tools/Entity Data Maintenance and I cannot click on
> PartyAndPostalAddress to view the data. I just want to import company
> names and address. Even when I try to export PartyAndPostalAddress I get
> this msg
> [1] [vvv] PartyAndPostalAddress skipping view entity. What is that about ?
> Thanks for your help
> Mike
>
>>On Wednesday 14 December 2005 19:09, [hidden email] wrote:
>>
>>>Hello,
>>>I'm trying to import prices to ofbiz. I have the xml file ready with
>>>following fields:
>>>productId,productPriceTypeId,currencyUomId,productStoreGroupId,fromDate
>>>but when I tried to import xml file I got this error:
>>>What am I doing wrong or what am I missing here ?
>>
>>Have a closer look at the data below, at the end it says:
>>
>>(ERROR: insert or update on table "product_price" violates foreign key
>>constraint "prod_price_prod")))
>>
>>The constraint is a foreign key you can find the the webtools section
>>under
>>Entity Reference, go there and with your browser do a search on
>>'prod_price_prod'. There you can see that is the productId in the price
>>table.
>>
>>It is saying you are loading a price with a productId which does not exist
>>in
>>the Product table... so first load the record in the Product table and
>>afterwards in the ProductPrice table
>>
>>hope this helps....
>>
>>--
>>Regards,
>>Hans Bakker
>>ANT Websystems Co.,Ltd (http://www.antwebsystems.com)
>>
>>If you want to verify that this message really originates from
>>from the above person, download the public key from:
>>http://www.antwebsystems.com/hbakkerAntwebsystems.asc
>>
>>>ERROR: org.ofbiz.entity.GenericEntityException: Exception while
>>>inserting
>>>the following entity:
>>>[GenericEntity:ProductPrice][createdStamp,2005-12-14
>>>07:48:14.577(java.sql.Timestamp)][createdTxStamp,2005-12-14
>>>07:47:19.826(java.sql.Timestamp)][currencyUomId,USD(java.lang.String)][from
>>>Date,2003-03-04
>>>18:48:49.113(java.sql.Timestamp)][lastUpdatedStamp,2005-12-14
>>>07:48:14.577(java.sql.Timestamp)][lastUpdatedTxStamp,2005-12-14
>>>07:47:19.826(java.sql.Timestamp)][price,55.0(java.lang.Double)][productId,0
>>>7829(java.lang.String)][productPriceTypeId,AVERAGE_COST(java.lang.String)][p
>>>roductStoreGroupId,_NA_(java.lang.String)] (while inserting:
>>>[GenericEntity:ProductPrice][createdStamp,2005-12-14
>>>07:48:14.577(java.sql.Timestamp)][createdTxStamp,2005-12-14
>>>07:47:19.826(java.sql.Timestamp)][currencyUomId,USD(java.lang.String)][from
>>>Date,2003-03-04
>>>18:48:49.113(java.sql.Timestamp)][lastUpdatedStamp,2005-12-14
>>>07:48:14.577(java.sql.Timestamp)][lastUpdatedTxStamp,2005-12-14
>>>07:47:19.826(java.sql.Timestamp)][price,55.0(java.lang.Double)][productId,0
>>>7829(java.lang.String)][productPriceTypeId,AVERAGE_COST(java.lang.String)][p
>>>roductStoreGroupId,_NA_(java.lang.String)] (SQL Exception while executing
>>>the following:INSERT INTO
>>>public.PRODUCT_PRICE (PRODUCT_ID, PRODUCT_PRICE_TYPE_ID,
>>>CURRENCY_UOM_ID,
>>>PRODUCT_STORE_GROUP_ID, FROM_DATE, THRU_DATE, PRICE, CREATED_DATE,
>>>CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, LAST_MODIFIED_BY_USER_LOGIN,
>>>LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
>>>CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
>>>(ERROR: insert or update on table "product_price" violates foreign key
>>>constraint "prod_price_prod")))
>>>Got -1 entities to write to the datasource.
>>>
>>>_______________________________________________
>>>Users mailing list
>>>[hidden email]
>>>http://lists.ofbiz.org/mailman/listinfo/users
>>
>>--
>>Regards,
>>Hans Bakker
>>ANT Websystems Co.,Ltd (http://www.antwebsystems.com)
>>
>>If you want to verify that this message really originates from
>>from the above person, download the public key from:
>>http://www.antwebsystems.com/hbakkerAntwebsystems.asc
>>
>>_______________________________________________
>>Users mailing list
>>[hidden email]
>>http://lists.ofbiz.org/mailman/listinfo/users
>
>
>  
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/users
>

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users
Free forum by Nabble Edit this page