Imports
The C-TMS Flat File Import functionality allows for data to be loaded into the system without the need for a formal electronic interface. The import mechanism allows a file from a users PC to be uploaded to the server and from there it can be loaded into the database.
There is a predefined set of import types which have been configured along with the fields which can be included in each import. It is possible to configure these imports to suit individual requirements, for example, on an Order import it is possible to pass in the id for an existing location or it is possible to pass in the name and address for a new location (only the first 2 parts of a postcode are required for a new location to be created) with relevant information such as loading rates automatically being copied from existing locations to their orders. Certain imports also have the concept of a record type allowing 2 types of information to be included in one import such as orders and order lines. Order details can be contained on one line and then one or many orders lines can be included in subsequent lines.
Access to maintain and execute the imports is subject to access control.
When an import is executed the file must be on the server, the system allows the user to upload the file onto the server if it is not already there.
Import Processing
There are a number of imports that are currently configured including Orders., Bookings, Slots and Receipts.
While processing the file C-TMS will attempt to process each line individually, upon completion it will report back to the user the number of lines that were processed successfully and the number that failed. Results and failures files (.res and .fail) are produced and can be viewed on the server to see what happened during the import. Upon completion a record will also be written to an audit table, detailing when the import was run, who ran it, the number of records processed successfully and the number that failed. If the Import was for orders it will also contain a comma separated string of all the orders that were created.
With regard to the Orders imports it is very important to prevent a file from being processed more than once. C-TMS will perform a check to ensure that the same file cannot be loaded twice, this is achieved using the checksum functionality on the server, if a user attempts to load a file that has already been processed it will be rejected. C-TMS also performs checks to ensure that the order being processed is not already in the system, the check is made based on the key fields of an order.
User Interface
There are 2 screens in C-TMS for imports, one for maintenance and the other for execution as follows:
Maintenance
Execution
File Upload
To upload a file onto the server for importing you will need to either accept the default file location for the type of import you are performing or use the 'browse' button to select a file to upload from your PC or a network location that you have access to
Once the file is found and selected you should click the 'Open' Button. This will then prompt you to confirm you wish to upload the file onto the system's server:
If you click on 'Yes' the file will be uploaded onto the server, depending on the import file's size you may be presented with an hour glass whilst the upload occurs. When the upload is complete you will be asked if you wish to proceed with the import:
If you click 'Yes' you will then be presented with a confirmation message advising what has happened during the import:
If errors occur during the import as above you will notice the 'Show Results File' button has become active you will be able to click on this to see why the data was rejected:
.
Currently Available Imports
A variety of imports are available in the C-TMS system, and bespoke imports are developed when required by the business. A current list of the imports available are described below:
| Import | Description |
|---|---|
| ACCOUNT | This import allows users to upload Accounts into C-TMS |
| ACC_SERVICES | This import allows users to upload Services into C-TMS |
| ACC_SRV_RTS | This import allows users to upload Account Service Requirements into C-TMS |
| ASSETS | This import allows users to upload permanent assets into C-TMS |
| BAX_DEL_TYPE | |
| BAX_ROUTE | |
| BOOKING | This import allows users to upload Orders into C-TMS |
| CARRIER | This import allows you to upload Carriers into C-TMS |
| CARRIER_LANE | This import allows users to upload Carrier Lanes into C-TMS |
| CONTRACT | This import allows users to upload Contracts into C-TMS |
| CURR_USAGE | This import allows users to upload Account Currency Usage records into C-TMS |
| CUSTOMER | This import allows you to upload Customers into C-TMS |
| CUST_FLEET | This import allows users to upload Customer Fleets into C-TMS. Note that this is specific to Fleet Maintenance users (Bespoke) |
| DEBRIEF | This import allows users to upload basic debrief information against a location on a trip into C-TMS. This includes signatory and arrival/departure date/time, and sets the orders at that location to POD confirmed. |
| DECODE | This import allows users to upload Import/Export Decodes into C-TMS |
| DEL_SCHEDULE | This import allows users to upload into C-TMS |
| DRIVERS | This import allows users to be uploaded Drivers into C-TMS. This allows for addition, modification or deletion of basic driver details. |
| DRIVER_SHIFT | This import allows users to allocate Drivers to Shift Patterns into C-TMS. This allows for Addition, modification or deletion of driver shift patterns. |
| DU_TYPE | This import allows users to upload Despatch Unit Types|Despatch Unit Types into C-TMS |
| FIXED_ROUTE | This import allows users to upload Fixed Routes into C-TMS |
| GAZ_DHL_ESD | This import allows users to upload Carrier Gazetteers into C-TMS |
| GAZ_MOVIANTO | This import allows users to upload Carrier Gazetteers into C-TMS |
| GAZ_POLARSP | This import allows users to upload Carrier Gazetteers into C-TMS |
| GAZ_UKMAIL | This import allows users to upload Carrier Gazetteers into C-TMS |
| GAZ_UKM_PO | This import allows users to upload Carrier Gazetteers into C-TMS |
| GAZ_UKM_SE | This import allows users to upload Carrier Gazetteers into C-TMS |
| GAZ_YODEL | This import allows users to upload Carrier Gazetteers into C-TMS |
| GAZ_YODEL_AC | This import allows users to upload Carrier Gazetteers into C-TMS |
| GAZ_YODEL_CF | This import allows users to upload Carrier Gazetteers into C-TMS |
| GAZ_YODEL_CY | This import allows users to upload Carrier Gazetteers into C-TMS |
| GAZ_YODEL_DE | This import allows users to upload Carrier Gazetteers into C-TMS |
| GAZ_YODEL_DP | This import allows users to upload Carrier Gazetteers into C-TMS |
| GAZ_YODEL_DS | This import allows users to upload Carrier Gazetteers into C-TMS |
| GAZ_YODEL_FE | This import allows users to upload Carrier Gazetteers into C-TMS |
| GAZ_YODEL_HA | This import allows users to upload Carrier Gazetteers into C-TMS |
| GAZ_YODEL_RE | This import allows users to upload Carrier Gazetteers into C-TMS |
| GAZ_YODEL_SE | This import allows users to upload Carrier Gazetteers into C-TMS |
| INVOICE_RQTS | This import allows users to upload Invoice Requirements into C-TMS |
| LANE | This import allows users to upload Lanes into C-TMS |
| LOCATION | This import allows users to upload Locations into C-TMS |
| LOC_PRD_FACT | This import allows users to upload location product factors into C-TMS |
| LOC_UPDATE | This import allows users to upload updated locations into C-TMS |
| LOC_ZONES | This import allows users to upload Location Zones into C-TMS |
| MILK_ROUND | |
| ORD_LINE_ITM | This import allows users to upload Orders into C-TMS |
| PARAGONXDOCK | |
| PAR_DEL_DATE | |
| PAR_TRIP_DTL | |
| PAR_XDOCKS | |
| PERSON | This import allows users to upload Drivers into C-TMS. This import allows for addition, modification or deletion of drivers details, carrier assignment and allowed vehicle types. |
| PORTAL | This import is used by portal when uploading Orders from Portal. |
| PROCESS_ITEM | |
| PROC_ITM_FIX | |
| PRODUCT | This import allows users to upload Product information into C-TMS |
| PROD_ITEMS | This import allows users to upload Product Items into C-TMS |
| RECEIPT | This import allows users to upload Receipts into C-TMS |
| REGION_DATA | This import allows users to upload Region mapping into C-TMS |
| REGION_DEPOT | This import allows users to upload Region assignments to Depot into C-TMS |
| RES_AVAIL | This import allows users to upload Resource Availability exceptions into C-TMS |
| SCHED_RULES | This import allows users to upload Schedule Rules into C-TMS |
| SCREENING | This import allows users to upload Customer Screening Charges into C-TMS. Note that this is bespoke functionality |
| SHIFT_PATT | This import allows users to upload Depot Shift Patterns into C-TMS. This import allows for addition, modification or deletion of shift patterns per depot. |
| SKU_ORDER | This import allows users to upload SKU’s into C-TMS |
| SLOT | This import allows users to upload Slot details into C-TMS |
| TEAMS | This import allows users to upload Teams into C-TMS. Note that this is bespoke to Sessions Collections processing only. |
| TI_ORDER | This import allows users to upload Orders into C-TMS |
| TRACTOR | This import allows users to upload Tractors into C-TMS. This import allows addition, modification or deletion of tractors. |
| TRAILER | This import allows users to upload Trailers into C-TMS. |
| TYRES | This import allows users to upload Tyres cross-reference data into C-TMS. Note that this is bespoke for Fleet Maintenance processes only. |
| VEHICLE | This import allows users to upload Vehicles into C-TMS. This import allows addition, modification or deletion of fixed vehicles (linked tractor and trailer) and the carriers to which they are assigned. |
| VOLUMETRICS | This import allows users to upload Product Vehicle volumes data into C-TMS. |
| WMS_PRODUCT | This import allows users to upload WMS Product cross-reference data into C-TMS. Note that this is bespoke and used for Brexit export processes only. |
| XDOCK_PATH | This import allows users to upload XDock_Paths into C-TMS. |
| ZONE_CHGS | This import allows users to upload Location Zone Surcharges into C-TMS. |
