Hi There,
I am currently using Command Line Parameters to export a view to Excel without any intervention and will be invoking this through VBA. I have three questions.
1. Does anyone know of a way to suppress the splash screen for Gridview so that it runs totally in the background?
and
2. Does anyone know of a way to export to .CSV through command lines instead of Excel?
3. Or at least to close Excel when it is done exporting - it leaves Excel open each time? (We can do this with programming but thought I'd ask)
Everything else is working perfectly and we can work around these issues, but it would be nice to have this all working perfectly.
Thanks for any input!

There is an INI setting that will send the ExcelDirect output directly to a CSV file. Details are in the ReadMe Help file with most applications. This is from the BankRec release note:

Thanks Andrew. That does work, except that it forces ALL USERS to export to CSV instead of Excel. I was hoping it would be available at the command line level. I am also posting the instructions here because it took a while to find them buried in an enhancement document.

If you don't have one already, create an ssi2xl.ini file in your x:\Softrak\System folder (where 'x' is the mapped drive Adagio is installed to) and enter the following settings, as per your particular environment.

[Initialization]

ForceCSV=1

NOTE: If you have Excel installed but want to use a CSV view instead you must have this setting. The setting is global to all users. Therefore, a site that has some machines with Excel and some with another viewer, say Open Office, would not need or want the setting 'on' unless they want ALL stations to use a viewer even if they have Excel (i.e. stations with Excel who wanted to use Excel would not be able to).


I am also VERY interested in an .ini setting that suppresses the Startup-splash screen for Grid View if that is a possibility.
Thanks.

Don't include the ForceCSV setting if you don't want to do this for all work stations. Just name the specific workstation in the INI file. Here is some more documentation about how this works:


If the EXE specified to open the resulting CSV file is not found, no error is reported.

Or, presuming that you are doing this after hours in a batch file, start the batch file by copying in an SSI2XL.INI file with the CSV setting, perform the ExcelDirect GridView commands, then copy back the original INI settings.

Don't hold your breath for suppressing the splash screen. Why is this important to you?

Thanks Andrew, This will be running at regular intervals all through the day. It looks like it will be an application that will be on someone's workstation so we want it to run in the background as much as possible. There are other options but we are trying to meet the client's request as close as we can.

The above instructions look like it applies only if Excel is not installed. The problem is Excel is installed on this machine, we just don't want to use it, we want it to go to .CSV.
Thanks again.

How about running it as a session on the server? or dedicating a machine to running the process? Since I don't really know what you are trying to accomplish, it's difficult to suggest an optimal strategy.

Of course, you could also adopt the "Copy INI" strategy for your process, and the user on the workstation would only notice if they happened to click the ExcelDirect button while the GV Export was happening in the background.

I have already suggested those two things. I think a server app is the best option, but not my decision. Basically the file that grid view produces is used to control some automated machinery. Very cool when we get it in. Thanks for your advice.

"The above instructions look like it applies only if Excel is not installed."

No, not the case. The above works whether or not Excel is installed on the machine.