Question

Excel Add-in - How to easily convert values to uppercase? (Apps10)

4 years ago
16 October 2019
2 replies
239 views

Userlevel 1

+4

Eva Schwartz
Sidekick (Employee)
7 replies

A customer is considering using the Excel Add-in for creating supplier for purchase part records. We created an Excel migration job for this and during testing we received the following error for the field Supplier Part No:
The value "SOOW 16/6 16 Gauge" has incorrect format for [VENDOR_PART_NO] in Purchase Part Supplier. Should be in uppercase.

How can the value in the column easily be converted to uppercase without needing any adjustment by the user in Excel? We would like to handle this via setup in the migration job. If the job was of type MIGRATE_SOURCE_DATA we could simply use the Oracle function UPPER when mapping, but we cannot figure out how to handle this for migration type EXCEL_MIGRATION.

2 replies

Userlevel 4

+9

Hi Eva,

Assuming a field like the supplier for purchase part note text is not needed for something else this can be used as a work around. (Or any other string field with no use)

In the migration job you find the PURCHASE_PART_SUPPLIER.VENDOR_PART_NO under column name and set its default value to UPPER(NOTE_TEXT). (Source Column should be blank)

Next find PURCHASE_PART_SUPPLIER.NOTE_TEXT and put NOTE_TEXT in the Source Column. The description for this line your can rename to Supplier Part No. That way it will show as if it is the Supplier Part no in the excel.