Manual

Login

Our 3D CAD supplier models have been moved to 3Dfindit.com, the new visual search engine for 3D CAD, CAE & BIM models.

You can log in there with your existing account of this site.

The content remains free of charge.

Manual

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

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

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

Manual

Login

Top Links

Manual

4.14.3.5.2. Block [MISC]