Data Migration

467 Topics

matkarDo Gooder (Customer)

Parameters in Data Migration where clause?

Hi!Does anyone know if it’s possible to use any kind of input parameters in a Data Migration where clause? In case you want to run the same job multiple times but using different input parameters without the need of edit the where clause statements every time..\Mats

3 years ago

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.

3 years ago

evrpatrinDo Gooder (Partner)

asked in Data Migration

Excel Data Migration Tool

Hi,I’ve used Excel Data Migration Tool before. But now I got this problem that when I try Validate or Execute, Excel-Add-In reads everything to the first column. I have a simple example with 2 columns A and B. But Excel-Add-In reads both column A and B to the first column. So the value for column A is getting to long and the value for column B is left empty.Is there some configuration for this. Thankful for ideas.BR,Patric

3 years ago

BartMaasDo Gooder (Partner)

asked in Data Migration

Migration of Closed Purchase Orders

Hi all, I received the below question from one of our APPS8 customers. They want to migrate closed PO's from their old ERP system into APPS8 (Customer recently aqcuisitioned new business).. My idea was to migrate the PO's with No Parts instead of Part lines, but I'd like to double check with the community!-------------------------------The question is if there is a way to migrate closed POs and what is the impact to postings. We will only go for a migration of No Part POs. If we are migrating POs with the status closed is there a posting connected to the status? Is this on kicking of the system functionality of posting a GRNI? If there is no posting linked to the status in the data migration, how is the matching of the invoice to the PO working? We will post an opening balance in IFS which is the closing balance of the old system. In this one we have the GRNI amount from the closed POs of the old system. So now we need to reduce this balance when we match an invoice to the closed PO wh

3 years ago

sttSidekick (Customer)

asked in Data Migration

webinar video access

How can access below webinar video?https://community.ifs.com/events/ifs-apps-10-ifs-data-migration-excel-add-in-overview-demo-20

3 years ago

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?

3 years ago

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

4 years ago

alanbclarkSidekick (Partner)

asked in Data Migration

Does any have a set of Apps 10 data migration jobs for IFS 2004 data?

I am setting up a data migration project for a client running IFS 2004 migrating into Apps 10 UPD8. In the Apps 10 database I have created local VIEWs in a separate schema named IFS2004 using a database link to their IFS 2004 database. This makes it easy to use the FNDMIG input of using a VIEW/TABLE as the data source. Its fast and easy. Does anyone have any pre-built data migration (FNDMIG) jobs for customers, suppliers, etc. that you can export and share (PL/SQL format preferred please)? Your assistance will keep me from having to re-invent the wheel. Thank you for your help!

4 years ago

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

4 years ago

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)

4 years ago

chrisellistonSidekick (Partner)

asked in Data Migration

Excel Data Migration - Dates

When using the Excel Data Migration Add-in if any fields contain dates IFS brings them into Excel in the form DD/MM/YYYY HH:MI:SS. If you do nothing and try to Validate the row, the result column seems to insist that the field doesn’t contain anything (if mandatory). If you click in the field and then out again Excel re-presents the field as YY/MM/YYYY HH:MI and right aligns it. It then validates ok. Obviously if you have a lot of records you can’t click in every field to ensure the formatting corrects itself. Does anyone know how to solve this ?

4 years ago

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

4 years ago

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.

4 years ago

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?

4 years ago

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

4 years ago

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?

4 years ago

LaneSidekick (Customer)

asked in Data Migration

Source Data Migration silent errors

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

4 years ago

Page 19 / 19

Badges

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded