Data Migration

This will include topics related to data migration.

  • 409 Topics
  • 1,071 Replies

409 Topics

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
rfedorchuk
Sidekick (Customer)
rfedorchukSidekick (Customer)
asked in Data Migration

Strange result when migrating users

Hi All,When migrating users, I get a strange result in the Description field.  Instead of the User Name, I get the contents of all the fields:I also can’t get the Web_User to populate into the User Email field 

17
rfedorchuk
Sidekick (Customer)
2 months 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
T
Do Gooder (Customer)
Thomas RebmanDo Gooder (Customer)
asked in Data Migration

Is there an issue with the fixed assets import?

Import fixed asset is not working properly.  Below is the test plan:Create an FA object with valid from date 8/30/2016, assigned to an object group with SL BP for 7y0m. Import the object with acc. Depreciation value for year 2022, period 12. Post the import transactions. Create a new depreciation proposal for the object above for year 2023, period 1, review the proposal, you will notice the depreciation will fully depreciate the object with the remaining residual value.  That is incorrect.  The object should still have another 8 months to depreciate. If you would like to review our data, object id TEST2 is done via external template, object id TEST3 is created in the system, both with the same issue.  The testing data is on my UAT database (URL: IFS Cloud). We are currently on IFS Apps 8 but not using the fixed assets module.  

16
G
Superhero (Partner)
1 year 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
P
Do Gooder (Customer)
Peter SuhajdaDo Gooder (Customer)
asked in Data Migration

How to see the JSON file for an Excel Migration Job?

Hey, I am trying to fix a broken excel migration job, but it keeps throwing the following error:Expected ',' or '}' after property value in JSON at position 222 (line 1 column 223) My issue is that I don’t know how I can check what the JSON file looks like that is created from the Excel file. Is there a way to see that, perhaps inside the debugger?Please let me know if you need more information regarding this problem to better understand.Thank you for your assistance in advance!

11
P
Do Gooder (Customer)
1 month ago
J
Do Gooder (Partner)
Johannes KopferDo Gooder (Partner)
asked in Data Migration

Excel AddIn in IFS Cloud 23R1 SU5 with Custom Fields

Hey everybody, I am trying to set up an Excel Migration Job for with custom fields. Unfortunately it doesn´t work. Without the CFs I am able to upload data in the master. With the CFs it seems to work (validation and execution works without errors), but the record set doesn´t update. I am curious if someone of you faced the same issue. Name and Cepi have been updated. Validation looks good.After execution it looks also good.The fields in IFS aren´t updated. Without the custom field data is updated.    Thank you in advance, Johannes

11
Nirogini Janstin
Do Gooder (Employee)
6 months ago
C
Do Gooder (Partner)
CheHiroyKDo Gooder (Partner)
asked in Data Migration

Data Migration/Execute Job function error message

Hi, This is my first time to use Data Migration/Execute Job function.When I did that, received the following error message.Where should I check for this?"interfaceDetail.NODET:No details found" Thanks!Kind regards,Kokubo

11
AkilaR
Hero (Partner)
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
jascoetsee
Do Gooder (Partner)
jascoetseeDo Gooder (Partner)
asked in Data Migration

Data Migration Manager - Define Installed Environment

Hi,I am trying to complete the task to Define Installed Environment after completing the Basic Project Data for a Data migration job. I am however getting the below error; How can I change the Thousand Separator Format value? 

10
jascoetsee
Do Gooder (Partner)
6 months ago
StephanS
Sidekick (Partner)
StephanSSidekick (Partner)
asked in Data Migration

Error: Field [ON_NEW] is mandatory for Deploy Definition Attributes and requires a value.

Dear Community, @Jens (you're a DMM guru I've been told ;))When using in Cloud 22R1 the Data Migration Manager, deploying the object Suppliers [SUPPLIER_GENERAL_INFO], we face an error when the output container is deployed, during the deployment: "Field [ON_NEW] is mandatory for Deploy Definition Attributes and requires a value.”In the target table definition this field ON_NEW is not available. Has anyone seen this error before and has a solution to fix it? At the moment we can't deploy the data to the target environment.  

9
D
Do Gooder (Customer)
3 months ago
D
Sidekick (Customer)
DevBobSidekick (Customer)
asked in Data Migration

Migrate Job: Execution Error...

We’re getting this error when updating a custom field in Customer_Info_Cfv created/added at data migration.It’s a simple update with just the CustomerNo and the new custom field, MS Set.Any ideas what to correct?     

9
D
Sidekick (Customer)
3 years 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
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..  

19959
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
A
Sidekick (Partner)
ArcElhadCSidekick (Partner)
asked in Data Migration

ERROR - ODP_RESOURCE_NOTFOUND - (ODP_RESOURCE_NOTFOUND Error): Object has already been deleted by another user. Resource not found.

Hello Ifs communityI have created migration job to load data in Part Based tab for sales price list page.Lines are inserted but when i want to deleted or updated it i get this errorAnd when i try to modify one column of this line insert through migration job i had this error message :but I have no problem deleting or modifying manually created lines. I only have this problem for lines loaded via data mig job.This is my migration job source mapping : thank you in advance for your help.  Regards.  

8
A
Sidekick (Partner)
22 days 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
C
Do Gooder (Customer)
CherylLausDo Gooder (Customer)
asked in Data Migration

Data Migration Manager Legacy Table joins

Just starting out with DMM in IFS Cloud 22R2. I need to pull data from two tables into one target table. The documentation indicates how legacy tables are joined is important but gives no information on how to do this.Somehow this worked when there were two legacy tables with the same key simply by identifying the keys on the Legacy Table definitions.In this new situation, there are three tables involved and I need data from tables T1 & T3. T1 and T2 have the same key. I labeled them Key 1 & 2.T2 and T3 are linked by a different field. I tried labeling these as Key 3, but that did not work.Is this possible to do and if so how?  

8
Nirogini Janstin
Do Gooder (Employee)
6 months ago
K
Sidekick (Partner)
ksebfSidekick (Partner)
asked in Data Migration

Data migration : Can I automatically pick the next customer order number

I'd like to wish you all a very happy new year. I'm creating migration jobs for customer orders where I'd like them to retrieve as much information as possible automatically. At the moment, I only have 3 mandatory pieces of information to enter.   I'd like the order number to be entered automatically, based on the last existing order number. Is this possible? Where do I enter it? For the example, my last order number is "S23000005957".I'd like the order number to be automatically set to "S23000005958" when I run my job, and for the countdown to take place naturally. If I manually recreate an order, my number should be "S23000005959".

7
Jens
Hero (Employee)
2 months ago
D
Hero (Employee)
Devni PanduwawalaHero (Employee)
asked in Data Migration

Migration job for CONTRACT_ITEM fails with an error

When the Migration job is executed, error “ORA-20110: ContractItem.CONSALESVALUEREQD: The Sales Value must have a value since Calculation Type is Sales Value and Calculation Method is Fixed.” occurs.The purpose of this migration job is to allow us to insert data from the user defined table to contract_item_tab. A similar error has been reported here.However, the procedure name used in the current example is MIGRATE_SOURCE_DATA and not procedure INSERT_BY METHOD_NEW  IFS Aurena framework version: 22.1.10.20221205084017.0IFS Aurena client version: 22.1.10.20221205084017.0 Kindly assist in identifying the root cause of this error.

7
D
Hero (Employee)
11 months ago
S
Do Gooder (Customer)
SPRRAJDo Gooder (Customer)
asked in Data Migration

Data Migration

My Migration Job based on procedure “CREATE_TABLE_FROM_FILE” is not able to load data into the IC/TEMP table from a file holding more than 1 million records. Is there a limitation in IFS Cloud to handle the number of records during Data Migration?

7
S
Do Gooder (Customer)
10 months ago
Disna Marakkala
Sidekick (Employee)
Disna MarakkalaSidekick (Employee)
asked in Data Migration

DMM Error when updating WORK_SCHED_ASSIGN in the Deployment container

hi All,I can insert or update the schedule in Employee schedule from IFS client , but I can only insert a record in WORK_SCHED_ASSIGN using DMM and update will give an error at the deployment container.My requirement is to use DMM tool to update the schedule from C to B in below IFS window. the CSV file is attached and it looks like : at the deployment container I get below error and the record did not get updated.Method NEW failed : ORA-20110: WorkSchedAssign.INSOVERLAP: Overlapping date intervals. Has anyone used DMM tool to update schedule in WORK_SCHED_ASSIGN?Does anyone know why I am getting below error and how to resolve this?Or is this a limitation in DMM? Thank you! 

7
C
Do Gooder (Employee)
6 months ago
M
Sidekick (Customer)
Magdalena KasjaniukSidekick (Customer)
asked in Data Migration

migration the charges to PURCHASE_CHARGE_SUPPLIER

Hi, I migrated the charges to PURCHASE_CHARGE_SUPPLIER, but I received error message:“ORA-20124: PurchaseChargeSupplier.FORMAT2: Field [DISTRIBUTE_ON_RECEIPT] in Purchase Charge Supplier has an invalid value format. The value is: "FALSE".” File string : 102517;3D;CLO;1;0;1;;;102517;;;23;;;;;;;;FALSE;FALSE;0Attribute string:VENDOR_NO=102517CONTRACT=3DCHARGE_TYPE=CLOSEQ_NO=1CHARGE_AMOUNT=0CHARGED_QTY=1PRINT_PURCHASE_CHARGE=PRINT_PURCHASE_CHARGE_DB=PRINTCHARGE_BY_SUPPLIER=102517DISTRIBUTE_CHARGE_BY=DISTRIBUTE_CHARGE_BY_DB=FEE_CODE=23INTRASTAT_EXEMPT=INTRASTAT_EXEMPT_DB=FALSECHARGE=MIN_ORDER_LEVEL=MAX_ORDER_LEVEL=VALID_FROM=VALID_UNTIL=DISTRIBUTE_ON_RECEIPT=FALSEDISTRIBUTE_ON_RECEIPT_DB=FALSECHARGE_AMOUNT_INCL_TAX=0    Do you know why I have this error ? 

7
Jens
Hero (Employee)
2 months ago
12gAshanD
Do Gooder (Partner)
12gAshanDDo Gooder (Partner)
asked in Data Migration

Unmapped Mandatory Fields Found Error in Smart Data Manager

Hello,We are working on data migrations of a 21R2 customer using the smart data manager. We have first started working with CUSTOMER_INFO and CUSTOMER_INFO_OUR_ID which has a parent-child relationship, both objects are in scope and target definition tables are also created.Our next step is to add the data in to the input container in "Mapping Legacy Tables To Migration Object” window. When we click on "Mapping Detail [Options]” > “Add into Input Container” we get the below error.   We investigated and found out the issue is triggered by the primary key/s of CUSTOMER_INFO_OUR_ID. Default values are empty. Please let us know what we are doing wrong here? 

7
StephanS
Sidekick (Partner)
1 year ago
A
Sidekick
AdarshSidekick
asked in Data Migration

Anyone have ppt of Data Migration and integration (IFS 10)?

Hello Guys,    Very appreciate  for us, if someone share PPT of above subjected line.      

7
Yasas Kasthuriarachchi
Superhero (Employee)
3 years ago

Badges

Show all badges
Terms & ConditionsCookie settings