exportRandom Transaction Format

About exportRandom Transaction Format

exportRandom transaction format exports in DBLoad format all objects identified by the specified search criteria.

Syntax

ExportRandom class-name {
(field1 | field1@unit) = "str1" fd
(field2 | field2@unit) = "str2" fd
...
(fieldN | fieldN@unit) = "strN" fd
[objectPtr pointer-name {
class = class-name fd
(field1 | field1@unit) = "str1" fd
(field2 | field2@unit) = "str2" fd
...
(fieldN | fieldN@unit) = "strN" fd
}]
...
[attachment {}]
...
[text {}]
}

Notes

  • You can use the wildcards, operators, and symbols to select multiple objects for export.

  • To export all notes associated with an object, insert nothing between the braces in the text statement, as shown in this example: text {}.

  • To export all attachments associated with an object, do not insert anything between the braces in the attachment statement, as shown in this example: attachment {}.

Note: Search keys for Notes and Attachments is not supported in this release.

Explanation

exportRandom class-name {
(field1 | field1@unit) = "str1" fd
(field2 | field2@unit) = "str2" fd
...
(fieldN | fieldN@unit) = "strN" fd

For class-name, specify the name of the class from which you want to export objects. Use the fields that follow, to specify the search criteria for selecting the objects to be exported. These search criteria consist of values for any of the class properties in the specified class.

[objectPtr pointer-name {
class = class-name fd
(field1 | field1@unit) = "str1" fd
(field2 | field2@unit) = "str2" fd
...
(fieldN | fieldN@unit) = "strN" fd
}]
...

Use one or more objectPtr statements to provide additional search criteria for selecting the objects you want to export. These search criteria consist of values for any of the pointers in the specified class.

[attachment {}]

To export all non-shared attachments associated with the exported object, use attachment {}.

[text {}]

Use one or more text statements to indicate which associated notes to export.

Example

This example exports all objects in the VIP Symbol class that have the value HITACH as part of their manufacturer code:
 

exportRandom u_vip_symbol {
manufactor_code_ = "HITACH*";
}