This section deals with general imports into the system, the spreadsheets provided here are designed for end customer completion whereby we will import them into the Vision database, generate scripts to complete the missing information and then import the data into the relevant data tables within Vision.

The document below and the pages are being moved directly into this wiki so when you see a page marked as “IMPORT - xxxxx“ the page may have been moved from the document onto the wiki

e.g. WMS Import Code Lists.

Each section, which is accessible from the list below could have several imports available.

Each page title shows a marker as to whether this import is important or not

Key Import this will be needed

Optional Import available if you have requested this during the data discussions.

Optional Imports but rarely used.

Alternative Import which could replace a Key Import

Import files can be provided as

CSV
Excel (some excel examples are held within the section pages which are linked on the right side of this section)

The key areas for data import are linked below :

Data Field Types

Throughtout all the pages you will see field / data types mentioned this is the reference list of those types and you can access through References Acronymns and an excert is shown below

WMS - Data Imports

Data Field Types