Data Migration

This will include topics related to data migration.

  • 416 Topics
  • 1,081 Replies

416 Topics

eqbstal
Superhero (Partner)
eqbstalSuperhero (Partner)
asked in Data Migration

Excel Data Migration tool

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?

6
M
Do Gooder (Customer)
1 year ago
WSHAH
Do Gooder (Customer)
WSHAHDo Gooder (Customer)
asked in Data Migration

Documents on IFS Data Migration Tool Kit/IFS Smart Data Tool

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

22
J
Sidekick (Partner)
2 years ago
D
Do Gooder (Customer)
dahuuk71Do Gooder (Customer)
published in Data Migration

Single Data Migration job of a Purchase Order

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..  

20339
Guzik
Do Gooder (Customer)
5 months ago
A
Sidekick (Customer)
atvanstSidekick (Customer)
asked in Data Migration

Migration job for API method

When trying to create migration job for method  Invent_Part_Quantity_Util_API.Move_Part and it’s not possible to save the job but you get error :Error making attribute and references - IntfaceMethodList.ILLARGTYPE:Arguement VALIDATE_HU_STRUCT_POSITION_ has illegal type. Only datatype DATE VARCHAR2 NUMBER allowed Same with Inventory_part_in_stock_API.Issue_Part_with_PostingReason seems to be that there are boolean arguments and this is not supported in data migration. Is there a way around this issue?

8
Z
Do Gooder
3 years ago
P
Do Gooder (Customer)
Phan479Do Gooder (Customer)
asked in Data Migration

Access Information Sources

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  

6
P
Do Gooder (Customer)
4 years ago
S
Sidekick (Partner)
SrichandSidekick (Partner)
asked in Data Migration

Cut over strategy

Hi,Can some one provide the steps for Cutover strategy in IFS and what are key points to be noted prior to data migration in Finance. Thanks & Regards,Srichand 

2
N
Hero (Employee)
2 years ago
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.  

2
Tor
Sidekick (Customer)
2 years ago
G
Sidekick (Partner)
GaSoGBSidekick (Partner)
asked in Data Migration

IFS Cloud 22R1: Data Migration Manager Template Project file

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.

16
J
Sidekick (Partner)
5 months ago
R
Superhero (Partner)
RutJWhalenSuperhero (Partner)
asked in Data Migration

Delete records using Data Migration

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.      

6
Z
Do Gooder
3 years ago
Tor
Sidekick (Customer)
TorSidekick (Customer)
asked in Data Migration

Install IFS Data Migration Excel Add-in in IFS Cloud 21R2

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

14
M
Do Gooder (Customer)
1 year ago
S
Sidekick
signilsSidekick
asked in Data Migration

Updating custom fields via migration job

I need to update update a custom field in Inventory_part_cfv at the same time as creating the Inventory part. Under method list, I specified Inventory_part_cfp.CF_New__ and it's of type Migrate Source data that fetches information from an IC table.I am assuming that's not enough because it doesn't update it and throws an error stating ROWKEY cannot be null.What other steps are needed? 

5
ArturasVit
Sidekick (Customer)
6 months ago
M
Do Gooder (Customer)
MDominickDo Gooder (Customer)
asked in Data Migration

Data Migration Error - SE_UNAUTHORIZED Insufficient privileges.

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  

5
M
Do Gooder (Customer)
1 year ago
Nadim
Do Gooder (Partner)
NadimDo Gooder (Partner)
asked in Data Migration

Excel Data Migration Add-in

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.” Do you know what Kind of mistake this is?   Thanks in Advance for your help! Kind regards,  Nadim

9
Nadim
Do Gooder (Partner)
4 years ago
C
Sidekick
CedDinesYSidekick
asked in Data Migration

Data Migration with multiple default values

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

6
A
Superhero (Employee)
3 years ago
A
Sidekick (Customer)
anushakhSidekick (Customer)
asked in Data Migration

data migration in IFS cloud

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.

10
A
Do Gooder (Employee)
1 year ago
R
Superhero (Partner)
RutJWhalenSuperhero (Partner)
asked in Data Migration

Data Migration Documentation

Does anyone have any documentation on IFS Data Migration? Thanking you in advance for your assistance and time. John

5
Yasas Kasthuriarachchi
Superhero (Employee)
3 years ago
STMVALENTINE
Sidekick (Customer)
STMVALENTINESidekick (Customer)
asked in Data Migration

Media Items in Media Library - Mass Import

I am using IFS Apps 9 and would like to know if there is a way to mass import media items (images) in a folder and then associate them with inventory parts.  The images are named by the inventory part number.Could this be a data migration job…?Anyone done this type of import before, or similar?Any help would be appreciated.

4
dsj
Superhero (Partner)
3 years ago
H
Sidekick (Customer)
hazelmsSidekick (Customer)
asked in Data Migration

INSERT OR UPDATE procedure of data migration

Hi,  Currently I’m having the need of updating data daily to inventory_part_planning view. And I was recommended to use INSERT_OR_UPDATE procedure for this. How can I selectively update just for some fields, e.g safety stock, order point? Much appreciated if someone has a user guideline for this type of procedure.   

2
H
Sidekick (Customer)
2 years ago
S
Sidekick (Partner)
Siva Ganesh MSidekick (Partner)
asked in Data Migration

Excel Data Migration Tool

HI there,   Is there any way we can write back the key values to the Excel sheet once the record is inserted or updated in IFS. For Example: A Excel migration job is configured to create a new Work order with data from the excel. Can the newly created Work order number be returned back to excel sheet and displayed against the data line.   Thanks in Advance.   Siva Ganesh M

2
S
Sidekick (Partner)
3 years ago
L
Sidekick (Customer)
LaneSidekick (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 

4
A
Do Gooder
1 year ago
T
Do Gooder (Customer)
todscottaDo Gooder (Customer)
asked in Data Migration

Migrating Data into a Custom Page

I have created a custom logical unit / custom page to add to the Supplier screen as a custom tab.  Is there an easy way to use the data migration tool (DMT) to populate the underlying custom table?  I’ve seen instructions on setting up the DMT to handle custom fields on a standard IFS screen, but this situation is a little different, in my mind, because it isn’t and extension of a standard method.

5
T
Do Gooder (Customer)
4 years ago
G
Do Gooder (Customer)
GOMALISONGDo Gooder (Customer)
asked in Data Migration

Apps 10 - Data Migration Templates for new implementation

We are a company at the start of our IFS implementation journey. Looking for templates for data migration of data across many different modules from our many different legacy systems. I’m aware of the Data Migration Tool to perform the migration, but looking for the templates, along with field help for the users populating the Excel sheet.  Does IFS offer something like this?

3
A
Superhero (Employee)
4 years ago
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 ?   

5
T
Hero (Partner)
2 years ago
A
Sidekick
Abid MujawarSidekick
asked in Data Migration

DATA MIGRATION TOOL EXCEL

Hi There,I am using Attached  excel Data migration tool,After Copying data from Excel, unable to paste in IFS (no Option to paste). it was working fine before OS Upgradation on my DESKTOP. Can somebody help me out please. Warm Regards,Abid 

8
N
Hero (Employee)
3 years ago
T
Do Gooder (Customer)
telamurphyDo Gooder (Customer)
asked in Data Migration

Loading Customer Owned Inventory to new system

We are in the process of implementing IFS10 having previously used IFS2003. Our inventory is customer owned. We want to use data migration to load our WIP (inventory parts in stock) into IFS10 but have come across the restriction that customer owned inventory cannot be received via NREC. So we’re looking at using Purchase Orders but with many tens of thousands of individual serial numbers this seems a big overhead. Is there a recommended way of bulk receiving customer owned inventory?

1
Joel Johnson
Do Gooder (Partner)
4 years ago

Badges

Show all badges
Terms & ConditionsCookie settings