Importing products from another database

[asgautm]

We are creating a e-commerce book store solution with OFBiz and need to import product data from another database.

There will be columns such as ISBN, author, publishing house and so on. They are present in a great number of book store, non-generic tables.

How can we import/map these data into the generic data model of OFBiz most efficiently?


Thanks.


Asgaut Mjølne

[Vince Clark]

We have researched integrating with publisher catalog feeds such as Ingram.

If I recall correctly we were planning on using attributes pretty heavily, and standardizing on attribute names like AUTHOR, CONTRIBUTOR, etc. For identifiers like ISBN use the Good Identifiers tab in Product.


Vince Clark
www.globalera.com
[hidden email]
[phone] office
[phone] cell


----- Original Message -----
From: "Asgaut Mjølne" <[hidden email]>
To: [hidden email]
Sent: Friday, August 14, 2009 5:42:32 AM GMT -07:00 US/Canada Mountain
Subject: Importing products from another database


We are creating a e-commerce book store solution with OFBiz and need to
import product data from another database.

There will be columns such as ISBN, author, publishing house and so on. They
are present in a great number of book store, non-generic tables.

How can we import/map these data into the generic data model of OFBiz most
efficiently?


Thanks.


Asgaut Mjølne
--
View this message in context: http://www.nabble.com/Importing-products-from-another-database-tp24970374p24970374.html
Sent from the OFBiz - User mailing list archive at Nabble.com.

[asgautm]

Thanks, we were looking at attributes too.

Do you have a recipe of how to create a product with attributes and everything else that relates to it? What tables are necessary and so forth.
We need this in order to write some code that import and map products from another database.

Sorry if I am asking basic questions but I am new to OFBiz :)

Asgaut Mjølne

Vince Clark wrote

We have researched integrating with publisher catalog feeds such as Ingram.

If I recall correctly we were planning on using attributes pretty heavily, and standardizing on attribute names like AUTHOR, CONTRIBUTOR, etc. For identifiers like ISBN use the Good Identifiers tab in Product.


Vince Clark
www.globalera.com
[e-mail]
[phone] office
[phone] cell


----- Original Message -----
From: "Asgaut Mjølne" <[e-mail]>
To: [e-mail]
Sent: Friday, August 14, 2009 5:42:32 AM GMT -07:00 US/Canada Mountain
Subject: Importing products from another database


We are creating a e-commerce book store solution with OFBiz and need to
import product data from another database.

There will be columns such as ISBN, author, publishing house and so on. They
are present in a great number of book store, non-generic tables.

How can we import/map these data into the generic data model of OFBiz most
efficiently?


Thanks.


Asgaut Mjølne
--
View this message in context: http://www.nabble.com/Importing-products-from-another-database-tp24970374p24970374.html
Sent from the OFBiz - User mailing list archive at Nabble.com.

[Pal Infocom Technologies-2]

Hello Asgaut,

In order to import the product data, you need to focus on two things.. First, study which tables and columns are used by OFBiz in order to add a product to the database. Also, which fields are mandatory in those tables. Secondly, study all the data, which need to be imported and available to you (by your client). Once you study all that.. you have to create the XML files, containing all the import data. Now you can import the newly created xml file(s) to the OFBiz database from web tools.

Hint: You can also create xml files with desired import data using sql queries.

That was just the overview to implement the task. If you need any further support on how to do this in detail, please feel free to email us at [e-mail]

--
Best regards,

Ajay Sodhi

Software Engineer,
Pal InfoCom Technologies (P) Ltd.,
Mohali - India
Marketing office - Portland (USA)
Phone: [phone]
Email: [e-mail]
Skype: ajay.palinfocom
Website: http://www.PalInfoCom.net/

** Web, wireless & SMS enabled applications development & maintenance
** Ofbiz enterprise solution implementation
** Offshore project management

Asgaut Mjølne wrote

Thanks, we were looking at attributes too.

Do you have a recipe of how to create a product with attributes and everything else that relates to it? What tables are necessary and so forth.
We need this in order to write some code that import and map products from another database.

Sorry if I am asking basic questions but I am new to OFBiz :)

Asgaut Mjølne

Vince Clark wrote

We have researched integrating with publisher catalog feeds such as Ingram.

If I recall correctly we were planning on using attributes pretty heavily, and standardizing on attribute names like AUTHOR, CONTRIBUTOR, etc. For identifiers like ISBN use the Good Identifiers tab in Product.


Vince Clark
www.globalera.com
[e-mail]
[phone] office
[phone] cell


----- Original Message -----
From: "Asgaut Mjølne" <[e-mail]>
To: [e-mail]
Sent: Friday, August 14, 2009 5:42:32 AM GMT -07:00 US/Canada Mountain
Subject: Importing products from another database


We are creating a e-commerce book store solution with OFBiz and need to
import product data from another database.

There will be columns such as ISBN, author, publishing house and so on. They
are present in a great number of book store, non-generic tables.

How can we import/map these data into the generic data model of OFBiz most
efficiently?


Thanks.


Asgaut Mjølne
--
View this message in context: http://www.nabble.com/Importing-products-from-another-database-tp24970374p24970374.html
Sent from the OFBiz - User mailing list archive at Nabble.com.