IDEAScript Questions
Scripts to Run Various Functions
Forums
Hello, we are currently utilizing IDEA 10. We run various functions for client data on things such as disbursements, A/R, and General Ledgers. These usually come in a variety of formats, which we import and write the various functions for. Is there a way to write a script to automate this process, much like the smart apps (which aren't currently an option for us).
- Read more about Scripts to Run Various Functions
- 1 comment
- Log in or register to post comments
Import data from a mySQL database
Forums
Hi,
I have loaded in a large amount of data into a mySQL database that I would like to also query from IDEA. I am new to IDEAScripting and would therefore like some assistance on how I could write an IDEAScript that will connect to the mySQL database and import all the tables into IDEA. Any suggestions?
Many thanks,
M
- Read more about Import data from a mySQL database
- 4 comments
- Log in or register to post comments
Script to Get the "Field Manipulation" window info
Forums
Hello !
I would like to know if there is a script which can put in a database all the "field manipulation" information : Field name, Type , Length, Parameter, Description
I would like to do this in order to compare field information especially when I need to make a join or append.
I am sorry if it has already been done, but I didn't find anything on this in the forum.
Many thanks for your help,
Best regards,
MagiBzh
Obtaining data from a database to use as a selection criteria
Forums
Dear All,
Currently i am making a script that is supposed to extract all cash transactions in excess of 15K. The data that i use is an auditfile(.adf). This is a database with all the journal entries of a financial administration.
Script Closes Early
Forums
Hello,
So I have this script that I've used countless times. I made a copy of it and within the copy made a few changes to the code to add some additional options. The issue is that when I run this new script it will sometimes run the entire script as it is supposed to perfectly, but then sometimes it just closes midway through. I've stepped through the program using the script editor and it works perfectly. I can't figure out why its closing early.
- Read more about Script Closes Early
- 3 comments
- Log in or register to post comments
Multi Files Importer: How to import SAP/AIS files
Forums
Hello!
I found this code:
For i = 0 To x
' Set-up the XML import task
Set task = Client.GetImportTask("ImportXML")
task.InputFileName = picked_folder & "\" & listbox2$(i)
Obtaining data from drop down combo box
Forums
Hey Brian,
This site has become a staple for me. Thanks so much for all your assistance.
I am trying to obtain the selection from a drop down combo box; however, when I select COL1 where the data is to be tested - nothing happens. When I select COL2 then the script continues and completes my test using the COL1 information. Any idea how to fix this or why it is happening?
This is a copy of the code that I am using to obtain the drop down combo box selection.
If dlg.DropListBox1 > 1 Then
userSel = ListBox1$(dlg.DropListBox1)
Else
- Read more about Obtaining data from drop down combo box
- 3 comments
- Log in or register to post comments
User determine column to test extraction
Forums
Hi Brian,
Is it possible for the user to enter the column to be tested and the extraction to use the user defined variable instead of hardcoding a column which will need to changed every extraction?
colNum = InputBox("Enter column to be tested (Col1, Col2, Col3 etc...)")
task.AddExtraction dbName, "", "@Isini(""Oper"", colNum)"
These are the two lines specifically. I tried to do it and it shows "Bad equation provided"; however, if i type Col1 instead of colNum, then it works.
Any ideas?
Thanks!
- Read more about User determine column to test extraction
- 8 comments
- Log in or register to post comments
Output calculation into new field
Forums
Hey, I've been trying to create a script which will perform a calculation to verify that a list of swedish social security numbers are valid. This is done by a mathematical process.
- Read more about Output calculation into new field
- 3 comments
- Log in or register to post comments
How to get the database's index information ?
Forums
Hi Brian,
If I have a IDEA file and there exist 4 index , have any possible to write a function to get all index information ?
Thanks,
Derek