Book a Demo

Author Topic: Notes input to describe database format issue  (Read 6093 times)

Wolf K

  • EA Novice
  • *
  • Posts: 7
  • Karma: +0/-0
    • View Profile
Notes input to describe database format issue
« on: May 21, 2014, 05:20:41 am »
I am using EA to document my database dictionary.  The output for my customer is a generated RTF document.  In order to add sufficient field descriptions I use the 'Notes' field for the field element.  However, the format options are not really sufficient to document a field properly.  For example: I try to copy and paste a small table into the notes field (from Word) and all formatting is immediately lost.  Is there a way to have EA support better formatted notes?

skiwi

  • EA Expert
  • ****
  • Posts: 2081
  • Karma: +46/-82
    • View Profile
Re: Notes input to describe database format issue
« Reply #1 on: May 21, 2014, 06:41:38 am »
I wish
and good luck with that (see Memo tags allow rich text please )

At a minimum please submit a feature request
Orthogonality rules
Using EA16.1 (1627) on Windows 11 Enterprise/64 bit. Repositories in SQLServer2019 DB Schema 1558.
WebEA on Pro Cloud Server 4.2.64

Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 8098
  • Karma: +118/-20
    • View Profile
Re: Notes input to describe database format issue
« Reply #2 on: May 22, 2014, 08:42:08 am »
The recommendation is to use a linked document if you want tables as part of your notes.

Wolf K

  • EA Novice
  • *
  • Posts: 7
  • Karma: +0/-0
    • View Profile
Re: Notes input to describe database format issue
« Reply #3 on: May 23, 2014, 04:41:12 am »
I don't understand this suggestion.  I have about 100-150 feature classes and tables in my model with at least (estimate) 10+ attributes (columns) for each.  I want to print out a data dictionary for my customer and I in the data dictionary I want to show in the 'notes' column my 'formatted' explanation for that field.  You are suggesting that I add a 'linked' document, I am not sure how that would help me.  In essence I am writing my data dictionary now outside EA.  I thought EA would allow me to single source my efforts.

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +396/-301
  • I'm no guru at all
    • View Profile
Re: Notes input to describe database format issue
« Reply #4 on: May 23, 2014, 05:20:31 am »
Actually that is exactly what Simon suggests. You may consider to use automation to create the linked documents.

q.

Mauricio Moya (Arquesoft)

  • EA User
  • **
  • Posts: 344
  • Karma: +8/-4
  • EA Consulting and development in Spanish
    • View Profile
    • Arquehub Azure Module
Re: Notes input to describe database format issue
« Reply #5 on: May 23, 2014, 06:11:41 am »
But linked documents exist per class/table (element), not per attribute/colum as required in this case.

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +396/-301
  • I'm no guru at all
    • View Profile
Re: Notes input to describe database format issue
« Reply #6 on: May 23, 2014, 06:56:48 am »
Quote
But linked documents exist per class/table (element), not per attribute/colum as required in this case.
Sure. So you have to create a more (or less) complex document inside the class which knows about the contained attributes. We all know it's crap but you likely can't hope for a meaningful solution in time.

q.

Wolf K

  • EA Novice
  • *
  • Posts: 7
  • Karma: +0/-0
    • View Profile
Re: Notes input to describe database format issue
« Reply #7 on: May 23, 2014, 10:18:27 am »
This is getting pretty complicated for a relatively simple task.  It looks like I am back to maintaining a separate data dictionary in word.  Unfortunately my customer insists that I add various business rules that affect most columns to the data dictionary, and the notepad style formatting supported by EA is not sufficient for this task.

skiwi

  • EA Expert
  • ****
  • Posts: 2081
  • Karma: +46/-82
    • View Profile
Re: Notes input to describe database format issue
« Reply #8 on: May 23, 2014, 01:08:32 pm »
Woolf, get yourself and 100 of your friends, and all the EA trainers you know to each submit a feature request. You might get it by christmas, especially if your 100 friends are all EA trainers.
Orthogonality rules
Using EA16.1 (1627) on Windows 11 Enterprise/64 bit. Repositories in SQLServer2019 DB Schema 1558.
WebEA on Pro Cloud Server 4.2.64