MANUALS > Technical Records > Technical Records Module > Technical Records, Update Menu > Defect Report > Defect Report Buttons > Import Button, via Defect Report
Import Button, via Defect Report
From the Defect Report window, select the Import button for the quick import of many records (instead of manually entering them) into the Defect Report window.
For information regarding how to prepare the import file, refer to Preparing File For Import, via the Import Button of the System Standards Training Manual.
Note: Import files for eMRO should be saved as .csv (comma delimited) or .xlsx and cannot have spaces in the title of the file. Spaces in the file path will cause errors when importing.
Once the file has been prepared, go to Technical Records/ Update/ Defect Report.
Criteria for W/O Task Card Import file:
Column Name
|
Data Type
|
Limitation
|
Path
|
W/O
|
Numeric
|
8
|
Technical Records/Update/Defect Report Detail, General Tab/W/O Button
|
Defect
|
Alphanumeric
|
12
|
Technical Records/Update/Defect Report Detail, General Tab.
|
Defect Item
|
Numeric
|
4
|
Technical Records/Update/Defect Report Detail, General Tab.
|
Reported Hour
|
Numeric
|
2
|
Technical Records/Update/Defect Report Detail, General Tab.
|
Reported Minute
|
Numeric
|
2
|
Technical Records/Update/Defect Report Detail, General Tab.
|
Reported Date
|
Alphanumeric
|
8
|
Technical Records/Update/Defect Report Detail, General Tab.
|
A/C
|
Alphanumeric
|
10
|
Technical Records/Update/Defect Report Detail, General Tab.
|
Station
|
Alphanumeric
|
10
|
Technical Records/Update/Defect Report Detail, General Tab.
|
Reported By
|
Alphanumeric
|
10
|
Technical Records/Update/Defect Report Detail, General Tab.
|
Chapter
|
Numeric
|
2
|
Technical Records/Update/Defect Report Detail, General Tab.
|
Section
|
Numeric
|
2
|
Technical Records/Update/Defect Report Detail, General Tab.
|
Reference Task Card
|
Alphanumeric
|
8
|
Technical Records/Update/Defect Report Detail, Resolution Tab.
Will be added to the Resolution Description.
If a Work Order is created, it will be added as a Scheduled Task Card. If the Work Order already exists, the Reference Task Card will be attached to the already existing Work Order.
|
RII By
|
Alphanumeric
|
10
|
Technical Records/Update/Defect Report Detail, General Tab.
|
Defect Description
|
Alphanumeric
|
4000
|
Technical Records/Update/Defect Report Detail, General Tab.
|
Resolution Description
|
Alphanumeric
|
4000
|
Technical Records/Update/Defect Report Detail, Resolution Tab.
|
Defect Type
|
Alphanumeric
|
8
|
Technical Records/Update/Defect Report Detail, General Tab.
|
Reference Sequence
Number
|
Numeric
|
8
|
Technical Records/Update/Defect Report Detail, General Tab.
|
Resolved By
|
Alphanumeric
|
10
|
Technical Records/Update/Defect Report Detail, Resolution Tab.
|
Resolved Date
|
Alphanumeric
|
8
|
Technical Records/Update/Defect Report Detail, Resolution Tab.
|
Resolved Hours
|
Numeric
|
2
|
Technical Records/Update/Defect Report Detail, Resolution Tab.
|
Resolved Minutes
|
Numeric
|
2
|
Technical Records/Update/Defect Report Detail, Resolution Tab.
|
References
|
Alphanumeric
|
25
|
Technical Records/Update/Defect Report Detail, Resolution Tab.
|
Status
|
Alphanumeric
|
10
|
Technical Records/Update/Defect Report Detail, General Tab.
Note: If the status selected is not either 'Open' or 'Closed', an Exception will result and the Import will fail.
|
Defer
|
Alphanumeric
|
8
|
Technical Records/Update/Defect Report Detail, Defer Tab.
|
Defer By
|
Alphanumeric
|
10
|
Technical Records/Update/Defect Report Detail, Defer Tab.
|
Defer Date
|
Alphanumeric
|
8
|
Technical Records/Update/Defect Report Detail, Defer Tab.
|
Defer To Date
|
Alphanumeric
|
8
|
Technical Records/Update/Defect Report Detail, Defer Tab.
|
MEL
|
Alphanumeric
|
8
|
Technical Records/Update/Defect Report Detail, Defer Tab.
|
MEL Sub
|
Alphanumeric
|
10
|
Technical Records/Update/Defect Report Detail, Defer Tab.
|
MEL Number
|
Alphanumeric
|
20
|
Technical Records/Update/Defect Report Detail, Defer Tab.
|
Defer Category
|
Alphanumeric
|
10
|
Technical Records/Update/Defect Report Detail, Defer Tab.
|
Schedule Hours
|
Numeric
|
6
|
Technical Records/Update/Defect Report Detail, Defer Tab.
|
Schedule Cycles
|
Numeric
|
6
|
Technical Records/Update/Defect Report Detail, Defer Tab.
|
Schedule Days
|
Numeric
|
6
|
Technical Records/Update/Defect Report Detail, Defer Tab.
|
Defer to Hours
|
Numeric
|
2
|
Technical Records/Update/Defect Report Detail, Defer Tab.
|
Defer to Minute
|
Numeric
|
2
|
Technical Records/Update/Defect Report Detail, Defer Tab.
|
Plan Defect
|
Alphanumeric
|
10
|
Technical Records/Update/Defect Report Detail, Defer Tab.
|
Repeat Number
|
Numeric
|
6
|
Technical Records/Update/Defect Report Detail, Defer Tab.
|
Completed Number
|
Numeric
|
6
|
Technical Records/Update/Defect Report Detail, Defer Tab.
|
Defer Hour
|
Numeric
|
2
|
Technical Records/Update/Defect Report Detail, Defer Tab.
|
Defer Minutes
|
Numeric
|
2
|
Technical Records/Update/Defect Report Detail, Defer Tab.
|
Defer Notes
|
Alphanumeric
|
2000
|
Technical Records/Update/Defect Report Detail, Defer Tab.
|
Linking Defect
|
Alphanumeric
|
12
|
Technical Records/Update/Defect Report Detail, Defer Tab.
|
Linking Defect Item
|
Numeric
|
5
|
Technical Records/Update/Defect Report Detail, Defer Tab.
|
Defect Category
|
Alphanumeric
|
10
|
Technical Records/Update/Defect Report Detail, General Tab.
|
ASC Code
|
Alphanumeric
|
4
|
Technical Records/Update/Defect Report Detail, General Tab.
|
Select the Import button for the quick import of many records (instead of manually entering) into the Defect Report window.

From the Import From File window complete all of the Import steps.

For information regarding how to Import a file, refer to Importing a File via Import Button of the System Standards Training Manual.
The following information/options are available in this window: _____________________________________________________________________________________
Import File
The file to be imported must be Tab delimited. Individual records that will be imported must contain a Location/Site that matches the location that is currently selected.
First Line Is Header checkbox
Check to indicate that the first line in the Tab delimited text file represents a Header line and should not be imported.
Auto Generate Defect Number checkbox
Select this checkbox to auto generate a Defect Number for the Defect Report import.
_____________________________________________________________________________________
|