Export Multiple Files From IDEA into Excel

10 posts / 0 new
Last post
aveenm293
Offline
Joined: 10/23/2012 - 16:02
Export Multiple Files From IDEA into Excel

Hi There
I am looking for a custom function / script that will allow me to export multiple IDEA databases into excel without exporting each one individually. I am using IDEA 8.5.
Thank you in advance!
Aveen
 

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

Hi Aveen, would that be multiple idea databases into the same Excel spreadsheet but with different worksheets or each IDEA database gets a separate spreadsheet?  IDEA has two scripts that might help you out which I have attached.  Let me know if you are looking for something different.

seif2468's picture
seif2468
Offline
Joined: 09/19/2017 - 08:00

Iam using IDEA 3.0 
first file gaves me error on line: 191 - object doesn't support this property or method 
task.IncludeAllFields

aclark
Offline
Joined: 03/23/2015 - 08:56

Brian, thank you for the script to export multiple databases into one Excel worksheet. It is exactly what I was looking for. What is the max amount of databases that can be exported into one worksheet? I tried to export about 20 and the script began processing before showing an error.
Thanks,

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

Hi Andrew,

These are actually scripts developed by IDEA, I just posted them here as they are very useful.

Can you give me more info on what the error was, also where these large databases?  You might have exceeded the limitations of excel.  Let me know a bit more info and I will see if I can figure out what happened.

Thanks

Brian

Derek
Offline
Joined: 03/29/2016 - 03:10

Hi Brian,
Based on your script -  Export Multiple Databases.iss, if I try to export multiple database (for example , one is sales personal information, anothers are sales order、invoice 、material training ... etc ) become a MS Access file, have any possible export to one Access file not multiple Access files ?
Thank you in advance!
Derek

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

Hi Derek,

I tried to find a way to do this on the weekend and I couldn't find an easy way.  Excel doesn't allow you to save as an Access database and in Access you can only bring in one Excel worksheet at a time.  So unfortunately I can't help you out with this problem.

Brian

raoul.kelly
Offline
Joined: 08/13/2019 - 07:12

Hi Brian 
Im hoping you can help me ,  Im having an issue with both  Export Multiple Databases.iss   and exportdatabase.iss  . When I run the export , i'm presented with the the browser for folder option, but am unable actually "browse"  . Attached below is a screenshot of what I see
 
Thanks in advance for your advice
 

Images: 
svanzon
Offline
Joined: 09/06/2018 - 10:35

I have the same problem, it always opens only the desktop and I can not browse to the IDEA folder. Have tried the script on this page and the one from the IDEAscirpt vault (the outcome is the same).

  • OS: Windows 10
  • IDEA: Client Version: 10.4.1.1032 (X86)
  • Latest Excel (Microsoft 365)
raoul.kelly
Offline
Joined: 08/13/2019 - 07:12

Resolved by using Export Multiple Databases.iss   and exportdatabase.iss from IdeaScriptVault