Manuals - 3Dfindit

4.13.3.5. Configuration file nightupdate.cfg

4.13.3.5.2. Block [MISC]

Access data for LinkDB
Specify the user name.
```
user=sa
```
Path specification 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 " is to be used as a separator, you must precede it with an escape character such as a backslash.
```
SEP=\"
```
Key "QUOTE" - Text delimiter
Optionally enter a text delimiter.
If " is to be used as a text identifier, you must precede it with an escape character such as a 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 data records in link database without link in 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 the update if the CSV value is empty
List the respective columns comma separated.
Example:
```
DontOverwriteValueIfEmpty=ACTIVE_STATE,MAT_NAME
```

Prev	Up	Next
4.13.3.5.1. Block [LOG]	Home	4.13.3.5.3. Block [LOAD]