Master Data Import

Top  Previous  Next

 

Pulldown-Menu: SYSCAD / SYSCAD-Config -> XLS-Import

 

 

Ribbon: SYSCAD 20XX -> Config -> XLS-Import

 

 


 

With this command, it is possible to import some article information from an ERP-System into SYSCAD. The import folder is in the master data folder under /DATEN/XLSIMEXPORT. You have to create this folder manually.

 

file dbart_out.xls - Import article data into SYSCAD:

 

 

Fieldname

Type

Length

Description

Example 1

Example 2

PROFIL

CHAR

12

Articlenumber

0815

0816

FOLGETEILE

CHAR

75

further articles, only for calculation. The actual article is excluded in the calculation.

 

 

PROFILTYP

CHAR

25

Denomination of the article

Profile 1

Accessory 1

IX

NUM 9.2

9

Statical value IX (cm4)

2.56

0

IY

NUM 8.2

8

Statical value IY (cm4)

1.67

0

EM

NUM

4

mechanical surface (mm)

20

0

EA

NUM

4

anodical surface (mm)

60

0

ZUBEHOER

J/N

1

is the article an accessory?

 

X

GEWICHT

NUM 8.2

8

Weight of the article (KG/m)

1.1

0

RAB_GRUPPE

NUM

2

discount group for calculation

10

20

EURO

NUM 12.4

12

Price in EURO per m / pcs.

7.78

1.34

LAGERL

NUM 7.2

7

Stocklength of the profile or stock unit of the accessory

6

100

BLOCK

CHAR

12

DWG for alternative insertion in the drawing (if empty, then PROFIL)

 

 

GESBR

NUM 7.2

7

Width of the article (mm)

20

 

GESHO

NUM 7.2

7

Width of the article (mm)

30

 

UWERT

NUM 7.2

7

U-Value of the profile

 

 

KATALOG

J/N

1

Is this article in the catalogue?

X

 

LAGER

J/N

1

Is this article in stock?

X

 

ISKDVERB

J/N

1

Is this article only available, if rolled by yourself?

 

 

SCHALE_I

CHAR

32

Articlenummer inner component

0817

 

SCHALE_A

CHAR

32

Articlenummer outer component

0818

 

THERMTR

CHAR

32

Articlenummer thermical component

0819,0820

 

 

If you need a XLS-File for your system, please send us an e-Mail.