Export data from Ivara to Excel using dynamic tables

Question

I am trying to generate a dynamic table linked to a specific section of Ivara to automate some calculations. There is any way to export to Excel a specific table from Ivara automatically using dynamic tables or other functions on Excel? Thanks.

David Crozier · Accepted Answer

Thanks for the additional detail. Couple of options depending on the result you want. First is to get the SQL from the configuration, in R6 and above you can do this by right clicking the configuration, select configuration, and select Display SQL (if you get ?'s, hold shift down and hit refresh). Once you have the SQL you have two options, 1) create a view in your SQL database based on the SQL, when you want the data query the view. Second is to create a target table in the SQL database, create a script that clears the table and then runs the extracted SQL as an insert into your table. Let me know if that helps, if you would like to get into more detail, or discuss this i would suggest a call, you can reach me at 3605310557 or email me at David.crozier@bentley.com. If you would like we could also estimate doing this work for you. Let me know. thanks David

Daniel Hillman · Answer

Hello Francesc Castellvell Baqu&eacute; , 
 As you have pointed out the Display SQL option is not available. 
 This is due to running the 'Smart Client'. The default behavior when using the smart client is to not show the 'Display SQL', however, if you hold the shift key down then right click the list as you have done, the 'Display SQL' will show up. 
 Hope this helps. 
 Dan

David Crozier · Answer

I'm not sure which screen you are on, but it looks like it is from a Browse window inside another object, like projects? Not sure the display SQL works from there becuase the product does some embedded filtering before those types of screens are displayed that would not show up in the SQL. You would need to ask Support that one. However, if you are looking for transactions the best way to get this is to go to the resource management view, transaction tab, all transactions sub tab, enter your filter data and then do the right click, show SQL. Let me know if that helps.