Import Runs - Revision history

LMA at 10:28, 28 November 2025

2025-11-28T10:28:07Z

2025-11-25T13:29:38Z

2025-11-25T13:24:42Z

2025-11-17T14:22:58Z

2025-11-17T14:22:32Z

2025-11-17T14:17:48Z

2025-11-17T14:17:39Z

2025-08-22T11:02:21Z

2025-08-11T10:03:21Z

2025-03-05T15:02:22Z

‎Workorder Import

← Older revision		Revision as of 10:28, 28 November 2025
Line 1:		Line 1:
		+	= Naming Convention =
		+
		+	'''General file naming convention:'''
		+	All import Excel files must follow the pattern:
		+
		+	xxxx.<import-type>.xlsx
		+
		+	Where xxxx can be any project- or customer-specific identifier.
		+
		+	Supported import types:
		+
		+	* Equipment Import
		+	xxxx.equipment.xlsx
		+
		+	* Workorder Import
		+	xxxx.workorder.xlsx
		+
		+	* Progress Operation Import
		+	xxxx.progress-op.xlsx
		+
		+	* QRF Operation Import
		+	xxxx.qrf-op.xlsx
		+
		+	* Check Operation Import
		+	xxxx.check-op.xlsx
		+
		+	* Joint Operation Import
		+	xxxx.joint-op.xlsx
		+
		+	* Blinding Operation Import
		+	xxxx.blinding-op.xlsx
		+
		+	* Scheduling Import
		+	xxxx.scheduling.xlsx
		+
		+	* User Import
		+	xxxx.user.xlsx
		+
		+	* Company Import
		+	xxxx.company.xlsx
		+
		+	* Material Import
		+	xxxx.material.xlsx
		+
		+	* Preparation Document Import
		+	xxxx.preparation-document.xlsx
		+
		+	* Joint Location Import
		+	xxxx.joint-location.xlsx
		+
		+	* Blinding Location Import
		+	xxxx.blinding-location.xlsx
		+
		+
	= Equipment Import =		= Equipment Import =

@@ Line 309: / Line 309: @@
 * Inspected_Date  (TT/MM/JJJJ hh:mm)
 * Equipment  (Text)
 [[Category:MaTaP|Import Runs]]

← Older revision		Revision as of 13:24, 25 November 2025
Line 182:		Line 182:
	* JointLocation (Text)		* JointLocation (Text)

		+	= Blinding Operation Import =
		+
		+	To import Blinding Operations following columns are required:
		+	* OperationID (Text)
		+
		+	'''NOTE:''' “Number” and “NormalDuration” must be formatted as Number and all dates must be formatted as TT/MM/JJJJ hh:mm!
		+
		+	Columns that can be imported additionally:
		+	* Workorder (Text)
		+	* Operation (Text)
		+	* ShortText (Text)
		+	* Number (Number)
		+	* NormalDuration (Number)
		+	* NormalDurationUnit (Text)
		+	* Work (Number)
		+	* WorkUnit (Text)
		+	* Workcenter (Text)
		+	* ActivityCode (Text)
		+	* eStart (TT/MM/JJJJ hh:mm)
		+	* eFinish (TT/MM/JJJJ hh:mm)
		+	* lStart (TT/MM/JJJJ hh:mm)
		+	* lFinish (TT/MM/JJJJ hh:mm)
		+	* Company (Text)
		+	* CompanyCode (Text)
		+	* LongText (Text)
		+	* Comment (Text)
		+	* PermitCode (Text)
		+	* Planner (Text)
		+	* Suboperation (Text)
		+	* BlindingLocation (Text)
		+	* Type (Text)
		+	* BlindingPackage (Text)

	= Scheduling Import (for Operations)=		= Scheduling Import (for Operations)=

@@ Line 252: / Line 252: @@
 Columns that can be imported additionally:
 * FileName (Text)
 [[Category:MaTaP|Import Runs]]

@@ Line 1: / Line 1: @@
 = Equipment Import =
@@ Line 151: / Line 150: @@
 * Suboperation (Text)
@@ Line 222: / Line 252: @@
 Columns that can be imported additionally:
 * FileName (Text)
 [[Category:MaTaP|Import Runs]]

@@ Line 1: / Line 1: @@
 = Equipment Import =
@@ Line 118: / Line 119: @@
 * QRFDescription (Text)
@@ Line 286: / Line 223: @@
 * FileName (Text)
-= Blinding Location Import =
+[[Category:MaTaP|Import Runs]]
-−
-To import Blinding Locations following columns are required:
-* BlindingLocationID (Text)
-−
-Columns that can be imported additionally:
-* No
-−
-= Joint Location Import =
-−
-To import joint locations following columns are required:
-* Joint_ID (Text)
-−
-Columns that can be imported additionally:
-* No
-* Equipment
-* SOP
-* Description
-* BlindingNumber
-* PID
-* Size
-* Type
-* LocationType
-* NormalPosition
-* OnSite
-* ICCNumber
-* BlindSapNumber
-* BlindQuantity
-* GasketSAPNumber
-* GasketQuantity
-* Stage
-* Height
-* Scaff
-* Insul
-* Crane
-* Remarks
 [[Category:MaTaP|Import Runs]]

@@ Line 53: / Line 53: @@
 * EquipmentGroup (Text)
-[[Category:MaTaP|Import Runs]]
 = Progress Operation Import =
@@ Line 85: / Line 85: @@
 * Suboperation (Text)
-[[Category:MaTaP|Import Runs]]
 = QRF Operation Import =
@@ Line 119: / Line 119: @@
 * QRFDescription (Text)
-[[Category:MaTaP|Import Runs]]
 = Check Operation Import =
@@ Line 151: / Line 151: @@
 * Suboperation (Text)
-[[Category:MaTaP|Import Runs]]
 = Scheduling Import  (for Operations)=
@@ Line 209: / Line 209: @@
 * BOMItemNr (Text)
 * ItemCategory (Text)
 * Quantity (Number)
 * Unit (Text)

@@ Line 34: / Line 34: @@
 = Workorder Import =
 To import WorkOrders following column is required:
 * Workorder (Text)
 Columns that can be imported additionally:
@@ Line 45: / Line 47: @@
 * Longtext (Text)
 * DrainlistDocument (Text)
 Following columns are optional, as we recommend to import them directly using the Equipment.import instead: