Changes between Version 13 and Version 14 of RdsSpreadsheetBatchUpload

Show
Ignore:
Timestamp:
09/04/08 08:41:12 (16 years ago)
Author:
margs (IP: 193.212.132.34)
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • RdsSpreadsheetBatchUpload

    v13 v14  
    3030 
    3131The batch input facility, currently consists of seven worksheets for different types of RD. The worksheets are placed on tabs in the lower right hand part of the RDE user interface, and consist of – 
    32  
    3332 * The ''Object sheet'' is used to define and/or modify all (instances of) ISO 15926-2 Thing. That is, data about any type of class, relationship, individual (or instances of any other legal entity type can be specified here. 
    34  
    3533 * The ''Relationship sheet'' is used to add necessary information for (instances of) ISO 15926-2 Relationship (as well as Class of Relationship and Class of Class of Relationship). Note that these Relationships can already be defined in the Object sheet, or be defined directly in the Relationship sheet. 
    36  
    3734 * The ''Representation sheet'' is used to add the value of (instances of) ISO 15926-2) Express String, Express Real, Express Integer, Gregorian Date and UTC Time, etc. Note that these Representations can already be defined in the Object sheet, or be defined directly in the Representation sheet. 
    38  
    3935 * The ''Role sheet'' is used to add information about (instances of) ISO 15926-2 Role and Domain, used in Multidimensional objects. Note that these Roles must already be defined in the Object sheet. 
    40  
    4136 * The ''Parameters sheet'' is used to add information about (the classes that are used as) Parameters in (instances of) ISO 15926-2 Class of Multidimensional object. Note that these Parameters (classes) must already be defined in the Object sheet. 
    42  
    4337 * The ''Dimension sheet'' is used to add necessary information about (the class instances that are used as) Parameters in (instances of) ISO 15926-2 Multidimensional object.. Note that these Dimensions must already be defined in the Object sheet. 
    44  
    4538 * The ''Cardinality sheet'' is used to add necessary information about (the instances of) ISO 15926-2 Cardinality. Note that these Cardinalities must already be defined in the Object sheet.[[BR]] 
    4639 
     
    259252 Action :: 
    260253   Action to be performed by the RDS (use INSERT for new classes, UPDATE for changing data of existing classes, DELETE for removing classes).  
    261  
    262254 PCA ID :: 
    263255     Unique ID of the class (leave blank for new classes). 
    264  
    265256 RDL Designation :: 
    266257     The name of the object (class, relationship or individual). 
    267  
    268258 RDL Designation (KEY) :: 
    269259    Optional means of identifying existing class If changing RDL Designation of the object, without defining PCA ID, this field should hold the old RDL Designation. 
    270  
    271260 Entity type :: 
    272261     The entity type (in ISO 15926-2) that this class is an instance of). 
    273  
    274262 Creator :: 
    275263  The (editor) user who created the Reference Data object. Leave blank when importing new data, leave unchanged when updating or deleting data. 
    276  
    277264 Creation date :: 
    278265  The date and time that the Reference data object was first imported (or manually created in the RDE). Leave blank when importing new data, leave unchanged when updating or deleting data. 
    279  
    280266 Deleted :: 
    281267  The time that the Reference Data object was deleted (this is only set when Reference data is imported with the Action set to DELETE). 
    282  
    283268 Registration status :: 
    284269     Choose from set of statuses according to ISO 11179 (use INCOMPLETE for new classes). 
    285  
    286270 Alternative designation :: 
    287271     Alternative class name (can be ignored). 
    288  
    289272 RDL Definition :: 
    290273     Definition of the class (not mandatory - but probably the most important field for creating meaningful reference data ;-) 
    291  
    292274 Administrative note(s) :: 
    293275     Meta-data field specified by ISO 11179 (can be ignored if no relevant data to record). 
    294  
    295276 Change description :: 
    296277     Meta-data field specified by ISO 11179 (can be ignored if no relevant data to record). 
    297  
    298278 Explanatory comment(s) :: 
    299279     Meta-data field specified by ISO 11179 (can be ignored if no relevant data to record). 
    300  
    301280 Unresolved issue :: 
    302281     Meta-data field specified by ISO 11179 (can be ignored if no relevant data to record). 
    303  
    304282 RDL adapted definition :: 
    305283     Meta-data field specified by ISO 11179 (can be ignored if no relevant data to record). 
    306  
    307284 Abbreviation :: 
    308285     Meta-data field specified by ISO 11179 (can be ignored if no relevant data to record). 
    309  
    310286 Note(s) :: 
    311287     Meta-data field specified by ISO 11179 (can be ignored if no relevant data to record). 
    312  
    313288 Examples :: 
    314289     Meta-data field specified by ISO 11179 (can be ignored if no relevant data to record). 
    315  
    316290 Submitting organization :: 
    317291     Meta-data field specified by ISO 11179 (can be ignored if no relevant data to record). 
    318  
    319292 Submitter :: 
    320293   Meta-data field specified by ISO 11179 (can be ignored if no relevant data to record). 
    321  
    322294 Registrar :: 
    323295   Meta-data field specified by ISO 11179 (can be ignored if no relevant data to record). 
    324  
    325296 Registration Authority :: 
    326297    Meta-data field specified by ISO 11179 (can be ignored if no relevant data to record). 
    327  
    328298 Stewardship :: 
    329299    Meta-data field specified by ISO 11179 (can be ignored if no relevant data to record). 
    330  
    331300 Stewardship contact :: 
    332301    Meta-data field specified by ISO 11179 (can be ignored if no relevant data to record). 
    333  
    334  Error code :: 
    335      Added by the RDS if errors in there are errors in import data (leave blank). 
    336  
     302 Error code :: 
     303     Added by the RDS if errors in there are errors in import data (leave blank). 
    337304 Error Description :: 
    338305     Added by the RDS if errors in there are errors in import data (leave blank). 
     
    344311 Action :: 
    345312     Action to be performed by the RDS (use INSERT for new relationships, UPDATE for changing data of existing relationships, DELETE for removing relationships). 
    346  
    347313 PCA ID :: 
    348314     Unique ID of the relationship (leave blank for new relationships). 
    349  
    350315 RDL Designation :: 
    351316     The name of the Relationship. 
    352  
    353317 Entity type :: 
    354318   The entity type (in ISO 15926-2) of the relationship. 
    355  
    356319 1.Role :: 
    357320     The role of "class 1" 
    358  
    359321 1.Entity type :: 
    360322     The entity type (in ISO 15926-2) of "class 1" (NOTE that the choice of class 1 and class 2 is arbitrary, but specified by 1.Role and 2.Role below). 
    361  
    362323 1.PCA ID :: 
    363324     Unique ID of "class 1" 
    364  
    365325 1.RDL Designation :: 
    366326     The name of the "class 1" 
    367  
    368327 1.Cardinality ID :: 
    369328   The PCA ID of the Cardinality of 1.Role 
    370  
    371329 1.Cardinality Name :: 
    372330   The RDL Designation of the cardinality of 1.Role 
    373  
    374331 2.Role :: 
    375332   The role of "class 2" (NOTE that the choice of class 1 and class 2 is arbitrary, but specified by 1.Role and 2.Role below). 
    376  
    377333 2.Entity type :: 
    378334     The entity type (in ISO 15926-2) of "class 2" 
    379  
    380335 2.PCA ID :: 
    381336     Unique ID of "class 2" 
    382  
    383337 2.RDL Designation :: 
    384338     The name of the "class 2" 
    385  
    386339 2.Cardinality ID :: 
    387340   The RDL Designation of the cardinality of 2.Role 
    388  
    389341 2.Cardinality Name :: 
    390342   The PCA ID of the Cardinality of 2.Role 
    391  
    392  Error code :: 
    393      Added by the RDS if errors in there are errors in import data (leave blank). 
    394  
     343 Error code :: 
     344     Added by the RDS if errors in there are errors in import data (leave blank). 
    395345 Error Description :: 
    396346     Added by the RDS if errors in there are errors in import data (leave blank). 
     
    402352 Action :: 
    403353   Action to be performed by the RDS (use INSERT for new relationships, UPDATE for changing data of existing relationships, DELETE for removing relationships). 
    404  
    405354 PCA ID :: 
    406355    Unique ID of the Representation (leave blank for new Representations).  
    407  
    408356 RDL Designation :: 
    409357  The name of the Representation. 
    410  
    411358 Entity type :: 
    412359   The entity type (in ISO 15926-2) that this representation object is an instance of).  
    413  
    414360 Value :: 
    415361   The value of the Representation. 
    416  
    417  Error code :: 
    418      Added by the RDS if errors in there are errors in import data (leave blank). 
    419  
     362 Error code :: 
     363     Added by the RDS if errors in there are errors in import data (leave blank). 
    420364 Error Description :: 
    421365     Added by the RDS if errors in there are errors in import data (leave blank). 
     
    426370 Action :: 
    427371  Action to be performed by the RDS (use INSERT for new relationships, UPDATE for changing data of existing relationships, DELETE for removing Roles). 
    428  
    429372  PCA ID :: 
    430373    Unique ID of the Role (leave blank for new Roles).  
    431  
    432374 RDL Designation (KEY) :: 
    433375   The name of the Role. This should be the same as the RDL Designation given to the Role object when defining it through the Object sheet (and can most easily be found by searching in the RDE). 
    434  
    435376 Entity type :: 
    436377    The entity type (in ISO 15926-2) that this Role is an instance of). 
    437  
    438378 MC PCA ID :: 
    439379   The PCA of the Class of Multidimensional Object that includes the Role (this is a reference to the PCA ID of the Class of Multidimensional Object defined in the Object sheet). 
    440  
    441380 MC RDL Designation ::  
    442381   The RDL Designation of the Class of Multidimensional Object that includes the Role (this is a reference to the RDL Designation of the Class of Multidimensional Object defined in the Object sheet). Note that either MC PCA ID or MC RDL Designation must be specified. 
    443  
    444382 Role Position :: 
    445383   The  position (order) of the Role within the Class of Multidimensional Object  The same Role could be used in more than one Position (and this should be specified in different rows). This field is not required for the DELETE action. 
    446  
    447384 Mandatory :: 
    448385   Boolean value that specifies whether or not the Role is mandatory in the Class of Multidimensional Object that includes this Role. 
    449  
    450386 Cardinality ID :: 
    451387   PCA ID of the Cardinality of the Role in the Class of Multidimensional Object that includes the Role. 
    452  
    453  Error code :: 
    454      Added by the RDS if errors in there are errors in import data (leave blank). 
    455  
     388 Error code :: 
     389     Added by the RDS if errors in there are errors in import data (leave blank). 
    456390 Error Description :: 
    457391     Added by the RDS if errors in there are errors in import data (leave blank). 
     
    462396 Action :: 
    463397   Action to be performed by the RDS (use INSERT for new relationships, UPDATE for changing data of existing relationships, DELETE for removing Parameters). 
    464  
    465398 PCA ID :: 
    466399    Unique ID of the Parameter (leave blank for new Parameters).  
    467  
    468400 RDL Designation :: 
    469401  The name of the Parameter. 
    470  
    471402 Entity type :: 
    472403    The entity type (in ISO 15926-2) that this Parameter is an instance of). 
    473  
    474404 Role Position :: 
    475405   The Position of the parent Role of the Parameter in the Class of Multidimensional Object that includes the Parameter. Note that one of Role Position, Role PCA ID or Role RDL Designation must be given. 
    476  
    477406 Role PCA ID :: 
    478407  The PCA ID of the parent Role of the Parameter in the Class of Multidimensional Object that includes the Parameter. 
    479  
    480408 Role RDL Designation :: 
    481409  The RDL Designation of the parent Role of the Parameter in the Class of Multidimensional Object that includes the Parameter. 
    482  
    483410 MC PCA ID :: 
    484411   The PCA of the Class of Multidimensional Object that includes the Parameter (this is a reference to the PCA ID of the Class of Multidimensional Object defined in the Object sheet). 
    485  
    486412 MC RDL Designation :: 
    487413   The RDL Designation of the Class of Multidimensional Object that includes the Parameter (this is a reference to the RDL Designation of the Class of Multidimensional Object defined in the Object sheet). Note that either MC PCA ID or MC RDL Designation must be specified. 
    488  
    489  Error code :: 
    490      Added by the RDS if errors in there are errors in import data (leave blank). 
    491  
     414 Error code :: 
     415     Added by the RDS if errors in there are errors in import data (leave blank). 
    492416 Error Description :: 
    493417     Added by the RDS if errors in there are errors in import data (leave blank). 
     
    499423 Action :: 
    500424   Action to be performed by the RDS (use INSERT for new relationships, UPDATE for changing data of existing relationships, DELETE for removing Dimensions). 
    501  
    502425 PCA ID :: 
    503426    Unique ID of the Dimension (leave blank for new Dimensions). 
    504  
    505427 RDL Designation :: 
    506428  The name of the (ISO 15926-4) Dimension. 
    507  
    508429 Entity type :: 
    509430    The entity type (in ISO 15926-2) that this Dimension is an instance of). 
    510  
    511431 Role Position :: 
    512432  The Position of the parent Role of the Parameter that instantiates the Dimension in the Class of Multidimensional Object that classifies the Multidimensional Object. This is optional. 
    513  
    514433 Position :: 
    515434   The Position of Dimension in the Multidimensional Object that instantiates the Class of Multidimensional Object that includes the Parameter corresponding to the Dimension. Note that this has too be specified in INSERT mode. 
    516  
    517435 MO PCA ID :: 
    518436   The PCA ID of the Multidimensional Object that includes the Dimension (this is a reference to the PCA ID of the Multidimensional Object defined in the Object sheet). 
    519  
    520437 MO RDL Designation :: 
    521438  The RDL Designation of the Multidimensional Object that includes the Dimension (reference to the RDL Designation of the Multidimensional Object defined in the Object sheet). 
    522  
    523439 Role PCA ID :: 
    524440  The PCA ID of the Role that classifies the Dimension in the Class of Multidimensional Object instantiating the Multidimensional Object (this is an optional reference to the PCA ID of the Role defined in the Object sheet). 
    525  
    526441 Role RDL Designation :: 
    527442  RDL Designation of the Role that classifies the Dimension in the Class of Multidimensional Object instantiating the Multidimensional Object (this is an optional reference to the PCA ID of the Role defined in the Object sheet). 
    528  
    529443 Error code :: 
    530444     Added by the RDS if errors in there are errors in import data (leave blank) 
    531  
    532445 Error Description :: 
    533446     Added by the RDS if errors in there are errors in import data (leave blank) 
     
    535448===  8.7 The Cardinality sheet === 
    536449This subsection contains a commented list of all parameters in the Cardinality sheet, listed in the same order as the columns in the worksheet. 
    537  
    538450 Action :: 
    539451   Action to be performed by the RDS (use INSERT for new relationships, UPDATE for changing data of existing relationships, DELETE for removing Cardinalities). 
    540  
    541452 PCA ID :: 
    542453    Unique ID of the Cardinality (leave blank for new Cardinalities). 
    543  
    544454 RDL Designation :: 
    545455   The name of Cardinality. 
    546  
    547456 Min :: 
    548457  The  minimum value allowed in the referenced Cardinality. 
    549  
    550458 Max :: 
    551459  The  maximum value allowed in the referenced Cardinality. 
    552  
    553  Error code :: 
    554      Added by the RDS if errors in there are errors in import data (leave blank). 
    555   
     460 Error code :: 
     461     Added by the RDS if errors in there are errors in import data (leave blank).  
    556462 Error Description :: 
    557463     Added by the RDS if errors in there are errors in import data (leave blank). 
     
    589495||Error Code|| 
    590496||Error Description|| 
     497 
Home
About PCA
Reference Data Services
Projects
Workgroups