We build GUI’s in MS Access so the data and model front-end are all together. You can build some nice user input forms to change the data, set up queries to get responses, etc. Once the user does that, you can include a big ‘Go’ button which calls a DOS shell and launches GAMS. You can also do some post-processing to present the user with the results, again in an Access form.
Nice thing about Access is its an all in one tool for data storage, manipulation, and presentation. It has its limits (2gig data) so the size of the dataset should be considered.
Dewayne
From: gamsworld@googlegroups.com [mailto:gamsworld@googlegroups.com] On Behalf Of Ryan Cooper
Sent: Tuesday, February 14, 2012 10:05 AM
To: gamsworld@googlegroups.com
Subject: Re: GUI and GAMS
You can almost do it with any language. Java is good. I toyed with the idea of setting up a node based gui with arcs etc where you could set up demands, sources, constraints linking constraints… etc. I figured if you can draw it out it shouldn’t be too hard to have the gams source be written based on the picture.
On Tue, Feb 14, 2012 at 8:46 AM, Edson Cordeiro do Valle wrote:
Hello all
In my opinion the Java is an easy way to implement some GUI and interface with GAMS. Some time ago I did a command line java program to a customer to read and write data from oracle tables, it was pretty straightforward (there are an example in GAMS page, which actually have a small bug).
You can make a GUI layer that communicate with some table or databank ( or even write a text file) and trigger GAMS from Java.
Regards
2012/2/14 Dol, Wietse
Hi Frank/Shok
There are not many alternative. The free one would be GSE (http://www3.lei.wur.nl/gamstools ). Since then we did some other interfacing stuff, but building an interface depends on the quality and structure of your model. The simplest UI you can make is building a spread sheet and read your spread sheet data in your model. Another approach is that you use GDX files. A tool like DataExplorer (again form our gams tools) is the only GDX editor in the world, making it possible to let a user change GDX and then you can run you GAMS code, save all your output again as GDX and your user can use the DataExplorer again to show results (and even compare scenarios/gdx files).
Hope this helps,
Wietse
From: gamsworld@googlegroups.com [mailto:gamsworld@googlegroups.com] On Behalf Of Frank Ward
Sent: Monday, February 13, 2012 23:20
To: gamsworld@googlegroups.com
Cc: Frank Ward; Shahruh Jalilov (sjalilov@gmail.com); Saud A Amer (samer@usgs.gov)
Subject: GUI and GAMS
Hi GAMS friends.
Help! Does anybody know how to write a GUI interface that connects GAMS with outside data. We’d like an ordinary person to be able to change data that’s already connected to an existing GAMS model. The ordinary person shouldn’t have to know how to be a GAMS programmer. We hope to star with baby (newborn) steps by using the famous little GAMS transport model. We can later take big boy steps.
Thank for any help.
Best wishes,
Frank Ward (fward@nmsu.edu)
and
Shok Jalilov (sjalilov@nmsu.edu)
Frank A. Ward
Professor of Water Policy
College of Agricultural, Consumer and Environmental Sciences
New Mexico State University
Las Cruces, NM USA 88011
fward@nmsu.edu
To post to this group, send email to gamsworld@googlegroups.com.
To unsubscribe from this group, send email to gamsworld+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/gamsworld?hl=en.
Edson Valle
edsoncv@gmail.com
To post to this group, send email to gamsworld@googlegroups.com.
To unsubscribe from this group, send email to gamsworld+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/gamsworld?hl=en.
This e-mail transmission is strictly confidential. It is intended solely for the
addressee. If you are not the addressee, please delete the e-mail and notify us
by return email or by contacting our systems administrator on +44 131 243 4444
forthwith.
Moreover if you are not the addressee, you must not copy, use, act or rely on,
disclose or distribute this e-mail. Wood Mackenzie Limited accepts no
responsibility or liability for any harm to your, or any third party’s, system
or data caused by this e-mail or its attachments or any viruses or similar
contained in it.
Wood Mackenzie Limited may monitor and record e-mails and their content passing
through its network.
–
To post to this group, send email to gamsworld@googlegroups.com.
To unsubscribe from this group, send email to gamsworld+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/gamsworld?hl=en.