|
A program called Gdxviewer will move data from a GDX file and place it a number of places including an Access database. Gdxviewer was developed by Erwin Kalvelagen, at the GAMS Development Corporation and is distributed through http://www.gams.com/~erwin/interface/interface.html. It is now embedded in the IDE and accessed when one opens a GDX file.
When run, Gdxviewer organizes the symbols in a tree format on the left hand side of the screen. Simultaneously in the right hand pane, the data for the item selected are shown in tabular format. However, the display column headers are not very descriptive with names like dim1, dim2, etc. because the GDX file does not contain information on domains of parameters and other items. Once one selects an item in the left hand window one can right click on it with the mouse and choose among a number of export possibilities. Data for the selected object can be plotted or sent to a
| • | Text file: a plain ASCII file for inclusion into text editors and by programs you write. |
| • | CSV file: a comma separated value files. |
| • | Excel XLS file: a new XLS file ('new workbook') or to a new sheet in an existing spreadsheet. This option works only if Excel is available on your PC. |
| • | Excel Pivot table. An Excel pivot table within a workbook. This only works for parameters or variables/equations with 2 dimensions or more. This option works only if Excel is installed on your PC. |
| • | GAMS include file: for subsequent use through a $Include. |
| • | Access database. A new table will be generated. If the .MDB file does not exist already it will be created. This option works only if Access is installed on your PC. |
| • | HTML file: Data can be exported to HyperText Markup Language: the language of Web pages. Rutherford's GAMS2TBL can also write such files. |
| • | XML file: Data can be exported to XML a web related format to store data. |
For more details see the write-up at http://www.gams.com/~erwin/interface/interface.html. Also note one needs to watch out for file names and paths with spaces in them as discussed above.
|