Skip to main content

General discussion

Is it posible to change the execution time for a script?

Hello Everyone,
 
What I'm trying to do is running an IdeaScript wich calls a python program, that program makes a transformation of the data and then create a csv which is taken by IDEA again. But the problem I have is that IDEA execute the script too fast, so the csv is not generated on time to IDEA. That is the reason why I want to delay the time of execution to give python some time to generate the file that IDEA requests.
 

Report Reader and Adobe Pro DC

At my office we recently switched from Adobe 9 (I think) to Adobe Pro DC. We are finding some issues when we now import PDFs into Report Reader. For example Report Reader isn't reading the PDFs as clearly as before. It may turn the number 0 into the letter o. Usually we add a page number to the PDF, so if the Report Reader misses something, we can easily see where the problem is. However, adding the page number now seems to hinder from reading the PDF clearly. We have IDEA version 10. Would version 11 fix this? Or is anyone else running into a similar problem?

ODBC Import - Date Filter

Hi there,
Does anyone know how data can be imported using the ODBC connection feature in IDEA with applying a filter on a date field?  I have tried numerous formats for dates ('YYYY-MM-DD') and ('MM/DD/YYYY'), using both a live Oracle database and Excel practice files but nothing seems to work.  I can filter on character and on numeric fields with no problems, but date fields do not seem to work.  
Does anyone know how to fix this or is this a bug in IDEA with the ODBC connection?
Any help would be appreciated!
Mike

Internal Auditors

How many people here are internal auditors?  I'd love some ideas on ways to use IDEA in all sorts of areas.  I work for a tribal govt in Internal Audit and am also a CFE.  I use IDEA in a variety of ways usually for special projects like the new Covid 19 payroll, and determining turnover but would love to develop some weekly/monthly recurring analysis using the data I can get from our accounting system and the HR system.  Eventually I'd like to get access to the gaming data.    How many have the IDEA certifications?  I've been looking at jobs and a lot of

How to make a join with scripting - Criteria problem

Hi!!
While I was studying, i tried to make a join between 2 databases that I already have both IMD files.
I have a criteria inside IDEA, but I can't use the same criteria using IdeaScripting..
Would you mind helping me to fix it? Please!
 
Set db = Client.OpenDatabase("SR3_STEP1.IMD")
Set task = db.JoinDatabase
task.FileToJoin "SR3_STEP2.IMD"
task.IncludeAllPFields
task.AddSFieldToInc "ID_SR"