![caseware idea extract caseware idea extract](https://i.ytimg.com/vi/QVNmiNjf3e0/hqdefault.jpg)
ProjectInfo(i).Unsupported = rs.Fields("Unsupported") ProjectInfo(i).SubFolder = rs.Fields("SubFolder") ProjectInfo(i).Filename = rs.Fields("Filename") ProjectInfo(i).TaskStream = rs.Fields("TaskStream") ProjectInfo(i).TaskType = rs.Fields("TaskType") ProjectInfo(i).AllRecordsUsed = rs.Fields("AllRecordsUsed") ProjectInfo(i).RecordGUID = rs.Fields("RecordGUID") ProjectInfo(i).TaskGUID = rs.Fields("TaskGUID") ProjectInfo(i).DataBaseGUID = rs.Fields("DatabaseGUID") ProjectInfo(i).HistoryLog = rs.Fields("HistoryLog") ProjectInfo(i).IDEAScript = rs.Fields("IDEAScript")
![caseware idea extract caseware idea extract](https://www.ideascripting.com/sites/default/files/ltdt4.jpg)
ProjectInfo(i).UserName = rs.Fields("UserName") Allows the User to extract a specified number of top or bottom records from the dataset, for the. ProjectInfo(i).DateTime = rs.Fields("DateTime") CaseWare IDEA Quick Access Functionality Crib Sheet. ProjectInfo(i).TaskName = rs.Fields("TaskName") 'populate the array with the information. ReDim preserve ProjectInfo(UBound(ProjectInfo) + 1)
![caseware idea extract caseware idea extract](https://docplayer.net/docs-images/68/59595269/images/58-1.jpg)
'increment the array to hold the informaiton Set rs = objConn.execute("SELECT TaskName, DateTime, UserName, IDEAScript, HistoryLog, DatabaseGUID, TaskGUID, RecordGUID, AllRecordsUsed, TaskType, TaskStream, Filename, SubFolder, Unsupported, ProjectName, Deleted FROM Overview")' You can import your clients data directly from online accounting software.
#Caseware idea extract software#
If you have the new method switched on in your app, refer to Import data from online accounting software - new method. In this instance all the fields are accessed, I used the field names instead of using SELECT *.* Import data from online accounting software (old method) This is the old method to import fom online accounting software. The Data source has to point to the sdf file of the project you want to extract the infoĬonnStr = "Provider=.OLEDB.3.5 Data Source=C:\Users\eleme\Documents\My IDEA Documents\IDEA Projects\EBP v10.2\ProjectOverview.sdf " If we use your example of a Sales Transaction file, we can first do a summary by Customer Number, and then do an extract of all the Customers that have one transaction. The first is to perform a summary, an extraction and finally a join. Set objConn = CreateObject("ADODB.Connection") A: You can do this several different ways in IDEA. 'create the connection object to the database 'create a type to hold the entire overview table from the database I am using a program called CompactView to view the database.
#Caseware idea extract how to#
This shows how to access the table and some basic SQL to read all the records into an array which can be changed to access specific information. To assist with easily analysing SAP® data on an ongoing basis, we have SmartExporter a Windows based extraction tool, specifically designed to import SAP® data into CaseWare IDEA. The Parent table shows the parent child relationship between the files through the ChildGUID and ParentGUID. The sdf database contains two tables, the Overview which I am access and the Parent. Here is some code that should get you on the right track.