HansaManuals Home   >> Standard ERP   >> Items and Pricing   >> Exports  

Previous   Next               Entire Chapter in Printable Form               Search  

This text refers to program version 8.5  

Items Data

This page describes the 'Items Data' Export function in the Integration module.

---

You can use the 'Items Data' Export function in the Integration module to export Item information from your database. This is a practical tool for when you want to create a new Company or database that will need this information.

This function creates a file with the correct format to be imported into another Standard ERP Company or database. The file will contain separate sections for each register or setting that you choose to export. You can produce an Export/Import Format report in the Technics module if you need to see the format (field order) that will be used in each section. To produce this report for a single register or setting, enter one of the following values in the Vc (View Code) field (and select the Include Blocks option for the settings marked with *):

Register/Setting	Vc (View Code)
Barcodes	BarcodeVc
Base Price Changes	BPCVc
Batch Specifications	BatchTextVc
Commodity Codes	CommodityVc
Default Items	CompItemVc
Discount Matrices	RebVc
Item Classifications	DIVc
Item Formulae	CPMVc
Item Groups	ITVc
Item Varieties	VARVc
Item Variety Groups	VARGVc
Items	INVc
Locations	LocationVc
Minimum Stock Levels	MinPerLocVc
Price Formulae	PFormVc
Price Lists	PLDefVc
Prices	PLVc
Purchase Items	PIVc
Quantity Dependent Discounts	StaffVc
Quantity Dependent Prices	PLQVc
Recipes	RecVc
Units	UnitVc
Variety Sets	VARMasksVc
Variety Subsets	VARSubsetsVc
Weighted Average	WeigAvVc
Item Settings	ItemSettingBlock*
Item Status Settings	ItemStatusSetBlock*
Structured Items	StructPrintBlock*
Variety Masks	VARMaskBlock*
Variety Settings	VarietyBlock*

Please refer to the Exporting Settings and Registers - Index page for a list of the Export functions that you can use to export information from other settings and registers.

To use the 'Items Data' Export function, you must log in as a Global User or Person whose Access Group explicitly grants full access to the Integration module. Ensure you are in the Integration module and open the 'Exports' list by clicking the [Routines] button in the Navigation Centre and the [Exports] button in the subsequent 'Routines' window. Then double-click 'Items Data' in the 'Export' list to open the 'Specify Items Data' window.

File Comment

Enter a short comment describing the contents of the export file (up to 40 characters are permitted). If you try to import the resulting file to another Company or database using the 'Automatic' import function in the System module, this description will be shown in the list of importable files.

Check boxes

Check one or more boxes to specify the registers and/or settings from where records are to be exported.

Confirm by clicking the [Run] button, or cancel using the close box. After clicking [Run], a dialogue box will open, where you can name the export file and specify where it is to be saved.

Enter a name for the file, and click [Save] or press the Enter key. If you are exporting with the intention of importing the information into another Standard ERP database or Company using the 'Automatic' and 'Manual file search' Import routines, do not name the file with two leading minus signs/hyphens (e.g. --Data.txt). Information will not be imported from files named in this way.

A message window informs you about the progress of the export process. You can interrupt the process at any time by pressing Esc (Windows) or ⌘-Full Stop (macOS).

---

Go back to:

• Home page for Export functions concerned with Items and Pricing
  

• Home page for Items and Pricing manual
  

• Home page for Standard ERP manual

Previous   Next   Top            Entire Chapter in Printable Form