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.
To run the script above, should we have SQL on our computer?
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.
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?
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.
Seems another computer language have to be involved. I will learn it when I am leisure.
Thank you all your advices. :)
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
No you don't need SQL on your computer for this macro.
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"
IDEA is a trademark of CaseWare International Inc., used by permission.
All material provided on the IDEAScripting website is presented as is without any warranty or guarantee. Anybody using any solution provided on this pages is encouraged to validate the effectiveness and reliability on their own.
IDEA Help Videos
IDEA Related Videos
IDEA Success Stories