Differences between revisions 5 and 6
Deletions are marked like this. Additions are marked like this.
Line 3: Line 3:
 * [[ExcelIntegration|Back]]
Line 4: Line 6:

Excel Integration Client-Side Validation

Contents

  1. Excel Integration Client-Side Validation
  2. Introduction
    1. Column Descriptions
    2. Field Types
  3. Document - All Fields
  4. Rev-A - All Fields
  5. Rev-A Validation for Workflow Fields
    1. Erstellen(design)
    2. Stellungnahme (check)
    3. Bereinigung (approve)
  6. Rev-B - All Fields
  7. Rev-B Validation for Workflow Fields
    1. Erstellen (design)
    2. Prüfbericht (check)
    3. Freigabe (approve)
  8. Rev-C - All Fields
  9. Rev-C Validation for Workflow Fields
    1. Versand (design)
    2. erhalten (check)
    3. übergeben (approve)
  10. User Defined Fields

Introduction

Client-side validation will be implemented as Excel formulas and maps, assigned to validation cell properties.

Column Descriptions

Descriptions of columns used in the tables below:

  1. Field - The field name from the Header Structure

  2. Type - The field type/format validation that should be applied

  3. Reqd. - Is the field required. A value must be present in the field

  4. RO - Is the field read-only, e.g. the user cannot edit the field

  5. Size - For fields of type text the maximum number of characters

  6. Validation/Notes - Validation rules of other notes

Field Types

Explanation of the field types values:

  1. date - Date. Format is dd.mm.yy

  2. float - Floating point number. Format is 9.9

  3. formula - Format varies

  4. integer - Integer value. Format is 9

  5. menu - Values determined by menu

  6. text - Text field, with maximum length

Document - All Fields

  • Field

    Type

    Reqd.

    RO

    Size

    Validation/Notes

    xContractLookup

    n/a

    n/a

    n/a

    n/a

    hidden

    bereichCode

    menu

    Y

    N

    n/a

    locked if keyDocId set

    gruppeCodeMenu

    menu

    Y

    N

    n/a

    gruppeCodeLookup

    n/a

    n/a

    n/a

    n/a

    hidden

    archivCode

    menu

    Y

    N

    n/a

    archivCodeLookup

    n/a

    n/a

    n/a

    n/a

    hidden

    drawingIndex

    formula

    Y

    Y

    n/a

    zugriffCode

    menu

    Y

    N

    n/a

    projektphaseCode

    menu

    Y

    N

    n/a

    fachCode

    menu

    Y

    N

    n/a

    objektCode

    menu

    Y

    N

    n/a

    kontaktCode

    menu

    Y

    N

    n/a

    documenttypCode

    menu

    Y

    N

    n/a

    drawingNo

    integer

    Y

    N

    n/a

    >= 0, <= 9999

    partNo

    text

    Y

    N

    3

    [A-Za-z0-9]

    externalKeyDoc

    text

    Y

    N

    255

    titel1

    text

    Y

    N

    255

    titel2

    text

    N

    N

    255

    titel3

    text

    N

    N

    255

    titel4

    text

    N

    N

    255

    massstab

    text

    N

    N

    64

    formatCode

    n/a

    n/a

    n/a

    n/a

    not implemented

    glTech

    n/a

    n/a

    n/a

    n/a

    not implemented

    glVertrag

    n/a

    n/a

    n/a

    n/a

    not implemented

Rev-A - All Fields

  • Field

    Type

    Reqd.

    RO

    Size

    Validation/Notes

    vorabzugMenu

    menu

    Y

    N

    n/a

    locked if keyRevAId set

    revBVorabzugFlag

    n/a

    n/a

    n/a

    n/a

    hidden, set to 1 if keyRevAId is set

    revARevisionCode

    text

    Y

    Y

    n/a

    revATv

    date

    Y

    Y

    n/a

    calculated

    revAErstellIst

    date

    Y

    N

    n/a

    see below

    revAErstellWer

    menu

    Y

    N

    n/a

    see below

    revADelta7

    integer

    Y

    N

    n/a

    >= 0

    revAStellungStnNr

    n/a

    n/a

    n/a

    n/a

    not implemented

    revAStellungSoll

    date

    Y

    Y

    n/a

    calculated

    revAStellungIst

    date

    Y

    N

    n/a

    see below

    revAStellungWer

    menu

    Y

    N

    n/a

    see below

    revAStellungStatus

    menu

    Y

    N

    n/a

    see below

    revAStellungStatusFormula

    n/a

    n/a

    n/a

    n/a

    hidden

    revADelta6

    integer

    Y

    N

    n/a

    >= 0

    revABereinSoll

    date

    Y

    Y

    n/a

    calculated

    revABereinIst

    date

    Y

    N

    n/a

    revABereinWer

    menu

    Y

    N

    n/a

    revABereinStatus

    menu

    Y

    N

    n/a

    revABereinStatusFormula

    n/a

    n/a

    n/a

    n/a

    hidden

Rev-A Validation for Workflow Fields

Erstellen(design)

  1. Field: revAErstellIst (design complete date)

    • >= today

    • <= revAStellungIst (next step), which may not be set

    • required if revAStellungIst (next step) set

  2. Field: revAErstellWer (design responsible id)

    • required if revAErstellIst (this step) set

Stellungnahme (check)

  1. Field: revAStellungIst (check complete date)

    • >= today

    • >= revAErstellIst (prev step)

    • <= revABereinIst (next step), which may not be set

    • required if revABereinIst (next step) step

  2. Field: revAStellungWer (check responsible id)

    • required if revAStellungIst (this step) set

  3. Field: revAStellungStatus (check status)

    • if revAStellungIst (this step) not set --> open (open)

    • if revAStellungIst (this step) set --> one of:

      • keine Bemerkungen (approved)

      • Bemerkungen einarbeiten (approved)

Bereinigung (approve)

  1. Field: revABereinIst (approve complete date)

    • >= today

    • >= revAStellungIst (prev step)

    • <= revBErstellIst (next step), which may not be set

    • required if revBErstellIst (next step) step

  2. Field: revABereinWer (approve responsible id)

    • required if revABereinIst (this step) step

  3. Field: revABereinStatus (approve status)

    • if revABereinIst (this step) not set --> offen (open)

    • if revABereinIst (this step) set --> bereinigt (approved)

Rev-B - All Fields

  • Field

    Type

    Reqd.

    RO

    Size

    Validation/Notes

    revBRevisionCode

    text

    Y

    Y

    n/a

    revBDelta5

    integer

    Y

    N

    n/a

    >= 0

    revBTzf

    date

    Y

    Y

    n/a

    calculated

    revBErstellIst

    date

    Y

    N

    n/a

    see below

    revBErstellWer

    menu

    Y

    N

    n/a

    see below

    revBPruefArt

    n/a

    n/a

    n/a

    n/a

    not implemented

    revBDelta4

    integer

    Y

    N

    n/a

    >= 0

    revBPruefNr

    n/a

    n/a

    n/a

    n/a

    not implemented

    revBPruefSoll

    date

    Y

    Y

    n/a

    calculated

    revBPruefIst

    date

    Y

    N

    n/a

    see below

    revBPruefWer

    menu

    Y

    N

    n/a

    see below

    revBPruefStatus

    menu

    Y

    N

    n/a

    see below

    revBPruefStatusFormula

    n/a

    n/a

    n/a

    n/a

    hidden

    revBQeNr

    n/a

    n/a

    n/a

    n/a

    not implemented

    revBDelta3

    integer

    Y

    N

    n/a

    >= 0

    revBTf

    date

    Y

    Y

    n/a

    calculated

    revBFreiIst

    date

    Y

    N

    n/a

    see below

    revBFreiWer

    menu

    Y

    N

    n/a

    see below

    revBFreiStatus

    menu

    Y

    N

    n/a

    see below

    revBFreiStatusLookupFormula

    n/a

    n/a

    n/a

    n/a

    hidden

Rev-B Validation for Workflow Fields

Erstellen (design)

  1. Field: revBErstellIst (design complete date)

    • >= today

    • >= revABereinIst (prev step), which may not be set

    • <= revBPruefIst (next step), which may not be set

    • required if revBPruefIst (next step) set

  2. Field: revBErstellWer (design responsible id)

    • required if revBErstellIst (this step) set

Prüfbericht (check)

  1. Field: revBPruefIst (check complete date)

    • >= today

    • >= revBErstellIst (prev step)

    • <= revBFreiIst (next step), which may not be set

    • required if revBFreiIst (next step) step

  2. Field: revBPruefWer (check responsible id)

    • required if revBPruefIst (this step) step

  3. Field: revBPruefStatus (check status)

    • if revBPruefIst (this step) not set --> offen (open)

    • if revBPruefIst (this step) set --> Prüfbericht erstellt (approved)

Freigabe (approve)

  1. Field: revBFreiIst (approve complete date)

    • >= today

    • >= revBPruefIst (prev step)

    • <= revCVersandIst (next step), which may not be set

    • required if revCVersandIst (next step) step

  2. Field: revBFreiWer (approve responsible id)

    • required if revBFreiIst (this step) step

  3. Field: revBFreiStatus (approve status)

    • if revBFreiIst (this step) not set --> offen (open)

    • if revBFreiIst (this step) set --> one of:

      • Keine freigabe (rejected)

      • ohne Berkungen (approved)

      • mit Berkungen (approved)

Rev-C - All Fields

  • Field

    Type

    Reqd.

    RO

    Size

    Validation/Notes

    revCRevisionCode

    text

    Y

    Y

    n/a

    x_revCRevisionTypeMenu

    menu

    Y

    N

    n/a

    revCRevisionTypeId

    n/a

    n/a

    n/a

    n/a

    hidden

    revCVersandIst

    date

    Y

    N

    n/a

    see below

    revCVersandWer

    menu

    Y

    N

    n/a

    see below

    revCErhaltenIst

    date

    Y

    N

    n/a

    see below

    revCErhaltenWer

    menu

    Y

    N

    n/a

    see below

    revCErhaltenStatus

    menu

    Y

    N

    n/a

    see below

    revCErhaltenStatusFormula

    n/a

    n/a

    n/a

    n/a

    hidden

    revCDelta2

    integer

    Y

    N

    n/a

    >= 0

    revCTgza

    date

    Y

    Y

    n/a

    calculated

    revCUerbergebenIst

    date

    Y

    N

    n/a

    see below

    revCUerbergebenWer

    menu

    Y

    N

    n/a

    see below

    revCUerbergebenStatus

    menu

    Y

    N

    n/a

    see below

    revCUerbergebenStatusFormula

    n/a

    n/a

    n/a

    n/a

    hidden

    revCDelta1

    integer

    Y

    N

    n/a

    >= 0

    revCT0

    date

    Y

    N

    n/a

    revCT0wv

    date

    Y

    N

    n/a

Rev-C Validation for Workflow Fields

Versand (design)

  1. Field: revCVersandIst (design complete date)

    • >= today

    • >= revBFreiIst (prev step), which may not be set

    • <= revCErhaltenIst (next step), which may not be set

    • required if revCErhaltenIst (next step) set

    • cannot be set if revCUerbergebenStatus is set to Keine Freigabe (rejected)

  2. Field: revCVersandWer (design responsible id)

    • required if revCVersandIst (this step) set

erhalten (check)

  1. Field: revCErhaltenIst (check complete date)

    • >= today

    • >= revCVersandIst (prev step)

    • <= revCUerbergebenIst (next step), which may not be set

    • required if revCUerbergebenIst (next step) step

  2. Field: revCErhaltenWer (check responsible id)

    • required if revCErhaltenIst (this step) step

  3. Field: revCErhaltenStatus (check status)

    • if revCErhaltenIst (this step) not set --> offen (open)

    • if revCErhaltenIst (this step) set --> erhalten (approved)

übergeben (approve)

  1. Field: revCUerbergebenIst (approve complete date)

    • >= today

    • >= revCErhaltenIst (prev step)

  2. Field: revCUerbergebenWer (approve responsible id)

    • required if revCUerbergebenIst (this step) step

  3. Field: revCUerbergebenStatus (approve status)

    • if revCUerbergebenIst (this step) not set --> offen (open)

    • if revCUerbergebenIst (this step) set --> erfolgt (approved)

User Defined Fields

  • Field

    Type

    Reqd.

    RO

    Size

    Validation/Notes

    resourcePlanCad

    float

    Y

    N

    n/a

    >= 0

    resourcePlanPi

    float

    Y

    N

    n/a

    >= 0

    resourcePlanPl

    float

    Y

    N

    n/a

    >= 0

    resourcePlanVon

    date

    Y

    Y

    n/a

    resourcePlanBis

    date

    Y

    Y

    n/a

    resourcePlAxpo

    float

    Y

    N

    n/a

    >= 0

    resourcePlPruef

    float

    Y

    N

    n/a

    >= 0

    resourcePlVon

    date

    Y

    Y

    n/a

    resourcePlBis

    date

    Y

    Y

    n/a

    verteilerRevAPl

    integer

    Y

    N

    n/a

    >= 0

    verteilerRevAPi

    integer

    Y

    N

    n/a

    >= 0

    verteilerRevAOebl

    integer

    Y

    N

    n/a

    >= 0

    verteilerRevAUn

    integer

    Y

    N

    n/a

    >= 0

    verteilerRevAExt

    integer

    Y

    N

    n/a

    >= 0

    verteilerRevAAblage

    integer

    Y

    N

    n/a

    >= 0

    verteilerRevBPl

    integer

    Y

    N

    n/a

    >= 0

    verteilerRevBPi

    integer

    Y

    N

    n/a

    >= 0

    verteilerRevBOebl

    integer

    Y

    N

    n/a

    >= 0

    verteilerRevBUn

    integer

    Y

    N

    n/a

    >= 0

    verteilerRevBExt

    integer

    Y

    N

    n/a

    >= 0

    verteilerRevBAblage

    integer

    Y

    N

    n/a

    >= 0

    verteilerRevCPl

    integer

    Y

    N

    n/a

    >= 0

    verteilerRevCPi

    integer

    Y

    N

    n/a

    >= 0

    verteilerRevCOebl

    integer

    Y

    N

    n/a

    >= 0

    verteilerRevCUn

    integer

    Y

    N

    n/a

    >= 0

    verteilerRevCExt

    integer

    Y

    N

    n/a

    >= 0

    verteilerRevCAblage

    integer

    Y

    N

    n/a

    >= 0

ExcelIntegrationValidation (last edited 2011-05-10 14:40:36 by alan)

Copyright 2008-2014, SoftXS GmbH, Switzerland