Import W/O Task Card Button, via Work Order Detail, Optional Tab

MANUALS > Production > Production Module > Production, Update Menu > W/O > Work Order Detail > Work Order Detail, Optional Tab > Import W/O Task Card Button, via Work Order Detail, Optional Tab

A customer's Task Cards that do not exist in the Engineering module's Task Card database can be imported into the Work Order by clicking the Import W/O Task Card button. The TPW checkbox must be selected on the General Tab in order for the Import W/O Task Card button to be visible in the Optional tab. The Import W/O Task Card button allows the vendor to receive an excel spreadsheet file of Task Cards to import. The user may then attach these imported Task Cards to a third-party Work Order package.

Note: This button is security controlled via Production/ Update/ W/O/ W/O Task Card Import. For more information refer to the Security Explorer of the System Administration module.

Note: This import option is only used for Third Party Work Orders. The Third Party checkbox must be checked for this option to be available.

First, the user must prepare an excel spreadsheet file. 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: This import can be used to manually mass link Customer Task Cards to system generated Task Cards. Attachments associated with the Customer Task Cards will also be linked to the system generated Task Cards.

Note: The Mod No column of the Excel file template must be populated for a Task Card Import to execute. If the Mod No column is null, the record will go to the Exceptions tab with other data that could not be processed.

Criteria for W/O Task Card Import Excel file:

Release	Column Name	Data Type	Limitation	Path
	Task Card	Alphanumeric	25	Production/Update/W/O Task Card, General Tab
	Aircraft	Alphanumeric	10	Production/Update/W/O Task Card, General Tab
	Phase	Alphanumeric	8	Production/Update/W/O Task Card, General Tab
	Part Number	Alphanumeric	35	Production/Update/W/O Task Card, General Tab
	Part Number Serial Number	Alphanumeric	20	Production/Update/W/O Task Card, General Tab
	Task Card Description	Alphanumeric	250	Production/Update/W/O Task Card, General Tab
	EC	Alphanumeric	25	Production/Update/W/O Task Card, General Tab
	Revision	Alphanumeric	20	Production/Update/W/O Task Card, General Tab
	Corrosion	Alphanumeric	10	Production/Update/W/O Task Card, Optional 1 Tab
	NDT	Alphanumeric	10	Production/Update/W/O Task Card, Optional 3 Tab
	SSID	Alphanumeric	10	Production/Update/W/O Task Card, Optional 3 Tab
	Allow Defer	Alphanumeric	10	Production/Update/W/O Task Card, Optional 3 Tab
	MPD	Alphanumeric	25	Production/Update/W/O Task Card, Optional 1 Tab
	Area	Alphanumeric	70	Production/Update/W/O Task Card, Optional 1 Tab
	ETOPS	Alphanumeric	10	Production/Update/W/O Task Card, Optional 3 Tab
	Chapter	Numeric	2	Production/Update/W/O Task Card, Optional 2 Tab
	Section	Numeric	2	Production/Update/W/O Task Card, Optional 2 Tab
	Mod No	Alphanumeric	25	Production/Update/W/O Task Card, Optional 2 Tab
	Task Card Item	Alphanumeric	5	Production/Update/W/O Task Card Item/General Tab
	Skill	Alphanumeric	10	Production/Update/W/O Task Card Item/Skills Tab
	Man Hours	Numeric	2	Production/Update/W/O Task Card Item/Skills Tab
	Men Required	Numeric	2	Production/Update/W/O Task Card Item/Skills Tab
	Task Card Text	Alphanumeric	4000	Production/Update/W/O Task Card Item/General Tab
	Mechanic checkbox	Alphanumeric	1	Production/Update/W/O Task Card Item/Skills Tab
	Inspector checkbox	Alphanumeric	1	Production/Update/W/O Task Card Item/Skills Tab
	Duplicate Inspection checkbox	Alphanumeric	1	Production/Update/W/O Task Card Item/Skills Tab
	Inspector Skill	Alphanumeric	10	Production/Update/W/O Task Card Item/Skills Tab
	Inspector Man Hours	Numeric	2	Production/Update/W/O Task Card Item/Skills Tab
	Inspector Man Require	Numeric	2	Production/Update/W/O Task Card Item/Skills Tab
	Dual Inspector Skill	Alphanumeric	10	Production/Update/W/O Task Card Item/Skills Tab
	Dual Inspector Man Hours	Numeric	2	Production/Update/W/O Task Card Item/Skills Tab
	Dual Inspector Men Required	Numeric	2	Production/Update/W/O Task Card Item/Skills Tab
	Schedule Start Date	Numeric	6	Production/Update/W/O/ Task Card/ Schedule Tab
	(Start) Hour	Numeric	2	Production/Update/W/O/ Task Card/ Schedule Tab
	(Start) Min	Numeric	2	Production/Update/W/O/ Task Card/ Schedule Tab
	Schedule End Date	Numeric	6	Production/Update/W/O/ Task Card/ Schedule Tab
	(End) Hour	Numeric	2	Production/Update/W/O/ Task Card/ Schedule Tab
	(End) Min	Numeric	2	Production/Update/W/O/ Task Card/ Schedule Tab
	Additional Work	Checkbox	Y/N	Production/Update/W/O Task Card Item/General Tab
	Task Card Category	Alphanumeric	8	Engineering/update/Task Card
	Critical Task	N/A	Y/N	Production/Update/W/O/ Task Card/ Optional 3 Tab
	RII	N/A	Y/N	Production/Update/W/O/ Task Card/ Optional 3 Tab
	CDCCL	N/A	Y/N	Production/Update/W/O/ Task Card/ Optional 3 Tab
	ATTACHMENT Note: Refer to the Importing Customer Task Card PDFs via the Production Training Manual.	Alphanumeric	25	Production/Update/W/O/Customer Task Card Button/Attachment button
	Task Card Reference	Alphanumeric	25	Production/Update/W/O/Task Card/Optional 2 Tab
	Sequence	Numeric	3	Production/Update/W/O/Print button/WorkPack Print/Task Card button/ W/O Task Card Print
	MRB	Alphanumeric	15	Production/Update/W/O/Task Card/Optional 2 Tab

Note: If any exception is generated during the import, all of the records in the file will be rejected. For additional information, refer to the Exceptions topic via the System Standards Training Manual.

Go to Production/ Update/ W/O to create a new Work Order, or to find an existing Work Order.

eMRO Import WO Task Card Button, via Work Order Detail, Optional Tab

After clicking the TPW checkbox, save the Work Order in the General Tab and then click the Optional tab.

eMRO Work Order Detail, Optional Tab(2)

Select Upload button to choose the an excel file. Then select the Save button to import the Task Cards into the Work Order.

Note: For more information on the Import Customer TC button and how to import a customer's T/C PDF files, refer to Importing Customer Task Card PDFs via the Production Training Manual.

For additional information regarding how to import a file, refer to Importing a file via Import Button of the System Standards Training Manual.

Each Task Card will appear in the W/O Task Card window after uploading an excel file of Customer Task Cards.

eMRO Import WO Task Card Button, via Work Order Detail, Optional Tab (1)

Click the Select button to open a Task Card.

eMRO Import WO Task Card Button, via Work Order Detail, Optional Tab (2)

Note: In the Optional 3 Tab of the Task Card, the following checkboxes--Allow Defer, S.S.I.D, ETOPS, etc.--appear unchecked if left blank in the column of the same name in the excel file.

When importing Third-Party Work Task Cards that don't exist in the system database, users can use the Label Task button to create Non-Routine labels for the non-system task cards.

Note: This function is only used for companies currently using the Work Order Task Card Work In Progress option.

For more information regarding the Label Task button, please refer to the Label Task Card button section of this manual.

In This Section

Importing Customer Task Card PDFs, via Import WO Task Card Button