How to export history from databases using IDEA script?

jennylam

Forums

Hi All,
I completed a few group projects via using IDEA macro, while I need to export the history, PDF version, from databases manaually for documentation purposes.
I read Language Browser for help, and it seems no introduction on that is about history export.
How could I get the history from databases automatically rather than manaually exporting them one by one?
Seeking for your advice.
Regards
 

Brian Element Sat, 03/24/2018 - 09:18

Hi Jenny,

Unfortunately the best the script can do is export it as a text file.  There are no native commands in IDEAScript to access the save as pdf for the history (that I know of).  Also there are no native commands in visual basic to do this, you would probably need to get an addon.

If you have 10.3 of IDEA I just looked and there is a python module that will create pdf documents.  So creating a script in python could be an option.

Brian

talebi Thu, 01/13/2022 - 15:43

Hi Brian,
To run the script above, should we have SQL on our computer?

Brian Element Thu, 01/13/2022 - 16:45

The script will only work for IDEA 10, it won't work for IDEA 11 as CaseWare changed how they track the project overview in IDEA 11 and the script hasn't been updated.

SKaiser Thu, 04/14/2022 - 15:40

Hi. I know this is old, but I've been trying to use this script, but I don't know much about SQL and I'm getting an error on line 41, because it doesn't find a provider. Is there anything else I have to set up befure running the script?

Brian Element Wed, 04/20/2022 - 11:38

The script was built for IDEA 10, the project overview changed in V11 and V12 so this script won't work for either of those two.  Unfortunately I don't have any updates of the script for the newer versions of IDEA.

jennylam Sun, 03/25/2018 - 21:20

Seems another computer language have to be involved. I will learn it when I am leisure.
Thank you all your advices. :)
Kind Rgards

talebi Fri, 02/18/2022 - 17:16

Hi Brian, I have question for you. Do we need SQL in our computer to run this Macros?
I get an error on line 40
 
Thanks,

klmi Thu, 05/12/2022 - 04:12

At least the smallest edition of MS SQL-Server must be installed on the system. 
SQL-Server Compact Edition is called with the lines:
connStr = "Provider=Microsoft.SQLSERVER.CE.OLEDB.3.5; DataSource=ProjectOverview.sdf" 
objConn.open connStr