Data Migration

This will include topics related to data migration.

  • 410 Topics
  • 1,073 Replies

410 Topics

P
Do Gooder (Customer)
Prince EmmanuelDo Gooder (Customer)
asked in Data Migration

IFS integration

To extract data from IFS, Is the use of ETL like Boomi prevent the use of other mode of Extraction( flat files extraction ) ? that is to say, if i use Boomi to extract data from IFS i cannot do so using flat file in the same time ?

5
Peter Sketch Boomi
Hero (Partner)
1 year ago
G
Sidekick (Partner)
GaSoGBSidekick (Partner)
asked in Data Migration

IFS Cloud 22R1: Data Migration Manager Legacy data files structures

Hi All,When we do Data Migration using old Data Migration tool, we create legacy data file structure based on the Migration job we write.For example assume we need to migrate Customers.In the csv file we define headers as CUSTOMER_ID, NAME,CUSTOMER_CATEGORY,DEFAULT_LANGUAGE etc. based on the DM job column order  and then fill data in csv file  accordingly.Based on new tool ‘Data Migration Manager’ documentation, it looks like we do not need to do this anymore. Instead we can export legacy data into csv files as it is in the legacy system  and then import them into IFS Data Migration manager. After the import it looks like we can map legacy data into target tables as we require.We can also use dblink in order to map legacy data tables into target tables as well. Could someone explain and confirm if my understanding is correct?   

2
G
Sidekick (Partner)
1 year ago
H
Do Gooder (Customer)
HDZSTEPHANIEDo Gooder (Customer)
asked in Data Migration

Getting Failed to initialize job ORA-20110: IntfaceDetail.NODET: No details found for HMH_CUSTOMER_INFO

I am trying to migrate a small customer file (only 4 records for testing) and am getting the following error:  Failed to initialize job ORA-20110: IntfaceDetail.NODET: No details found for HMH_CUSTOMER_INFO Any ideas out there?THanks,Stephanie

4
V
Do Gooder (Customer)
1 year ago
T
Do Gooder (Customer)
ThereBoDo Gooder (Customer)
asked in Data Migration

Excel Data Migration - Date Validation

How can I validate dates entered in an Excel Migration Job (IFS 9)?I have a migration job where the user can modify a date, but if the user enters an invalid date (for exampel giving an invalid month) there is no error thrown (other errors work fine). The record status is “Updated” after execution, even though nothing has been updated.Can to_date() be used? In that case, where should it be placed in the migration job to be executed? Thanks!

2
N
Do Gooder
1 year ago
A
Sidekick
AdarshSidekick
asked in Data Migration

Someone explain about data migration?

Hello All frnds,      Could you explain us different types of data migration in ifs 10.     how can achieved data from .csv,text file into IFS tables.     If  possible then share some docs or screenshot as well. Thanks in advance.

3
M
Do Gooder
1 year ago
E
Sidekick (Customer)
ERPDMORENASidekick (Customer)
asked in Data Migration

Migration Job Create Output File with line breaks

Hi IFS Community,does anyone have a solution to export csv file without line breaks?I’ve seen topics about line breaks for data import but not for data export.I guess we need to replace line breaks with IFS but I can’t do that with the procedure CREATE_OUTPUT_FILE.There is no transformation option on FILE MAPPING tab.Maybe we need to use a rule like CALLEXTPROC (Call external procedure after each row) but I didn’t found information about this.If I have a solution to replace line breaks it will be possible to replace semicolons too and build a clean csv file.Migration Job RULES tabThanks

3
Jens
Hero (Employee)
11 months ago
Thirunavukkarasu Kapilan
Hero (Partner)
Thirunavukkarasu KapilanHero (Partner)
asked in Data Migration

IFS Excel Add-in issue in IFS Cloud

Hi Community, I have tried to add the Excel migration Add-in (IFS Excel Add-in - 21.2.0.2) using both Excel windows client and office 365 web client for IFS Cloud. When I click the IFS Excel Add-in icon in the Excel, I am getting the ADD-IN ERROR.For the window client, I have opened the Excel as ‘Run as  Administrator’. so this is not a privilege issue.  Any idea on how to resolve this issue? Best Regards,Kapilan

4
A
Sidekick (Partner)
7 months ago
V
Do Gooder (Customer)
VT_VKOLBDo Gooder (Customer)
asked in Data Migration

Excel Migration Job - integrity constraint error

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.

6
V
Do Gooder (Customer)
1 year ago
P
Do Gooder
peak0610Do Gooder
asked in Data Migration

Creating an Excel Migration job (IFS Applications 10)

Hi When I try to create an Excel Migration job, I got an error as below. What is the base view. Why the SITE_INVENT_INFO is not a base view.Thanks & RegardsPeak 

3
T
Do Gooder (Partner)
1 year ago
J
Do Gooder (Customer)
jaylee78Do Gooder (Customer)
asked in Data Migration

[AURENA] Does anyone have any experience using REST API? (Powerbi to pull IFS Data)

I’m trying to use PowerBI to pull data from IFS. Someone mentioned that it’s possible through REST API but I have no idea and there are not many materials I can look. Does anyone have any experience using REST API?

1
william.klotz
Superhero (Customer)
1 year ago
O
Sidekick
OzgeSidekick
asked in Data Migration

Status of Structures

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

6
O
Sidekick
2 years ago
C
Sidekick (Partner)
Christophe BUSSISidekick (Partner)
asked in Data Migration

Data Migration on Activity object

Hi Evevybody, We prepare de data migration job to add some project activities. Table is ACTIVITY and a key field is ACTIVITY_SEQ. is it possible to call activity_seq.nextval to init this field ?I test but without success. When I initialize with a numeric value it works but I will prefer use sequence.Regards, Christophe

3
Jens
Hero (Employee)
1 year ago
W
Sidekick (Customer)
washtonSidekick (Customer)
asked in Data Migration

Cannot insert NULL into ("IFSAPP"."PUTAWAY_BIN_TMP"."BAY_ROUTE_ORDER")

Hi,In APPS10, we’re getting this error when trying to perform an inventory movement. Upon checking the inventory location, it appears that it’s because Bay Route Order, Row Route Order and Tier Route Order are NULL.This is odd as the location’s Bay ID, Row ID and Tier ID are populated so I would expect the route orders to have the same value.Bay ID, Row ID, Tier IDBay Route Order, Row Route Order, Tier Route OrderI’m not able to use a migration job to populate these fields as they’re not stored values. Is there a way to almost refresh/re-execute the package methods to update the route order fields with the correct values? The packages used for these fields are:&AO.Warehouse_Bay_API.Get_Route_Order, &AO.Warehouse_Bay_Row_API.Get_Route_Order and &AO.Warehouse_Bay_Tier_API.Get_Route_OrderThis seems to be happening to quite a lot of inventory location records. Any help would be appreciated.

4
M
Do Gooder
1 year ago
A
Do Gooder (Partner)
ArcAleksSDo Gooder (Partner)
asked in Data Migration

Method to change structure status

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

6
J
Do Gooder (Customer)
5 months ago
WSHAH
Do Gooder (Customer)
WSHAHDo Gooder (Customer)
asked in Data Migration

Data Migration Manager

Hi All,How we can use Project basic data setup in DMM and how we can import DMM project export file with any sample data and from where we get DMM project file for importRegards

2
WSHAH
Do Gooder (Customer)
1 year ago
Malan Jayanka
Sidekick (Employee)
Malan JayankaSidekick (Employee)
asked in Data Migration

FNDMIG_EXPORT populate server error when try to export ins file

HiThis is a IFS cloud 22R1 environment. I need to export .ins file of a migration job.I have used FNDMIG_EXPORT.Deployable file is generated. But when I click the “Export to File” button, the it populates an error. Restricted file type.        Url: https://karopharma-cfg.ifs.cloud/main/ifsapplications/projection/v1/ExecuteJobHandling.svc/ExportExecuteJob(IntfaceFile=null,IntfaceName='FNDMIG_EXPORT')        Date = 2022-05-27T12:40:04.539Z        Request Id = 63c800a2-eda1-4a57-a5f3-82205ace9850        Client version = 22.1.1.20220406123110.0 I have exported .txt file without an issue. But can not export .ins fileIs this a permission issue?/Malan Jayanka

2
C
Do Gooder
1 year ago
M
Sidekick (Partner)
mtocaSidekick (Partner)
asked in Data Migration

Data Migration Manager - Connect to external database

Hi,I’m looking into the Data Migration Manager component and am looking for a way to migrate data from an external database into IFS Cloud. I took a look at the online documentation and it mentions that in the process of defining a Migration Project, there is a section where you can connect to an environment using a Database Link, which will be created by Cloud Operations in the application.Does anybody have a guide on how exactly we would create or define this Database Link?If I wanted to connect to an external database for data migration, is using the Database Migration Manager the correct process? If so, how does this process work? If not, what is the correct process?Any insights would be very much appreciated. Thanks!

3
L
Do Gooder (Customer)
11 months ago
N
Do Gooder (Customer)
NielfDo Gooder (Customer)
asked in Data Migration

Export customer address data to Excel - SQL

Hi, I am trying to export at list of customers to Excel. However, I can see that I am limited to these columns fro the customer table:Is i possible, using an advanced SQL query, to include the address columns of Address Identity ‘10’ in the export?  Br,Nielf

2
A
Sidekick (Customer)
1 year ago
C
Do Gooder (Partner)
CSGarethFDo Gooder (Partner)
asked in Data Migration

Migration Project Template files

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

5
Y
Do Gooder (Partner)
5 months ago
srinivas
Sidekick
srinivasSidekick
asked in Data Migration

Working with Excel Data Migration for the screens with multiple views(Master detail Tab Form Window)

How to work with Excel Data Migration for the screens with multiple views(E.g. Master detail Tab Form Window)

2
eqbstal
Superhero (Partner)
3 years ago
T
Do Gooder (Partner)
Tom_LuciferDo Gooder (Partner)
asked in Data Migration

ORA-20105: Dictionary.CLIENTNAME_IS_NULL: Cannot convert the client name [NULL] into a database name.

when executing a migration job (procedure type =insert or update ) i’m getting this error ,i’m using 22r2 version.i have set default values for null values in migration job also can anyone help me to solve this ? 

2
T
Do Gooder (Partner)
1 year ago
S
Sidekick
signilsSidekick
asked in Data Migration

Migration Job field flags

Whats the different between P and K field flags in a migration job?I thought P stood for Primary key?

3
K
Do Gooder (Employee)
1 year ago
G
Sidekick (Partner)
GaSoGBSidekick (Partner)
asked in Data Migration

IFS Cloud 22R1: Data Migration Manager - Number series functions

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)

6
M
Hero (Customer)
1 year ago
A
Do Gooder (Partner)
ArcAleksSDo Gooder (Partner)
asked in Data Migration

Data Migration - Excel Add-In - Purchase Order

Hello,I am trying to update a line in the Purchase Order (view PURCHASE_ORDER_LINE_PART). I want to update a price for several lines at the same time. Every time when I am trying to do that I have the following error message:Entering a new line works perfectly, but the update of existing line doesn’t work. Has anybody encountered the following problem? Is it possible to update the Purchase Line with the Excel Add-In? Thank you in advance,

5
A
Do Gooder (Partner)
6 months ago
P
Do Gooder (Customer)
pknightDo Gooder (Customer)
asked in Data Migration

Table name for field

I am looking to extract the email addresses from user accounts in sqldeveloper but do not know the location of the field.Using version 10It is showing on the create User screen  but system info shows only as Control: textboxEmailWhats this ID: labelEmail.Any help appreciated  

4
Jens
Hero (Employee)
1 year ago

Badges

Show all badges
Terms & ConditionsCookie settings