IDEAScript Questions

Hi again,
I'm runing a script that involves importing an excel spreadsheet and then multiple pdfs, which are all joined in turn to the spreadsheet.
To eliminate error, I'd first list to read the data from a specific field in the excel file (trader ID) and from a specific field in the first pdf import (trader ID) to ensure that the matching keys are there.
The Trader ID will remain constant, i.e. it will be the same in every cell in the file.

I have in my database a caracter's field wich contains sometines quotes.
exemple : JOURNAL DES "A NOUVEAUX"
I'm trying to replace or delate quote " by the following function but it doesn't work :
    Set db = Client.OpenDatabase(DBNAME)
    Set task = db.TableManagement
    Set field = db.TableDef.NewField
    field.Name = "JOURLIB2"
    field.Description = ""
    field.Type = WI_VIRT_CHAR

Hi,
I would like to know if it's possible to protect a script with a password ?
I don't want the users modify the script.
Thank you
Ben

Is it possible to import delimited text files without an RDF? 
 
I believe that is what Mohamed was doing here using RDFCREATORLib, but I can't get it to work in IDEA script.
 
https://www.ideascripting.com/forum/issue-importing-date-field-text-file
 
Thanks
Scott

Hi there.
I have to export many information to excel for some users but i have to wait for them to confirm whent to do it. They don't have database users so I was thinking to create some sort of configuration file where I do write my credentials and let them execute my script to import data...I know it's to much to ask encrypting-decrypting function to retrieve authetication info, but I'm expecting to be able of retrieving user and password.
Any advice?

Hi Brian,
I'm sure somebody might have asked you the question.
I'm coming back to idea scripting after three years and almost forgot all the tips and tricks.
Previously i have created many macros with list box but not rememebr facing this issue.
I'm getting internal error for the below example. I have defined the array for list box seperately but still facing issue. I'm using idea 10 version. Do you see something that i'm missing? I have a 3000 line code having this problem. so, just created an example with simple list box.
code:

Hi Brian,
I'm writing a script that creates a working folder, does a lot of file compilation within that folder, and then moves the resulting two files to a new folder.
Once the results are moved to the new folder I then want to delete the working folder.
 
As part of the main subroutine I have the folder name defined much earlier in the script as shown below
 
Set fldrName as String
Set wD as String
 
wD= CurDir()

I've noticed that whenever I run a script which creates a new database, I have to manually click the "Refresh List" to get the File Explorer to display the new database which was created. Is there a line of code I can put at the end of my script to automatically refresh the File Explorer?

Is there a way to check if a field type is numeric or a string? I found the code to check is a field exists but now i need some code to check is the field type is numeric or not.
 
 
Function checkIfFieldNameExists(fieldname As String, filename As String) As String
 
fieldname = UCase(fieldname)
origFieldName = fieldname
 
Set db = Client.OpenDatabase(Databasename)
Set table = db.TableDef
field_count = table.count
 
ReDim fieldNames(field_count)
 
For i = 1 To field_count

I have a macro now that performs extractions and random samples based on a number of user-entered edit boxes on the dialog screen. The user entered data comes from a standardized Excel workbook that contains the proper data in a structured manner. What am I wondering is if there is a way to "import" those values such that the text boxes are essentially filled in with the data contained in the Excel workbook?
Thanks for any information!