Data Migration

We are on IFS Cloud 25.1.2.  Microsoft just forced updated Office to 2507 (19029.20136) which broke our IFS Excel add-ins.  Users that stayed on 2506 are still OK.Issue is, when you click login, the add-in panel briefly flashes and does not bring up the login window for IFS cloud.Anyone else have this issue? 

Data Migration Tool Kit (Have been majorly used in US side)IFS Smart Data Tool (New Migration Tool Launched around 2 months ago)

Hi All,When migrating users, I get a strange result in the Description field.  Instead of the User Name, I get the contents of all the fields:I also can’t get the Web_User to populate into the User Email field 

Hello,I’m preparing a CREATE_TABLE_FROM_FILE migration job to upload data in EMPLOYEE_ACCESS_SUP.Looking at the proposed File Mapping, I was surprised by the column list which is pre-set : SUPERVISOR_BU_TYPE_DBVALID_FROMVALID_TOTRANS_FROMTRANS_TOGENERAL_ACCESSORG_CODERELATION_IDINCLUDE_SUBWhen I try the SQL command :select * from EMPLOYEE_ACCESS_SUPI get a list of columns that makes much more sens, 28 columns, such as :Org Bu IdSupervisor Person IdSupervisor Company IdSupervisor Emp NoSupervisor Bu Type DbSupervisor Bu TypeEmp Company IdEmp NoEmp Bu IdEmp Pos CodeAccess RoleValid FromValid ToTrans FromTrans ToGeneral AccessOrg Bu TypeOrg CodeEmployee GroupPerson GroupRelation IdSupervisor Relation IdSupervisor Pos Code

Import fixed asset is not working properly.  Below is the test plan:Create an FA object with valid from date 8/30/2016, assigned to an object group with SL BP for 7y0m. Import the object with acc. Depreciation value for year 2022, period 12. Post the import transactions. Create a new depreciation proposal for the object above for year 2023, period 1, review the proposal, you will notice the depreciation will fully depreciate the object with the remaining residual value.  That is incorrect.  The object should still have another 8 months to depreciate. If you would like to review our data, object id TEST2 is done via external template, object id TEST3 is created in the system, both with the same issue.  The testing data is on my UAT database (URL: IFS Cloud). We are currently on IFS Apps 8 but not using the fi

Hi All, From where can I find IFS Cloud 22R1 Template Project file for Data Migration Manager?  I am new to Data Migration Manager and my idea is to create a Project Template and load a pre-built Template file copied into DM server location , drill down into details of the project and understand how it is set up instead of creating a Data Migration Project from scratch.

Hello, I would like to know whether there is a functionality to “delete” data by using data migration:Let me explain:Data has been integrated in IFS using data migrationThe client wants to delete and update a new list of data. Is it possible to “delete” data by using data migration. Thanking you for your feedback.

Hi, We have followed the instruction to install the IFS Data Migration Excel Add-in (https://docs.ifs.com/techdocs/21r2/020_installation/400_installation_options/010_data_management/030_data_migration/) but I do not seem to be able to deploy the manifest in Excel in a “Normal” Excel client. Does this only work in the web client? /Tor

Hello, I have a VPN to the IFS cloud. Now I have noticed that the Select does not show any data on many VIEWS, although data is available there according to the IFS quick report.CUSTOMER_INFO: works fine PURCHASE_ORDER: no Data In IFS-Quickreport i can select all Purchase Orders ! Is there a reason and solution so that I can see data from all VIEWS that I select via Qracle SQL Developer and not just the column names?I have already written the IFSAPP in front of the VIEW names.Thanks for your helpGreetingsMarkus

Hello, I'm Markus and I'm new here in this community, and this is my first post.One of my tasks is to prepare the master data from the old ERP and migrate it to the IFS cloud. Of course, a lot of mapping is necessary, as we don't have this many columns and tables in the old ERP.I learned from our consulting to use these data migration tools: Migration Job for LOAD and for MIGI have a VPN to the IFS cloud and can select the data VIEWS via ORACLE SQL Developer to reconcile the column names and fields for the migration job files or to build the mapping for this.Is there a best practice for the migration of master datafrom our old ERP to our IFS cloud?Thank you very much for your knowledgeGreetingsMarkus 

Hey everybody, I am trying to set up an Excel Migration Job for with custom fields. Unfortunately it doesn´t work. Without the CFs I am able to upload data in the master. With the CFs it seems to work (validation and execution works without errors), but the record set doesn´t update. I am curious if someone of you faced the same issue. Name and Cepi have been updated. Validation looks good.After execution it looks also good.

Anyone have luck using a Post Deployment process to change Routing Alternate or Product Structure Alternate from Tentative to Buildable in Data Migration Manager? I’m trying ROUTING_ALTERNATE_API.BUILD_ in this example. I can’t get it to fire off, no matter what settings I try. The Customer Order Status change is very straightforward in comparison, just requiring the ORDER_NO. I’m wondering if it has something to do with the migration not actually filling anything in for the OBJID or OBJVERSION. No idea what should go in the ATTR or ACTION sections. 

Hi, This is my first time to use Data Migration/Execute Job function.When I did that, received the following error message.Where should I check for this?"interfaceDetail.NODET:No details found" Thanks!Kind regards,Kokubo

Hey, I am trying to fix a broken excel migration job, but it keeps throwing the following error:Expected ',' or '}' after property value in JSON at position 222 (line 1 column 223) My issue is that I don’t know how I can check what the JSON file looks like that is created from the Excel file. Is there a way to see that, perhaps inside the debugger?Please let me know if you need more information regarding this problem to better understand.Thank you for your assistance in advance!

Hi,I am trying to complete the task to Define Installed Environment after completing the Basic Project Data for a Data migration job. I am however getting the below error; How can I change the Thousand Separator Format value? 

How can the data be migrated into IFS cloud? Like we want to migrate some companies/sites/their users/service requests from legacy system to IFS cloud.

As I’m learning Data Migration Manager I have created a few projects. For a couple of them, while Mapping Legacy Tables to Migration Object there has not been any Target Tables available in the Smart Mapping assistant and I have had a hard time figuring out why. Am I missing any setup? What are the requirements for Target Tables to be available for Smart Mapping? 

Hi, We have requirement to create Work Order and Work Task using Create Table from flat file and then MIGRATE Source Data.We are able to create the Work Order but unable to get the WO_NO (system generated) in order to create the Work Task. There is no getter function to get the WO_NO in ACTIVE_SEPARATE_APIAny help would really appreciated.Thanks,Nishith

Dear Community, I want to connect Excel with IFS - My question is, what address have I to put in the field of "Connect to"?   I have tried it with a Link of the Citrix-Race: https://erldemoa10i2.corpnet.ifsworld.com:48080/I also tried with a Link of an customer: https://exdaswvc08167.asysdaas.de:48080/ But after I press on OK an error message open with the notice: “The remote name could not be resolved.”

Hi Community, I want to create a migration Job which calls the procedure Confirm_Alternates from Engineering Transfer_API view. The Parameter Structure_rec_ is a variable for the above procedure Can anyone help me on how to use this as a parameter in migration job?Best Regards,Thean

Hi -  I can create 2 data migration jobs to create a Purchase Order. - One to create the header and one to create the lines. I am looking to create a single Migrate Source Data DM Job to create header  and lines based on an imported table of data. So the stage 1 imported Data would be simplified as something like.. Supplier Part No Qty  Stage 2 to Create a PO for the distinct list of Suppliers and then create the attached lines Anyone think this is possible without custom code? Thanks for looking..  

Dear Community, @Jens (you're a DMM guru I've been told ;))When using in Cloud 22R1 the Data Migration Manager, deploying the object Suppliers [SUPPLIER_GENERAL_INFO], we face an error when the output container is deployed, during the deployment: "Field [ON_NEW] is mandatory for Deploy Definition Attributes and requires a value.”In the target table definition this field ON_NEW is not available. Has anyone seen this error before and has a solution to fix it? At the moment we can't deploy the data to the target environment.  

We’re getting this error when updating a custom field in Customer_Info_Cfv created/added at data migration.It’s a simple update with just the CustomerNo and the new custom field, MS Set.Any ideas what to correct?     

Hello Ifs communityI have created migration job to load data in Part Based tab for sales price list page.Lines are inserted but when i want to deleted or updated it i get this errorAnd when i try to modify one column of this line insert through migration job i had this error message :but I have no problem deleting or modifying manually created lines. I only have this problem for lines loaded via data mig job.This is my migration job source mapping : thank you in advance for your help.  Regards.  

Hi All, Can anyone share Data Migration Manager> Template Project file for 23R2 and if you have 24R1 as well?