[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: Re: [ubl-dev] Simple description of XML-Spreadsheet format
G. Ken Holman wrote: > Chee-Kai, you may consider publishing these UBL v1.0 IDD spreadsheets > as genericode files so that you are using a standard representation: > > http://docs.oasis-open.org/codelist/genericode/ > > UBL v2.0 IDD spreadsheets are available in XML format using genericode > ... the latest version I published was in July 2007: > > > http://www.CraneSoftwrights.com/resources/ubl/index.htm#ubl2idd2genericode > Thanks for highlighting this, Ken. Much delighted to see genericoding of the spreadsheet values for UBL v2.0. It's certainly good to be using the genericode standard for coded values. I took a look at your pointer above and compared carefully between the genericode format and XML-Spreadsheet (by no means an official name, I'm just using it to describe "that" format which I'm using) format to see if I could merge and use the standard. I haven't really ploughed through the whole history of genericode, but from the nice intro on your web page and browsing the examples .gc files, I get the sense that genericode is, as its name suggests, designed more to represent code lists, though there can be creative use in other purposes like representing model spreadsheets. I think that although the two formats look similar with the <Row> elements, their intents, purposes, structures, and content values are quite drastically different from what I can see. As I briefly described in the earlier intro posting, the XML-Spreadsheet is intentionally simple, and purposefully crafted so that it reflects as faithfully as possible the various pieces of datum found in the original spreadsheet. If this objective is closely followed, then some special uses become possible, such as allowing a user's customized spreadsheet, whose columns and rows might have been changed much, to be converted faithfully into an XML format. Also, when UBLish v2.0 becomes available, users can generate their own native/proprietary or customized spreadsheets directly. So XML-Spreadsheet's format needs to be flexible enough to allow various kinds of spreadsheets so that users can relate the XML format conveniently to the spreadsheet coordinates. The advantage of genericode to store model spreadsheets (CommonLibrary and main documents), the way I see it, is that it contains processed linkages of related and essential values, so that perhaps lesser processing needs to take place during use. In terms of "faithfulness" to original spreadsheet, for instance, I'm not exactly sure how to reduce spreadsheet's "Dictionary Entry Name" into "den", "Cardinality" into "card", why is "type" a <SimpleValue> whereas a "terms" is a <ComplexValue> and so on. That hidden conversion table and knowledge imply a knowledgeable converter (a utility software or human) that stores such a "mapping". It wouldn't quite serve a more general case where an arbitrary spreadsheet, such as one modified by user, is to be converted. Hence the introduction of XML-Spreadsheet format which links information such as row & column numbers back to spreadsheet. The purposes of both formats are quite different, so I understand the purpose of one cannot be used to justify the merit of the other. (BTW, I think attribute names should, heeding good practice from UBL NDR, be lowerCamelCased. So attributes such as "ColumnRef", "Id", and "Use" should be lowerCamelCased. Just a thought) > When the updated IDD is ratified I'll be republishing this resource > with the latest definitions. > > That way your IDD files and my IDD files will cover both versions and > will be in the same standardized vocabulary. For the next release involving UBL v1.0 IDD draft spreadsheet, I'm getting ready the XML-Spreadsheet version and hadn't thought about using genericode prior to your posting. After realizing the lack of "mapping" knowledge (mentioned above), I find it easier if you might want to try taking the v1.0 IDD XML-Spreadsheet to generate, in turn, genericode encodings of UBL v1.0 IDD since you've the tacit knowledge required to "get it right". I would offer to work out the UBL v2.0 IDD draft if you could share the draft spreadsheet online somewhere. (Or perhaps by then UBLish v2.0 alpha is released so you could just do the conversion yourself too) Regards, Chin Chee-Kai
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]