How to export history from databases using IDEA script?

20 posts / 0 new
Last post
Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

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
Offline
Joined: 11/23/2021 - 14:15

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

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

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
Offline
Joined: 11/11/2021 - 10:30

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's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

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
Offline
Joined: 03/11/2017 - 21:18

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

talebi
Offline
Joined: 11/23/2021 - 14:15

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,

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

No you don't need SQL on your computer for this macro.

klmi
Offline
Joined: 02/13/2019 - 08:41

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

Pages