Have a look at IFS Excel Add-in - Technical Documentation For IFS Cloud

Thanks ​@Alexander Heinze for sharing this. I will try to use this Add in and will update you on this channel. Thanks Again. 

There are also some tips in IFS Cloud - Next-Generation Service Management demystified (24R2) | IFS Community, chapter Data migration using the Excel Add-in.

​@lokeshC1990  I looked at the connected file. Seems ok. Most important if loading a structure is to start at the top. Seems obvious, but the migration will fall over the fact that a parent object is not available if not migrated yet. What you can do is set in the migration job that you allow errors to happen. System will try to process the next available csv line. This will give a percentage of good rows and some with an error. Rerunning the migration job will most likely accept the previous errors. When importing bulk load of data, the best is to import the csv in a separate directory (Oracle), which allows background processing, which is not available with the Excel add inn.

Hi ​@Alexander Heinze, I tried to add manifest.xml in excel but Its not allowing me to add any add on in Excel as per below screenshot. Is there any standard  excel file that having these add in included and can be used. 

Did you check the above document, chapter Install the Excel Add-in?

​@lokeshC1990 You may follow the non Excel path as follows:

Open Migration Job and add a new one with
Job ID: FUN_OBJECT_IMP
Description: Import Functional Object
Procedure name to select: CREATE_TABLE_FROM_FILE
View Name: EQUIPMENT_FUNCTIONAL
On tab File Configurations, set the File Location to: OnClient

On the tab File Mapping, select the lines that have a flag that contains an 'M’ (Mandatory field). Also select the rows with flag K/P as these represent the primary/parent key. Give them a position number. This will be the sequence (pos) in which you will have to set up the csv file.

In the tab Rules, add a new row that gets Rule ID: SKIPLINES and Rule Value 1 (we want to have a row in the CSV (the first one) that will contain the column names or descriptions.

Use command Execute Job to see if it is working.
Prepare a csv with the correct number of columns in the correct sequence. Don't overdo here. Three new objects is enough to test this.

Open the Detail Tab and select Load File. An assistant for file selection will open. Once selected, the header and the three rows of information will be shown. You are now ready to use command Start Job > Online. The csv file content has now been retrieved and stored in a temporary file. The name is IC_FUN_OBJECT_IMP_TAB. Prefix is always IC_ and there is a postfix of _TAB. Important to know as there is an Oracle limit to the length of the name of a table. Notice that 3 rows were selected and commited.

Add a new migration job using the following settings:

Open tab Source Mapping.

There is a column with the Default Value. If it contains <MISSING OPTIONAL DEFAULT_VALUE> make sure to use the content of field Db Client Values and use one of the shown values. Use that as the default value and make sure to put the value between single quotes. So N should be entered as ‘N’.

Ok, now that the temporary table is created and filled, start the migration job using the command Execute Job > Execute Job > Online.

If there is an error, it will be shown. In my case I got the error that the OBJ_LEVEL was not filled. Use command Clean Up and return to maintaining the migration job FUN_OBJECT_MIG and make the change to the field in error by giving it a default value. Redo the migration using Start/Execute.

Once you get the hang of these steps, expand the FUN_OBJECT_IMP and the FUN_OBJECT_MIG accordingly (if you add a new field in the first, update the second to map the field against the correct field in EQUIPMENT_FUNCTIONAL view. 

If you are in IFS10, read RMB and find the named option that are in this description mentioned as 'command’.

After this: keep experimenting and make sure to head over to the help text as this helps (search for the ...050_data_migration/070_references/020_tips_and_tricks/).

Hi ​@eqbstal , Thanks for sharing !! Could you please share the template that you used for migration the object. 

Thanks

Lokesh

​@lokeshC1990 Sorry, it doesn't take much time to prepare the settings your self. It took me at most an hour and hey, you may learn from it to?

I gotch you Thank you ​@eqbstal  I’ll try to get it done and will let you know in case of any issue. 

Hi ​@eqbstal, 

I Tried, and I got below error while Migrating from Tem Table. Is there any specific access that I need to give. 

Thanks

Lokesh

It is hard to understand which step you are taking, the loading of data or the migrating? Are there no error messages in the detail tab?

Hi ​@eqbstal - Here is the log while imported and the screen shot that I shared was from Mig Job. 

Start time - 25-JUN-2025 10:22:30 FUN_OBJECT_IMP_LC1 - Execution No 0

READ ONLY GRANTS FOR IFSINFO

   1 rows selected  

   1 rows committed  

   0 rows failed  

Used 0 hours and 0 minutes
Average of 60 rows per minute

Created table IC_FUN_OBJECT_IMP_LC1_TAB (
MCH_CODE VARCHAR2(100),
MCH_NAME VARCHAR2(200),
OBJ_LEVEL VARCHAR2(30),
CONTRACT VARCHAR2(5),
IC_ROW_NO NUMBER)

File Path:
File Name:
File Location: OnClient

Used 0 hours and 0 minutes

End time - 25-JUN-2025 10:22:30 FUN_OBJECT_IMP_LC1

I take it that you have write access (all access to EQUIPMENT_FUNCTIONAL). If not, that might be the problem. Else try to see if the used SQL statement is ok. Open the mig job FUN_OBJECT_MIG_LC1. See the command Show Select Statement. Does it come back with an error or does it state 'Select statement IK, parsed and executed...’?

On tab Method List, are columns New and Modify equal to Yes?

I see that you used different names for the migration jobs. The actual source migration is even FUN_OBJECT_MIG_LC1_TAB. The postfix _TAB does add nothing. TAB is the default Oracle naming convention that a table is being used. Most likely this doesn't have to create the error.

Hi ​@eqbstal : Sql statement showing passed and executed. Also New & Modify equal to Y.

Are you familiar with debugging the screen? I don't see an obvious reason why this would go wrong. The debug might help you.

Hi ​@eqbstal , I am new to IFS so m not sure about the debugging the screen . 

Thanks 

Hi ​@eqbstal , It worked now. It was getting error  due to Object Id - Error. I was passing it into small case. Thank you for sharing the approach.

Thanks ​@Alexander Heinze  - For Sharing information related to Excel Add In - I will try to use excel loader as well for my master data migration. 

Thank You So Much ​@IFS Community  for providing this platform.

Lokesh