Data Migration

Settings: IFS9. Excel in Windows10 environment User has gone to Add-ons menu and selected the following two: To create and update data in IFS Applications using Microsoft Excel you need to install the IFS Data Migration Excel Add-in. As a prerequisite you need to install Visual Studio 2010 Tools for Office Runtime. Next Excel is opened. The new tab IFS Applications is visible. User uses the icon to connect to IFS: Nothing happens. No log in screen is presented. Anyone an idea what could be the issue for this?

Hello IFS Community! I’m assessing a strategy for a legacy ERP migration into a PRODUCTION IFS APPS 10 (UPD16). This is a multi-tenant  instance (many companies are running on this IFS instance). There is already one company operational and I am migrating company #2.My question is this: we are considering two strategiesMigrate this new company (let’s call it, company “A”) into PRODUCTION where the current company (company “B”) is operational. Do the migration and QA work directly in PROD. Once the GO-NO GO decision is made (if GO) then just start using PROD with no further delays. In this approach there is no freeze period for company “B” Migrate this new company in a staging environment that we will clone off PRODUCTION (so all of company’s “B” data is there), freeze PROD during migration (tell users of company “B” site is off-limits for now). Do the migration and QA work there (in staging). Once the GO-NO GO decision is made (if GO) then clone back the staging into PROD and unfreeze

Hello,I receive below error when trying to execute a Excel Migration,Any idea why?

Hi all, We recently implemented IFS Apps 10 beginning of december for our first business unit. I was - together with a collegae - responsible for data migration. As a data warehouse builder I am wondering how we can access the data for other purposes, like reporting. On premise we have a SQL server BI stack. Is it possible for me to access data from the Information Sources? Or is this only possible from the Enterprise Explorer and/or the EOI? Kind regards, Jeroen  

I have one company (not the source one) which does not appear in the Target companies list. How can I include all existing companies in this window?

​Hello everyone,I get an error message when I try to load migration job (detail) or to execute job with my personal user in Cloud:How can I assign this privilege to a user?I cannot find it in the list:Thanks for a feedback.BR,Jan​

I’ve got my source migration job working, but I’m trying to log errors that just show up as unprocessed records. In this case it’s a bad Operation No/ID and you can see in the debugger it can’t find the Objid/Objversion for the routing operation I’m trying to update. Is there a way to flag these rows so the end users can go back and resolve the issue with the source data?     Thanks, Lane

I am trying to migrate Customer_info where the Creation Date is today’s date.  The migration does not like the format:  1000001 ABAN ABRAHAM PTE LTD 11/16/2022 1000001 CUSTOMER United States of America en 1000041 SEADRILL OFFSHORE AS - EUROPE OPERATIONS 11/16/2022 1000041 CUSTOMER United States of America en 1000342 TURKIYE PETROLLERI A.O. 11/16/2022 1000342 CUSTOMER United States of America en 1000457 TRANSOCEAN DRILLING LTD 11/16/2022 1000457 CUSTOMER United States of America en                                                          

Hi, I have customer who is into an Upgrade project from IFS Apps 8 to IFS Cloud.How do we manage the Data Migration of the existing data into IFS Cloud?For Example: We migrate the Inventory Parts, Inventory Stock etc.How about the LotBatchMaster, LotBatch History or Part Serial History windows?Does this needs to be migrated as a part of the Upgrade project?

I have the exact same Excel Migration Job over BUS_OBJ_REPRESENTATIVE in our DEV and TEST environments and they do not perform the same.   The migration job in DEV will perform a modification as expected and return the “Updated” result.The migration job in TEST will not perform the requested update and returns a result of “Business Object Representative already exists”.   of course it exits, I want to update the “Representative Type” associated with the record.We have check all permissions and have no idea what would be causing the difference in functionality.Any help is greatly appreciated. Sincerely,Vince

Please any one can tell what this error mean is. ORA-20110: InventoryPartUnitCost.N-0  

Hi,when sending a HTTP Post request to IFS REST API I get an 400 error as respone.On the IFS Server I see this log message:2023/10/06 06:31:12 [warn] 96#96: *149147568 [lua] cookie.lua:146: bake(): SameSite value must be 'Strict', 'Lax' or 'None' while connecting to upstream, client: x.x.x.x, server: IFS, request: "POST /main/ifsapplications/projection/v1/LocationHandling.svc/LocationSet HTTP/1.1", host: "IFS"The Post request is initiated by our Lobster middleware, using postman everything is working fine. When doing a HTTP Get to request data it is working as epected.Is there some config missing in IFS regarding SameSite cookies or do we have to configure something ob Lobster-side?Thanks,best regards,Nico

Hello,I want to change the structure status from “tentative” to “buildable”. I am using a two step job and I am looking for the right method. I was trying with this one (screenshot), but I get the message that the method is not righT. could you please advise?Thank you!Aleksandra

I am trying to export SRV_REQUEST_CFV using the procedure FNDMIG_EXPORT and when I execute it, it returns an empty file.  I have one record that I have entered into the table, but it is not pulling it.  Any ideas? 

Hi all, Can to convert the status of structures from Tentative to Buildable in one move? Best regards,Ozge

HelloWith the latest version of excel, it seems IFS Excel migration does not work. cloud 23R2 version 

Hi Guys Wondering if someone can help me with a data migration query.Scenario:As a part of Customer data migration, i am also looking to migrate Address types (Pay, Delivery and Document which is coming from view- CUSTOMER_INFO_ADDRESS_TYPE)  Created a migration job to insert new Customers,  Addresses and Address types (third highlighted view as below)  Migration job works fine and creates first default value i.e. Pay   But to pass other two default values (Delivery and Document) I am replacing Pay with other two one- by-one and running the same job few times. Is there any easier way to pass all three value once so that i don’t have to run the same job thrice? Thanks in advance/D

Has anyone seen this error message when loading or validating data for jobs with the Excel addin?  Last week we could load data the COA to the worksheet without error.  This week we are getting the above error for any of the migration jobs.  Office365Aurena  

Does IFS Data Migration Manger have built in Number series functions which can be used in the Input Container as Transformation Rules.For example assume a Customer in the legacy system has multiple addresses.If they do not have Address IDs in the legacy system , how do we generate Address IDs in IFS (Say Address IDs 01,02,03,04,05)

Is there a defined location where we can get the Project Template files for Data Migration Manager for the latest release?  The training says it is recommended to use them, but as Partners I cant see where we would get them from.There is a topic where someone has kindly shared the files for 22r1 But this is now out of date as 23r1 has been released.It would be preferred if these template files were made available in a known place for Partners so we can use them in our Customer Projects.In the meantime, can anyone share the 23r1 Project Template?Gareth

Is there a process to get the system populated with example, demo, or dummy data?We are new to IFS Cloud, and will be starting our implementation process with our partner soon. However, we would like to be able to see what a basic setup would look like.Our prior ERP system had an example database which had the minimal setup with some dummy transactions. This was helpful in exploring functionality not implemented and was helpful to the development process.

We have been attempting to migrate absence data into an environment as a trial for bringing absences in that are registered outside the system. The migration job uses the ABSENCE_REGISTRATION view using the INSERT_OR_UPDATE procedure.  I am experiencing two issues, this is the first. We are able to successfully bring the absences into IFS Cloud however when the value is less than one day (irrespective of the absence type setup being working hours or working days) the system automatically turns absences less than 1 day or less than the scheduled 8 hours into 1 whole day or a full day schedule. The issue we have is that it isn’t uncommon to book less than your scheduled hours yet when we try to migrate data into this view we aren’t able to successfully include a time in the format. Does anyone have experience of a similar migration job where you have encountered the same issue?Things I have tried so farUsing TIME_FROM and TIME_TO but only a date format is being accepted. When you run a r

I have a Migration Job that uses the Excel Add-In and some of the custom fields are linked to views/tables, so I understand that the “_DB” value will be that of the OBJKEY/ROWKEY.  What I don’t understand is why I am receiving an integrity constraint error for NULL entries of the “_DB” columns.  one of my errors: “integrity constraint (IFSAPP.BUSINESS_OPPORTUNITY5_CRK) violated - parent key not found”how can one prevent this for NULL values for non-mandatory custom fields? Sincerely,Vince K.

Hello All,I have created a migration job to export User Grants, but I can’t get the File Mappings to populate.Any thoughts? Thanks,Rob 

Is it possible to delete records from WORK_SCHED_ASSIGN using Data Migration and WORK_SCHED_ASSIGN_API.Remove__   Can anyone please advise how this is done.