Skip to main content

Data Migration

This will include topics related to data migration.

  • 571 Topics
  • 1,432 Replies
571 Topics
HAFFRASVE
Sidekick (Customer)
HAFFRASVESidekick (Customer)
asked in Data Migration
Migrate Service Notes to Location

We have some information stored in technical attributes for equipment object that would like to migrate to Service Notes, but that was not as easy as I though since Notes are a CLOB field.We are currently on 24R1 SU4 and I found this workaroundExcel Migration - Technical Documentation For IFS CloudBuisness_Lead_API have a procedure Write_Note_Excel__, but Request_Contact_Note_Api does not have a similar procedure in our version. Could some see if the Api been improved with such a procedure in 24R2 or 25R1?      

152
HAFFRASVE
Sidekick (Customer)
A
Sidekick (Partner)
ArcPierreLSidekick (Partner)
asked in Data Migration
Handle engineering revision transfer after migration

Hello,I noticed that Engineering part transfer actions do not check wether the engineering revision already exist on destination site until a first transfer is made.I’m having an issue with a customer where inventory parts & engineering part revisions have been created via data migration. However, now each time a une an existing part revision in a new engineering structure, when I transfer the top code it creates revisions for all the components … This means the setup of Product structures (issue to location, conumption type, alternatives,  ...) needs to be made every single time a component is transferred for the first time, for all the parts already in destination site. I tried to tag the transfer actions as ‘transferred’ but couldn’t reach my goal. => Has everyone encountered such an issue ? How could this be fixed ?Thank you,//Pierre 

502
ww2sys
Do Gooder (Partner)
S
Do Gooder (Customer)
s.bondarDo Gooder (Customer)
asked in Data Migration
Project invoice to have direct access to Customer data with hyperlink

The PROJECT INVOICE should  have direct access to the Customer details with hyperlink. This is already in place and active with the CUSTOMER INVOICE.  

131
Abdul
Superhero (Partner)
G
Do Gooder (Partner)
GogHashivDo Gooder (Partner)
asked in Data Migration
Importing attachments from external system (non IFS application) to IFS Cloud

Hi, We have a business requirement to import attachments (all doc formats and JPEG, PNG, JPG, etc) into IFS Cloud work task template, functional object from an external non IFS system application. We came across FsMig Tool (File Sharing Migration Tool) which is used only to import attachments from IFS Applications to IFS Cloud. is there some tool or any better way to import attachments from other systems to IFS cloud, open to suggestions.

311
FlorianTauber
Do Gooder (Partner)
A
Do Gooder (Partner)
AnyDo Gooder (Partner)
asked in Data Migration
Data migration- Supplier advances invoices

Hello community,For opening balances migration, what is the better approach for Down payments into supplier? Is there a template for that or it’s possible to migrate those advances invoices through the template  Thanks and Regards.

100
A
Do Gooder (Partner)
V
Sidekick (Partner)
venkateshSidekick (Partner)
asked in Data Migration
Ventechi Migration | Generic question

Hi Team, We are doing migration using the Ventechi script. We have a question about this: What is the processing time for this? It's been a day, and it is still running. Can we get the max time it took to process so far and the least time? Is there any workaround to speed up this process? Thanks, in advance.Thanks, 

330
V
Sidekick (Partner)
K
Do Gooder (Partner)
k.burdzyDo Gooder (Partner)
asked in Data Migration
Instant Invoice Migration

Hi,Has anyone managed to configure the migration job/jobs so that you can migrate instant invoice header and lines (multiple headers and multiple lines). The problem is that when creating the header, invoice_id and inovice_no are generated and you have to enter it in lines.I'm talking about the window Financials\Supplier Invoice\Manual Supplier Invoice

540
K
Do Gooder (Partner)
Z
Do Gooder (Customer)
ZSPRPMAJDDo Gooder (Customer)
asked in Data Migration
Excel plug-in Search function - load rows with empty field

Is it possible to import data into Excel using Excell addin by the Search function - only rows with empty ( NULL) field ? In IFS (cloud version) we can show rows with empty fields only using filter “!<>”  Is it a similar solution for import rows into Excel ?  

30
Z
Do Gooder (Customer)
D
Do Gooder (Partner)
DisnaMarakkalaDo Gooder (Partner)
asked in Data Migration
Excel Add-In InvalidArgument when handling CLOB data type

Hi All,I was following the below URL to use Excel migration job to insert/update Note field in BUSINESS_LEAD page in IFS. (IFS Cloud 24R1)https://docs.ifs.com/techdocs/Foundation1/040_administration/260_data_management/050_data_migration/002_migration_types/030_excel_migration/default.htm?_gl=1*1kzdxq4*_ga*MTI0OTMxMDg4OC4xNzA0ODM1MDgw*_ga_H7YJR9R7Q1*MTcwODUzMzQ2Mi45MC4xLjE3MDg1MzM0OTAuMC4wLjAAnd I got below error when trying to insert or update the Note field.I have attached the migration job I used.What could be the reason or any idea of resolving this error will be much appreciated.Thank you!

392
D
Do Gooder (Partner)
B
Do Gooder (Partner)
BawLakshBDo Gooder (Partner)
asked in Data Migration
Delete data from data integration

Hello, I would like to know whether there is a functionality to “delete” data by using data migration:Let me explain:Data has been integrated in IFS using data migrationThe client wants to delete and update a new list of data. Is it possible to “delete” data by using data migration. Thanking you for your feedback.

34114
mduchaff
Sidekick (Customer)
C
Do Gooder (Customer)
CelalettinDo Gooder (Customer)
asked in Data Migration
How can we add custom menu to IntfaceHeader?

Hi all,We want to add custom menu on Execute Job page but when I try to create new projection configuration I can’t find entity name of IntfaceHeader. Is there any specific reason why I cant find it. Does any one know how can we solve that?  

190
C
Do Gooder (Customer)
D
Do Gooder (Partner)
Daniel_HassanDo Gooder (Partner)
asked in Data Migration
DMM Date format

Hello Community,I'm facing an issue with the Data Migration Manager. Whenever I deploy records that include dates, the time is being interpreted as 12:00 PM instead of 12:00 AM, which leads to a "resource not found" error.For example: 1/1/2000 12:00 PM is being used, but it should be 1/1/2000 12:00 AM.I've tried modifying the date format in the legacy file, but that hasn't resolved the issue.Thank you for your support.

280
D
Do Gooder (Partner)
R
Sidekick (Customer)
rodriguezfrSidekick (Customer)
asked in Data Migration
Inventory Quantities Zero Out Options

We are looking to find a way to zero out and add back our inventory quantities, as that is a requirement to move from FIFO to Standard Costing and Allow Negative OnHand. Long story short, IFS deprecated deferred backflushes from Apps10 on.We are in IFS APPS8 but upgrading to Cloud. We want to do this change before said upgrade.Does anyone have any ideas how to do this is a script or batch manner?We have engaged IFS to provide with a script but they’re not really coming thru, and our implementation partner doesn’t want the liability -if they provide the script and somehow that fails and messes our data.We would need one method/script/batch to zero out our Inv Part in Stock quantities, and another to add the quantities back, in-between us make the inventory part changes and rolling costs.Our partner suggested that maybe a script using Issue Inventory Part and Receive Inventory Part, but the problem there is that the receive method changes the receipt date. It would probably have to be Co

251
Abdul
Superhero (Partner)
A
Do Gooder (Customer)
AGrochoskiDo Gooder (Customer)
asked in Data Migration
Assyst: Importing Items .CSV file via ETM

Edit: Sorry, for some reason this post cannot be made in the Assyst discussion board. Hi, all! I am currently trying to get ETM to import a .CSV file of our hardware, but I’m having trouble getting Assyst to import the file. My current setup is:A hardware list is generated by another program and a .csv file is created. That file is emailed to ETM via a MS Graph Import Channel formatted for .csv files. That .csv file is mapped to our hardware import datamapper.Whenever the email is sent to ETM, however, it fails to interact with the attached .csv file in the email. Is there any way for ETM to receive an email and then utilize an attached file, or do I need to come at this from a different angle? I’d greatly appreciate any input, thanks!

100
A
Do Gooder (Customer)
DMTCCAN
Sidekick (Customer)
DMTCCANSidekick (Customer)
asked in Data Migration
Copy External file template.

Hi, I would like to copy an external file template from an environment to another one. Can somebody heklp me. Regards Christophe

282
Thushanthy Walter
Sidekick (Employee)
P
Do Gooder (Partner)
pc001058388Do Gooder (Partner)
asked in Data Migration
External File Template - ApiApi Before Unpack and Api After Unpack

Hello All, Can anyone help, how to use Api Before Unpack and Api After Unpack in package option in external file template input file in ifs aurena.

141
M
Hero (Employee)
mduchaff
Sidekick (Customer)
mduchaffSidekick (Customer)
asked in Data Migration
Migration job to activate users

Hello,I have created successfully a set of migration jobs to create users.Hopefully, the following system parameter is active :The only point which resist is the following : I’d like to automate with another Migration job, the activation of the first login. Making the automate password  as “ to change on the 1st login” is OK, but presently, the user/password fail! Thanks for your help

80
mduchaff
Sidekick (Customer)
M
Do Gooder (Customer)
Michael_BDo Gooder (Customer)
asked in Data Migration
Create PSO-Customer via REST API

Dear all,we are setting up our new PSO environment on ifs-cloud 24.2.2 and want to insert several thousands of customers with their names, adresses and contact information via REST-API calls.Currently we can successfully create the customer via REST-API “…/CustomerHandling.svc/CustomerInfoSet”.How can we add the communication-information via REST (the endpoint …/CustomerInfoContactEntity.svc/CustomerInfoContactSet seems not to be active)?How can we add the Address-information via REST (the endpoint …/CustomerInfoAddressEntity.svc/CustomerInfoAddressSet seems not to be active)?The json structure to POST this data seems to be correct.Best regardsMichael

304
M
Do Gooder (Customer)
M
Sidekick (Customer)
MANI0202Sidekick (Customer)
asked in Data Migration
Extracting data from IFS Cloud via ETL tool

Hey All, I have a query, is there any way to extract the data from IFS Cloud via the ETL tool(talend, boomi etc.) to our data warehouse? Is their any documentation regarding this.  Thanks and Regards,Mani Shankar

1825
FlorianTauber
Do Gooder (Partner)
M
Do Gooder (Customer)
Markus S.Do Gooder (Customer)
asked in Data Migration
Best Practices for Data Migration to IFS Cloud (24.1.3)

Hello, I'm Markus and I'm new here in this community, and this is my first post.One of my tasks is to prepare the master data from the old ERP and migrate it to the IFS cloud. Of course, a lot of mapping is necessary, as we don't have this many columns and tables in the old ERP.I learned from our consulting to use these data migration tools: Migration Job for LOAD and for MIGI have a VPN to the IFS cloud and can select the data VIEWS via ORACLE SQL Developer to reconcile the column names and fields for the migration job files or to build the mapping for this.Is there a best practice for the migration of master datafrom our old ERP to our IFS cloud?Thank you very much for your knowledgeGreetingsMarkus 

68911
FlorianTauber
Do Gooder (Partner)
T
Do Gooder (Customer)
TokoWiemeDo Gooder (Customer)
asked in Data Migration
Simple migration tool

We are currently using IFS app 9 and some of the users do use the Simple Data migration Tool. So they use xls files to load data into IFS. Now I'm looking for a similar tool in IFS Cloud and was going through different threads in this community. It seems the future is available in 24R2, but I cannot find any comfirmation on this.  Can anyone tell if it is yet availbale? 

491
Abdul
Superhero (Partner)
Poulton
Do Gooder (Customer)
PoultonDo Gooder (Customer)
asked in Data Migration
IFS Cloud Example Data

Is there a process to get the system populated with example, demo, or dummy data?We are new to IFS Cloud, and will be starting our implementation process with our partner soon. However, we would like to be able to see what a basic setup would look like.Our prior ERP system had an example database which had the minimal setup with some dummy transactions. This was helpful in exploring functionality not implemented and was helpful to the development process.

1976
Mathias Dahl
Superhero (Employee)
W
Sidekick (Customer)
WampyraeSidekick (Customer)
asked in Data Migration
How to request sales quotation status ?

Hi,In the sale quotation, there is a State field and a Status field. The State field corresponds to CLOSED_STATUS/CLOSED_STATUS_DB in the database.accepted values : won / lost / no decision / nullI can't find the Status information in the database, and I need it for data migration.Does anyone have any information on this subject?

554
Jens
Hero (Employee)
D
Do Gooder (Partner)
Devanthi ShanikaDo Gooder (Partner)
asked in Data Migration
Depreciation calculation - FA

Hi All,Thank you in advanceI have the below depreciation requirement.financial year - 2024/1/1 - 2024/12/31Asset acquisition date - 2024/May/15Asset value - 12000Estimate life - 10 yearDepreciation method - straight line but in the year of the acquisition, depreciation should be calculated for half and distributed equally among the periods.Example as per my scenario, deprecation will start from May but the amount posted for each period should be = 7512000/10 --> 1200 per year1200/2 = 600 in the first year600/8 = 75 per month in the first year (8 = no of months in the first year)Can someone please help me to set this depreciation method?

100
D
Do Gooder (Partner)
mduchaff
Sidekick (Customer)
mduchaffSidekick (Customer)
asked in Data Migration
Migration job mapping : missing columns

Hello,I’m preparing a CREATE_TABLE_FROM_FILE migration job to upload data in EMPLOYEE_ACCESS_SUP.Looking at the proposed File Mapping, I was surprised by the column list which is pre-set : SUPERVISOR_BU_TYPE_DBVALID_FROMVALID_TOTRANS_FROMTRANS_TOGENERAL_ACCESSORG_CODERELATION_IDINCLUDE_SUBWhen I try the SQL command :select * from EMPLOYEE_ACCESS_SUPI get a list of columns that makes much more sens, 28 columns, such as :Org Bu IdSupervisor Person IdSupervisor Company IdSupervisor Emp NoSupervisor Bu Type DbSupervisor Bu TypeEmp Company IdEmp NoEmp Bu IdEmp Pos CodeAccess RoleValid FromValid ToTrans FromTrans ToGeneral AccessOrg Bu TypeOrg CodeEmployee GroupPerson GroupRelation IdSupervisor Relation IdSupervisor Pos CodeStructure IdStructure TypeOrig Bu IdInclude SubOrganization AssignmentWhy such a difference ?Should I manually add every missing row in the mapping ?Thank you for your help

10916
mduchaff
Sidekick (Customer)

Badges

Show all badges
Terms & ConditionsCookie settings