Skip to content

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

  1. On your IFS Cloud Web interface, navigate to Solution Manager/Data Management/Data Migration and open the Execute Job page.
  2. 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.
  3. On the Execute Job page Detail tab, click Load File.
  4. Drag and drop or browse for and select the .csv file to be uploaded.
  5. Click OK. If a file was successfully uploaded, a message is displayed indicating such.
  6. Click Search in the top banner, then click Job ID and enter 002_FLM_AC_RUN_ALL.
  7. 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.
  8. Based on the summary:

    1. 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.

    2. 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.