3 weeks ago
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
Request clarification before answering.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
54 | |
10 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.