Topic Options
#37522 - 06/21/13 11:50 AM GV to CSV
Brian Puddington Offline
Adagio Ace

Registered: 06/09/08
Posts: 225
Loc: Montreal, Canada
One user needs to export to a csv file from Gridview every day. All the other users export to Excel. I would like to automate the export to csv as much as possible using command line parameters. Changing the ssi2xl.ini file changes it for all users. I think that I am doing it wrong. What is the syntax for the ssi2xl.ini file? I seem to remember that somewhere in the file I can specify the user's Windows login and include a line "Forcecsv=1" or something like that. How do I have one user exporting from GV and the others exporting to Excel?

If this can't be done I will simply export to Excel and write a VBA macro in Excel to export to csv.
_________________________
Brian Puddington
Geneva Financial Systems
Montreal

Top
#37523 - 06/21/13 12:06 PM Re: GV to CSV [Re: Brian Puddington]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
In SSI2XL.INI the section should look like:
Code:
[Initialization] 
*-CSVDIR=C:\demodata
; Microsoft Notepad
workstation name-CSVVIEWER=c:\windows\system32\notepad.exe

Replace the workstation name with "*" to have the setting apply to everyone.
_________________________
Andrew Bates

Top
#37540 - 06/24/13 04:10 PM Re: GV to CSV [Re: Retired_Guy]
Bruce Gardner Offline
Adagio Wizard

Registered: 06/15/04
Posts: 3612
Loc: Toronto ON, Canada
Hello Support:
I've tested and that works perfectly in an interactive mode. Does it also work in an automated mode? Thank you.
_________________________
Bruce Gardner
ARX Business Solutions Inc.

Top
#37541 - 06/24/13 04:52 PM Re: GV to CSV [Re: Bruce Gardner]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Why wouldn't it?
_________________________
Andrew Bates

Top
#37542 - 06/24/13 08:24 PM Re: GV to CSV [Re: Retired_Guy]
Bruce Gardner Offline
Adagio Wizard

Registered: 06/15/04
Posts: 3612
Loc: Toronto ON, Canada
Thank you Andrew. That is helpful.
_________________________
Bruce Gardner
ARX Business Solutions Inc.

Top


Moderator:  Christa_Meissner 
Who's Online
1 registered (Softrak Support), 123 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14464 Topics
70648 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30