General discussion

Hi Idea Community!
I have a problem regarding exporting reports to pdfs.
Sometimes when i want to export report to pdf IDEA starts the export and i see tens/hundrets of pages beeing generated in the pop up window. If i would leave it there it could generate the report infinitely. There should be one or two pages tops usually. This occures sometimes on my machine and then suddenly the issue disapears. Unfortunately this can happen on other machines in my organisation and the problem wouldnt go away.
Please help!

Greetings, where can I get the date functions #cwi_1stOfNextMonth(), so I can download them all and install them?

Hello,
Some of my IDEA files were saved with IMD extensions but when I installed IDEA 12.3 version, I cannot open these files.  Instead, I keep getting the message that IDEA can open IDM files only.  Is there anyway to open up the old files with IMD?
Thanks,
Samy 

Hi everyone, just to let you know there is a site called Auditopia where they have lots of free training in data analytics.  Also the site is undergoing changes and until Feb 22, 2024 you can join the groups for free, one of them is on IDEA, after that date the groups will only be for pro members, I would suggest you check it out.

https://auditopia.com/groups-list/

Hi Brian,
I hope this message finds you well. I am reaching out to seek assistance in sorting the columns of my table based on our fiscal year, which runs from April to March. The table may include only a subset of months, for example, from April to August.
I am wondering if there is a more efficient way to achieve this rather than manually sorting the columns. I attempted to use an "if" function, but I encountered difficulties in implementing it successfully.
Ideally, I would like to extract the data with logic similar to the following:
 
 

I was using IDEA and running some scripts, suddenly I encountered the attach pop up.
I have check that the system anti virus is not blocking the software.
How can I solve this issue?

When applying criteria IDEA freezes at 0% with any file.  I imported a tiny 3 row, 2 field test file.  I set a criteria and it worked ok.  Then if you close and reopen the file it just sits at 0%.  IDEA is being run from a local drive (not network) and i have full permissions on the location. Any ideas?

Hi!
I'm looking for a script that would append additional column into my ile with values equal to source file name.
In my example I have text files e.g.  20230831.txt with one column of data.
I would like to import this file into IDEA and have to column of which one would store in every field value "20230831".
If there would be a way to import multiple file this way at the same time that would be excelent! :)
 
Thanks in advance for the help!
Regards,
Maciej

Hi,
 
I am importing a text file which has 32 lakh records but upon import idea shows only 16 lakh records. 
 
Can someone help me what could be the reason. System has enough space

I am trying to import a table with today's date, that is, current. but it throws an access denied error on line 8.
example
Sub Main
 Call ODBCImport()
End Sub
 
Function ODBCImport
' para esta tabla rango de fecha para tomar el balance que quedo. 
dbName = "Devengo.IMD"Am I not doing it properly?