The Maintenance Planning Data (MPD) fields and its contents must meet the specifications defined in the table below in order to load correctly into TRAX. After the Excel file is modified to the specifications it must be converted to tab delimited text file for loading into trax. Keep a copy of the Excel file as the master source because, once the excel file is Saved as a tab delimited text file it cannot be opened again in Microsoft Excel for editing.
Prepare the MPD Excel File (.xls) provided by the aircraft manufacturer in Microsoft Excel as follows:
Open the Excel File in Microsoft Excel.
Arrange and modify the columns (fields) to meet the specification in the table below.
|
Column Name
|
Data
|
TRAX Fields Populated
|
Path
|
A
|
Rev Code
|
N/A
|
not imported
|
|
B
|
Section
|
N/A
|
not imported
|
|
C
|
Task Number
|
25 characters
one entry
|
E/C Reference
|
Engineering/ Update/ Engineering Control
|
D
|
Source Task Reference
|
N/A
|
not imported
|
|
E
|
Access
|
25 characters max
multiple entries allowed
space delimited
|
Task Card Panels
|
Engineering/ Update/ Task Card/ Panel button
|
F
|
Preparation
|
not imported
|
not imported
|
|
G
|
Zone
|
25 characters max
multiple entries allowed
space delimited
|
Task Card Zones
|
Engineering/ Update/ Task Card/ Zone button
|
H
|
Description
|
250 characters
|
Task Card Description Field
AND
Engineering Control Description Field
|
Engineering/ Update/ Task Card
AND
Engineering/ Update/ Task Card
|
I
|
Skill Code
|
10 characters
one entry
|
Task Card Item Skills
If the skill code does exist a new entry will be created in Settings/Update/Skills.
|
Engineering/ Update/ Task Card/ Skills tab, Items button
|
J
|
Task Code
|
8 characters
one entry
|
Task Card Category Field (Transaction Code)
AND
Engineering Control Category Field (Transaction Code)
|
Engineering/ Update/ Task Card
AND
Engineering/ Update/ Engineering Control
|
K
|
Sample Threshold
|
If Threshold Field is blank, the program will take data from this field.
All data is the same as Threshold Field.
|
See Threshold Field
|
|
L
|
Sample Interval
|
If Interval Field is blank, the program will take data from this field.
All data is the same as Interval Field.
|
See Interval Field
|
|
M
|
Threshold
Note: The First Schedule in the Engineering Control, Schedule tab is pulled from this column when populated.
|
<time><time type>
where: <time> = Numeric Digits <time type>=2 char. code YE = years DY = days MO = months FH = flight hours CY = cycles
Example: 300 CY 1000 FH
multiple entries
line delimited
In Excel use ALT+Enter to add multiple line delimited entries.
|
|
Engineering/ Update/ Engineering Control/ A/C CTL button/ Override
|
N
|
Interval
|
<time><time type>
where: <time> = Numeric Digits <time type>= 2 char. code YE = years DY = days MO = months FH = flight hours CY = cycles
Example: 300 CY 1000 FH
multiple entries
line delimited
In Excel use ALT+Enter to add multiple line delimited entries.
|
E/C Repeat Schedule
|
Engineering/ Update/ Engineering Control/ A/C CTL button/ Override
|
O
|
Source
|
N/A
|
not imported
|
|
P
|
Tci
|
N/A
|
not imported
|
|
Q
|
Tps
|
N/A
|
not imported
|
|
R
|
Reference
|
25 characters
multiple entries
line delimited In Excel use ALT+Enter to add multiple line delimited entries.
|
E/C Engineering Document
|
Engineering/ Update/ Engineering Control, Document button
|
S
|
Men
|
2 digit number
|
Task Card Item Skill Tab Men Required Field
|
Engineering/ Update/ Task Card/ Skills Tab, Items button
|
T
|
Task Mh
|
6 digit number and 2 decimal places
multiple entries allowed
|
Task Card Item Skill Tab Man Hours Field
Note: When imported, the values in row U and V will be added to the value in row T.
|
Engineering/ Update/ Task Card/ Skills Tab, Items button
|
U
|
Acc Mh
|
6 digit number and 2 decimal places
multiple entries allowed
|
Task Card Item Skill Tab Man Hours Field
Note: When imported, the values in row U and V will be added to the value in row T.
|
Engineering/ Update/ Task Card/ Skills Tab, Items button
|
V
|
Prep Mh
|
6 digit number and 2 decimal places
multiple entries allowed
|
Task Card Item Skill Tab Man Hours Field
Note: When imported, the values in row U and V will be added to the value in row T.
|
Engineering/ Update/ Task Card/ Skills Tab, Items button
|
W
|
AC Effectivity
|
1,000 characters
multiple entries
space delimited
If field = ALL, then E/C and Task Card will be effective to all A/C in the system.
If field is blank, then there will be no A/C effectivity. (See notes.)
|
A/C Effectivity for E/C (A/C)
AND
A/C Effectivity for Task Card (A/C)
Note: When loading an MPD revision, if an Engineering Control is set up originally as a P/N E/C, but the MPD file has applicability against the aircraft, the system will override and remove the original P/N E/C effectivity and assign it to the aircraft effectivity. It is important that when this scenario is in effect, in order for the MPD Loader not to override the P/N E/Cs effectivity, the file must be amended by removing the aircraft effectivity against the Engineering Controls set up as a P/N E/Cs. When the aircraft applicability is removed and left blank, the system will retain the original P/N E/C effectivity.
Note: If this field is left blank in the import file, then there will be no A/C effectivity. However, if the A/C Effectivity Tab is populated with a Type/Series, then that Type/Series will override the blank effectivity field in the document and give effectivity to all Aircraft under that Type/Series.
Note: A/Cs must exist in the Aircraft Master.
|
Engineering/ Update/ Engineering Control/ A/C CTL button
AND
Engineering/ Update/ Task Card/ Effectivity button
|
X
|
Additional Description 
|
2000 characters
|
Task Card Item 1
|
Engineering/ Update/ Task Card/ Item Button
|
Y
|
FSTOTAL 
|
<time><time type>
where: <time> = Numeric Digits <time type>=2 char. code YE = years DY = days MO = months FH = flight hours CY = cycles
Example: 300 CY 1000 FH
one entry allowed
|
Total Hours and Total Days. The system will convert months into days for the Total Days field.
|
Engineering/ Update/ Engineering Control, E/C Schedule Tab
|
Z
|
Task Type 
|
10 characters
one entry
|
Task Card Type field
|
Engineering/Update/Task Card
|
Save the MPD in Excel (.xls) format to keep as a master source.
Save another copy of the file as a tab delimited text file for loading into TRAX.