Export Multipel IDEA Database into 1 Excel File

5 posts / 0 new
Last post
EnriqueDiez
Offline
Joined: 10/30/2020 - 11:10
Export Multipel IDEA Database into 1 Excel File

Hello!

I am having trouble exporting my .IMD databases to an Excel (with multiple sheets)
I have tried the IdeaScripVault scripts "Export Multiple Databases.iss" and "Databases.iss" but I always have the same problem

If the folder that contains all the IMD has subfolders (can be empty) I get a message: MsgBox ("The folder you selected does not contain IDEA databases", 16, "Error")

But if the folder where all the .IMD are does not contain more subfolders, the script works correctly

Can you help me?

Thanks!

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57
Hi Enrique, what version of IDEA are you using?
ElaP
Offline
Joined: 03/30/2022 - 04:21

Hi Brian
Is it possible to export .IMD databases to an Excel with multiple worksheets?  For example, I have 5 .IMD databases and would like to export them to a single Excel file where each database is on a worksheet.
The version I have is IDEA 10.4.

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

Hi ElaP,

There is a solution but you need IDEA 11 + to use it.  It can be found in passport within the Utility SmartAnalyzer apps.  

For 10.4 I think there is a script in Passport that would probalby work for you.  It is called Export Multiple Databases to Excel.

ElaP
Offline
Joined: 03/30/2022 - 04:21

Thank you very much Brian