cancel
Showing results for 
Search instead for 
Did you mean: 

SAP Power Designer Excel Bulk Upload on Entity > Mapping > Entity Attribute Mappings

Vipul09
Explorer
0 Kudos
86

Hi Folks,

I am looking for bulk upload through excel for the below mentioned navigation

Entity > Mapping > Entity Attribute Mappings

(this screen can also be reached by Mapping Properties > Structural Feature mapping)

Here my main focus is to upload values in bulk mainly for Entity Attribute and Mapped To columns.

Can someone please guide on how to prepare the excel file and finally how to do the mapping of the excel tabs with Power Designer to insert the values ?

Thanks,

Vipul

SAP PowerDesigner 

View Entire Topic
Ondrej_Divis
Contributor

Hi Vipul,

I am afraid, that you are asking too much (from PD Excel import). I`ve tried several times to import mappings using standard Excel Import extension and my each conclusion was that it cannot be done.

As a result, I created my own automated mappings import from Excel. Pros and cons are obvious. You can tailor the script for importing mappings to your current Excel structure. However, you still have to take into account mandatory items such as Data Sources, Attribute mapping cannot exist without a parent Entity mapping, etc. Disadvantage is also clear. You have to spend time by writing the import script. And believe me, importing mappings is not a matter of 200 lines of VB script. There are surprisingly many things/rules you have to check to make sure, your imported data are consistent and PD-valid.

Unlike me, you have the great advantage of being able to use my previously acquired knowledge and save time doing your own import. Let me know on LinkedIn if you are interested.

Have a nice day,

Ondrej Divis

GeorgeMcGeachie
Active Contributor
0 Kudos
I agree - I've had to write a script to do this in the past and it was PDM-specific. I also added some extended attributes to help with the matching process.