Record Level Format
Quick Start
Maps
Creating a Map
Using the Map Wizard
Publishing a Map
Deleting a Map
The Map Screen
Reading the map
Shading
Visible Area
Style
Borders
Labels
Background
Colours
Data Sets
Uploading
Format
Summary Formats
Area
District
Sector
Record Level
Sharing
Deleting
Level Conversion
Mapping PayPal Data
Postcodes

The system can accept files that have rows with postcodes on them. Once they are uploaded they will need processing before they can be plotted. The following are examples of record level data files:

A row for each customer

The file contains a postcode amongst the address data of the customer, with the column name 'postcode'.

The numeric columns could be totals for the customer such as 'total sales' or 'total revenue' etc.

Enclose all columns with quotes ". This prevents commas within the columns corrupting the data.

You don't have to have any numeric columns. The system will just give you a count of your customers (rows) per area when aggregating it.

Do not have more than one column containing a postcode.

Here is an example of a file shown in a spreadsheet and in raw text.

A row for each customerA row for each customer
A row for each sale

The file contains a postcode amongst the despatch address data, with the column name 'postcode'.

The numeric columns could be 'order qty' or 'order value' etc.

Enclose all columns with quotes ". This prevents commas within the columns corrupting the data.

You don't have to have any numeric columns. The system will just give you a count of sales (rows) per area when aggregating it.

Do not have more than one column containing a postcode.

Here is an example of a file shown in a spreadsheet and in raw text.

A row for each saleA row for each sale
A row for each postcode

Whilst this is not exactly record level - the system handles it the same way.

The file contains a postcode with the column name 'postcode'.

The columns after the postcode should be the totals of various things within that postcode. These could be 'number of sales', 'total revenue' etc.

Enclose all columns with quotes ". This prevents commas within the columns corrupting the data.

Do not have more than one column containing a postcode.

You don't have to have a row for every postcode - just the ones you have data for.

Here is an example of a file shown in raw text and in a spreadsheet.

A row for each postcode