Selecting ingredients page

<< Click to Display Table of Contents >>

Navigation:  Exporting data > Export wizard > ASCII text export wizard >

Selecting ingredients page

The ASCII Text Import Wizard selecting ingredients page allows you to determine exactly what you wish to export to an ASCII text file.  The page will look like the one below.

 

asciitextexporting1

 

This page is divided into two main sections.  They are as follows:

 

Ingredient selection

Field selection

 

Ingredient selection

 

From this section you must decide which ingredients you wish to export.  You can choose from the following options:

 

All ingredients - will export all available ingredients from your database                or

A Single Category - will export all available ingredients assigned to a single category        or

A Single Supplier - will export all available ingredients assigned to a single supplier.

 

Choose the option you wish to export. If selecting a single supplier or category, use the drop lists to choose the category or supplier you wish to export.

 

Field selection

 

The field selection allows you to choose exactly which details you wish to export for the selected group of ingredients.

 

You can choose any or all of the following details for the ingredients from the 'Ingredient database fields' list box to be exported:

 

Name

Stock code

Product code

Purchase quantity

Purchase unit (name)

Purchase unit (symbol)

Usage unit (name)

Usage unit (symbol)

Purchase cost

Purchase unit cost

Usage unit cost

Supplier name

Category name

 

By clicking on one of the above fields you can move it to and from the 'Fields in destination file' list box.  

 

Adding a field

 

Adding a field to the 'Fields in destination file' list box will mean that this field will be exported to the ASCII text file.  

 

To add a single field, highlight the field in the 'Ingredient database fields' list box and click the wizardaddbutton button.  This will move the selected field into the 'Fields in destination file' list box.

 

To add all fields, click the wizardaddallbutton button.  All fields available will be moved to the 'Fields in destination file' list box.

 

Removing a field

 

Removing a field from the 'Fields in destination file' list box will mean that this field will not be exported to the ASCII text file.

 

To remove a single field, highlight the field in the 'Fields in destination file' list and click the wizardremovebutton button.  This will remove the selected field from the 'Fields in destination file' list box and place it back in the 'Ingredient database fields' list box.

 

To remove all fields, click the wizardremoveallbutton button.  All fields in the 'Fields in destination file' list box will be returned to the 'Ingredient database fields' list box.

 

It is also possible to move the names of the fields appearing in the 'Fields in destination file' list box up or down to suit your presentation requirements.  To do this, select the field and click on the wiardmoveupbutton or wizardmovedownbutton buttons.

 

In the example below we are exporting all ingredients, including names, purchase quantity, purchase cost, supplier name and category name. See the following image.

 

asciitextexporting2

 

 

Once you have selected the fields you require to be exported click the "Next" button.  This will take you to the Text format page.