IDEAScript suggestions
Suggestions for useful IDEAScripts
overall api reference
Forums
Hi, is there a PDF or some website that contains all the API reference?
like this sequence:
Try
client = New Idea.IdeaClient
client.RunThroughVisualScript = True
db = client.OpenDatabase(dbName)
Catch ex As Exception
- Read more about overall api reference
- 1 comment
- Log in or register to post comments
Daily Script
Renombrar nombre de columnas
Forums
Buena tarde Brian estoy buscando una forma de poder renombrer todas las columans de mi base agradeceria algun scrip
- Read more about Renombrar nombre de columnas
- 3 comments
- Log in or register to post comments
create formulario en Ideascritps
Forums
create a form in ideascritps that selects two dates in a calendar type textbox and substitutes those dates in a search in an import dbc
Note: calendar type
- Read more about create formulario en Ideascritps
- 2 comments
- Log in or register to post comments
Exporting IDEA's File Explorer List of databases to Excel?
Forums
Hello,
I am not sure if there is any other way to do this. What I need is to be able to export the list of IMD's in my IDEA's File Explorer to an Excel or Text file.
for example, I currently have over 50 IMD files listed under the IDEA File Explorer window for the current project. The IDEA File Explorer lists important information about each of the 50 IMD:
I need to export this list to Excel with all the information displayed there: Name, Number of Records, Size, Modified Date, Crated date.
Export Multipel IDEA Database into 1 Excel File
Forums
Hello!
I am having trouble exporting my .IMD databases to an Excel (with multiple sheets)
I have tried the IdeaScripVault scripts "Export Multiple Databases.iss" and "Databases.iss" but I always have the same problem
If the folder that contains all the IMD has subfolders (can be empty) I get a message: MsgBox ("The folder you selected does not contain IDEA databases", 16, "Error")
But if the folder where all the .IMD are does not contain more subfolders, the script works correctly
Can you help me?
Thanks!
How to eliminate the Reversals (DR & CR Net to Zero) in Journal entries
Forums
Hope you are well I'm constantly following your posts in the site and your idea-scripts and im searching for idea-script or procedure to do with this issue ( Removes reversals of Dr & Cr in GL) if you can help me im thankfull to your appreciate Thanks,Hady
Function to email output from IDEA
Forums
Hi Brian,
I would like to know if a script can be made to enable automatic mailing of outputs to pre determined email ID's. If there is no function in IDEA, is there any workaround?
Regards
Padma T
- Read more about Function to email output from IDEA
- 3 comments
- Log in or register to post comments
Search numbers from range in another database
Forums
Hi
Please help
I have 2 tables
1st table contains value (e.g. 2, 8, 13, 17, 55, 104,)
2nd table contains 3 columns. 1st Column Start range, 2nd column End range, 3rd Column value)
I want to build a query, where second column will be added in 1st Table.....which will contain criteria and will query the value in 1st table and check the value betwene Start and End range of 2nd table...if the value is between the start and end range...then it will give the corresponding value in 3rd column of 2nd table.
E.g.
1st Table
Value
- Read more about Search numbers from range in another database
- 1 comment
- Log in or register to post comments
Previous Row Repeat Given Certain Condition in Column X
Forums
Hi all!
First post :)
I could not find any script for this so I'll post here.
I want to create a script that picks out the following information below. Please note that all information is within one column. Each break is one row.
I have a column that contains the following information that repeats for all the transactions, see example below.
#Verification A3000 "20170301" "Personal Expenses" <- Header information