Skip to main content

Data Migration

This will include topics related to data migration.

  • 608 Topics
  • 1,517 Replies
608 Topics
R
Sidekick (Customer)
rkescoupland
asked in Data Migration
Excel add-in SQL select not working

I am using Excel add-in for data migration most of the time no issues.in a few examples i need to do some data retrieval/lookup and have used an expression in the ‘default value’ column in the migration job.However, as yet i am struggling to do the same with a simple SQL select. Is it not possible or is my syntax incorrect. I have no guidance so I am making it up as a I go, I could be doing it incorrectly.I did write a select first in quick reports to prove it was correct, although it is so simple I did not really need to.When I click validate or execute - I don’t get any feedback, (the debug feature does not work) - but if I remove the select my other data updates - so something about my approach is failing. Thank you for any suggestions!  

30
R
Sidekick (Customer)
C
Do Gooder (Partner)
CPatabendiDo Gooder (Partner)
asked in Data Migration
Excel Migration Job - integrity constraint error

I’m getting this error when trying to migrate data to a Custom TAB. ORA-02291: integrity constraint (IFSAPP.C_PART_INTERCHANGE1_CRK) violated - parent key not found Method List Attribute Source mappingNote: I tried to retrieve the objkey from the parent container and set it using the source mapping, but I'm still getting the same error.Any idea how to resolve this? 

160
C
Do Gooder (Partner)
J
Do Gooder (Customer)
japaukDo Gooder (Customer)
asked in Data Migration
IFS Excel migration Addin not working with latest excel

HelloWith the latest version of excel, it seems IFS Excel migration does not work. cloud 23R2 version 

2906
T
Sidekick (Customer)
J
Do Gooder (Customer)
jnolanDo Gooder (Customer)
asked in Data Migration
IFS Cloud Excel Add-in not working after Excel update

We are on IFS Cloud 25.1.2.  Microsoft just forced updated Office to 2507 (19029.20136) which broke our IFS Excel add-ins.  Users that stayed on 2506 are still OK.Issue is, when you click login, the add-in panel briefly flashes and does not bring up the login window for IFS cloud.Anyone else have this issue? 

89318
T
Sidekick (Customer)
J
Do Gooder (Partner)
jaroslav.runstukDo Gooder (Partner)
asked in Data Migration
Test topic

Hello, Test topic, to find out is community works or not. 

50
J
Do Gooder (Partner)
J
Do Gooder (Customer)
Julien T.Do Gooder (Customer)
asked in Data Migration
How to include headers in a datamigration in IFS V10

Hello,How can i include description header (description of each field instead of column name) on in my datamigration export in csv format ?  

161
M
Hero (Employee)
A
Do Gooder (Customer)
akaushik123Do Gooder (Customer)
asked in Data Migration
Unable to update record using Data Migration Manager tool (DMM)

I'm trying to update an existing record for functional objects using the Smart Data Migration Manager (DMM) tool. I've mapped the Equipment Object Seq field to the legacy source, but when I deploy from the deployment container, it treats it as a new INSERT and returns an error saying the functional object already exists.I've included all the configuration details and data in the description. Could someone help me identify what I might be missing or doing incorrectly?Excel Record I’m trying to Update :Legacy Data :Mapping : Deployment Container :Error;  

230
A
Do Gooder (Customer)
S
Do Gooder (Customer)
SondrumDo Gooder (Customer)
asked in Data Migration
Changing Units of Measure

Hello;        I’m new to IFS & I’m quite surprised at the difficulty there is in changing a unit of measure. I’m a designer, & a portion of my former company was acquired by another who uses IFS. In the process there was a lubricant that got transferred & the unit of measurement was a pail. I’m not sure what the correct unit is but that wasn’t the unit it was supposed to be. Instead of being able to correct the unit, my main division of the company is saying the only thing we can do is create a new part no. with the correct unit of measure. This lubricant is used all over the place in 103 boms & 93 drawings which would have to be changed. Is this a limitation with IFS, & if it is, why would it be. I believe with our former system using CMS, we would have just revised the unit, & been done with it. I should add, it has already been used which seems to make it more of an issue.Thanks for any input in advance. SonDrum

5975
D
Sidekick (Customer)
A
Do Gooder (Customer)
AO0001Do Gooder (Customer)
asked in Data Migration
Sales Quotation Mig Job - Issue since UPD20

We have an existing migration job that worked until Update 20 was applied. The job adds lines to a sales quotation. Now the lines are added successfully only for rows where the customers price list has a value in the Discount Type field for the part in question. The job looks like this:The error returned is “Field [DISCOUNT_TYPE] is mandatory for Order Quote Line Discount and requires a value.”. The migration job doesn’t currently include a method list entry for the Order Quote Line Discount view so it isn’t possible to add a default value for this field: What we would like is to be able to add a default value if there isn’t one on the price list. Is there a way of doing this?

661
S
Do Gooder (Customer)
msurasky-price
Sidekick (Customer)
msurasky-priceSidekick (Customer)
asked in Data Migration
Migration of Excel-AddIn Job fails with: Unexpected end of JSON file

Hi IFS Community!Upon running the Excel-Add In for Data Migrations on IFS Cloud for a specific job in Production, we get "Unexpected end of JSON file" with no further information as to why this is happening.We migrated the same data to a different environment last week (CFG) with NO errors whatsoever, so we know that the data we are migrating is not the issue.We checked permissions for the user running the migration and it all looks fine as well. Any ideas what could be causing it?

2562
A
Do Gooder (Partner)
A
Do Gooder (Partner)
Asanka DineshDo Gooder (Partner)
asked in Data Migration
How to update the Thru_Date when importing a Fixed Assets Object from an external file?

Hi All,My requirement is to update the total accumulated depreciation up to the cutoff date during the import process and set the cutoff date as the Thru_Date. Then, when running depreciation using the Depreciation Proposal, depreciation should be calculated correctly only for the period after the cutoff date.

1062
B
Do Gooder (Customer)
W
Do Gooder (Customer)
westjanDo Gooder (Customer)
asked in Data Migration
Creating new configuration using migration job.

Hi community,in IFSAPP10 I am trying to create new configuration for quotation line with migration job.I checked the configuration form and found these two tables: CONFIGURATION_SPEC and CONFIG_SPEC_VALUE.I used the table CONFIG_SPEC_VALUE as many times as I have parameters in my configuration revision. I am able to create new configuration with this migration job. I can see records in both tabels with new configuration ID, but I am not able to create the record regarding the connection between the new configuration and particular "Order Quotation Line".I found table CONFIG_SPEC_USAGE where you can see the records, that connect configuration ID with another object, but I am not able to use the table/method CONFIG_SPEC_USAGE in migration job. Could anybody provide any suggestions? How to solve the connection between new configuration and other object?Thanks a lot.IFSAPP10

350
W
Do Gooder (Customer)
S
Do Gooder (Customer)
shaunsDo Gooder (Customer)
asked in Data Migration
Column Names for Invoice_Item

Hello,I am looking to see if there are any column level definitions in any of the IFS documentation for fields like C1, C2 and N1, N2 etc that can be found on tables/views like Invoice_Item_Tab.I found some defitions for Invoice Header and Invoice_Line under the EDI messages page but nothing for the Invoice Item.https://ifstestcloud.xxxxxxxxx.com/ifsdoc/documentation/en/default.htm?openpage=https://ifstestcloud.xxxxxxxxx.com/ifsdoc/documentation/en/GeneralIFSApplications/AboutEDIMessages.htm (I replaced our local instance name with xxxxx)Is there a place where I can find these?Thank you

311
F
Do Gooder (Partner)
S
Do Gooder (Customer)
shaunsDo Gooder (Customer)
asked in Data Migration
Total Weight Group on Shipment

Hello,I am trying to locate some data from the Shipments page in the underlying views/tables but coming up empty. I am looking at Shipment Management > Outbound Shipment > Shipment, general Tab and then Weight.I have the following in there - Net Weight, Adjusted Net Weight,Tare Weight,Manual Gross Weight,Operative Gross Weight,Operative Adjusted Gross Weight. When I look at Debug > Page Info, I am told these are all part of the TotalWeightGroup element under the View Shipment.But when I query the Shipment view, none of these columns exist in it.Where can this information be found in the IFSAPP database?Thank you

362
S
Do Gooder (Customer)
S
Sidekick (Customer)
sachiniSidekick (Customer)
asked in Data Migration
How to concatenate two words in Method List Attribute- IFSAPP10

Hi,There is a migration job to create or update suppliers. We want to add ‘30’ prefix for the supplier id if the the supplier is a new supplier. I would like to know how we can do this.  we tried to get next supplier id and add ‘30’ prefix in the Method  List attribute as below. but it didn’t work.Thanks,Sachini

397
M
Hero (Partner)
P
Do Gooder (Customer)
puzinojDo Gooder (Customer)
asked in Data Migration
External File Assistant Deprecated in IFS Cloud

We recently found out the External File Assistant has been (or is about to be) deprecated in IFS Cloud.  Is there any information on a replacement for this functionality?  Will that replacement be an additional cost?

221
M
Hero (Partner)
E
Do Gooder (Partner)
ERSADo Gooder (Partner)
asked in Data Migration
How to clear values in Data Migration Manager(DMM)

Hi Experts, I want to clear existing values in DMM. How should I set it up? Here are some specific examples. I want to update the notes value to blank.Deploying blank data will not update the notes. How do I clear values in DMM?

302
E
Do Gooder (Partner)
T
Do Gooder (Partner)
TheanDo Gooder (Partner)
asked in Data Migration
Method to change structure status Plannable to Tentative

What method should I use to change the status Plannable to Tentative? Thanks in advance,

271
matt.watters
Superhero (Partner)
G
Do Gooder (Partner)
GogHashivDo Gooder (Partner)
asked in Data Migration
IFS Cloud - Unable to override values for Test point Parameter through migration jobs

I am trying to run a migration job to import a large number of test points and parameters on functional objects. I am experiencing the below issue Parameters: When my migration job (EQUIP_OBJ_PARAM), it updates the Parameter for the Default testpoint not my newly created Testpoint. Anyone had a similar issue or has a solution in IFS Cloud?  I ran migration job for Hours but the system generate and associates the parameter that is created in migration job to the test point id * Default Testpoint (there is no such parameter template). I even tried key manipulation by changing the flag on method EQUIP_OBJ_PARAM and EQUIPMENT_OBJECT_TEST_PNT for the attribute TEST_PNT_SEQ from “P” to “-” (minus sign) it errors something like this “exact fetch returns more than requested number of rows” suggestions are appreciated

200
G
Do Gooder (Partner)
G
Do Gooder (Partner)
GogHashivDo Gooder (Partner)
asked in Data Migration
Update custom field through migration job in IFS Cloud

Is it possible to update values on a custom field through migration job in IFS Cloud?I’m trying to set a value in a custom Cf$ screen using migrate from source data I see no exception but the value is not updated.I even tried hard coding all the keys and value still no luck. Ideas appreciated.

542
G
Do Gooder (Partner)
D
Do Gooder (Customer)
davidh3891Do Gooder (Customer)
asked in Data Migration
How to call a custom Projection Action from a Migration Job

Hi,I’m using a Migration Job to import some Customer Orders.  When Customer Orders are created in Aurena we have a custom action in place that creates a new Financial Project, and connects the new Customer Order to the Financial Project.  I can see this running in the Log Window, which shows that the action name is “Cf_CreateConnectFinancialProject” and the Projection is “CustomerOrderHandling”: I can confirm that this Projection>Action exists by looking at the Projection in Enterprise Explorer: What I’m stuck on is how I call this action from my Migration Job, as it claims the method doesn’t exist:I’m familiar with how to call APIs but not Projection Actions.  Can anyone help please?We’re running APPS 10 Release 25.

445
Marcel.Ausan
Ultimate Hero (Partner)
R
Superhero (Partner)
RutJWhalenSuperhero (Partner)
asked in Data Migration
Migrating Customer Information

Whilst migrating customer master data I have an issue when attempting to migrate the information that would populate the Customer > Sales tab.   View:  CUST_ORD_CUSTOMER_ENTI am receiving the following message:ORA-20111: CustOrdCustomer.ORDERATTR: Customer BDAR has no delivery address with order specific attributes specified. Looking at CustOrdCustomer.plsql can see: PROCEDURE Exist (   customer_no_ IN VARCHAR2,   customer_category_ IN VARCHAR2 DEFAULT 'CUSTOMER')IS   BEGIN                                                  IF (NOT Check_Exist___(customer_no_)) THEN      Error_SYS.Record_Not_Exist(lu_name_,'ORDERATTR: Customer :P1 has no delivery address with order specific attributes specified.', customer_no_);   END IF;   super(customer_no_);END Exist;  I have checked that customer BDAR has an address: Also, checked the Sales Address Information tab: Any ideas on how to resolve this?Many thanks in advance.Kind Regards John

202
Jens
Hero (Employee)
J
Do Gooder (Customer)
james.cunninghamDo Gooder (Customer)
asked in Data Migration
cloud data migration custom lu views are not supported

In cloud version, cannot create data migration job for custom view. Returning “custom lu views are not supported” error. Any idea?

655
T
Sidekick (Customer)
A
Do Gooder (Customer)
abdelmalek.mecheriDo Gooder (Customer)
asked in Data Migration
Media printing on Work Task IFS

Hello, Using IFS designer I would like to add the media imported by the technicians when carrying out a step of a work task so that the photos are present in the printed report. The configuration was carried out by one of my predecessors (see the result in the photo) a long time ago but since the version upgrade to 23.1.13 the configuration has disappeared. Except that in IFS Designer I cannot find the solution to include the media coming from the technicians when carrying out the step. Can you help me please ?  Thank’s  

421
T
Sidekick (Employee)
C
Do Gooder (Customer)
CirrostratusDo Gooder (Customer)
asked in Data Migration
Change Site X from Company Y to Company Z

Is there an “easy button” to move one site under another company within the same IFS instance? Or does that require a full blown data migration to move data from one company to another? How have other IFS customers resolved this situation?

2214
Marcel.Ausan
Ultimate Hero (Partner)

Badges

Show all badges
Terms & ConditionsCookie settings