Problems opening GDXIN

GAMS
1

Hi,

I just started to learn how to use GDXXRW, however I encountered with
a problem that I couldn’t solve myself.

I am trying to import data from excel and wrote following code related
to this aim:

Parameters c1(l,j);

$CALL GDXXRW.EXE olacako.xls par=Level rng=sheet1!A1:D4

$GDXIN olacako.gdx
$LOAD Level=Level
$GDXIN

c1.FX(l,j) = Level(l,j);
display Level, c1.L;

solve sevkiyat using MIP minimizing z;

display z.l, xk.l, xa.l;

However GAMS gives the following error:
Error 510
Problems opening GDXIN:file error


I could not manage this myself, and any advice will be very helpful
for me.
Thanks.

Gülcan Yayla

\

2

Tamar,

I notice you send the entire model. With something like this you
would do well to break the problem down into smaller pieces. For
example, is the problem in the call of gdxxrw? Probably so, but you
can see for sure by looking at the content of the file olacako.gdx
(using the command-line utility gdxdump or better yet the GDX browser
in the GAMS IDE). If you know the problem is with the GDX file you
can ignore all the following steps for the moment and look at the
parameters to the GDXXRW call and the structure of your .xls file.
Also look at the messages from your GDXXRW run.

-Steve

On Tue, Sep 14, 2010 at 3:10 AM, tamar wrote:

Hi,

I just started to learn how to use GDXXRW, however I encountered with
a problem that I couldn’t solve myself.

I am trying to import data from excel and wrote following code related
to this aim:

Parameters c1(l,j);

$CALL GDXXRW.EXE olacako.xls par=Level rng=sheet1!A1:D4

$GDXIN olacako.gdx
$LOAD Level=Level
$GDXIN

c1.FX(l,j) = Level(l,j);
display Level, c1.L;

solve sevkiyat using MIP minimizing z;

display z.l, xk.l, xa.l;

However GAMS gives the following error:
Error 510
Problems opening GDXIN:file error

I could not manage this myself, and any advice will be very helpful
for me.
Thanks.

Gülcan Yayla

–
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.




– Steven Dirkse, Ph.D. GAMS Development Corp., Washington DC Voice: (202)342-0180 Fax: (202)342-0181 sdirkse@gams.com http://www.gams.com

3

In addition to the suggestion from Steven to remove everything other
than the parameter declartion and data read code, also try something
like:

$CALL GDXXRW.EXE olacako.xls log=olacako_gdxin.log trace=3 par=Level
rng=sheet1!A1:D4

This will produce a file called olacako_gdxin.log which may contain
some error messages which help trace the problem.


Also, delete your olacako.gdx file before running your code, just to
make sure it is being produced.


AndyC

On Sep 14, 8:10 pm, tamar wrote:

Hi,

I just started to learn how to use GDXXRW, however I encountered with
a problem that I couldn’t solve myself.

I am trying to import data from excel and wrote following code related
to this aim:

Parameters c1(l,j);

$CALL GDXXRW.EXE olacako.xls par=Level rng=sheet1!A1:D4

$GDXIN olacako.gdx
$LOAD Level=Level
$GDXIN

c1.FX(l,j) = Level(l,j);
display Level, c1.L;

solve sevkiyat using MIP minimizing z;

display z.l, xk.l, xa.l;

However GAMS gives the following error:
Error 510
Problems opening GDXIN:file error

I could not manage this myself, and any advice will be very helpful
for me.
Thanks.

Gülcan Yayla

\