Enterprise Architect, UML, SysML, BPMN and ArchiMate
Home EA BPMN UML SysML ArchiMate Feedback Resources Pricing Partners Contact
 Home > EA > EA Excel Data Transfer Workshop
 

EA Excel Data Transfer Workshop

This workshop teaches delegates how to transfer data between Enterprise Architect and MS Excel. Delegates use CSV files and VBScript to synchronise data. This allows information such as a set of requirements or data model to be updated either as a spreadsheet or graphical model.
Duration: 1 day
 

 

Prerequisites: Delegates should have a working knowledge of Enterprise Architect.
Some basic programming experience is also helpful, but not essential.
 
Equipment:

This workshop is delivered on the customer's own site. The customer should provide a suitable training room with a projector to connect to our trainer's laptop and a whiteboard or flipchart. All delegates require access to a PC or laptop running Enterprise Architect (Corporate edition or higher) and Microsoft Excel.

A trial version of Enterprise Architect is fine for training purposes and can be downloaded from Sparx Systems website: www.sparxsystems.com/products/ea/trial.html 
 
Workshop Style: 25% theory, 75% practical.
This workshop comprises a set of targeted hands-on sessions to allow delegates to become confident using CSV and scripts to transfer data between Enterprise Architect and MS Excel.
 
Delegate Handouts: Each delegate receives a booklet containing all the workshop slides and comprehensive theory notes which form excellent reference material. A set of exercises and suggested solutions are also provided. Following successful completion of the workshop each delegate will receive a certificate.
Module Key: Teaches concepts and notation

  Teaches practical use of Enterprise Architect
              Covers UML, SysML, BPMN and/or ArchiMate

Download
Course Outline

      Includes paper exercises, EA hands-on sessions

Workshop Modules: HIPPO 00    Introduction   hour          
  HIPPO W41  EA Excel CSV Workshop  2 hours      
  HIPPO W43  EA Excel Scripting Workshop  5 hours      


Workshop Details:
 

HIPPO 00  Introduction   hour  
 
  • Delegate background and objectives

  • Timetable and workshop outline


HIPPO W41  EA Excel CSV Workshop  2 hours
 
 
  • Use CSV to transfer data from Excel to EA

  • Use CSV to transfer data from EA to Excel

  • Use CSV to transfer tagged values

 
HIPPO W43  EA Excel Scripting Workshop  5 hours
      
 
  • Write scripts to connect Excel to EA via API

  • Write scripts to transfer data from Excel to EA

  • Write scripts to transfer data from EA to Excel

hippo@hippo-software.co.uk

+44 (0)1506 202164

    Hippo Software Limited 2014. All registered trademarks acknowledged.