Replies posted by todscotta

3 Replies

T
Do Gooder (Customer)
todscottaDo Gooder (Customer)
asked in Data Migration

Migrating Data into a Custom Page

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    

5
T
Do Gooder (Customer)
4 years ago
T
Do Gooder (Customer)
todscottaDo Gooder (Customer)
asked in Data Migration

Migrating Data into a Custom Page

Thanks.  I was able to set this up successfully.

5
T
Do Gooder (Customer)
4 years ago
T
Do Gooder (Customer)
todscottaDo Gooder (Customer)
asked in Data Migration

Migrating Data into a Custom Page

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.

5
T
Do Gooder (Customer)
4 years ago

Badges

Show all badges
Terms & ConditionsCookie settings