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 |
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. |
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
|
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
|
Free forum by Nabble | Edit this page |