thanks Mr. brian
now i will need ur help when actually i have to iimport data
ur guidance that time will help a lot
Let me know and I will try and help you out.
with any permission you must have an ORACLE user to access the tables in IDEA through ODBC.
Connecting to the ORACLE database through ODBC does not display the tables.
I have managed to amend the Oracle ODBC script to meet my needs, however, I am now seeking to improve it and remove the need to make manual amendments. As can be seen in the attachment, I have had to include a payment date in the SQL parameters for the import.
Is it possible to add variables that are not included on the dialogue box? I would like to pull from eg the user entering 19/20, a "FROM" date of '01-APR-2019' and a TO date of '31-MAR-2020' which can be used in the SQL.
Currently, if a user was to enter 17/18 in the Financial Year, I would expect it would bring back no results, due to my fixed SQL parameters.
I did have a thought that I could include a file or database with a list of dates, financial years and start and end dates to look up to, however, that may be overcomplicating things at this stage!
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