4.14.3.5.2. Block [MISC]

4.14.3.5. Configuration file nightupdate.cfg 4.14.3.5.2. Block [MISC]
Prev	Next

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
```

Prev	Up	Next
4.14.3.5.1. Block [LOG]	Home	4.14.3.5.3. Block [LOAD]