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 [email protected] -- Best regards, Ajay Sodhi Software Engineer, Pal InfoCom Technologies (P) Ltd., Mohali - India Marketing office - Portland (USA) Phone: +91-172-461-8033 Email: [email protected] 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 >> [email protected] >> (303) 493-6723 office >> (303) 523-4843 cell >> >> >> ----- Original Message ----- >> From: "Asgaut Mjølne" <[email protected]> >> To: [email protected] >> 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. >> >> >> > > -- View this message in context: http://www.nabble.com/Importing-products-from-another-database-tp24970374p25004466.html Sent from the OFBiz - User mailing list archive at Nabble.com.
