# Installation 

## Requirements

- Windows
- .NET 4.5 or greater
- EA 10.0 or greater (some functions are not supported with EA 9.0, possible Exception)
- Local administration rights for installation

## Install

You can choose a per-user installation to install without admin provileges.

- Click on hoTools.msi and follow the instructions
- Advanced, to choose a per-user installation to install without admin rights

If you chosse advanced you can decide wheter to install per-user (no admin privileges required) or per-machine.

![](images/NoAdminInstall1.png)
![](images/NoAdminInstall0.png)

### SPARX EA

- [SPARX: Import MDG Technology to Model](http://sparxsystems.com/enterprise_architect_user_guide/13.0/modeling_tools/importmdgtechnologies.html)
- [SPARX: Manage MDG Window](http://www.sparxsystems.com/enterprise_architect_user_guide/13.0/modeling_tools/manage_mdg_technologies.html)
- [SPARX: Manage Add-Ins](http://www.sparxsystems.com/enterprise_architect_user_guide/13.0/automation/addinmanager.html)

### hoModelViewsMDG.xml

[Features](hoModelViewMDG)

In users\<userName>AppData\Local\Apps\hoTools\ you find the MDG 'hoModelViewsMDG.xml'. To install it see:

- [Import MDG Technology to Model](http://sparxsystems.com/enterprise_architect_user_guide/13.0/modeling_tools/importmdgtechnologies.html)


It contains Model Views and Searches for:

- Diagrams
- Diagram Types

## Settings

- EA
  - In EA: Extension, Addin Windows is selected
  - In EA: Manage Addins, MDG: hoTools is selected
  - hoToolsRemove.ps1 (deinstall with PowerShell, just for convenience)
- hoTools Settings
  - hoTools Tab
    - [General](SettingsGeneral)
    - [LineStyle](Setting-default-Linestyle)
    - [Toolbar](Settings-for-Toolbars-and-Services)
    - [Keys](Settings-Global-Keys)
  - SQL and Script Tab
    - [SQL + Script](Settings-for-Toolbars-and-Services)

  hoTools saves the settings.

## Folders involved

It may slightly differ dependent on the Windows release.

### Application / Software

users\<userName>AppData\Local\Apps\hoTools\

| Name                    | Description                                               |
|-------------------------|-----------------------------------------------------------|
| ActiveX.dll.config      | Default configuration                                     |
| EaStandardSearches.json | Documentation EA Standard Searches for Searching          |
| [hoModelViewsMDG.xml](hoModelViewMDG)     | MDG: Model Views (Diagram, Example to structure Searches  |
| [hoToolsBasic.xml](MdgBasic)        | MDG: Basic Searches for hoTools                           |
| [hoToolsCompilation.xml](MdgCompilation)  | MDG: Compilation of Searches for hoTools                  |
| [hoToolsHybridScripts.xml](MdgHybridScripts)  | MDG: Hybrid Scripts to easily call Java/C# console applications                  |
| SQL.zip                 | Some of my searches you may use to see how it works. Copy the content to your defined SQL path in [Settings SQL and Scripts](SettingsSqlAndScript).       |

### Configuration

users\<userName>AppData\Roaming\Apps\ho\hoTools\..

| Name              | Description                                                                             |
|-------------------|-----------------------------------------------------------------------------------------|
| user.config       | Current configuration, delete to get the default settings                               |
| UserSearches.json | Definition of user Searches to easily [find](FindSearch) them, just an easier [access](FindSearch) to your Searches |

### SQL error

The files are also accessable via hoTools, Help menu.
  
- %APPDATA%\Sparx Systems\EA\dberror.txt (Last SQL error, deleted before SQL is processed)
- %APPDATA%\Sparx Systems\EA\hoTools_LastSql.txt (The SQL string send to database)
- %APPDATA%\Sparx Systems\EA\hoTools_SqlTemplatesAndMacros.txt (hoTools Macros and templates, after first SQL execution)

## References

- [Edit SQL Search](SqlExternalEdit)
- [Execute Search](ExecuteSearch)
- [Export SQL results to Excel](Export)
- [Export csv from Clipboard to Excel](Export)
- [Find Search](FindSearch)
- [hoTools](hoTools)
- [SQL](SQL)
- [MdgBasic: Basic Searches and more](MdgBasic)
- [MdgCompilation: Advanced Searches and more](MdgCompilation)
- [Manage Add-Ins](http://www.sparxsystems.com/enterprise_architect_user_guide/13.0/automation/addinmanager.html)
- [Develop an EA Add-In installer with WIX](AddInWithoutAdmin)
- [MDG](MDG)
  - [hoMdgBasic](MdgBasic)
  - [hoMdgCompilation](MdgCompilation)
  - [hoMdgHybridScripting](MdgHybridScripting)
  - [hoModelView](hoModelViewMDG)

### Books

- [Fifty Enterprise Architect tricks, by Peter Doomen](https://leanpub.com/entarch)
- [Scripting Enterprise Architect, by Thomas Kilian](https://leanpub.com/ScriptingEA)
- [Inside Enterprise Architect, by Thomas Kilian](https://leanpub.com/InsideEA)
- [Shape Script made easy, by Thomas Kilian](https://leanpub.com/shapescript)
- [Domain Specific Profiles, by Thomas Kilian](https://leanpub.com/EA-MDG-Profiles)