Book a Demo

Author Topic: Export time from Resource allocation to CSV  (Read 4917 times)

angel-chrystian

  • EA Novice
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
Export time from Resource allocation to CSV
« on: March 13, 2018, 05:47:47 am »
Hi,
I have a use cases package and each use case has its resource allocation information so I want to get a CSV file that contains the next fields:
- Role or Task
- Resource
- Expected time
- Time expended
- Notes`

I tried from the Publish -> CSV -> CSV Import/Export option but those fields are not listed.

Or how would I get a list of all the tasks assigned in the Resource Allocation window with resource and time?.

Thanks in advance.

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Export time from Resource allocation to CSV
« Reply #1 on: March 13, 2018, 08:58:25 am »
I'd recommend to adapt the CSV export script that comes with the EAScriptingLib so it fits your needs.

q.

angel-chrystian

  • EA Novice
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
Re: Export time from Resource allocation to CSV
« Reply #2 on: March 13, 2018, 02:40:24 pm »
Can you please point me to some documentation about creating a custom CSV exporter?.

Thanks.


Helmut Ortmann

  • EA User
  • **
  • Posts: 970
  • Karma: +42/-1
    • View Profile
Re: Export time from Resource allocation to CSV
« Reply #3 on: March 13, 2018, 06:08:29 pm »
Hi,

you can also:
- Build a search and export results to *.csv (I think some limitations with notes)
  (Standard EA feature)
- Use free hoTools which supports *.csv and Excel export for searches
  (https://github.com/Helmut-Ortmann/EnterpriseArchitect_hoTools/wiki/Export#sql-to-excel)

Kind regards,

Helmut
Coaching, Training, Workshop (Addins: hoTools, Search&Replace, LineStyle)

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Export time from Resource allocation to CSV
« Reply #4 on: March 13, 2018, 07:47:40 pm »
- Enable the EAScripLib MDG
- Open the scripting window (Tools/Scripting in pre V13)
- Look into the EAScriptLib folder and find a VB and a JScript version of a CSV export.

I think they are easily to adapt.

q.