OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

ubl message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]

Subject: Re: [ubl] CurrencyCodeContentType and CurrencyCodeType issues

Good morning, all,

At 2006-07-19 16:44 +0800, Tim McGrath wrote:
>i think we should also have a listSchemeURI of 
>for currency code in the QualifiedDataTypes 
>schema. this is what we now have in the 
>spreadsheets.  so please note, i have updated 
>the QDT schema in the latest build.

Great ... that is reflected in the massaged XSD files.

>also, why do the QualifiedDataTypes for code lists have:
><xsd:attribute name="listURI" type="xsd:anyURI" use="optional">
>- when the spreadsheets say the values for 
>ListURI should be the genericode files, e.g.: 
>"../codelist/gc/CurrencyCodeType.gc" ?

It looks like you are not working from the latest 
spreadsheets, Tim ... Alan made some last-minute 
changes that included this.  The relative 
addresses were removed from the attributes 
because to an application accessing an instance, 
the relative addresses would be relative to the 
instance, not the model, and we have no idea 
where the user's instance is, as I posited in:


>if this is in error we need to update those as well.

I've done an analysis of the sanity1 ODF models 
with the sanity2 ODF models and the only 
differences I see (copied below) are in the qDT 
part of the information model.  I see the 
following differences (with my comments as to which I think is correct):

(1) - the listURI is present in sanity2 and not present in sanity1 (I think
       sanity1 is correct)
(2) - the listSchemeURI has ":schema:xsd:" in sanity2 and ":codelist:gc:"
       in sanity1 (I think sanity1 is correct since the list contents are not
       XSD files; I can be swayed, though, if we want to say the scheme is XSD
       because the structure is declared in XSD, but the values are not in the
       XSD but are in genericode so that is why I think sanity1 is correct)
(3) - the listVersionID for country code has "0.3" in sanity2 and "0,3" in
       sanity1 (I think this sanity2 is correct and this should be "0.3"; I
       note that the XSD has "0.3" and I'm not sure why but the XSD is correct;
       opening the sanity1 model in OpenOffice I see "0.3" yet the XML that
       is exported puts out "0,3", so this must be an ODF localization issue
       because sanity1 was created in Denmark and sanity2 in Australia)
(4) - the listVersionID for currency code has "2001" in sanity2 and "0,3" in
       sanity1 (I think sanity2 is correct based on the Pacific call this week
       and this is part of the massage I'm doing to the schemas)

It is understandable when collaboratively working 
on files to get slightly out of sync.  This is 
something we can clean up ... and based on (3) 
above, I think that either (a) Tim should modify 
his model or (b) change the value in the 
spreadsheet cell from a number type to a string 
type so that the XML export is "0.3" instead of 
"0,3" to reflect what we need.  This is the first 
evidence I've seen of the impact of the 
localization of OpenOffice on data, but I think 
the impact makes sense: the field is numeric, so 
it is saved in the file as a localized numeric 
value ... we should be treating the version ID as 
a string so that it is not changed by localization.  I've not seen this before.

And regarding clean up, I noted this morning that 
the timestamps of the spreadsheets reveal a 
possible mismatch between the ODF versions and 
the XLS versions.  My understanding is that the 
ODF file is the master and the XLS is the slave 
copy, such that the timestamp of the XLS should 
always follow the timestamp of the ODF thus 
revealing that it should be up-to-date as in:

2006-07-19  17:08            21,662 UBL-qDT-2.0.ods
2006-07-19  17:15           109,056 UBL-qDT-2.0.xls

But I note that the ODF follows the XLS in this example:

2006-07-14  19:18           169,197 UBL-CommonLibrary-2.0.ods
2006-07-14  17:46           860,672 UBL-CommonLibrary-2.0.xls

... and the maindoc models are almost all different by six days:

2006-07-14  19:18            18,839 UBL-ApplicationResponse-2.0.ods
2006-07-08  14:16            42,496 UBL-ApplicationResponse-2.0.xls
2006-07-14  19:18            19,181 UBL-AttachedDocument-2.0.ods
2006-07-08  13:53            86,528 UBL-AttachedDocument-2.0.xls

... and a date order sort of the listing of 
maindoc files reveals that all XLS files predate 
all ODF files.  But I do not have time to check 
this this morning because I have to work on 
defaultCodeList.xsl and the analysis above took 
more time than I planned ... perhaps someone else can check these.


. . . . . . . . . . . . . Ken

T:\>diff sanity1\CraneUBLModelReport.xml sanity2\CraneUBLModelReport.xml
 >       <Values>../codelist/gc/AllowanceChargeCodeType.gc</Values>
 >       <Values>../codelist/gc/ChannelCodeType.gc</Values>
 >       <Values>../codelist/gc/ChipCodeType.gc</Values>
<       <Values>0,3</Values>
 >       <Values>0.3</Values>
 >       <Values>../codelist/gc/CountryIdentificationCodeType.gc</Values>
<       <Values>0,3</Values>
 >       <Values>2001</Values>
 >       <Values>../codelist/gc/CurrencyCodeType.gc</Values>
 >       <Values>../codelist/gc/DocumentStatusCodeType.gc</Values>
 >       <Values>../codelist/gc/LatitudeDirectionCodeType.gc</Values>
 >       <Values>../codelist/gc/LineStatusCodeType.gc</Values>
 >       <Values>../codelist/gc/LongitudeDirectionCodeType.gc</Values>
 >       <Values>../codelist/gc/OperatorCodeType.gc</Values>
 >       <Values>../codelist/gc/PaymentMeansType.gc</Values>
 >       <Values>../codelist/gc/SubstitutionStatusCodeType.gc</Values>
 >       <Values>../codelist/gc/PortCodeType.gc</Values>
 >       <Values>../codelist/gc/PackagingTypeCodeType.gc</Values>
 >       <Values>../codelist/gc/TransportationStatusCodeType.gc</Values>
 >       <Values>../codelist/gc/TransportModeCodeType.gc</Values>
 >       <Values>../codelist/gc/UnitOfMeasureCodeType.gc</Values>
[Note: this is not available for public distribution]</Values>

Registration open for UBL training:    Montréal, Canada 2006-08-07
Also for XSL-FO/XSLT training:    Minneapolis, MN 2006-07-31/08-04
Also for UBL/XML/XSLT/XSL-FO training: Varo,Denmark 06-09-25/10-06
World-wide corporate, govt. & user group UBL, XSL, & XML training.
G. Ken Holman                 mailto:gkholman@CraneSoftwrights.com
Crane Softwrights Ltd.          http://www.CraneSoftwrights.com/o/
Box 266, Kars, Ontario CANADA K0A-2E0    +1(613)489-0999 (F:-0995)
Male Cancer Awareness Aug'05  http://www.CraneSoftwrights.com/o/bc
Legal business disclaimers:  http://www.CraneSoftwrights.com/legal

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]