Join us at the Scottish Gathering of EA Users
Friday 29th September 2017, Livingston, Scotland

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 and can be downloaded from Sparx Systems website: www.sparxsystems.com/products/ea/trial.html 
 
Workshop Style: 20% theory, 80% practical.
This workshop comprises a set of targeted hands-on exercises 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. Booklets also contain exercises and suggested solutions. Following successful completion of the workshop each delegate receives a certificate.
Module Key: Teaches concepts and notation

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

Download
Course Outline

      Includes paper exercises, EA hands-on sessions

Workshop Modules: HIPPO 00    Introduction   hour          
  HIPPO W61  EA Excel CSV Workshop  2 hours      
  HIPPO W63  EA Excel Scripting Workshop  5 hours      


Workshop Details:
 

HIPPO 00  Introduction
      hour  
 

  Delegate background and objectives

  Timetable and course outline

 
HIPPO W61  EA Excel CSV Workshop

    hour  

 EA Hands-On Exercises  1 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 W63  EA Excel Scripting Workshop

   1 hour  

 EA Hands-On Exercises  4 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

  Extend scripts to transfer tagged values

  Synchronise EA elements with Excel

hippo@hippo-software.co.uk

+44 (0)1506 202164

    Hippo Software Limited 2017. All registered trademarks acknowledged.