Changes between Version 13 and Version 14 of RdsSpreadsheetBatchUpload
- Timestamp:
- 09/04/08 08:41:12 (16 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
RdsSpreadsheetBatchUpload
v13 v14 30 30 31 31 The 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 33 32 * 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 35 33 * 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 37 34 * 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 39 35 * 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 41 36 * 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 43 37 * 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 45 38 * 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]] 46 39 … … 259 252 Action :: 260 253 Action to be performed by the RDS (use INSERT for new classes, UPDATE for changing data of existing classes, DELETE for removing classes). 261 262 254 PCA ID :: 263 255 Unique ID of the class (leave blank for new classes). 264 265 256 RDL Designation :: 266 257 The name of the object (class, relationship or individual). 267 268 258 RDL Designation (KEY) :: 269 259 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 271 260 Entity type :: 272 261 The entity type (in ISO 15926-2) that this class is an instance of). 273 274 262 Creator :: 275 263 The (editor) user who created the Reference Data object. Leave blank when importing new data, leave unchanged when updating or deleting data. 276 277 264 Creation date :: 278 265 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 280 266 Deleted :: 281 267 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 283 268 Registration status :: 284 269 Choose from set of statuses according to ISO 11179 (use INCOMPLETE for new classes). 285 286 270 Alternative designation :: 287 271 Alternative class name (can be ignored). 288 289 272 RDL Definition :: 290 273 Definition of the class (not mandatory - but probably the most important field for creating meaningful reference data ;-) 291 292 274 Administrative note(s) :: 293 275 Meta-data field specified by ISO 11179 (can be ignored if no relevant data to record). 294 295 276 Change description :: 296 277 Meta-data field specified by ISO 11179 (can be ignored if no relevant data to record). 297 298 278 Explanatory comment(s) :: 299 279 Meta-data field specified by ISO 11179 (can be ignored if no relevant data to record). 300 301 280 Unresolved issue :: 302 281 Meta-data field specified by ISO 11179 (can be ignored if no relevant data to record). 303 304 282 RDL adapted definition :: 305 283 Meta-data field specified by ISO 11179 (can be ignored if no relevant data to record). 306 307 284 Abbreviation :: 308 285 Meta-data field specified by ISO 11179 (can be ignored if no relevant data to record). 309 310 286 Note(s) :: 311 287 Meta-data field specified by ISO 11179 (can be ignored if no relevant data to record). 312 313 288 Examples :: 314 289 Meta-data field specified by ISO 11179 (can be ignored if no relevant data to record). 315 316 290 Submitting organization :: 317 291 Meta-data field specified by ISO 11179 (can be ignored if no relevant data to record). 318 319 292 Submitter :: 320 293 Meta-data field specified by ISO 11179 (can be ignored if no relevant data to record). 321 322 294 Registrar :: 323 295 Meta-data field specified by ISO 11179 (can be ignored if no relevant data to record). 324 325 296 Registration Authority :: 326 297 Meta-data field specified by ISO 11179 (can be ignored if no relevant data to record). 327 328 298 Stewardship :: 329 299 Meta-data field specified by ISO 11179 (can be ignored if no relevant data to record). 330 331 300 Stewardship contact :: 332 301 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). 337 304 Error Description :: 338 305 Added by the RDS if errors in there are errors in import data (leave blank). … … 344 311 Action :: 345 312 Action to be performed by the RDS (use INSERT for new relationships, UPDATE for changing data of existing relationships, DELETE for removing relationships). 346 347 313 PCA ID :: 348 314 Unique ID of the relationship (leave blank for new relationships). 349 350 315 RDL Designation :: 351 316 The name of the Relationship. 352 353 317 Entity type :: 354 318 The entity type (in ISO 15926-2) of the relationship. 355 356 319 1.Role :: 357 320 The role of "class 1" 358 359 321 1.Entity type :: 360 322 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 362 323 1.PCA ID :: 363 324 Unique ID of "class 1" 364 365 325 1.RDL Designation :: 366 326 The name of the "class 1" 367 368 327 1.Cardinality ID :: 369 328 The PCA ID of the Cardinality of 1.Role 370 371 329 1.Cardinality Name :: 372 330 The RDL Designation of the cardinality of 1.Role 373 374 331 2.Role :: 375 332 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 377 333 2.Entity type :: 378 334 The entity type (in ISO 15926-2) of "class 2" 379 380 335 2.PCA ID :: 381 336 Unique ID of "class 2" 382 383 337 2.RDL Designation :: 384 338 The name of the "class 2" 385 386 339 2.Cardinality ID :: 387 340 The RDL Designation of the cardinality of 2.Role 388 389 341 2.Cardinality Name :: 390 342 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). 395 345 Error Description :: 396 346 Added by the RDS if errors in there are errors in import data (leave blank). … … 402 352 Action :: 403 353 Action to be performed by the RDS (use INSERT for new relationships, UPDATE for changing data of existing relationships, DELETE for removing relationships). 404 405 354 PCA ID :: 406 355 Unique ID of the Representation (leave blank for new Representations). 407 408 356 RDL Designation :: 409 357 The name of the Representation. 410 411 358 Entity type :: 412 359 The entity type (in ISO 15926-2) that this representation object is an instance of). 413 414 360 Value :: 415 361 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). 420 364 Error Description :: 421 365 Added by the RDS if errors in there are errors in import data (leave blank). … … 426 370 Action :: 427 371 Action to be performed by the RDS (use INSERT for new relationships, UPDATE for changing data of existing relationships, DELETE for removing Roles). 428 429 372 PCA ID :: 430 373 Unique ID of the Role (leave blank for new Roles). 431 432 374 RDL Designation (KEY) :: 433 375 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 435 376 Entity type :: 436 377 The entity type (in ISO 15926-2) that this Role is an instance of). 437 438 378 MC PCA ID :: 439 379 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 441 380 MC RDL Designation :: 442 381 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 444 382 Role Position :: 445 383 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 447 384 Mandatory :: 448 385 Boolean value that specifies whether or not the Role is mandatory in the Class of Multidimensional Object that includes this Role. 449 450 386 Cardinality ID :: 451 387 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). 456 390 Error Description :: 457 391 Added by the RDS if errors in there are errors in import data (leave blank). … … 462 396 Action :: 463 397 Action to be performed by the RDS (use INSERT for new relationships, UPDATE for changing data of existing relationships, DELETE for removing Parameters). 464 465 398 PCA ID :: 466 399 Unique ID of the Parameter (leave blank for new Parameters). 467 468 400 RDL Designation :: 469 401 The name of the Parameter. 470 471 402 Entity type :: 472 403 The entity type (in ISO 15926-2) that this Parameter is an instance of). 473 474 404 Role Position :: 475 405 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 477 406 Role PCA ID :: 478 407 The PCA ID of the parent Role of the Parameter in the Class of Multidimensional Object that includes the Parameter. 479 480 408 Role RDL Designation :: 481 409 The RDL Designation of the parent Role of the Parameter in the Class of Multidimensional Object that includes the Parameter. 482 483 410 MC PCA ID :: 484 411 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 486 412 MC RDL Designation :: 487 413 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). 492 416 Error Description :: 493 417 Added by the RDS if errors in there are errors in import data (leave blank). … … 499 423 Action :: 500 424 Action to be performed by the RDS (use INSERT for new relationships, UPDATE for changing data of existing relationships, DELETE for removing Dimensions). 501 502 425 PCA ID :: 503 426 Unique ID of the Dimension (leave blank for new Dimensions). 504 505 427 RDL Designation :: 506 428 The name of the (ISO 15926-4) Dimension. 507 508 429 Entity type :: 509 430 The entity type (in ISO 15926-2) that this Dimension is an instance of). 510 511 431 Role Position :: 512 432 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 514 433 Position :: 515 434 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 517 435 MO PCA ID :: 518 436 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 520 437 MO RDL Designation :: 521 438 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 523 439 Role PCA ID :: 524 440 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 526 441 Role RDL Designation :: 527 442 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 529 443 Error code :: 530 444 Added by the RDS if errors in there are errors in import data (leave blank) 531 532 445 Error Description :: 533 446 Added by the RDS if errors in there are errors in import data (leave blank) … … 535 448 === 8.7 The Cardinality sheet === 536 449 This subsection contains a commented list of all parameters in the Cardinality sheet, listed in the same order as the columns in the worksheet. 537 538 450 Action :: 539 451 Action to be performed by the RDS (use INSERT for new relationships, UPDATE for changing data of existing relationships, DELETE for removing Cardinalities). 540 541 452 PCA ID :: 542 453 Unique ID of the Cardinality (leave blank for new Cardinalities). 543 544 454 RDL Designation :: 545 455 The name of Cardinality. 546 547 456 Min :: 548 457 The minimum value allowed in the referenced Cardinality. 549 550 458 Max :: 551 459 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). 556 462 Error Description :: 557 463 Added by the RDS if errors in there are errors in import data (leave blank). … … 589 495 ||Error Code|| 590 496 ||Error Description|| 497