Export/Import of Texts

Texts are automatically included in distribution if:

• Samples are exported/imported:

  CCTEXT.ID = CCSAMPLE.ANALYSIS_TEXT_ID

  CCTEXT.ID = CCSAMPLE.PRODUCT_SPEC_RESULT_TEXT_ID

  CCTEXT.ID = CCSAMPLE.REGISTRATION_TEXT_ID

  CCTEXT.ID = CCSAMPLE.REPORT_TEXT_ID

• Sample Schemes are exported/imported:

  CCTEXT.ID = CCSAMPLESCHEME.ANALYSIS_TEXT_ID

  CCTEXT.ID = CCSAMPLESCHEME.REPORT_FOOTER_TEXT_ID

  CCTEXT.ID = CCSAMPLESCHEME.REPORT_HEADER_TEXT_ID

  CCTEXT.ID = CCSAMPLESCHEME.REPORT_TEXT_ID

  CCTEXT.ID = CCSAMPLESCHEME.RESULT_HEADER_TEXT_ID

• Sample Scheme Analytes are exported/imported: CCTEXT.ID = CCSAMPLESCHEMEANALYTE.REPORT_TEXT_ID
• Products are exported/imported: CCTEXTID = CCPRODUCT.PRODUCT_TEXT_ID
• Standards are exported/imported: CCTEXTID = CCSTANDARD.STANDARD_TEXT_ID
• Hazards are exported/imported:

  CCTEXT.ID = CCHAZARD.DISPOSAL_METHOD_TEXT_ID

  CCTEXT.ID = CCHAZARD.LABEL_TEXT_ID

  CCTEXT.ID = CCHAZARD.SPECIAL_INSTRUCTIONS_TEXT_ID

• Sample Handlings are exported/imported:

  CCTEXT.ID = CCSAMPLEHANDLING.LABEL_TEXT_ID

  CCTEXT.ID = CCSAMPLEHANDLING.SPECIAL_INSTRUCTIONS_TEXT_ID

• Schemes are exported/imported:

  CCTEXT.ID = CCSCHEME.SCHEME_TEXT_ID

  CCTEXT.ID = CCSCHEME.SCHEME2_TEXT_ID

• Scheme Versions are exported/imported:

  CCTEXT.ID = CCSCHEMEVERSION.REPORT_FOOTER_TEXT_ID

  CCTEXT.ID = CCSCHEMEVERSION.REPORT_HEADER_TEXT_ID

  CCTEXT.ID = CCSCHEMEVERSION.RESULTS_HEADER_TEXT_ID

  CCTEXT.ID = CCSCHEMEVERSION.SCHEME_VERSION_TEXT_ID

• Scheme Version Analytes are exported/imported:

  CCTEXT.ID = CCSCHEMEVERSIONANALYTE.ANALYTE_TEXT_ID

  CCTEXT.ID = CCSCHEMEVERSIONANALYTE.SCHEME_VERSION_ANALYTE_TEXT_ID

• Specifications are exported/imported:

  CCTEXT.ID = CCSPECIFICATION.FAIL_STATEMENT_TEXT_ID

  CCTEXT.ID = CCSPECIFICATION.PASS_STATEMENT_TEXT_ID

  CCTEXT.ID = CCSPECIFICATION.WARN_STATEMENT_TEXT_ID

• Methods are exported/imported: CCTEXT.ID = CCMETHOD.METHOD_TEXT_ID
• Canned Comments are exported/imported: CCTEXT.ID = CCCANNEDCOMMENT.LONG_FORM_TEXT_ID

The following data is included when a Text record is exported/imported:

• All fields in the record, except for those specified as being cleared, and Creation User and Last Mod User which are cleared also.

  • Language category

• Specific links to other records are maintained, and the linked record is exported/imported if it does not already exist in the destination organisation.
• Related child or group member records are exported/imported.
• All related EFS files (for example, scripts, images) are exported/imported.
• All related custom attributes and related content are exported/imported.
• All related I18n records are exported/imported for all exported/imported records.