Hi Team, I am new to IFS Cloud EAM. I am just want to import some of equipment objects into cloud. Could you please help me on the process? I prepare the below sheet using ChatGpt, Not sure if its looks good or not ?
Solved
IFS Cloud Import Equipment Functional Object
+3Best answer by eqbstal
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/).
+3Thanks
+23There are also some tips in IFS Cloud - Next-Generation Service Management demystified (24R2) | IFS Community, chapter Data migration using the Excel Add-in.
+21
+3Hi
+23Did you check the above document, chapter Install the Excel Add-in?
+21
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/).
+3Hi
Thanks
Lokesh
+21
+3I gotch you Thank you :)
+3Hi
I Tried, and I got below error while Migrating from Tem Table. Is there any specific access that I need to give.
Thanks
Lokesh
+21It 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?
+3Hi
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
+21I 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.
+21Are you familiar with debugging the screen? I don't see an obvious reason why this would go wrong. The debug might help you.
+3Hi
Thanks
Thank You So Much
Lokesh
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.