– Fields must be separated by one of the following delimiters:
– Semicolon (
;
)
– Comma (
,
)
– Tabulator (
\
t
)
– Pipe (
|
)
– The delimiter defined in the header line must be used throughout the file.
– A double quotation mark (
"
) must be used as the escape character. A character string must
be escaped if it contains a semicolon or a double quotation mark.
– In an escape character string, double quotation marks (
"
) are shown twice (
"
"
).
Example:
– Character string:
T
-
s
h
i
r
tl
a
r
g
e
;l
o
n
g
-
a
r
m
e
da
n
d"
c
o
l
o
u
r
f
u
l
"
– Output in CSV file:
"
T
-
s
h
i
r
tl
a
r
g
e
;l
o
n
g
-
s
l
e
e
v
e
da
n
d"
"
c
o
l
o
u
r
f
u
l
"
"
"
Field descriptions
The specified data types correspond to the SQL server data types for the corresponding columns.
For optimum compatibility, in interfaces WERMA recommends using data types that have the
same value range.
The number and definition of the fields can change in future WERMA-StockSAVER upda-
tes.
Field ID
Data type
Description
Required
field
M
a
t
e
r
i
a
l
N
a
m
e
[
n
v
a
r
c
h
a
r
]
(
3
2
)
Part Number
M
a
t
e
r
i
a
l
D
e
s
c
r
i
p
t
i
o
n
1[
n
v
a
r
c
h
a
r
]
(
6
0
)
Description of the material
P
i
e
c
e
s
P
e
r
B
o
x
[
i
n
t
]
Bin quantity (pieces per bin)
If an empty string is transferred as a value,
100 pieces per bin is used as the default.
M
a
t
e
r
i
a
l
S
c
a
n
C
o
d
e
s
[
n
v
a
r
c
h
a
r
]
(
3
2
)
Material-Barcodes
All the barcodes valid for this material must
be specified.
Multiple entries must be separated by a
semicolon (
;
) and the field must be enclo-
sed by double quotation marks (
"
).
Example:
M
a
t
e
r
i
a
l
n
a
m
e
;
M
a
t
e
r
i
a
l
s
c
a
n
c
o
d
e
s
M
4
7
1
1
;
"
B
A
R
C
O
D
E
1
;
B
A
R
C
O
D
E
2
"
5.3.5 Finding a Material
1.
In the toolbar, click
Search
.
The
Find Material
window appears.
74
310.865.005 0318_AB
Summary of Contents for WERMA-StockSAVER
Page 1: ...Handbuch WERMA StockSAVER Version 1 0 03 2018 310 865 005 0318_AB ...
Page 159: ...Manual WERMA StockSAVER Version 1 0 03 2018 310 865 005 0318_AB ...
Page 314: ...Manuel WERMA StockSAVER Version 1 0 03 2018 310 865 005 0318_AB ...
Page 370: ...2 Cliquez sur Rechercher un pilote sur mon ordinateur Version 1 0 03 2018 57 ...
