Veda2.0 Released!


CSV Export in Veda
#1
I use the csv export function in Veda to export ca. 100 tables to create a dashboard (e.g. https://tim-review1.netlify.app/results). I find the function really convinient! However currently it has a few "side effects":
- it takes about half an hour to query the data and several minutes to half an hour to write it out to csv files;
- during this time the application becomes not usable;
- after finishing the job, Veda does not always release the resources. Actually in some cases it has to be restarted (simply closing is not sufficient) for resources to be released.

I was wondering:
- is there any way to make the export process more efficient?
- is it possible see which of the tables take longest to export?

Cheers,
Olex
Reply
#2
We will make the CSV export more efficient in the next update. Hopefully, your second request will not stand after that.

The dashboard looks great! We should do a web meeting to look at the advanced reporting feature at some point. It is designed to create input for such platforms through systematic specification in an Excel file. No need to create numerous views.
Reply
#3
Ok, thank a mil, Amit! :-)
Would be great to learn about the advanced reporting feature.
Reply
#4
Thanks a lot, Amit! I've tested the most recent version and noticed a significant efficiency improvement of CSV export: 113 results tables with 7 scenarios for a single region model with 40 time slices and 22 periods now takes about 14 minutes.
Reply
#5
thanks for the update Smile
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Veda Help Saad Awan 2 1,030 11-07-2023, 02:51 PM
Last Post: Saad Awan
  Veda Help Saad Awan 15 5,156 11-07-2023, 12:55 PM
Last Post: AKanudia
  Veda Errors Saad Awan 0 562 03-07-2023, 06:10 PM
Last Post: Saad Awan
  Veda Errors Saad Awan 2 1,196 16-06-2023, 04:06 PM
Last Post: Saad Awan
  VFE case export issue james 1 2,177 04-06-2021, 07:44 AM
Last Post: AKanudia
  MAC vs. Windows for VEDA-TIMES FE & BE? mbr1818 5 10,048 22-02-2021, 01:52 PM
Last Post: AKanudia
  problem with (re)SYNC of previous working models/DB after reinstall of VEDA Koen Smekens 9 8,083 29-12-2020, 08:01 PM
Last Post: Antti-L
  Fatal error in VEDA opening vahid.aryanpur 2 4,037 15-07-2020, 06:05 PM
Last Post: vahid.aryanpur
  Unexpected termination of the VEDA-FE run seckg 3 5,662 21-09-2019, 07:25 PM
Last Post: Antti-L
  Export all Tables to Excel in one step [email protected] 3 5,948 03-07-2019, 01:14 PM
Last Post: AKanudia

Forum Jump:


Users browsing this thread: 1 Guest(s)