Author name: Amit Vyas

About IFS Cloud IFS Cloud is a composable enterprise software application that choreographs people, customers, and assets to minimize insolubility, cost and risk factors as you plan, manage and optimize critical asset availability, endeavor for operational superiority and workforce productivity. IFS provides a large range of ERP, Service Management and Enterprise Asset Management capabilities. Organizations choose the capabilities they need from across the solution areas. Construct on a powerful, flexible common platform IFS Cloud combines deep industry and functional strength with intelligent autonomous abilities. First, let’s understand the fundamentals of IFS Data Migration concepts. IFS Data Migration   IFS Data Migration is a tool that loads data from external sources into the application core objects in IFS Cloud. This tool is typically used to transfer data from previous legacy systems when an IFS solution is first implemented, or when systems are consolidated. The prime benefit of IFS Data Migration is that it always loads data through the business logic APIs in IFS Cloud. Unlike other tools and resources that insert data straight into tables IFS Data Migration assures that business rules, validations, and integrity checks are never bypassed. Data Migration jobs are highly adaptive and multiple jobs can be rope together depending on your requirement. Data Migration is the process of transferring data from one location to another, one format to another, or one application to another. It is a tough and complex job due to the data gravity. IFS Data migration tool assists to migrate your data overcoming the intricacy of data gravity. It permits you to move data via a system application business logic guarantees that the transferred data is valid at the destination. The tool supports various types of Data Migrations such as File migration and Source Migration. In order to shift data using IFS Data Migration tool, the first step is, you need to create a Migration Job. Migration Jobs In order to begin migrating data adopting IFS Data Migration Tool, one should first create a Migration Job. it is compulsory to create a migration job for all migration types because it comprises of configuration details such as Source, Destination, Type, Metadata, Rules etc. Go to Solution Manager > Data Management > Data Migration > Migration Job form. Here you have a header with details common to all types of migrations and child tabs that enable according to the selected Procedure (Migration type).      Field Description Job Id Unique name to identify the migration job. Only characters, numbers and “_” are allowed for this. allowed for this. Description Description of the Job. Procedure Defines the behaviour/type of migration job. (File Migration, Source Migration). According to the selected procedure, detail tabs will be changed. Direction This is a read only field. The direction values will be changed according to the selected procedure. View Name Enter an IFS view name if you want the source migration job to automatically create a New__ method in the method list. This will populate the File Mapping, Source Mapping and Method List Tabs accordingly. Group ID Migration Jobs can be assigned to a pre-defined group for easy management. Note Text You should always use the note text column to describe the purpose of the job. These will be fetched when printing the documentation of a job. Last Info Displays the log of the last execution. Migration Types Migration jobs can be divided on the way they migrate data. Each type may have different procedures for migrating data. File Migration This type of migration jobs transfers data between the database and files. The data can be imported to a single database logical unit or to a data migration container table (IC Table). You can export the data from multiple logical units to a single file. Source MigrationThis type of migration job can be used to migrate data from one data source to another. The source can be a TABLE, VIEW, JOIN, DB LINK or UNION, while destination can be a single or multiple logical units in the database. Excel Migration This type of migration job can be used to migrate data between Microsoft Excel (using the IFS Excel Add-In) and the database. Data can be both queried from and saved into single or multiple logical units. Internal Replication This type of migration jobs can be used to replicate data within an IFS Application instance. Internal Replication can be configured to replicate data between Sites and Companies in the same IFS Applications instance. Export/Import Migration Definition Use this type when you need to export/import migration jobs between IFS Application instances. Now we talk about our main purpose of writing this blog and that this “IFS Data Migration Using Excel Migration Web Add-In”. So, let’s start data migration using Excel Migration Job step by step. Excel Migration A migration job with procedure type Excel Migration can be executed through MS Excel and an authorized end user could load / manipulate data in the specific logical units related to the given migration job. The IFS Data Migration Excel Add-In uses the Excel Migration procedure type and is an extension to the standard data migration functionality in IFS Cloud. Step #1 Creating a Excel Migration job Go to Solution Manager > Data Management > Data Migration > Migration Job form. In the Migration Job page, create a new job with the Procedure Name to EXCEL_MIGRATION. You must specify a ‘View Name’.    Source Mapping Here add/modify required columns for the migration job. Make sure Pos and Length are not set to 0. Enter a value for the Source Column if you want to display it as an input from the user in Excel. The Source Column names will be used when creating the IC table for migrating data. Note the following restrictions for the Source column: 1. Should not exceed 30 characters. 2. Should not have any duplicates. 3. Should not contain spaces. 4. Should start with a letter. 5. All mandatory fields of the logical unit(s) should have a Source Column value, unless there