Hi, we are starting to create a new model from scratch using IDA 8. I have tablename, columnname, column descriptions (documentation), datatypes, format and other information on a data dictionary spreadsheet. I want to know if there is a way to import into the tool so effort used in manually entring into IDA can be eliminated or reduced.
NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
This topic has been locked.
4 replies Latest Post - 2012-10-18T10:03:25Z by SystemAdmin
Pinned topic Help---Import attributes, descriptions, datatypes into IDA from Excel
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-10-18T10:03:25Z at 2012-10-18T10:03:25Z by SystemAdmin
rraddatz 060000QXJC55 PostsACCEPTED ANSWER
Re: Help---Import attributes, descriptions, datatypes into IDA from Excel2012-08-15T14:58:36Z in response to sai.teradbHi Sai,
You can use Model Import to import an excel spreadsheet into IDA; however, it has to be of the correct format. The format is described in a sample "Standard-Blank.xlsx" included with IDA:
In IDA 8.1, this directory could be:
Also provided is an Excel 'Add-In' based 'ribbon' or menu to help navigate and manage spreadsheets which are designed using the standard format.
sai.teradb 270005KCN52 PostsACCEPTED ANSWER
Re: Help---Import attributes, descriptions, datatypes into IDA from Excel2012-08-22T21:56:45Z in response to rraddatzRobin, I dont see any "Program Files\IBM\SDPShared" folder. And I also checked "C:\Program Files (x86)\IBM\IDA8.1.0\plugins\" I other IBM related folders but I dont see any excel spreadsheet.
rraddatz 060000QXJC55 Posts
SystemAdmin 110000D4XK374 PostsACCEPTED ANSWER
Re: Help---Import attributes, descriptions, datatypes into IDA from Excel2012-10-18T10:03:25Z in response to sai.teradbHi,
Thank you, I couldn't import data model and now I can.
remember to check the option Import Export tick during the install. Use the IBM installation Manager to add the option.