powered by CADENAS

Manual

Manual

4.14.3.5.2.  Block [MISC]

  • Access data for LinkDB

    Specify the user name.

    user=sa

  • Path declaration for CSV file

    The PLM/ERP system exports a CSV file.

    Specify the location of this file.

    The placeholder <date> is automatically replaced by the current date.

    inputcsv=C:\temp\input_<date>.csv

    Output could be for example: c:\temp\input_31_05_2011.csv

  • Determine start line

    You can define the desired start line (1 for the first, 2 for the second, 3 for the third,...).

    startline=1

  • Column separator

    You can work with fixed column width or with a certain separator:

    • Fixed column width

      If "FixedWidth" is empty, then "SEP" and "Quote" is used; if values are set, then these are used.

      FIXED_WITH=10,80,100

    • Separator

      Example 1:

      Semicolon is often used.

      SEP=;

      Example 2:

      Also tab can be used as separator.

      SEP=\t

      Example 3:

      If " shall be used as separator, then you have to prefix an escape character such as backslash.

      SEP=\"

  • Key "QUOTE" - Text delimiter

    Optionally enter a text delimiter.

    If " shall be used as text delimiter, then you have to prefix an escape character such as backslash.

    Example:

    QUOTE=\"

  • Key "ProcessLine" - Exclude certain lines from takeover

    • Example 1.

      All lines are overtaken.

      ProcessLine=1

    • Example 2:

      At very large CSV files and/or in the case that many lines are not to be used, you can exclude lines from takeover.

      If a line shall be ignored, which contains the value "STEEL" in the column 3, then state the following:

       ProcessLine=row.cells.item(2).value<>"STEEL"

    • Example 3:

      If only that lines shall be overtaken, which contain the value "STEEL" in the column 3, then state the following:

       ProcessLine=row.cells.item(2).value="STEEL"

    • Example 4:

      You can join together several conditions.

      Each logical operator (AND,OR,XOR,…) can be used.

      If only that lines shall be overtaken, which contain the value "STEEL" or "GOLD" in the column 3, then state the following:

       ProcessLine=row.cells.item(2).value="STEEL" OR row.cells.item(2).value="GOLD"

  • Create missing datasets in the link database without link in the ERPTABLE

    Value range: 0/1

    Advantage: At a later call up the META data are available at once.

    Disadvantage: Possibly many unnecessary datasets are created.

    createEmptyERPdataSetIfUnknown=1

  • Exclude certain columns from update - if the CSV value is empty

    List the respective columns comma separated.

    Example:

    DontOverwriteValueIfEmpty=ACTIVE_STATE,MAT_NAME