HomeProductsSupportInfoDownloadsBuyContact
Home : Support : Knowledge Base : Article 0016
Knowledge Base    

Youmehub v2.x
Youmehub v3.x

 

Importing postcode data

Postcode address lists can be an invaluable tool for creating and maintaining accurate databases, helping you to reduce time typing the full address, the number of returned or undelivered items and sharpen your customer profiling. Youmehub allows you to import postcode address files obtained form your postal office in a variety of formats such as tab or comma separated text files. Once imported you can perform address lookups for any address records by clicking on the search icon in the postcode field.

1. Choose Youmehub > Youmehub Preferences or click the preferences button in the menu bar.
2. Select the CRM tab and then the Postcode tab.
3. Click the import button above the postcode list.
4. Locate your postcode data file and select open.
5. In the Import Field Mapping window match the source field names with the target field names.
6. Click import.

Note: Field names used in Youmehub conform to the UK Royal Mail PAF data file conventions. However, if you are importing postcode data from another source which uses a different field naming convention, you will need to refer to the field definitions list below. Fields marked ‘no’ are not used used by Youmehub.

Field name
Field definitions
Used in Youmehub
ORD
Department
Yes
ORG
Organisation
Yes
SBN
Sub-building Name
Yes
BNA
Building Name
Yes
POB
PO Box
Yes
NUM
Number
Yes
DST
Dependent Street
Yes
STR
Main or only Street
Yes
DDL
Double-dependent Locality
Yes
DLO
Dependent Locality
No
TWN
Post Town
Yes
PCD
Postcode
Yes
CTA
Country - Administrative
Yes
CTP
Country - Postal
Yes
CTT
Country - Traditonal
Yes
SCD
Sortcode
No
CAT
User category
No
NDP
Delivery Points
No
DPS
Delivery Points Suffix
No
URN
Unique Delivery Point Reference Numbber (UDPRN)
No
GRE
Grid Eastings
No
GRN
Grid Northings
No
WCD
Local Authorirty Ward Code
No
WNW
Local Authorirty Ward Name
No
WNA
Local/Unitary Authority Name
No
NHS
NHS Health Authority Code
No
NNH
NHS Health Authority Name
No
PCG
Primary Care Trust/LHB Code
No
PNH
Primary Care Trust Strategic HA
No
PNP
Primary Care Trust Name
No

 

Article ID: 0016
Category: Preferences & Settings
Products:
Youmehub (Single-User Mac)
Youmehub (Single-User Win)
Youmehub (Multi-User Standard)

Date Created: Dec 12, 2007
Date Modified: Dec 12, 2007

©2010 Youmeus Design Ltd | Refund Policy | Privacy Policy | Site Map