OFBiz › OFBiz - User

[OFBiz] Users - Bulk Product Loader

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

7 messages Options

Gershaw, Geoffrey

[OFBiz] Users - Bulk Product Loader

Hello,

I have searched on the Wiki and in the mailing list, but I haven't seen a conclusive answer. Has anyone created a bulk product loader yet?

Thanks,

Geoff

DISCLAIMER

This e-mail, and any attachments thereto, is intended only for use by the addressee(s) named herein and may contain legally privileged and/or confidential information. If you are not the intended recipient of this e-mail, you are hereby notified that any dissemination, distribution or copying of this e-mail, and any attachments thereto, is strictly prohibited. If you have received this e-mail in error, please immediately notify me and permanently delete the original and any copy of any e-mail and any printout thereof.

E-mail transmission cannot be guaranteed to be secure or error-free. The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission.

NOTICE REGARDING PRIVACY AND CONFIDENTIALITY

Knight Capital Group may, at its discretion, monitor and review the content of all e-mail communications.

http://www.knight.com

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

Daniel Kunkel

Re: [OFBiz] Users - Bulk Product Loader

Hi Geoff

I created a large spreadsheet that would output in an xml format that I
could import... I eventually got it to work, but it was far more flimsy
than I would have liked... but I'd be happy to share with you or publish
on wiki if anyone is interested.

Daniel

On Mon, 2005-07-18 at 11:30 -0400, Gershaw, Geoffrey wrote:

> Hello,
>
> I have searched on the Wiki and in the mailing list, but I haven't
> seen a conclusive answer. Has anyone created a bulk product loader
> yet?
>
> Thanks,
>
> Geoff
>
>
>
>
> DISCLAIMER
>
> This e-mail, and any attachments thereto, is intended only for use by
> the addressee(s) named herein and may contain legally privileged
> and/or confidential information. If you are not the intended recipient
> of this e-mail, you are hereby notified that any dissemination,
> distribution or copying of this e-mail, and any attachments thereto,
> is strictly prohibited. If you have received this e-mail in error,
> please immediately notify me and permanently delete the original and
> any copy of any e-mail and any printout thereof.
>
> E-mail transmission cannot be guaranteed to be secure or error-free.
> The sender therefore does not accept liability for any errors or
> omissions in the contents of this message which arise as a result of
> e-mail transmission.
>
> NOTICE REGARDING PRIVACY AND CONFIDENTIALITY
>
> Knight Capital Group may, at its discretion, monitor and review the
> content of all e-mail communications.
>
>
> http://www.knight.com
>
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/users

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

Gershaw, Geoffrey

RE: [OFBiz] Users - Bulk Product Loader

In reply to this post by Gershaw, Geoffrey

I would love to take a look. Why don't you publish on the wiki? Could you post a url to it when you are done?

Thanks for the response....

Geoff

-----Original Message-----
From: [hidden email] [mailto:[hidden email]] On Behalf Of Daniel Kunkel
Sent: Monday, July 18, 2005 11:47 AM
To: OFBiz Users / Usage Discussion
Subject: Re: [OFBiz] Users - Bulk Product Loader

Hi Geoff

I created a large spreadsheet that would output in an xml format that I could import... I eventually got it to work, but it was far more flimsy than I would have liked... but I'd be happy to share with you or publish on wiki if anyone is interested.

Daniel

On Mon, 2005-07-18 at 11:30 -0400, Gershaw, Geoffrey wrote:

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

DISCLAIMER
This e-mail, and any attachments thereto, is intended only for use by the addressee(s) named herein and may contain legally privileged and/or confidential information. If you are not the intended recipient of this e-mail, you are hereby notified that any dissemination, distribution or copying of
this e-mail, and any attachments thereto, is strictly prohibited. If you have received this e-mail in error, please immediately notify me and permanently delete the original and any copy of any e-mail and any printout thereof.
E-mail transmission cannot be guaranteed to be secure or error-free. The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission.
NOTICE REGARDING PRIVACY AND CONFIDENTIALITY
Knight Capital Group may, at its discretion, monitor and review the content of all e-mail communications.

http://www.knight.com

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

BJ Freeman

RE: [OFBiz] Users - Bulk Product Loader

In reply to this post by Gershaw, Geoffrey

Not a generic one. just ones that fit the data sent from the suppliers.

-----Original Message-----
From: Gershaw, Geoffrey [mailto:[hidden email]]
Sent: Monday, July 18, 2005 3:31 PM
To: '[hidden email]'
Subject: [OFBiz] Users - Bulk Product Loader

Hello,

I have searched on the Wiki and in the mailing list, but I haven't seen a conclusive answer. Has anyone created a bulk product loader yet?

Thanks,

Geoff

DISCLAIMER

NOTICE REGARDING PRIVACY AND CONFIDENTIALITY

Knight Capital Group may, at its discretion, monitor and review the content of all e-mail communications.

http://www.knight.com

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

Daniel Kunkel

RE: [OFBiz] Users - Bulk Product Loader

In reply to this post by Gershaw, Geoffrey

Hi

Ok... I've got a wiki page up...

http://ofbizwiki.go-integral.com/Wiki.jsp?
page=ExcelProductImportingSpreadsheet

Hope that helps as a good start. I originally used it with OFBiz 3.0 or
so, and have not kept up with any recent updates.

Thanks

On Mon, 2005-07-18 at 11:52 -0400, Gershaw, Geoffrey wrote:

> I would love to take a look. Why don't you publish on the wiki? Could you post a url to it when you are done?
>
> Thanks for the response....
>
> Geoff
>
> -----Original Message-----
> From: [hidden email] [mailto:[hidden email]] On Behalf Of Daniel Kunkel
> Sent: Monday, July 18, 2005 11:47 AM
> To: OFBiz Users / Usage Discussion
> Subject: Re: [OFBiz] Users - Bulk Product Loader
>
> Hi Geoff
>
> I created a large spreadsheet that would output in an xml format that I could import... I eventually got it to work, but it was far more flimsy than I would have liked... but I'd be happy to share with you or publish on wiki if anyone is interested.
>
> Daniel
>
>
> On Mon, 2005-07-18 at 11:30 -0400, Gershaw, Geoffrey wrote:
> > Hello,
> >
> > I have searched on the Wiki and in the mailing list, but I haven't
> > seen a conclusive answer. Has anyone created a bulk product loader
> > yet?
> >
> > Thanks,
> >
> > Geoff
> >
> >
> >
> >
> > DISCLAIMER
> >
> > This e-mail, and any attachments thereto, is intended only for use by
> > the addressee(s) named herein and may contain legally privileged
> > and/or confidential information. If you are not the intended recipient
> > of this e-mail, you are hereby notified that any dissemination,
> > distribution or copying of this e-mail, and any attachments thereto,
> > is strictly prohibited. If you have received this e-mail in error,
> > please immediately notify me and permanently delete the original and
> > any copy of any e-mail and any printout thereof.
> >
> > E-mail transmission cannot be guaranteed to be secure or error-free.
> > The sender therefore does not accept liability for any errors or
> > omissions in the contents of this message which arise as a result of
> > e-mail transmission.
> >
> > NOTICE REGARDING PRIVACY AND CONFIDENTIALITY
> >
> > Knight Capital Group may, at its discretion, monitor and review the
> > content of all e-mail communications.
> >
> >
> > http://www.knight.com
> >
> > _______________________________________________
> > Users mailing list
> > [hidden email]
> > http://lists.ofbiz.org/mailman/listinfo/users
>
>
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/users
>
>
> DISCLAIMER
> This e-mail, and any attachments thereto, is intended only for use by the addressee(s) named herein and may contain legally privileged and/or confidential information. If you are not the intended recipient of this e-mail, you are hereby notified that any dissemination, distribution or copying of
> this e-mail, and any attachments thereto, is strictly prohibited. If you have received this e-mail in error, please immediately notify me and permanently delete the original and any copy of any e-mail and any printout thereof.
> E-mail transmission cannot be guaranteed to be secure or error-free. The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission.
> NOTICE REGARDING PRIVACY AND CONFIDENTIALITY
> Knight Capital Group may, at its discretion, monitor and review the content of all e-mail communications.
>
> http://www.knight.com
>
> _______________________________________________
> 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

Re: [OFBiz] Users - Bulk Product Loader

Daniel, Geoffrey,

another good way to perform bulk data imports into OFBiz is using the
OFBiz datafile tool + the entity xml import tool.

The tool has been recently improved and now you can parse character
separated text files (e.g. csv files) and transform them into entity xml
files (that can be easily imported into OFBiz using the entity xml
import tool).

For example, if you need to import products from a csv file called
"products.csv" (with '#' as the separator character):
PRODUCT_A#Description of product A
PRODUCT_B#Description of product B
PRODUCT_C#Description of product C

You can create the following datafile definition "products_def.xml":
<?xml version="1.0" encoding="UTF-8" ?>
<data-files xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:noNamespaceSchemaLocation="http://www.ofbiz.org/dtds/datafiles.xsd">
<data-file name="products" separator-style="delimited" delimiter="#"
type-code="text">
<record name="Product" limit="many">
<field name="productId" type="String"></field>
<field name="description" type="String"></field>
<field name="productTypeId" type="String" expression="true"
default-value="FINISHED_GOOD"/>
</record>
</data-file>
</data-files>

Then go to Webtools-->Work with DataFiles and fill the form with the
path to the data file (products.csv), the path to the datafile
definition file (products_def.xml), and the path of the entity xml file
you want to create (e.g. products_entity.xml).
Submit the form and you'll get the following entity xml file:

<?xml version="1.0" encoding="UTF-8"?>
<entity-engine-xml>
<Product productId="PRODUCT_A" productTypeId="FINISHED_GOOD"
description="Description of product A"/>
<Product productId="PRODUCT_B" productTypeId="FINISHED_GOOD"
description="Description of product B"/>
<Product productId="PRODUCT_C" productTypeId="FINISHED_GOOD"
description="Description of product C"/>
</entity-engine-xml>

Finally you can easily import the file using the standard entity xml
import (or import dir) tools.

Hope this helps,

Jacopo

PS: by the way, have a look at the datafiles.xsd file definition: there
are a lot of hidden features (you can define expression fields, skip
fields, etc)

Daniel Kunkel wrote:

> Hi
>
> Ok... I've got a wiki page up...
>
> http://ofbizwiki.go-integral.com/Wiki.jsp?
> page=ExcelProductImportingSpreadsheet
>
>
> Hope that helps as a good start. I originally used it with OFBiz 3.0 or
> so, and have not kept up with any recent updates.
>
> Thanks
>
>
>
>
> On Mon, 2005-07-18 at 11:52 -0400, Gershaw, Geoffrey wrote:
>
>>I would love to take a look. Why don't you publish on the wiki? Could you post a url to it when you are done?
>>
>>Thanks for the response....
>>
>>Geoff
>>
>>-----Original Message-----
>>From: [hidden email] [mailto:[hidden email]] On Behalf Of Daniel Kunkel
>>Sent: Monday, July 18, 2005 11:47 AM
>>To: OFBiz Users / Usage Discussion
>>Subject: Re: [OFBiz] Users - Bulk Product Loader
>>
>>Hi Geoff
>>
>>I created a large spreadsheet that would output in an xml format that I could import... I eventually got it to work, but it was far more flimsy than I would have liked... but I'd be happy to share with you or publish on wiki if anyone is interested.
>>
>>Daniel
>>
>>
>>On Mon, 2005-07-18 at 11:30 -0400, Gershaw, Geoffrey wrote:
>>
>>>Hello,
>>>
>>>I have searched on the Wiki and in the mailing list, but I haven't
>>>seen a conclusive answer. Has anyone created a bulk product loader
>>>yet?
>>>
>>>Thanks,
>>>
>>>Geoff
>>>
>>>
>>>
>>>
>>>DISCLAIMER
>>>
>>>This e-mail, and any attachments thereto, is intended only for use by
>>>the addressee(s) named herein and may contain legally privileged
>>>and/or confidential information. If you are not the intended recipient
>>>of this e-mail, you are hereby notified that any dissemination,
>>>distribution or copying of this e-mail, and any attachments thereto,
>>>is strictly prohibited. If you have received this e-mail in error,
>>>please immediately notify me and permanently delete the original and
>>>any copy of any e-mail and any printout thereof.
>>>
>>>E-mail transmission cannot be guaranteed to be secure or error-free.
>>>The sender therefore does not accept liability for any errors or
>>>omissions in the contents of this message which arise as a result of
>>>e-mail transmission.
>>>
>>>NOTICE REGARDING PRIVACY AND CONFIDENTIALITY
>>>
>>>Knight Capital Group may, at its discretion, monitor and review the
>>>content of all e-mail communications.
>>>
>>>
>>>http://www.knight.com
>>>
>>> _______________________________________________
>>>Users mailing list
>>>[hidden email]
>>>http://lists.ofbiz.org/mailman/listinfo/users
>>
>>
>>_______________________________________________
>>Users mailing list
>>[hidden email]
>>http://lists.ofbiz.org/mailman/listinfo/users
>>
>>
>>DISCLAIMER
>>This e-mail, and any attachments thereto, is intended only for use by the addressee(s) named herein and may contain legally privileged and/or confidential information. If you are not the intended recipient of this e-mail, you are hereby notified that any dissemination, distribution or copying of
>>this e-mail, and any attachments thereto, is strictly prohibited. If you have received this e-mail in error, please immediately notify me and permanently delete the original and any copy of any e-mail and any printout thereof.
>>E-mail transmission cannot be guaranteed to be secure or error-free. The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission.
>>NOTICE REGARDING PRIVACY AND CONFIDENTIALITY
>>Knight Capital Group may, at its discretion, monitor and review the content of all e-mail communications.
>>
>>http://www.knight.com
>>
>>_______________________________________________
>>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

Jacques Le Roux

Re: [OFBiz] Users - Bulk Product Loader

Administrator

Jacopo and all,

I come back from teen days of vacation and *yes* this will help me a lot.
Thanks for this detailled tip

Jacques

----- Original Message -----
From: "Jacopo Cappellato" <[hidden email]>
To: "OFBiz Users / Usage Discussion" <[hidden email]>
Sent: Monday, August 08, 2005 9:17 AM
Subject: Re: [OFBiz] Users - Bulk Product Loader

> Daniel, Geoffrey,
>
> another good way to perform bulk data imports into OFBiz is using the
> OFBiz datafile tool + the entity xml import tool.
>
> The tool has been recently improved and now you can parse character
> separated text files (e.g. csv files) and transform them into entity xml
> files (that can be easily imported into OFBiz using the entity xml
> import tool).
>
> For example, if you need to import products from a csv file called
> "products.csv" (with '#' as the separator character):
> PRODUCT_A#Description of product A
> PRODUCT_B#Description of product B
> PRODUCT_C#Description of product C
>
> You can create the following datafile definition "products_def.xml":
> <?xml version="1.0" encoding="UTF-8" ?>
> <data-files xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> xsi:noNamespaceSchemaLocation="http://www.ofbiz.org/dtds/datafiles.xsd">
> <data-file name="products" separator-style="delimited" delimiter="#"
> type-code="text">
> <record name="Product" limit="many">
> <field name="productId" type="String"></field>
> <field name="description" type="String"></field>
> <field name="productTypeId" type="String" expression="true"
> default-value="FINISHED_GOOD"/>
> </record>
> </data-file>
> </data-files>
>
> Then go to Webtools-->Work with DataFiles and fill the form with the
> path to the data file (products.csv), the path to the datafile
> definition file (products_def.xml), and the path of the entity xml file
> you want to create (e.g. products_entity.xml).
> Submit the form and you'll get the following entity xml file:
>
> <?xml version="1.0" encoding="UTF-8"?>
> <entity-engine-xml>
> <Product productId="PRODUCT_A" productTypeId="FINISHED_GOOD"
> description="Description of product A"/>
> <Product productId="PRODUCT_B" productTypeId="FINISHED_GOOD"
> description="Description of product B"/>
> <Product productId="PRODUCT_C" productTypeId="FINISHED_GOOD"
> description="Description of product C"/>
> </entity-engine-xml>
>
> Finally you can easily import the file using the standard entity xml
> import (or import dir) tools.
>
> Hope this helps,
>
> Jacopo
>
> PS: by the way, have a look at the datafiles.xsd file definition: there
> are a lot of hidden features (you can define expression fields, skip
> fields, etc)
>
>
>
> Daniel Kunkel wrote:
> > Hi
> >
> > Ok... I've got a wiki page up...
> >
> > http://ofbizwiki.go-integral.com/Wiki.jsp?
> > page=ExcelProductImportingSpreadsheet
> >
> >
> > Hope that helps as a good start. I originally used it with OFBiz 3.0 or
> > so, and have not kept up with any recent updates.
> >
> > Thanks
> >
> >
> >
> >
> > On Mon, 2005-07-18 at 11:52 -0400, Gershaw, Geoffrey wrote:
> >
> >>I would love to take a look. Why don't you publish on the wiki? Could

you post a url to it when you are done?
> >>
> >>Thanks for the response....
> >>
> >>Geoff
> >>
> >>-----Original Message-----
> >>From: [hidden email]
[mailto:[hidden email]] On Behalf Of Daniel Kunkel
> >>Sent: Monday, July 18, 2005 11:47 AM
> >>To: OFBiz Users / Usage Discussion
> >>Subject: Re: [OFBiz] Users - Bulk Product Loader
> >>
> >>Hi Geoff
> >>
> >>I created a large spreadsheet that would output in an xml format that I
could import... I eventually got it to work, but it was far more flimsy
than I would have liked... but I'd be happy to share with you or publish on
wiki if anyone is interested.

> >>
> >>Daniel
> >>
> >>
> >>On Mon, 2005-07-18 at 11:30 -0400, Gershaw, Geoffrey wrote:
> >>
> >>>Hello,
> >>>
> >>>I have searched on the Wiki and in the mailing list, but I haven't
> >>>seen a conclusive answer. Has anyone created a bulk product loader
> >>>yet?
> >>>
> >>>Thanks,
> >>>
> >>>Geoff
> >>>
> >>>
> >>>
> >>>
> >>>DISCLAIMER
> >>>
> >>>This e-mail, and any attachments thereto, is intended only for use by
> >>>the addressee(s) named herein and may contain legally privileged
> >>>and/or confidential information. If you are not the intended recipient
> >>>of this e-mail, you are hereby notified that any dissemination,
> >>>distribution or copying of this e-mail, and any attachments thereto,
> >>>is strictly prohibited. If you have received this e-mail in error,
> >>>please immediately notify me and permanently delete the original and
> >>>any copy of any e-mail and any printout thereof.
> >>>
> >>>E-mail transmission cannot be guaranteed to be secure or error-free.
> >>>The sender therefore does not accept liability for any errors or
> >>>omissions in the contents of this message which arise as a result of
> >>>e-mail transmission.
> >>>
> >>>NOTICE REGARDING PRIVACY AND CONFIDENTIALITY
> >>>
> >>>Knight Capital Group may, at its discretion, monitor and review the
> >>>content of all e-mail communications.
> >>>
> >>>
> >>>http://www.knight.com
> >>>
> >>> _______________________________________________
> >>>Users mailing list
> >>>[hidden email]
> >>>http://lists.ofbiz.org/mailman/listinfo/users
> >>
> >>
> >>_______________________________________________
> >>Users mailing list
> >>[hidden email]
> >>http://lists.ofbiz.org/mailman/listinfo/users
> >>
> >>
> >>DISCLAIMER
> >>This e-mail, and any attachments thereto, is intended only for use by

the addressee(s) named herein and may contain legally privileged and/or
confidential information. If you are not the intended recipient of this
e-mail, you are hereby notified that any dissemination, distribution or
copying of
> >>this e-mail, and any attachments thereto, is strictly prohibited. If you
have received this e-mail in error, please immediately notify me and
permanently delete the original and any copy of any e-mail and any printout
thereof.
> >>E-mail transmission cannot be guaranteed to be secure or error-free.
The sender therefore does not accept liability for any errors or omissions
in the contents of this message which arise as a result of e-mail
transmission.
> >>NOTICE REGARDING PRIVACY AND CONFIDENTIALITY
> >>Knight Capital Group may, at its discretion, monitor and review the
content of all e-mail communications.

> >>
> >>http://www.knight.com
> >>
> >>_______________________________________________
> >>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
>

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