Skip to main content
Solved

Unable to delete lines that don't need migrating (blanks) (could delete on apps 9)

  • October 23, 2024
  • 2 replies
  • 51 views

Srikanth
Superhero (Partner)
Forum|alt.badge.img+18

Hi,

In Apps 9 whilst using Data Migration Jobs, users were able to delete records after loading data from spreadsheet and before migrating the records into IFS.

However, in IFS Cloud (23.1.11) there seems to be no option to delete records like the ones highlighted below:

Users need this ability to review and delete records before migrating them into IFS.

Is this a case of missing functionality in Cloud that will be added in future updates?

Best answer by Jens

Hi @Srikanth 

additional hint/experience from my point of view.

I suppose you’re trying to migrate data using the procedures INSERT_BY_METHOD_NEW or INSERT_OR_UPDATE.

I don’t recommend to use these procedures because of limited possibilities. For very simple migrations where the provided data is always good this might be ok.

My recommendation is to use 2 migration jobs (CREATE_TABLE_FROM_FILE to load the raw data into a “temporary” Oracle table (IC_-table) and then MIGRATE_SOURCE_DATA to fetch the data from the “temporary” table and migrate the data using APIs).

When using the MIGRATE_SOURCE_DATA job then you have much more possibilities. So for example you can also filter “empty” records with a WHERE-clause.

To delete these kind of “empty” records manually several times cost a lot of time.

Kind regards,

Jens

 

 

 

View original
Did this topic help you find an answer to your question?

2 replies

Abdul
Superhero (Partner)
Forum|alt.badge.img+12
  • Superhero (Partner)
  • 245 replies
  • October 23, 2024

Hi Srikant,

In IEE versions, there is step to save record after loading data through spreadsheets and before saving, option is there to delete desired record(s), however, in Clouds version, system automatically saves spreadsheet data with loading. 

I don’t think it is a case of missing functionality since IFS has automated the data saving procedure.

 

Regards

Abdul Rehman


Jens
Hero (Employee)
Forum|alt.badge.img+10
  • Hero (Employee)
  • 123 replies
  • Answer
  • October 24, 2024

Hi @Srikanth 

additional hint/experience from my point of view.

I suppose you’re trying to migrate data using the procedures INSERT_BY_METHOD_NEW or INSERT_OR_UPDATE.

I don’t recommend to use these procedures because of limited possibilities. For very simple migrations where the provided data is always good this might be ok.

My recommendation is to use 2 migration jobs (CREATE_TABLE_FROM_FILE to load the raw data into a “temporary” Oracle table (IC_-table) and then MIGRATE_SOURCE_DATA to fetch the data from the “temporary” table and migrate the data using APIs).

When using the MIGRATE_SOURCE_DATA job then you have much more possibilities. So for example you can also filter “empty” records with a WHERE-clause.

To delete these kind of “empty” records manually several times cost a lot of time.

Kind regards,

Jens

 

 

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings