Question

Migrating Data into a Custom Page

  • 25 February 2020
  • 5 replies
  • 536 views

Badge +2

I have created a custom logical unit / custom page to add to the Supplier screen as a custom tab.  Is there an easy way to use the data migration tool (DMT) to populate the underlying custom table?  I’ve seen instructions on setting up the DMT to handle custom fields on a standard IFS screen, but this situation is a little different, in my mind, because it isn’t and extension of a standard method.


5 replies

Userlevel 7
Badge +19

Assuming you are on APP10.

 

This is possible as custom logical units are having the same structure. The only difference is view name suffixes with _CLV and all the attributes prefixes with CF$_. 

 

This is well described in the following technical documentation path.

 

.../040_administration/260_data_management/050_data_migration/003_data_migration_in_custom_objects/090_custom_lu/default.htm

 

Try and let us know the outcome.

Badge +2

Thanks @Rusiru for the quick reply.  This is very helpful.  I’m still a little fuzzy on the instructions of dealing with key values.  The data I am importing does not necessarily need to be unique and won’t IFS automatically assign an OBJKEY to new records when they are added to the database?  Is it possible to use the EXCEL MIGRATION procedure to import the data?  Seems easier to use then generating a file to load by using one of the INSERT methods.

Userlevel 7
Badge +19

OBJKEY should be generated always so you cannot identify your record using it. That is why it instructs to maintain your own key. 

 

Yes, you can use excel migration procedure to import data. The only different is you should use _CLV as the view name. Source mapping columns and method list is fetched automatically as normal. 

Badge +2

Thanks.  I was able to set this up successfully.

Badge +2

I have another question.  I have a referenced field (Supplier ID) in the custom page.  Is there a way to get the OBJKEY from the referenced field to populate in the template behind the scenes?  I’ve tried a couple of different things in the Default value column - both a select statement and a function call but neither seems to be working in that validating or executing the excel spreadsheet returns no values in the Results column and no data is migrated into the custom page.  This was my latest attempt:

 

Set up a dummy field for Supplier ID that populated with a supplier number.

 

In the source table field I entered the following in the Default Value column:  select supplier_api.get_objkey(SUPPLIER_ID) from dual

 

 

Reply