IDEAScript Questions
Extracting blank records in a file
Forums
Hi all
I have built a script that extracts blank records from each field in a file. It is running without any error but it is not creating the extracted database.
The script is as below. Please help, thanks.
________________________________________________________________________________________
Sub Main
'Variable declarations
'Database objects needed from active DB
Dim NumFields As Integer
Dim olddb As Object
Dim task As Object
- Read more about Extracting blank records in a file
- 3 comments
- Log in or register to post comments
Create Pivot table from Ideascript
Forums
I am new to scritpting and have been utilizing history to create most of my scripts. I wanted to try and script to create a pivot table but unfortunatly when you create a pivot table there is no history to review. Is there a snippet or could someone share an example of how to create a pivot table in ideascript?
- Read more about Create Pivot table from Ideascript
- 9 comments
- Log in or register to post comments
Dialog Boxes
Forums
Hi, I am back once again. Have been working on the script and its been smooth with serveral ups and downs.
The current issue I am facing is that I cannot seem to store information within an object and I have the same error coming back to me each time.
My Dialog box's name is NewDialogX
sFieldName = listBox1$(NewDialogX.DialogBoxDropListBox2)
Error : Invalid Qualifier
If I were to remove NewDialogX the code runs but no information will be store in sFieldName.
p.s I ran a message box right after this.
Cheers!
- Read more about Dialog Boxes
- 8 comments
- Log in or register to post comments
Browse windows to select item
Forums
Hi Brain,
How are you doing? can you help me with a bit of script? I'm trying to get browse window to select a file. I already found a bit of script that lets you select a folder, but i need to select the file. I'm having problems converting the script to let me select a file instead of a folder.
Function BrowseFolder() Dim oFolder, oFolderItem Dim oPath, oShell, strPath, item Dim msg As String
- Read more about Browse windows to select item
- 8 comments
- Log in or register to post comments
How to compile a script
Forums
Hi folks,
Hoping you can help as I'm struggling to get this script to run and being fairly new to scripting (I've only compiled a couple before), I was hoping to get some help on what I'm doing wrong.
I've attached the script I'm trying to run, which is a composite of all the IDEA scripts for each stage of the process I want to automate. The problem I'm having is is keeps telling me I haven't defined my database names; I tried to do this using Dim but it still didn't work no matter what I entered so I removed it.
- Read more about How to compile a script
- 1 comment
- Log in or register to post comments
Hide Fields
Forums
Hi!
May I know if there is a way to hide fields?
p.s I have appended a field and if i were to use remove field function it would return an error
- Read more about Hide Fields
- 2 comments
- Log in or register to post comments
IDEAScripting with Dialogs
Forums
Greetings! (edited) This is my first post after a year being a member.
I am working in a yearly project and because of that I programmed everything in IDEA. My Project Manager asked me to program everything in a way that anyone, with little IDEA knowledge, can run it. I have many IDEAScripts that I wrote to perform all the analysis. Now I added dialogs to make it easier. Everything runs great without errors. Almost perfect! But (there's always a but)...
- Read more about IDEAScripting with Dialogs
- 11 comments
- Log in or register to post comments
Get data from Edit Input Box
Forums
Hi, I am very new to programming and would like to know how i can use data being entered into edit input boxes in my code.
- Read more about Get data from Edit Input Box
- 8 comments
- Log in or register to post comments
Overlapping of Dates
Forums
Hello, my current data include the travel's start date and end date.
I hope to identify duplicate entries(employee ID) with all overlapping travel date. May i know how can i go about doing it?
regards,iceshock
- Read more about Overlapping of Dates
- 1 comment
- Log in or register to post comments
How to export history from databases using IDEA script?
Forums
Hi All,
I completed a few group projects via using IDEA macro, while I need to export the history, PDF version, from databases manaually for documentation purposes.
I read Language Browser for help, and it seems no introduction on that is about history export.
How could I get the history from databases automatically rather than manaually exporting them one by one?
Seeking for your advice.
Regards