-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathPreactorScripts.txt
204 lines (202 loc) · 6.4 KB
/
PreactorScripts.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
Preactor Scripts:
________________________________________________________
Import SIMATIC IT Equipment (Unit):
________________________________________________________
Table name - Resources
Connection Type - Data Provider
Table Import - Secondary Constraints
========================================================
Query String -
SELECT equip.EquipmentName
FROM View_EquipmentNames equip
DB - Preactor
========================================================
Settings -
* Append New Records
* Update Current Records
* Delete Old Records
Imports
* EquipmentName - Name - String (ID)
________________________________________________________
Import SIMATIC IT Entry Statuses:
________________________________________________________
Table name - Operation Status
Connection Type - Data Provider
Table Import
========================================================
Query String -
SELECT [id] as StatusId,
COALESCE(Description,'') as Description
FROM [dbo].[POMV_ETRY_STAT]
DB - SitMesDb
========================================================
Settings -
* Clear Preactor Table
* Append New Records
Imports -
StatusId - Operation Status Name - String (ID)
Description - Description - String
________________________________________________________
Import SIMATIC IT Order Statuses:
________________________________________________________
Table Name - Order Status
Connection Type - Data Provider
Table Import
========================================================
Query String -
SELECT id as StatusId,
COALESCE(Description,'') as Description
FROM [dbo].[POMV_ORDR_STAT]
DB - SitMesDb
========================================================
Settings -
* Clear Preactor Table
* Append New Records
Imports -
StatusId - Operation Status Name - String (ID)
Description - Description - String
________________________________________________________
Import SIMATIC IT Equipment (Workcenter):
________________________________________________________
Table Name - Resource Groups
Connection Type - Data Provider
Table Import - Resources
========================================================
Query String -
SELECT equip.EquipmentName,
equip.EquipmentId,
equip.EquipmentSuperior
FROM View_EquipmentNames equip
DB - Preactor
========================================================
Settings -
* Append New Records
* Update Current Records
* Delete Old Records
Imports -
EquipmentName - Name - String (ID)
________________________________________________________
Import SIMATIC IT Equipment Relationship
________________________________________________________
Table Name - Resource Groups
Connection Type - Data Provider
Matrix Import - Resources
========================================================
Query String -
SELECT equip.EquipmentName,
equip.EquipmentSuperior
FROM View_EquipmentNames equip
DB - Preactor
========================================================
Settings -
* Append New Records
Imports - (Resource Groups)
* EquipmentName - Name - String (ID)
Imports - (Resources)
* EquipmentSuperior - Name - String (ID)
________________________________________________________
Import SIMATIC IT Orders
________________________________________________________
Table Name - Orders
Connection Type - Data Provider
Data Set - Schedule
Table Import - Internal Pegging Information
========================================================
Query String -
SELECT * From View_OrderInfo
ORDER BY
orderid, sequence
DB - Preactor
========================================================
Settings -
* Append New Records
* Rebuild Family
* Update Current Records
Additional Options - DOLOADSAVE
Imports -
* OrderPrimaryKey - MES Order PK - Number (ID)
* OrderId - Order No. - String (ID)
* DueDate - Due Date - Date MM/dd/yyyy
* Produced Quantity - Mid Batch Quantity - Number
* OrderStatus - Order Status - String
* EntryId - Operation Name - String (ID)
* EntryPrimaryKey - MES Operation PK - Number
* EntryStatusId - Operation Progress - String
* Sequence - Op. No. - Number (ID)
* ProcTimeType - Process Time Type - String
________________________________________________________
Import Orders Resource Data
________________________________________________________
Table Name - Orders
Connection Type - Data Provider
Data Set - Schedule
Matrix Import - Resource Data
========================================================
Query String -
SELECT ords.OrderNo,
ords.OpNo,
runRates.Equipment AS Resource,
1 AS AutomaticSequencing,
runRates.UnitsPerHour AS ResourceRatePerHour
FROM Userdata.orders AS ords
JOIN dbo.View_MesRunRates runRates ON ords.operationName = runRates.operationName
DB - Preactor
========================================================
Settings -
* Clear all matrix records
* Append new records
Additional opetions - DOLOADSAVE
Imports -
* OrderNo - Order No. - String (ID)
* OpNo - Op. No. - Number (ID)
________________________________________________________
Update Complete Ops
________________________________________________________
Table Name - Orders
Connection Type - Data Provider
Data Set - Schedule
Table Import - Internal Pegging Information
========================================================
Query String -
SELECT
OrderID,
Sequence AS Opno,
ActualStart,
Case When ActualEndTime = '1/1/1900 12:00:00 AM' Then ActualStart + .25 else ActualEndTime end as ActualEndTime,
ProducedQuantity,
WorkCenterUnit,
EntryStatusId,
1 as UseActualTimes
FROM dbo.View_OrderInfo
WHERE EntryStatusId= 'Complete'
DB - Preactor
========================================================
Settings -
* Update Current Records
Additional opetions - DOLOADSAVE
Imports -
* OrderId - Order No. - String (ID)
* Opno - Op. No. - Number (ID)
* ActualStart - Setup Start - Date MM/dd/yyyy
* ActualStart - Start Time - Date MM/dd/yyyy
* ActualEndTime - End Time - Date MM/dd/yyyy
* ActualEndTime - Mid Batch Time - Date MM/dd/yyyy
* ProducedQuantity - Mid Batch Quantity - Number
* EntryStatusId - Operation Progress - Number
* UseActualTimes - Use Actual Times - Number
________________________________________________________
Update Downtime Exceptions
________________________________________________________
Table Name - Resources
Connection Type - Data Provider
Table Import - Secondary Constraints
========================================================
Query String -
EXEC [Calendar].[InsertDowntimeExceptionsLMS]
SELECT Name from Userdata.Resources
DB - Preactor
========================================================
Settings -
* Update current records
Imports -
* Name - Name - String (ID)