Imports - Revision history

Anw: Added more examples of decodes.

2025-08-21T08:02:20Z

Added more examples of decodes.

@@ Line 156: / Line 156: @@
 ** ''Target Value'': The LogiNext Delivery Type
-Typically, these will be mentioned in the documentation of the specific screens, interfaces or processes as to which decodes are required for certain bespoke functionality to operate as required, and are not listed in this guide.
+Typically, these will be mentioned in the documentation of the specific screens, interfaces or processes as to which decodes are required for certain bespoke functionality to operate as required, and are not listed in this guide. Some other brief examples are:
@@ Line 166: / Line 178: @@
 * A unique name.
 * A type, provided in a drop-down list.
-You can save using the Save button and delete the decode table with the Delete button.
+You can save using the '''Save''' button and delete the decode table with the '''Delete''' button.
 When a decode table is selected, the decodes are shown in the lower table. You can edit existing decodes or add new ones with the '''Add''' button in this section.

Anw: ER047-005 - 528318 - Added LogiNext information

2025-07-08T11:58:50Z

ER047-005 - 528318 - Added LogiNext information

@@ Line 139: / Line 139: @@
 Decodes are tables of cross-reference data that you can use to convert import values to system values, to account for differences in import data formats.
 For example, you have a delivery type STANDARD. All external data import files provide the data, but one field says "STD" instead of "STANDARD". You could create an import decode to change "STD" to "STANDARD" and reference the decode table here.
 You create decodes in the Decode import tab.

Anw: Added searchable tables

2024-07-24T08:22:14Z

Added searchable tables

← Older revision		Revision as of 10:22, 24 July 2024
Line 216:		Line 216:
	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:		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:

	{\| class="wikitable" cellpadding="10" cellspacing="0" border="1" width="80%"		{\| class="wikitable apt-searchable" cellpadding="10" cellspacing="0" border="1" width="80%" id="imports"
	\|- bgcolor="silver"		\|- bgcolor="silver"
	!Import!!Description		!Import!!Description
Line 380:		Line 380:
	== Further Configuration ==		== Further Configuration ==
	The following System Parameters affect this functionality:		The following System Parameters affect this functionality:
	{\| class="wikitable" border="1"		{\| class="wikitable apt-searchable" border="1" id="importsparams"
	\|- bgcolor="silver"		\|- bgcolor="silver"
	!Parameter !! Description !! Level		!Parameter !! Description !! Level

Anw: Added BOOKING

2024-06-10T11:31:08Z

Added BOOKING

← Older revision		Revision as of 13:31, 10 June 2024
Line 232:		Line 232:
	\|BAX_ROUTE\|\|		\|BAX_ROUTE\|\|
	\|-		\|-
	\|[[Imports_Details#BOOKING\|BOOKING]] \|\|This import allows users to upload [[~~Orders~~]] into C-TMS		\|[[Imports_Details#BOOKING\|BOOKING]] \|\|This import allows users to upload [[Bookings]] into C-TMS. This import allows 3 different types: BOOKING, BOOKINGS_ASN and BOOKINGS_MDD.
	~~<!-- \|-~~
	\|BOOKINGS_ASN \|\|
	\|-
	\|BOOKINGS_MDD ~~\|\| -->~~
	\|-		\|-
	\|[[Imports_Details#CARRIER\|CARRIER]]\|\|This import allows you to upload [[RESOURCE#Carriers\|Carriers]] into C-TMS. This allows for addition, modification or deletion of carriers.		\|[[Imports_Details#CARRIER\|CARRIER]]\|\|This import allows you to upload [[RESOURCE#Carriers\|Carriers]] into C-TMS. This allows for addition, modification or deletion of carriers.

Anw: Added BOOKING

2024-06-10T10:00:51Z

Added BOOKING

← Older revision		Revision as of 12:00, 10 June 2024
Line 232:		Line 232:
	\|BAX_ROUTE\|\|		\|BAX_ROUTE\|\|
	\|-		\|-
	\|BOOKING \|\|This import allows users to upload [[Orders]] into C-TMS		\|[[Imports_Details#BOOKING\|BOOKING]] \|\|This import allows users to upload [[Orders]] into C-TMS
	<!-- \|-		<!-- \|-
	\|BOOKINGS_ASN \|\|		\|BOOKINGS_ASN \|\|

Anw: Merged from training document

2024-06-10T09:45:32Z

Merged from training document

← Older revision		Revision as of 11:45, 10 June 2024
Line 187:		Line 187:

	<center>[[Image:imp_4c.jpg]]</center>		<center>[[Image:imp_4c.jpg]]</center>
	.
	<center>[[Image:imp_4d.jpg]]</center>		<center>[[Image:imp_4d.jpg]]</center>

Line 202:		Line 202:

	If there is no decode or formula, then the data you attempt to upload ''must'' abide by the stated restrictions, otherwise the system will reject the data.		If there is no decode or formula, then the data you attempt to upload ''must'' abide by the stated restrictions, otherwise the system will reject the data.


			To preserve database integrity and prevent duplicate data being imported, every CSV file has a unique numeric identifier, not visible to the user. This is called the "checksum value".

			The system will prevent a file import if the content is identical to a previously uploaded file. For example, if an import is executed and completes ok, then the exact same file is attempted to be uploaded, with which the content remains unchanged from the first import, the following error message is displayed:

			<center>[[Image:imp_checksum.jpg]]</center>

			In this instance the data will already have been uploaded onto the system.

Anw: Added system parameters affecting the screen

2024-06-07T07:21:40Z

Added system parameters affecting the screen

@@ Line 370: / Line 370: @@
 |-
 |ZONE_CHGS||This import allows users to upload Location Zone Surcharges into C-TMS.
 |}

Anw: Added access control

2024-06-04T10:53:56Z

Added access control

@@ Line 3: / Line 3: @@
 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.
@@ Line 146: / Line 165: @@
 === Execution ===
 <center>[[Image:imp_2.jpg]]</center>
 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:

Anw: Added cross-reference to associated imports

2024-06-04T09:10:13Z

Added cross-reference to associated imports

← Older revision		Revision as of 11:10, 4 June 2024
Line 141:		Line 141:

	{{Note}} You can use the import process itself to import decode tables, by creating an import of import type "DECODE".		{{Note}} You can use the import process itself to import decode tables, by creating an import of import type "DECODE".
			* [[Imports_Details#DECODE\|DECODE]]

Anw: Added (and commented out) bookings for ASN and MDD and LOAD - may not be valid.

2024-06-04T08:41:19Z

Added (and commented out) bookings for ASN and MDD and LOAD - may not be valid.

← Older revision		Revision as of 10:41, 4 June 2024
Line 201:		Line 201:
	\|BAX_ROUTE\|\|		\|BAX_ROUTE\|\|
	\|-		\|-
	\|BOOKING		\|BOOKING \|\|This import allows users to upload [[Orders]] into C-TMS
	\|This import allows users to upload [[Orders]] into C-TMS		<!-- \|-
			\|BOOKINGS_ASN \|\|
			\|-
			\|BOOKINGS_MDD \|\| -->
	\|-		\|-
	\|[[Imports_Details#CARRIER\|CARRIER]]\|\|This import allows you to upload [[RESOURCE#Carriers\|Carriers]] into C-TMS. This allows for addition, modification or deletion of carriers.		\|[[Imports_Details#CARRIER\|CARRIER]]\|\|This import allows you to upload [[RESOURCE#Carriers\|Carriers]] into C-TMS. This allows for addition, modification or deletion of carriers.
Line 266:		Line 269:
	\|[[Imports_Details#INVOICE_RQTS\|INVOICE_RQTS]]\|\|This import allows users to upload [[ACC_MAINT#Invoice Requirements\|Invoice Requirements]] into C-TMS. This import allows for addition, modification or deletion of account invoice requirements data.		\|[[Imports_Details#INVOICE_RQTS\|INVOICE_RQTS]]\|\|This import allows users to upload [[ACC_MAINT#Invoice Requirements\|Invoice Requirements]] into C-TMS. This import allows for addition, modification or deletion of account invoice requirements data.
	\|-		\|-
	\|LANE		\|LANE \|\|This import allows users to upload Lanes into C-TMS
	\|This import allows users to upload Lanes into C-TMS		<!-- \|-
			\|LOAD \|\| Bespoke BWSC import process. -->
	\|-		\|-
	\|[[Imports_Details#LOCATION\|LOCATION]]\|\|This import allows users to upload [[Locations]] into C-TMS. This import allows addition ONLY of locations, constraints, contacts, references and trailer types.		\|[[Imports_Details#LOCATION\|LOCATION]]\|\|This import allows users to upload [[Locations]] into C-TMS. This import allows addition ONLY of locations, constraints, contacts, references and trailer types.

← Older revision		Revision as of 12:00, 10 June 2024
Line 232:		Line 232:
	\|BAX_ROUTE\|\|		\|BAX_ROUTE\|\|
	\|-		\|-
	\|BOOKING \|\|This import allows users to upload [[Orders]] into C-TMS		\|[[Imports_Details#BOOKING\|BOOKING]] \|\|This import allows users to upload [[Orders]] into C-TMS
	<!-- \|-		<!-- \|-
	\|BOOKINGS_ASN \|\|		\|BOOKINGS_ASN \|\|