Support for eserp 1.5 has been discontinued as of 01.01.2024, the online help will no longer be updated Materials catalog interface
The esmaterial materials interface has the task of importing vendor data (items, product groups, discount groups, prices, texts, etc.) into the eserp materials catalogs.
External programs | Other ES programs | Materials catalog interface authorization is required to open / use the materials catalog interface.
External programs | Other ES programs | Import materials catalogs authorization is required to import materials catalogs.
The following formats can be imported:
| Format | Version(s) supported | Comment |
|---|---|---|
| DATANORM - Create new - Edit - Discount groups - Product groups - Prices (DatPrice) |
Datanorm 3.0 Datanorm 4.0 Datanorm 5.0 |
Import to a materials catalog Transfer into the item master data is possible from there. Also see Datanorm |
| ELDANORM |
Version 01/96 |
Import to a materials catalog. Transfer into the item master data is possible from there. |
| ZVEH-NORM |
Version 01/96 |
Service line items in ZVEHNORM format are saved directly (as cascade parents) in the eserp item master data. Also see ZVEH |
|
Ziemer service catalogs |
These are basically item set data sets in DATANORM 4.0 format (including a service description). Also see SCC-CALC / Elektro Ziemer Datanorm files Contain the item number and service description of the Ziemer service item. Dataset files Contain the item numbers of the Ziemer service items and the associated item numbers of the electrical vendor, So-called CASCADES are formed in eserp using this association. |
|
| dBase / Excel |
Import of dBase databases and Excel tables into a materials catalog. Transfer into the item master data is possible from there. Manual assignment of source and target fields, field assignments can be saved. Also see |
Tab
Various tabs are provided in the esmaterial window which are used according to the format of the items to be imported.
'Settings' tab
The materials catalogs (sets) for importing the item data are created on this tab. Options for importing are also set here.
Options
Create which new items?
These options are used to determine whether all items or only items in a certain product group are to be imported.
If you have activated the Only import items in the entered product groups option, you must first create the product groups on the Product group tab or import them from a Datanorm product group file.
ANSI file format
Activate this option if the files to be imported are in ANSI format. This option should not be activated for ASCII format files.
Some vendors supply files in ASCII format (accented characters, etc. represented by special characters). Others use the ANSI format (accented characters not substituted). If the vendor has not indicated the type of file, check the file structure using a text editor.
If the accented characters are shown correctly, activate the ANSI file format option before importing the items using the materials interface.
If the accented characters appear as "hieroglyphics" in the text editor, please DO NOT activate the ANSI file format option.
Currency
Select the Currency that the prices in the files are to be imported in. If the selected currency does not match the currency of the items / prices to be imported, a corresponding message will be displayed when the items are imported.
Fill out SalesPrice1 field
The Fill out SalesPrice1 field option determines whether the gross price (taking the currency into account) is to be used to fill out the Sales price 1 on import.
Datanorm - no conversion / DATPREIS - net price only
If DATANORM DATPREIS files are imported (price changes) you can include the gross and net prices or only the net prices. All other fields are disregarded. The DATANORM - no conversion and DATPREIS - net price only options are provided on the Settings tab for this purpose.
'Product groups' tab
If you do not want to import a complete catalog, you can create product groups of a vendor on the Product groups tab.
This process can also be automated if the vendor has also supplied a DATANORM.WRG file
Open the corresponding product group file (file name extension *.WRG) and then select Prod. grp in the toolbar or in the Import | Import product groups menu.
Create a SET (catalog) before you import the product group file.
'Discount groups' tab
You can select discount groups recorded against vendors in eserp or create new discount groups on the Discount groups tab.
This can also be automated using a DATANORM.RAB file if available.
Open the corresponding discount group file (file name extension *.RAB) and then select Disc. grp in the toolbar or in the Import | Import discount groups menu.
'Long texts' tab
Long texts for the materials catalog (set) / vendor selected on the Settings tab can be imported in Datanorm or Eldanorm format on this tab.
'dBase / Excel' tab
The assignments necessary for importing dBase databases and Excel tables can be made on this tab.
Also see
'ZVEH' tab
The settings for importing items / services data in ZVEH format are specified on this tab.
Also see ZVEH
'Log' tab
A log is created when item data is imported. This log can be saved and used for error analysis if an error occurs.
'Sets' tab
Specify the relevant settings for importing Ziemer service catalogs here.
Also see SCC-CALC / Elektro Ziemer