Skip to Main Content

SQL Developer Data Modeler

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Glossary Editor Import / Export

jnicholas330Jul 14 2016 — edited Sep 19 2016

I wanted to update one of my glossaries using an external tool, so I exported the data as a CSV. However, when I reimported it, the fields didn't map 1-to-1. It appears that the Export uses a Oracle Data Modeler specific format, while the import uses an ERwin format. Please add an import option that can consume the data exported from the tool.

Comments

Philip Stoyanov-Oracle

Glosary editor can export in CSV (text) or XLS(Excel) format. And it can import text format(CSV/TXT that for ERwin) , Data Modeler format (if you want to import another glossary - probably edited) and Excel format. Tested with export/import of Excel format and it works for me. In excel format you only can modify existing fields, cannot add new terms into glossary.

Philip

jnicholas330

I do not see the XLS option. However, if DM is unable to read in new entries, it would not serve my needs.

pastedImage_0.png

Philip Stoyanov-Oracle

Sorry, I was looking DM 4.2

Philip

DM 4.1.5 is out and now export to CSV is bound to content in DM glossary (all elements of word definition are exported) and you can change it or add new elements and import it later.

In DM 4.2 that can be done also with Excel format (you need to have some existing entries in the excel file )

Philip

1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 17 2016
Added on Jul 14 2016
4 comments
1,507 views