Hi Xinhuan, to understand the data model (and save a lot of time!) it was very useful for me to read "Data Model Resource Book", which is the basis of the OFBiz data model. Best regards N
Il giorno mar 8 set 2020 alle ore 10:41 Wei Zhang <[email protected]> ha scritto: > Hi Xinhuan, > > A Product is a description of a service, facility use, asset use, or a > digital or physical good for sale. An Asset commonly represents an instance > of a Product, or in other words the physical item that the Product record > describes. > > Regarding hierarchy structure data, you may interest in BOM data > structure, see > https://cwiki.apache.org/confluence/display/OFBIZ/%5BWIP%5D+Getting+Started+with+Apache+OFBiz+Manufacturing+and+MRP+in+5+Easy+Steps > > > > 在 2020/9/8 下午3:35，“Xinhuan Zheng”<[email protected]> 写入: > > Good Afternoon, > > I'm a developer working for some digital company. My use case is not > too general, and is simpler than OFBiz. It is for a small business. I have > maintained a few Excel spreadsheet for a few years for some business asset. > The spreadsheet are not formal modeled, and from time to time we maintain > and query those sheets. The data present characteristics of hierarchy > structure and different attribute sets for different kind types. > Maintaining those data in database may require formal data modeling and I > am not clear how it works. > > I came across an old publication about Universal E-Catalog, and I > learned about OFBiz project. I want to learn Key-Value pair modeling > pattern. I downloaded the OFBiz ERD diagrams. I studied the ERD diagrams > for a couple days, and what I'm interested is Product, ProductType, > Content, ContentType, Entities that use Universal E-Catalog pattern. You > can correct me if that is not the case. This modeling pattern needs to have > seed data to understand, and I found the best way to view the seed data is > using Excel spreadsheet. I found the project on Github containing Seed > data, however, all Seed data are XML format. Is there any possibilities to > extract some XML seed data to convert to CSV format? From the ERD diagram, > I think I need Product, ProductType, ProductTypeAttr, Content, ContentType, > ContentAttr seed data. > > Thank you! > > Xinhuan Zheng > > > -- Nicola Mazzoni *Mp Styl**e Srl* via Meucci, 37 41019 Limidi di Soliera (MO) T 059/684916 M 347/9905529 www.mpstyle.it
