Importing products from another database

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

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
Reply | Threaded
Open this post in threaded view
|

Re: Importing products from another database

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]
(303) 493-6723 office
(303) 523-4843 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.

Reply | Threaded
Open this post in threaded view
|

Re: Importing products from another database

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
vclark@globalera.com
(303) 493-6723 office
(303) 523-4843 cell


----- Original Message -----
From: "Asgaut Mjølne" <asgaut.mjolne@bouvet.no>
To: user@ofbiz.apache.org
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.
Reply | Threaded
Open this post in threaded view
|

Re: Importing products from another database

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 ofbiz@palinfocom.net

--
Best regards,

Ajay Sodhi

Software Engineer,
Pal InfoCom Technologies (P) Ltd.,
Mohali - India
Marketing office - Portland (USA)
Phone: +91-172-461-8033
Email: ajay@palinfocom.net
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
vclark@globalera.com
(303) 493-6723 office
(303) 523-4843 cell


----- Original Message -----
From: "Asgaut Mjølne" <asgaut.mjolne@bouvet.no>
To: user@ofbiz.apache.org
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.