Documentation
Back to website >

Datanorm import and export

Using the Datanorm module, you can import and output articles in Datanorm format 5.0, 4.0 and 3.0. You can access the program item via the quick-start bar and there via "Accessories".

Fundamentals

General information

Datanorm is a standardization of the data medium exchange between the specialist wholesaler and the commercial enterprise.

Originally developed for the installation trade of heating, sanitation and air conditioning, great efforts have been made in recent years to open up this standard for other areas as well. Datanorm data medium exchange is now also available in the automotive sector through to EDP wholesalers such as Maxdata.

Wholesale supports this effort to the extent possible. Essential prerequisites for dialog-based company organization is the provision and maintenance of an article master file, which is tailored to the needs of the individual business enterprise and includes current sales and purchase prices. This costly article maintenance cannot be carried out by the individual business enterprise at economically justifiable expense. For this reason, specialist wholesalers and various manufacturers offer this article maintenance in data medium exchange as part of their range of services. It must be ensured that all wholesalers handle the article maintenance service in the same data format so that the business can cooperate with all wholesalers of its choice.

This resulted in the need to define a binding standard for the data format of the article maintenance service, Datanorm.

The transfer of all data takes place with three different files with different file names, each adapted to the intended use. Each file must be output separately on a data carrier or in a folder on the CD.

If the data volume of a file exceeds the capacity of the medium, additional media with the same name are output.

Datanorm versions

EULANDA® directly supports the Datanorm format 5.0. The older formats 3.0 and 4.0 are "up-converted" internally to the format 5.0 via an emulation. Field elements and mechanisms that do not exist in Datanorm5.0 are omitted.

Filenames

Datanorm files have the following file names:

  • Files with the name Datanorm.xxx for transferring article records for new creation or modification. The file extension xxx stands here for a number from 001 to 999.
  • Files named Datanorm.RAB for transferring discount groups with the corresponding discounts.
  • Files with the name Datanorm.WRG for transferring material groups.
  • Files with the name Datpreis.xxx to transfer price changes. The file extension xxx stands here for a number from 001 to 999.
  • Files with the name Datasets.xxx for transferring service records or bills of material. The file extension xxx stands for a number from 001 to 999.

Datanorm.001 to Datanorm.999

Files with the name Datanorm.xxx are usually used to create new datasets. Data stocks with article numbers, texts, units of measure, discount groups, main product groups as well as matchcodes, alternative article numbers, catalogue pages, copper codes and weights as well as EAN numbers (Euro article numbers) can be transferred to the user. Datanorm's data structure is designed so that articles with a minimum description can be used in the same way as comfortable texts (long texts).

All the fields transferred above can also be changed or deleted using the file named"Datanorm". Since the same record structure is used in the file for new creation or changes, only distinguished by processing flags, it is possible to mix new installations, changes and other processing types.

Datanorm.RAB

For organizational reasons, discounts are stored in a separate file. These floppy disks are usually identified separately by the data creator (wholesaler/manufacturer) and usually provided with the user name.

Datanorm.WRG

For organizational reasons, main merchandise categories are stored in a separate file. These floppy disks are usually identified separately by the data creator (wholesaler/manufacturer) and usually provided with the user name.

Datapreis.001 to Datapreis.999

In addition to the data medium exchange in the above form, various data creators offer a different form of pricing. Pricing is not based on discount groups and corresponding discounts, but on different procedures. In general price maintenance, each article can be displayed with up to 3 different discounts or - depending on the indicator - as net price. Within a file, both gross prices with discount and net prices can be transferred for articles.

If both gross and net prices are to be transferred for the same articles, this can be done by separate media, a medium with gross prices and a medium with net prices. When transferring within a file, the gross price must be turned off first and then the net price. Customer-specific price maintenance with pendulum disks is a special feature. This form of price maintenance is only used by a few wholesalers, such as the Cordes & Gräfe Group. The user must create a pendulum diskette after creating the articles. All articles for which prices are required by the wholesaler are stored in a file and the file is sent to the wholesaler on the pendulum diskette. The wholesaler reads this file, adds the latest prices and discounts and sends it back to the user. Both data medium exchange types are processed in a file called Datpreis.xxx. The user must always save his customer number on the pendulum diskette.

Datasets.001 to Datasets.999

Services (sets) are transferred with this file. Here there is a multi-layered application possibility for parts lists and the like.

Datanorm Import

Importing

The Datanorm module is accessed via the quick start bar and the "Accessories" item.

Reading Datanorm data

Note: All data imported via Datanorm must be in EUR. The imported values are therefore included 1:1 in the article master without conversion.

All suppliers (=vendors) created are available for selection in the Datanorm module. Select the data provider. If you have not yet defined a vendor in the address master, you can create the vendor in address management and activate it as a vendor in the pull-down menu.

Note: If you have previously worked with the DOS program EURO and converted the articles from the EURO into EULANDA®, articles imported from there are always considered "Own articles". If articles are imported via Datanorm, they are nevertheless added to the article number if the article number is identical, by clearly adding a number to the article number;"4711" then becomes"4711 (2)". If you do not want this, there is a script in the user forum that merges these (2) articles with the normal articles.

The current copper DEL value can be entered via the "CU" field. The value is entered in the master currency, usually in EUR per kg of copper. As of April 6, 2018, for example, this value was EUR 5.55. On the website of Westmetall the daily value can be read as DEL. note in EURO per 100 kg under the URL www.westmetall.com/TAEGL.HTM If a"0.0" is entered as the CU value, no copper surcharges are determined during import.

The calculated copper surcharge is only added to the EK and VK if this is greater than the copper value already included in the data record. Correspondingly, the complete copper weight is included in the calculation for fetch prices.

The option "Set characteristic on import" creates a characteristic for the vendor in the characteristic tree of article management and sets the identifier for all vendor articles. This function should not be used for large numbers (>200,000) of articles, as it requires a lot of RAM.

The"Process images" option can be used to determine whether any existing images are also to be imported during the Datanorm import.

Note: If a lot of data has been imported, the log file grows very quickly. In this case, you should restart the program and select the "Shrink database" function from the start menu.

In the left section"Progress", an estimated date of completion is given. For many articles, the import times towards the end of the import process will take considerably longer than at the beginning, especially if the working memory was selected too small. If 500,000 or more articles are read in here, the working memory on the SQL server should be expanded to 1GB and more. With SQL technology data is not only accessed via a few search terms, but via any field. That's why memory is so important here!

Setting Characteristics Subsequently

Set characteristic

You can also set the characteristics later via the main menu. The set characteristic allows the data selection of articles for the selected vendor during a later article search.

Select Datanorm file

After you have selected a supplier, start the Datanorm transfer using the arrow symbol in the toolbar or the key combination Ctrl+E. Select the folder from which the Datanorm files are to be imported.

If no supplier can be selected it must first be created in the address management and activated as supplier in the action menu.

You will be asked for the location of the data in a file selection box. EULANDA® automatically reads all Datanorm files in the selected folder. The program uses the following sequence:

Datanorm.RAB
Datanorm.WRG
Datanorm.001

by

Datanorm.999
Price.001

by

Dateprice.999

If the manufacturer of the Datanorm files uses different file names, it is not guaranteed that the file can be read.

EULANDA® processes data records with the identifier new creation and change equally. Existing articles are always updated, non-existing articles are created.

During the import, the currently processed Datanorm file is displayed. The progress bar shows the total processing as a percentage.

Discount group

If your Datanorm supplier provides discount group data, these are processed automatically. Due to the above-mentioned sorting, discount groups are read in first and are already taken into account in the current import. If the vendor does not make discount groups available on data carriers, you can create them on the "Discount groups" tab below.

Add discount groups

New discount groups can be inserted at the end of this table list. The new line is marked with an asterisk at the far left in the grey area. You can save the discount rate with the tick symbol using the Data navigator. A discount group is deleted with the minus symbol.

Recalculate price

Recalculate prices

Using the haput menu, you can recalculate the purchase prices at any time, even after manual changes to discounts.

Product group

The product groups of the Datanorm supplier can be read in via data carriers or entered manually on the "Product groups" tab below. EULANDA® supports only main product groups.

Change material group

New product groups can be inserted at the end of this table list. The new line is marked with an asterisk at the far left in the grey area. You can use the Data Navigator to save new product groups with the tick symbol. A merchandise category is deleted with the minus symbol.

Stat

This view gives you an overview of the number of articles for your vendor. The number of discount and merchandise categories used is also displayed. The discount groups also differentiate how many different discount rates exist. Often suppliers have 2000 or more discount groups, but only 50 different discount rates.

View statistics

The statistics are recalculated and displayed via the "Update" button. The process can take about one minute.

Procedure of the Datanorm import

EULANDA® additionally stores the original data of the supplier article in a separate table for each imported article. This makes it possible to freely change the article number in the article master without having to do without later price and article maintenance.

If an article from another supplier already exists, EULANDA® increases the article number to e.g. "KA-123 (2)". Collisions are thus excluded.

The supplier's discount groups are also stored in a separate table under his supplier ID. This means that you are always free of the groups of your suppliers when choosing your discount groups. The same applies to the product groups.

Extended article information system

The article information system always displays the sources of supply for the selected article. You can see at any time which original item number, prices or discount groups the vendor's item has, regardless of the information you want to use in your item master.

Number of suppliers

Datanorm Export

Exporting

You can save your articles in the Datanorm format in a variety of ways. In Windows® 10, you can save the data directly to a connected CD or DVD burner. Alternatively, it is possible to save the data via FTP protocol on a web server or to send the Datanorm files as e-mail. When sending e-mails, you also have the option of compressing them into ZIP format beforehand.

Datanorm Export

Readme

Create a readme file that you can output with the Datanorm set.

readme file

Copyright

By default, the output date is initialized to the current date. Datanorm allows you to add a copyright entry with the content of the output record. You can use the abbreviation to output a short and meaningful description so that the data recipient can assign the data uniquely.

copyright

Street address

Use the "Address" tab to enter your own address. This is inserted into the Datanorm file preprocessing record.

street address

News story

You use the characteristic tree to determine which articles you want to output in Datanorm format.

Select an article

Rates

Use this tab to determine how the price for Datanorm articles is determined. The purchase price is your selling price, i.e. the purchase price for your customer.

The default value is that this is formed from your sales order. The option "Gross profit -discount" forms a levy EK, which lies between your EK and Vk. Since the gross profit is used as a basis here, you cannot fall below the Ek.

If you have divided your customers into customer groups and your articles into discount groups and linked them, this discount can be used to calculate an EC tax. Alternatively, the option "Ek as discount in discount file" can be used. Although your sales price is transmitted as the issue price, an individual discount file with the corresponding discounts is output in a separate file for the specified customer group.

The option "Customer-specific prices" refers to an individual customer to be specified. The automatic price calculation is used here, as it is also carried out in order entry. This means that discount groups, customer groups, price lists and conditions are taken into account.

You can also transfer a sales order. If you want the data receiver to receive a Vk in addition to its Ek, two so-called A records are transmitted. The first with the option "New creation" and the second with the option "Change". An exception is the specification of the discount file. In this case, the sales price is transferred normally and the purchase price is specified as the discount value.

adjust prices

Caliber

With EULANDA® you can output Datanorm formats 5 and 4. In version 5 it is additionally possible to output images. Various image formats are supported.

Choose format

Car dispatch

Car shipping is a very powerful option. In conjunction with the e-mail output, you can send each customer an individual Datanorm file with their prices. Of course, auto dispatch is also possible with the other output options, but then the output is stopped until a manual release. You can burn a CD for a customer while the program waits for completion and then release the next CD to burn.

Prepare car shipping