Data Migration

This will include topics related to data migration.

  • 232 Topics
  • 599 Replies

232 Topics

T
Do Gooder (Customer)
traceybooDo Gooder (Customer)
posted in Data Migration

Migrating Open fixed assets

HI, does anyone have detailed instructions on how to migrate open fixed assets into IFS Cloud. Thanks

1
N
Do Gooder
8 hours ago
N
Do Gooder (Customer)
NorahmfDo Gooder (Customer)
asked in Data Migration

IFS Cloud migration job

Dears, I am new on IFS CLOUD, MY question is :there is migration job already exist I want add new view like(order-line_stage_billing40) to add new stage How I can do that ? Please I need urgent help.

2
N
Do Gooder (Customer)
19 hours ago
DHCRADPA
Sidekick (Customer)
DHCRADPASidekick (Customer)
asked in Data Migration

Basic Data Synchronization - Apps 10

I have one company (not the source one) which does not appear in the Target companies list. How can I include all existing companies in this window?

2
DHCRADPA
Sidekick (Customer)
1 day ago
chrisbrigg
Sidekick (Customer)
chrisbriggSidekick (Customer)
asked in Data Migration

Dynamic file names for external batch file

Hello,Is it possible to set up a Batch external file job to handle dynamic file names?  I tried putting an asterisk (*) at the end of the file name within the External File Template but that produces an error saying the file cannot be found.  

1
Jens
Hero (Employee)
1 day ago
L
Do Gooder (Customer)
lionDo Gooder (Customer)
asked in Data Migration

select * from 'excel file' then insert into 'table' by plsql

is it possible use select * from 'excel file' then insert into 'table' by plsql script?

1
A
Superhero (Employee)
1 day ago
P
Sidekick (Customer)
PhillBronsonSidekick (Customer)
asked in Data Migration

Own Process Share or Export

I have some success organizing different task and streamlining the process by using the “Own Process” functionality.It has enabled my team to create custom menus, RMB, conditional formatting, and conditional fields to keep the user experience pretty clean without introducing extraneous options when not applicable. To start, I have had interns work on designing different Own Processes under their own account, as proof of concepts. I don’t want to alter their permissions to allow access to base profiles in order to publish their pages. And I would love not to have to recreate these individually under the base profile as it would be quite time consuming and double work. Is there a way to export these Own Process versions of pages?I know I can save all my RMB separately and import them, as well as any lobby elements we have mapped to forms or pages. Sending these pages to others via “Stream or Email” only send a link to the original configuration of the view. I really need a more efficient

1
P
Sidekick (Customer)
1 day ago
H
Do Gooder (Partner)
HarshaDo Gooder (Partner)
asked in Data Migration

Smart Data Manager Mapping Parent Child Relationship in generated keys

We are using Smart Data Manager to migrate “EQUIPMENT_SERIAL” and “EQUIPMENT_OBJECT_TEST_PNT” which has a parent child relationship using field “EQUIPMENT_OBJECT_SEQ”  This field value is an auto generated value and in the EQUIPMENT_SERIAL and there is no way to put newly generated  “EQUIPMENT_SERIAL.EQUIPMENT_OBJECT_SEQ”  to “EQUIPMENT_OBJECT_TEST_PNT.EQUIPMENT_OBJECT_SEQ” Is there a built in way in the tool to resolve this  

0
H
Do Gooder (Partner)
1 day ago
G
Do Gooder (Partner)
GaSoGBDo Gooder (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.

6
E
Do Gooder (Partner)
7 days ago
S
Do Gooder
SPRRAJDo Gooder
asked in Data Migration

Excel Migration Error

Hello, I’m trying to load data into IFS Cloud using Excel Migration. When I load the data to Excel sheet and try to validate the records vis Excel Add-In login, I’m getting the error:Any suggestion, how to fix this error? Thanks

2
S
Do Gooder
7 days ago
A
Do Gooder (Partner)
ArcAleksSDo Gooder (Partner)
asked in Data Migration

Method to change structure status

Hello,I want to change the structure status from “tentative” to “buildable”. I am using a two step job and I am looking for the right method. I was trying with this one (screenshot), but I get the message that the method is not righT. could you please advise?Thank you!Aleksandra

2
Z
Do Gooder (Customer)
8 days ago
J
Do Gooder (Customer)
JannetteCDo Gooder (Customer)
asked in Data Migration

Schedule a quick report

Hello all, Hoping someone can help with this.  I am trying to schedule a quick report so the first thing I do is create the ‘Application server task’.  However when I save and RMB I get the following :I select yes, then get the following:How can I resolve this issue please ?

1
anbouk
Hero (Employee)
8 days ago
R
Do Gooder (Customer)
roxandcarDo Gooder (Customer)
asked in Data Migration

Incremental load with objversionfrom oData API

Me and my colleagues are part of a project to ingest data from IFS to google cloud platform, where we collect and curate data from ifs and other systems in order to gain insights using PowerBI.We would like to access objversion each table in the client API, so that we can load data  hourly both incrementally and idempotently.But this field is not exposed in the API.One option presented to us was to add a custom field from the objversion, but this poses another problem, because custom fields are added in the CFT tabal, which mean they are not part of any index on the table. This means that each request to a table performs a full table scan, which we do not want for two reasons:   1. It is slow and sometimes times out   2. It is too much processing on the database.Another option would be to load the entire table each hour, but that won't cut it for obvious reasons.In our estimation, exposing the objversion as a field in the client API would solve our problem with minimal effort involved.

0
R
Do Gooder (Customer)
10 days ago
B
Do Gooder
bkpskoczylasDo Gooder
asked in Data Migration

Data Migration in Cloud - xls file

Hi All,We are currently in the process of upgrading from IFS 8.0 to IFS Cloud.In the 8.0 application, we have a modification that allows you to load files directly from excel (xls) to data migration. According to the latest information in IFS Cloud it is impossible.I have a lot of migration tasks which create tables (procedure: Create_table_from_file). Have you some idea how to fulfill this tables using xls files? I don't like csv files.

0
B
Do Gooder
13 days ago
N
Sidekick (Customer)
Ngerst
asked in Data Migration

Replication Part

I am looking for a way to run a replication job for Inventory Parts from Contract A to Contract B. However, I want to change the value of a few fields when it goes to Contract B. Overall, we are changing to streamline our part creation process and one of the challenges we have faced was trying to replicate 80% of the inventory part into a new contract, but there are few value changes. Example would be Inventory Part Planner 17 for Contract A = Inventory Part Planner 20 for Contract B. Is it possible to change values of certain fields through the replication job? 

0
N
Sidekick (Customer)
13 days ago
Mohsin
Do Gooder (Partner)
MohsinDo Gooder (Partner)
asked in Data Migration

External File Definition Validity Issue

After creating a  external file type & template, when I added another record type with different view and checked for definition validity of template one error message comes up . Besides, external file template turns into invalid. Screenshot is attached here. Could anybody please suggest me about the issue here ??? 

2
C
Do Gooder (Customer)
14 days ago
R
Do Gooder (Partner)
Ryo AsadaDo Gooder (Partner)
asked in Data Migration

specify a range of dates of type DATETIME in the Excel-Addin

How do I specify a range of dates of type DATETIME in the Excel-Addin search screen of IFS Applications?

0
R
Do Gooder (Partner)
15 days ago
S
Do Gooder
SPRRAJDo Gooder
asked in Data Migration

Data Migration Error

I’m executing a loader job via OnServer route and once I select the file from the SFTP Server, getting an error “Invalid value for property “IntfaceFile””. Any suggestion on the reason of this error and how to fix it.Thanks

3
S
Do Gooder
15 days ago
M
Do Gooder (Partner)
manjunath.rao01Do Gooder (Partner)
asked in Data Migration

Data Migration in Upgrade Project

Hi, I have customer who is into an Upgrade project from IFS Apps 8 to IFS Cloud.How do we manage the Data Migration of the existing data into IFS Cloud?For Example: We migrate the Inventory Parts, Inventory Stock etc.How about the LotBatchMaster, LotBatch History or Part Serial History windows?Does this needs to be migrated as a part of the Upgrade project?

6
F
Sidekick (Partner)
17 days ago
T
Do Gooder (Partner)
Tom_LuciferDo Gooder (Partner)
asked in Data Migration

ORA-20105: Dictionary.CLIENTNAME_IS_NULL: Cannot convert the client name [NULL] into a database name.

when executing a migration job (procedure type =insert or update ) i’m getting this error ,i’m using 22r2 version.i have set default values for null values in migration job also can anyone help me to solve this ? 

2
T
Do Gooder (Partner)
20 days ago
V
Do Gooder (Partner)
VALMARODo Gooder (Partner)
asked in Data Migration

Problem launching Configuration Analyzer

Hi,I downloaded and installed the configuration analyzer tool on my workstation.I downloaded the file InterfaceReports.ifrWhen I launch the tool, I just have time to see the main screen and the application closes immediately.Do you have any ideas why ?Thank you

3
V
Do Gooder (Partner)
21 days ago
N
Do Gooder (Partner)
NishithDasDo Gooder (Partner)
asked in Data Migration

Data Migration Manager - Circular reference of basic Data and unable to validate and approve the data

IFS 22R1We came across one issue in Data Migration Manager where we found circular reference of tables while validating Basic Data and unable to validate the Basic DataCOMPANY_FINANCE being used as reference table for few other basic Data target tables. While validating COMPANY_FINANCE data, it is referring to CURRENCY_TYPE which also requires validation.On validating CURRENCY_TYPE, it is referring to COMPANY_FINANCE and also CURRENCY_CODE.CURRENCY_CODE also referring to COMPANY_FINANCE, seems like Circular reference and unbale validate basic Data for these target tables.Any suggestion how we should be resolving this issuescreen shot attached for referenceThanks,

3
N
Do Gooder (Partner)
21 days ago
S
Do Gooder (Partner)
signilsDo Gooder (Partner)
asked in Data Migration

Cursor error - cursor already open

Hi, I keep getting the error: ORA-06511: PL/SQL: cursor already openwhen executing below, can someone please tell me why:- DECLARE    info_ VARCHAR2(2000);    attr_ VARCHAR2(2000);        newrec_     identity_invoice_info%ROWTYPE;        automatic_pay_auth_flag_db  VARCHAR2(1):= '1';        CURSOR get_supp IS    SELECT * FROM IDENTITY_INVOICE_INFO;       BEGIN  FOR rec_ IN get_supp LOOP     OPEN get_supp;   FETCH get_supp INTO rec_;   EXIT WHEN get_supp%NOTFOUND;   CLOSE get_supp;                Client_SYS.Clear_Attr(attr_);                   Client_SYS.Add_To_Attr('AUTOMATIC_PAY_AUTH_FLAG_DB',automatic_pay_auth_flag_db,attr_);                        IDENTITY_INVOICE_INFO_API.Modify__(info_,rec_.objid,rec_.objversion,attr_,'DO');        END LOOP;    COMMIT;END;

3
T
Superhero (Employee)
22 days ago
N
Do Gooder (Customer)
Nico13
asked in Data Migration

GIS proxy configuration - Background job refresh proxy config

Hi,I am using a GIS server to have a map with objects in IFS.I also configured the GIS proxy in IFS but when I have a look at the documentation it says the new config should be populated with a background job called "GISINT - Refresh proxy configuration" but on my systems this job is missing.How can I populate the new proxy configuration and why is this job missing though it is described in the documentation?Thanks for any hint,best regards,Nico

3
dfsjmarchant
Do Gooder (Customer)
22 days ago
WSHAH
Do Gooder (Customer)
WSHAHDo Gooder (Customer)
asked in Data Migration

Data Migration Manager

Hi All,How we can use Project basic data setup in DMM and how we can import DMM project export file with any sample data and from where we get DMM project file for importRegards

2
WSHAH
Do Gooder (Customer)
22 days ago
H
Do Gooder (Customer)
HDZSTEPHANIEDo Gooder (Customer)
asked in Data Migration

Creating a flat file using Migration Job with Procedure = CREATE_OUTPUT_FILE in 21R1

Trying to create a flat file from a view using Migration Job CREATE_OUTPUT_FILE in 21R1.  No output is being generated and it is sitting at Error but no error message is displayed. 

2
X
Sidekick (Employee)
27 days ago

Badges

Show all badges
Terms & ConditionsCookie settings