Update entity product - mass update for producut price

[su2]

Hello All,

We have requirement where we need to do mass update on product price(also few other things, supplier etc) once every two weeks, we have thousands of products for which manual updates are not possible.

I would really appreciate if someone can give me some idea. We have ProductID and Product Price in one excel.

Thank you in advance.
Su-

 

[Jeroen van der Wal-2]

Hi Su,

We've used Talend Open Studio in a project to upload data from various
sources by calling services through the XML-RPC interface.

Jeroen van der Wal
Stromboli b.v.
[phone]


On Mon, Jan 25, 2010 at 3:47 PM, su2 <[hidden email]> wrote:

>
> Hello All,
>
> We have requirement where we need to do mass update on product price(also
> few other things, supplier etc) once every two weeks, we have thousands of
> products for which manual updates are not possible.
>
> I would really appreciate if someone can give me some idea. We have
> ProductID and Product Price in one excel.
>
> Thank you in advance.
> Su-
>
>
> --
> View this message in context:
> http://n4.nabble.com/Update-entity-product-mass-update-for-producut-price-tp1289414p1289414.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

[su2]

Thank you Jeroen for the reply.

Can you please elaborate the 'calling services through the XML-RPC interface.'

As what I understood from webtools > XML import  i can import data, but i want to update data that means I will have "WHERE" condition while updating the tables/entities.

I am looking into Talend Open Studio.

Thank you.
su-

[Rishi Solanki]

Hi,
Have a look at the ImprotProductServices.java >>
productImportFromSpreadsheet.
More you find at -
http://cwiki.apache.org/confluence/display/OFBIZ/Import+Data+Using+Apache+POI+api

Rishi Solanki
Enterprise Software Developer
HotWax Media Pvt. Ltd.


On Mon, Jan 25, 2010 at 8:17 PM, su2 <[hidden email]> wrote:

>
> Hello All,
>
> We have requirement where we need to do mass update on product price(also
> few other things, supplier etc) once every two weeks, we have thousands of
> products for which manual updates are not possible.
>
> I would really appreciate if someone can give me some idea. We have
> ProductID and Product Price in one excel.
>
> Thank you in advance.
> Su-
>
>
> --
> View this message in context:
> http://n4.nabble.com/Update-entity-product-mass-update-for-producut-price-tp1289414p1289414.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

[Ashish Vijaywargiya]

For more details on XML-RPC please have a look on http://ws.apache.org/xmlrpc/.
Using XML-RPC libraries you can call OFBiz services remotely by
setting attribute export="true" in service definition.

For more details you can refer existing code OOTB.
Refer XmlRpc*.java files & refer "xmlrpc" controller entry in webtools
component.

    <request-map uri="xmlrpc" track-serverhit="false" track-visit="false">
        <event type="xmlrpc"/>
        <response name="error" type="none"/>
        <response name="success" type="none"/>
    </request-map>

HTH!

--
Ashish

On Mon, Jan 25, 2010 at 9:55 PM, su2 <[hidden email]> wrote:

>
> Thank you Jeroen for the reply.
>
> Can you please elaborate the 'calling services through the XML-RPC
> interface.'
>
> As what I understood from webtools > XML import  i can import data, but i
> want to update data that means I will have "WHERE" condition while updating
> the tables/entities.
>
> I am looking into Talend Open Studio.
>
> Thank you.
> su-
> --
> View this message in context: http://n4.nabble.com/Update-entity-product-mass-update-for-producut-price-tp1289414p1289508.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

[su2]

Will this XMLRPC work with the "WHERE" clause.

I have 4000+ items/rows to update with "WHERE" clause. My Sample query I want to execute is

UPDATE PRODUCT SET WEIGHT = 1 WHERE PRODUCT_ID = 'xyz123'

Can please somebody help me with this?

Thank you.
Su-

[Bilgin Ibryam-2]

su2 wrote:

> Will this XMLRPC work with the "WHERE" clause.
>
> I have 4000+ items/rows to update with "WHERE" clause. My Sample query I
> want to execute is
>
> UPDATE PRODUCT SET WEIGHT = 1 WHERE PRODUCT_ID = 'xyz123'
>
> Can please somebody help me with this?
>
> Thank you.
> Su-
>  

First you have to create an ofbiz service which takes the productId(your
where clause) and fields to update (wight for example).
Then using xmlrpc you can call this service for each line (4000 times)

Bilgin