MDA Oracle Blue prism - Bulk copy CSV - Column MAP

GhaithAbdessale — Thu, 24 Mar 2022 13:53:00 GMT

Hello,

I am using the MDA Oracle Blue prism utility to extract data and execute querries on oracle data base.
One of my processes requires to import data to an already crreated table ,so I am using the bulk copy CSV stage.
Unfotunately, it's not working and I have the following error :"Column mapping is invalid"

How am I supposed to set this column map collection ?

Here is the code stage for the bulk copy:

Best regards,

------------------------------
Ghaith Abdessalem
------------------------------

RE: MDA Oracle Blue prism - Bulk copy CSV - Column MAP

ewilson — Thu, 24 Mar 2022 17:06:00 GMT

@GhaithAbdessale,

The Column Map collection is used to map the column names in the CSV to the associated column names in the Oracle table. Quite often, the columns will have different names. So, the Column Map collection should have two columns in it named CSV and Oracle.

Then you populate that collection with the CSV column names and the database column names.

As you should see from the screenshots above, my CSV file includes two columns names FName and LName. Those columns are mapped to the associated table columns in the database which are named first_name and last_name.

Does that make sense?

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

topic MDA Oracle Blue prism - Bulk copy CSV - Column MAP in University Forum

MDA Oracle Blue prism - Bulk copy CSV - Column MAP

RE: MDA Oracle Blue prism - Bulk copy CSV - Column MAP