Prepare and Load Aircraft Configuration¶
Aircraft type or assembly type configuration data, required for the maintenance of various aircraft, must be loaded to IFS Cloud for aircraft type configuration information to be available for Mobile Maintenance for Aviation.
Loading the aircraft type configuration is responsible for the creation or update of assemblies, systems, sub systems, Line Replaceable Unit (LRU) configuration slots, configuration slot positions, part groups and part numbers.
Prepare configuration file¶
To create or update aircraft type configuration a .csv file with aircraft configuration with a comma as a separator must be uploaded to the 001_FLM_AC_DATA_LOAD migration job for the said purpose. It should contain columns and values as follows:
Column No | Column Header | Description and Values | Column Applicable for Record Type | Mandatory for Record Type | Data Type | Max Length |
---|---|---|---|---|---|---|
1 | Record Type | The following are the record types that must be used to create or update the aircraft type configuration hierarchy as follows: ASSY to create or update an assembly SYS to create or update a system SUB to create or update a subsystem CFG to create or update a Line Replaceable Unit (LRU) config slot CFGPOS to create or update a configuration slot position PG to create or update a part group PN to create or update a part number PGP to create or update a part group part |
All record types | Yes | Varchar | 10 |
2 | Assembly Type Code | The code for the type of assembly. E.g. B131 | All record types | Yes for assembly and config slot No for system, sub system, config slot position and part group |
Varchar | 8 |
3 | System Code | The system code of the assembly system. E.g. 21-00 | System | No | Varchar | 50 |
4 | Sub System Code | The sub system code of the assembly sub system. E.g. 21-00-00 or 21-00-10. | Sub system | No | Varchar | 50 |
5 | Config Slot Code | The config slot code of the assembly sub system. E.g. 21-00-00 or 21-00-10. | Configuration slot, config slot position and part group | Yes | Varchar | 50 |
6 | Config Slot Position Code | The position code for the assembly config slot. E.g. FWD Left Cabin | Config slot position | Yes | Varchar | 200 |
7 | Part Group Code | The code for part group associated with the config slot. E.g. 29-11-04 | Part group | Yes | Varchar | 50 |
8 | Part Number | The part number of the part assigned to the part group. E.g. 11483-000 | Part | Yes | Varchar | 40 |
9 | Assembly Name/System Name/Sub System Name/Config Slot Name/Part Group Name/Part Name | The name of the assembly, system, sub system, config slot, part group or part, based on the record type being created. | All record types | No | Varchar | Assembly Name-80 System Name- 100 Config Slot Name-100 Part Group Name - 100 Part Name - 80 |
10 | Assembly Class Code | The class code for the assembly. Valid values are ACFT for aircraft assemblies, ADMIN for administrative assemblies, APU for auxiliary power unit assemblies, LDGEAR for landing gear assemblies and ENG for engine assemblies. | Configuration slot | No | Varchar | 8 |
11 | Inventory Class Code | The class code for the inventory. Valid values are SER, TRK, BATCH. | Configuration slot and part group | No for configuration slot and part number Yes for part group |
Varchar | 16 for config slot 8 for part group and part number |
12 | Parent Aircraft Type Code | The aircraft type code of the parent config slot. E.g. B131 | Configuration slot | No | Varchar | 16 |
13 | Parent Config Slot Code | The config slot code of the parent config slot. E.g. 21-00-00 | Configuration slot | No | Varchar | 40 |
14 | Config Slot Status | The status of the config slot. Valid values are ACTV for active configuration slots or OBSLT for obsolete configuration slots. | Configuration slot | No | Varchar | 8 |
15 | Is Mandatory | If the value is "TRUE" the configuration slot is a mandatory configuration slot for which when a component is removed, the hierarchy is considered incomplete until a replacement component is installed. Valid values are "TRUE" and "FALSE". | Configuration slot | Yes | Varchar | 20 |
16 | Is Software | If the value is "TRUE" the configuration slot it indicates that you want to install software components on the assembly. Valid values are "TRUE" and "FALSE". | Configuration slot | Yes | Varchar | 20 |
17 | Number of Config Slot Positions | The number of positions on the configuration slot on which parts can be installed. E.g. 2. | Configuration slot | Yes | Number | 20 |
18 | Part Quantity | This is the quantity to be installed on the configuration slot. E.g. 1. | Part group | Yes | Number | 20 |
19 | Is Line Replaceable | If the value is "1" this indicates if the part is a line replaceable unit. If the value is "0" this indicates that the part is not a line replaceable unit. | Part group | No | Number | 20 |
20 | Applicability Range | Values for the applicability range can consist of one or more applicability codes separated by commas and/or hyphens. E.g. 217, 219. | Part group | No | Varchar | 4000 |
21 | Is Common Hardware | If the value is "TRUE", this indicates that the part group is for common hardware. Valid values are "TRUE" and "FALSE". | Part group | Yes | Varchar | 20 |
22 | Is Req Spec Part | If the value is "TRUE" this indicates that a user must select a specific alternate part when requesting the part group. Valid values are "TRUE" and "FALSE". | Part group | Yes | Varchar | 5 |
23 | Conditions Desc | A description of the conditional part applicability or conditional information for the part group. | Part group | No | Varchar | 4000 |
24 | Manufacturer | The manufacturer code for the manufacturer of the part. E.g. GRIM. | Part | Yes | Varchar | 16 |
25 | Part Use | The category of part use. Valid values are AE for aeronautical equipment, TOOLS for tool part, and CONSUM for parts that are expensed when they are installed. | Part | No | Varchar | 20 |
26 | Is Repairable | If the value is "TRUE" this indicates that the part is repairable. Valid values are TRUE or FALSE. | Part | No | Varchar | 20 |
27 | Part Status | The status of the part. Valid values are ACTV for active parts, BUILD for bill of material parts and OBSLT for obsolete parts. | Part | No | Varchar | 20 |
28 | Is Standard | If the value is "TRUE", the part is a standard part for the part group. Valid values are "TRUE" or "FALSE". | Part Group Part | No | Varchar | 20 |
29 | Interchangeability Order | The interchangeability order of the part group. E.g. 1 or 2. | Part Group Part | No | Number | 20 |
30 | Is Approved | If the value is "TRUE", the part is an approved part. Valid values are "TRUE" and "FALSE". | Part Group Part | No | Varchar | 20 |
31 | Is Conditions | If the value is "TRUE", the alternate part has special conditions. Valid values are "TRUE" and "FALSE". | Part Group Part | No | Varchar | 20 |
32 | Is Obsolete | If the value is "TRUE", the record is obsolete. Valid values are "TRUE" and "FALSE". | All record types | Yes | Varchar | 20 |
33 | External ID | An external identifier for the record type which identifies the row and if the new record type needs to be created or updated. E.g. 1000301:ASMB80:1. If a record is uploaded with an External ID that is new to the system, a new record is created. If not, the record with the existing External ID is updated. | All record types | Yes | Varchar | 80 |
34 | System External ID | An external identifier for the system under which the sub system is to be created or updated. The value for this field must be the same as the External ID for a system created previously. E.g. 1000302:SYS80:2 | Sub system | Yes | Varchar | 20 |
35 | Part Group External ID | An external identifier for the part group to which the part group part needs to be assigned. The value for this field must be the same as the External ID for a part group created previously. E.g. 1000303:PG80:3 | Part Group Part | Yes | Varchar | 80 |
36 | Part Number External ID | An external identifier for the part number with which the part group part can be assigned to the part group. The value for this field must be the same as the External ID for a part number created previously. E.g. 1000304:PN80:3 | Part Group Part | Yes | Varchar | 80 |
Load configuration and run migration job¶
- On your IFS Cloud Web interface, navigate to Solution Manager/Data Management/Data Migration and open the Execute Job page.
- Click Search in the top banner, then click Job ID and enter 001_FLM_AC_DATA_LOAD. Note: If you are unable to see this job, you need to log in as a user with access to the job. To do so navigate to Solution Manager/Data Management/Data Migration/Basic Data and on the Authorized Users page, search for your user, click Bulk Grant, search for and grant access to jobs with Group ID MIG_FLM_AC.
- On the Execute Job page Detail tab, click Load File.
- Drag and drop or browse for and select the .csv file to be uploaded.
- Click OK. If a file was successfully uploaded, a message is displayed indicating such.
- Click Search in the top banner, then click Job ID and enter 002_FLM_AC_RUN_ALL.
- On the Execute Job page, click Start Job and then click Online. After the execution of the job, a message summarizing the execution is displayed. It states how many rows the file contained, how many were committed and how many failed, if any.
-
Based on the summary:
-
If all the rows the file contained were committed, the aircraft configuration has been uploaded and you can navigate to the Aircraft Type Details page in the Aviation Maintenance navigator, search for and view the uploaded aircraft configuration hierarchy. Expand the tree navigator for the aircraft type to view the systems, sub systems, and configuration slots. Click on a configuration slot in the tree navigator to view part groups and positions. To view alternate parts for a part group, expand the row for a part group.
-
If some or all rows failed, on the Execute Job page, search for the migration jobs with Group ID, MIG_FLM_AC. For the 001_FLM_AC_DATA_LOAD job click on the Detail tab. If the row failed data validation, the error message field displays why the row was not committed to the target tables. You can also navigate to the individual data migration jobs, 100_FLM_AC_ASSEMBLY, 200_FLM_AC_SYSTEM, 220_FLM_AC_SUB_SYSTEM, 300_FLM_AC_CFG_SLOT, 320_FLM_AC_CFG_SLT_POS, 400_FLM_AC_PART_GROUP, 420_FLM_AC_PART_NUMBER and 440_FLM_AC_PT_GRP_PART for aircraft type configuration, view the Detail tab and view the Error Message field. An example of an error that would be displayed on this tab, would be if the row for the configuration slot failed, on the Detail tab of the Execute Job page for Job ID 320_FLM_AC_CFG_SLT_POS, an error message would be displayed indicating that the configuration slot does not exist.
-
For more information on migration jobs, see Data Migration.