Skip to main content

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!

ElaP Wed, 04/06/2022 - 03:29

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 Wed, 04/06/2022 - 11:55

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.