Skip to main content

Data Migration

This will include topics related to data migration.

  • 615 Topics
  • 1,520 Replies
615 Topics
L
Hero (Customer)
LaneHero (Customer)
asked in Data Migration
Source Data Migration with Function Calls

At the end of the year we update our labor times on the routings from spreadsheets that are based on actual clockings during the prior year. I was trying to setup migration jobs to handle the entry back into IFS and I’m hitting  a road block on it. Probably missing something trivial. The input file has the site, part number, operation no and the new labor run time. I need to use functions to find the latest revision and to convert the operation no to operation id. From what I’m seeing in the debugger it looks like it isn’t saving the function call results. Below is the setup for the Source Migration job. Thanks in advance for any help with this,-Lane Source Mapping​​​​​Method List Method List Attribute 10Method List Attribute 20Method List Attribute 30 

7324
A
Do Gooder
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?

2911
william.klotz
Superhero (Customer)
ttzeleznik
Sidekick (Customer)
ttzeleznikSidekick (Customer)
asked in Data Migration
Migration User is DB Login while IFS is Set For SSO

Hello Community,Question:  how can I “Connect” in Excel when the Excel user is Local and the IFS instance is set to SSO?  That is, the Excel user’s Dir ID does not include the “@domain.com”.  Thanks,  Troy

450
ttzeleznik
Sidekick (Customer)
M
Sidekick (Customer)
MatthewSidekick (Customer)
asked in Data Migration
Migration Job - Export to none-DB machine

Hi, Has anyone managed to get an IFS Migration Job (we are Apps 9 but interested in other versions) to export a file directly to a machine other than the DB Machine?Thanks, Matt

2042
M
Sidekick (Customer)
J
Do Gooder (Customer)
jpartanenDo Gooder (Customer)
asked in Data Migration
Inventory part replication job

 Hello,How to include multiple views on replication job? We have already replication job that replicates item data from one site to another sites. There’s only INVENTORY.PART view included in this replication job and it’s working, but now there’s also need to include PART_REVISION data to this same replication but I cannot figure out how this can be achieved. Here’s the original replication job with only one view. This works ok.  Here’s how I have tried to create new replication job with two views. INVENTORY_PART and PART_REVISION. Firstrly I’m not sure how should I use the “Source Name” field. I guess I should use join clause here but not sure how should I format it. I have tried with these guides but with no success..Internal Replication (ifs.com)Db-Links, JOINS (ifs.com)Replication tab of the new replication job Source Mapping tab:And Method list 

1730
J
Do Gooder (Customer)
B
Sidekick (Customer)
bldrayiSidekick (Customer)
asked in Data Migration
New Company Creation Error

After company Creation from an existing company it gave in the log the following error  using IFS10 with UPD11:ORA-20111: UserFinance.RECNOTEXIST: Access denied! User IFSAPP is not connected to Company KSA022what id the reason and how it can be rectified?Best Regards,Bilal Drayi

5583
E
Sidekick (Customer)
R
Hero (Customer)
ronhuHero (Customer)
asked in Data Migration
The Intface Group does not exist

Community, i have this error when creating a migration job, may I know what I did wrong? Thank you.

1262
R
Hero (Customer)
D
Do Gooder (Customer)
DHPCALBRECHTDo Gooder (Customer)
asked in Data Migration
Supplier Company Migration

I have been doing these migrations for some time now and never have had an issue where I get no information to migrate.  I am getting not 1 record going into IFS and I just get Not Processed.  Can someone lead me to where I can understand why none of these MTK_SUPPLIER_COMPANY_TAB records are not being migrated.  

650
D
Do Gooder (Customer)
WSHAH
Do Gooder (Customer)
WSHAHDo Gooder (Customer)
asked in Data Migration
Data Migration Job Takes time

HiData Migration Job Takes much time, I have to Migrate more than 10 hundred thousand data.For data of 44 Thousands rows/records  job will take time more than 150 minutes.Kindly advise

1812
WSHAH
Do Gooder (Customer)
udenig
Do Gooder (Partner)
udenigDo Gooder (Partner)
asked in Data Migration
Can Data Migration Tool (APP10) support CLOB Data Type?

Customer needs to create Quick Reports through Data Migration Tool and need to specify the Query column which is a CLOB type, here it won’t allow.  Is there a way to migrate the CLOB data type? 

1391
M
Hero (Employee)
K
Hero (Customer)
KIMKIMANDREWHero (Customer)
asked in Data Migration
Calling an API in DataMig to schedule background job

I am trying to write a two part DataMig (MS_FORECAST_FILE to load the data then MS_FORECAST_MIG to schedule the import for each part) to load data using:level_1_forecast_util_api.Schedule_Import_Forecast  The first job to load the data works fine and I get an IC table ready for the 2nd DataMig job.To test the SQL code for the ATTR values to pass to the API call, I have a working PL/SQL cursor...begin  for ic in (select * FROM IC_MS_FORECAST_FILE IC) loop    level_1_forecast_util_api.Schedule_Import_Forecast__('CONTRACT' ||                                                         CHR(31) ||                                                         IC.CONTRACT ||                                                         CHR(30) ||                                                         'PART_NO' ||                                                         CHR(31) ||                                                         IC.PART_NO ||                                                         CHR(

2100
K
Hero (Customer)
N
Do Gooder (Customer)
NewbieCoderDo Gooder (Customer)
asked in Data Migration
How to export information source for QIS Importing

Hello, I am wondering if I am able to export current information source in business reporter and import to QIS for a duplicate source with additional information. I tried the export of original information source as .ins and .xml. When I import however to QIS it does not read the .ins and errors the .xml file.

830
N
Do Gooder (Customer)
S
Do Gooder (Partner)
SandyDo Gooder (Partner)
asked in Data Migration
Connect External Customer invoice with Customer Order

The standard customer invoice templates facilitate to load advance customer invoices. Can they be connected with the customer order number when loading? The reference fields can be used but it will not connect the customer invoice with the customer order.

890
S
Do Gooder (Partner)
I
Do Gooder (Partner)
israelolDo Gooder (Partner)
asked in Data Migration
Error of Insufficient Privilege while spooling IFS report to excel

Please I am having this IFS error of insufficient privilege while spooling report to excel, and the select privileges on the table have been granted already. This spools correctly when a normal report is run, but fails when I choose Export to ExcelError message: "Excel Plugin Error: ORA-06550: line 11, column 26: PL/SQL: ORA-01031: insufficient privileges"  

2122
I
Do Gooder (Partner)
W
Do Gooder (Customer)
WHAPOLDFIELDDo Gooder (Customer)
asked in Data Migration
System set up for shortages.

does anyone know where the system set up is for shortages? , getting following error when trying to load inventory parts - ORA-20110: InventoryPart.NOSHORTAGEHANDLE: Cannot have shortages at part level if System flag is set to No.

1842
W
Do Gooder (Customer)
A
Do Gooder (Customer)
aweDo Gooder (Customer)
asked in Data Migration
Use IFSAPP log in Excel Plug in with SSO enabled

Hi!How can we log in to Excel plug in using IFSAPP when we have SSO enabled? non of the checkboxes in the picture makes any differences.Best regardsAlbin 

1812
A
Do Gooder (Customer)
A
Sidekick
Amitesh_IFSSidekick
asked in Data Migration
migration job with multiple method list

Hi,Is there any way we can achive the below through migration ? I have 2 method calls in method list Method1Method2how can we use the out parameter from Method1 is and use the same in Method2 ? Thanks in AdvanceAmitesh

5872
A
Sidekick
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

3176
O
Sidekick
A
Do Gooder (Employee)
amithelaooDo Gooder (Employee)
asked in Data Migration
Data Migration for a live project

I have the below Data Migration query from a customer and I wanted to check if there is a standard guidance for this? When a customer goes live half way through an active project which was more than one or two years what is the best mechanism for data migration. -App10 I want to confirm which all connections the customer would need to consider to migrate (Sub Contracts, Sales Contracts, Purchase Orders, etc) and how can they manage open PO’s, Sub contracts? How would you recommend to move the Used/Actual cost? Assuming they wouldn't need detailed historical transactions, would it recommended to create Cutover activities and bring in the values in this new activity? Anything else they would need to consider before they start with this process?

1510
A
Do Gooder (Employee)
XitJeyadR
Do Gooder (Partner)
XitJeyadRDo Gooder (Partner)
asked in Data Migration
Data migration for a new implementation in Projects Module

When a customer wants to implement Project Module for the first time, how can they bring in closed POs, Invoiced time transactions, other project transactions to reflect the actual and used costs in the project?

740
XitJeyadR
Do Gooder (Partner)
arebbeadle
Hero (Customer)
arebbeadleHero (Customer)
asked in Data Migration
How to use Excel Data Migration with Referenced fields

I want to import data into a custom logical unit using Excel Data Migration but one of the fields is a Referenced fields?Data sample to import.Custom object to import into.  Referenced object Migration Job. Error when I try to execute.integrity constraint (IFSAPP.ARE_WATER_JET_PART_GRP1_CRK) violated - parent key not found  Can this be done?  How should I setup?  I think I need to get the OBJKEY for the referenced field?Need help. Thank you,

4091
Technical Outlaws
Hero (Employee)
C
Sidekick (Partner)
Christophe BUSSISidekick (Partner)
asked in Data Migration
Excel Data Migration install issue

Hi, We use 21R2 on IFS Cloud and try to use Excel Data Miogration.I downloaded Excel DataMigr Manifest from IFS but when I try to import it in Excel  I have a certificat error.Do you an idea about this ? Regards, Christophe

3316
Jens
Hero (Employee)
P
Do Gooder (Partner)
Peroni79Do Gooder (Partner)
asked in Data Migration
detailed data migration steps

Where can I find detailed information on how to perform data migration end to end. There is not much detail at this location: https://docs.ifs.com/techdocs/Foundation1/010_overview/260_data_management/010_fndmig/default.htm

2042
Randini Jayasundara
Superhero (Employee)
Tor
Sidekick (Customer)
TorSidekick (Customer)
asked in Data Migration
Insufficient privileges, "SE_UNAUTHORIZED" - Can't Load data using the IFS Data Migration Excel Add-in

We have created a manifest (xml) from our test environment (IFS Cloud 21R2). Manifest is added to Excel successfully and the user can log on and load the FNDMIG job itself. But when trying to load the data this error occurs: Insufficient privileges, "SE_UNAUTHORIZED".The user has full grants in the instance.  

17592
Tor
Sidekick (Customer)
T
Sidekick
Tj12Sidekick
asked in Data Migration
Data Migration Excel Add-in 

Re Data Migration Excel Add-in  Do we need to buy a separate license to use this ?   

5735
T
Hero (Partner)

Badges

Show all badges
Terms & ConditionsCookie settings