Problem with translating a gdx file to a format .dat file (using gdx2dat comand

GAMS
1

Hi

i´m facing problem when import an excel spreadsheet to a “dat” format file using gdx2dat comand. The importation works well and the output file is a gdx file, but i wont it to be a dat file. My gams code is:

set
AC global set (SAM accounts and others items)
/accounts SAM list/
alias (AC, ACP)
sets
i nameinput /2003mozsam.xlsx/
parameter SAM (AC,ACP);
$call gdxxrw.exe 2003mozsam.xlsx par SAM rng=mtrx!A6:EK146 Rdim=1 Cdim=1
set AC rng=A7:A146
set ACP rng=B6:EK6
parameter gdx2dat 2003mozsam.gdx >2003mozsam.dat

it imports well but does’t change the gdx file format output into a dat format. Help m please.
i get the following results:


— Job dissertacão.gms Start 02/11/13 12:26:11 WEX-VS8 23.9.5 x86/MS Windows
GAMS Rev 239 Copyright (C) 1987-2012 GAMS Development. All rights reserved
Licensee: GAMS Development Corporation, Washington, DC G871201/0000CA-ANY
Free Demo, 202-342-0180, sales@gams.com, www.gams.com DC0000
— Starting compilation
— dissertacão.gms(148) 3 Mb
— call gdxxrw.exe 2003mozsam.xlsx par SAM rng=mtrx!A6:EK146 Rdim=1 Cdim=1

GDXXRW Jul 4, 2012 23.9.5 WIN 36376.36401 VS8 x86/MS Windows
Input file : C:\Users\Aspire4349\Documents\gamsdir\projdir\2003mozsam.xlsx
Output file: C:\Users\Aspire4349\Documents\gamsdir\projdir\2003mozsam.gdx
Total time = 967 Ms
— dissertacão.gms(151) 3 Mb
— Starting execution - empty program
*** Status: Normal completion
— Job dissertacão.gms Stop 02/11/13 12:26:12 elapsed 0:00:01.180

chees

Djemilo

–
To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+unsubscribe@googlegroups.com.
To post to this group, send email to gamsworld@googlegroups.com.
Visit this group at http://groups.google.com/group/gamsworld?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

\

2

Hi Djemilo



First, the utility is a command line utility. You should run it in a dos-window (or use a different call in your gams file):

Ø gdx2dat 2003mozsam.gdx >2003mozsam.dat

Secondly, even then the utility does not work (on my machine). The utility was developed in 2004. Gdxxrw utility was introduced in 2003 andI assume that the gdx files used then are not compatible anymore.

I tried using gdxcopy to change the format of my gdx file to an earlier version of gdx, but that also did not work (gdxcopy can produce gdx-formats back to version 5 of gdx).



You can however use the gdx viewer to export your parameters to a gams include file. Click on the parameter and choose export and the format you wish.


Cheers



Renger







Von: gamsworld@googlegroups.com [mailto:gamsworld@googlegroups.com] Im Auftrag von Djemilo Cardoso
Gesendet: Montag, 11. Februar 2013 16:05
An: gamsworld@googlegroups.com
Betreff: Problem with translating a gdx file to a format .dat file (using gdx2dat comand



Hi



i´m facing problem when import an excel spreadsheet to a “dat” format file using gdx2dat comand. The importation works well and the output file is a gdx file, but i wont it to be a dat file. My gams code is:



set

AC global set (SAM accounts and others items)

/accounts SAM list/

alias (AC, ACP)

sets

i nameinput /2003mozsam.xlsx/

parameter SAM (AC,ACP);

$call gdxxrw.exe 2003mozsam.xlsx par SAM rng=mtrx!A6:EK146 Rdim=1 Cdim=1

set AC rng=A7:A146

set ACP rng=B6:EK6

parameter gdx2dat 2003mozsam.gdx >2003mozsam.dat



it imports well but does’t change the gdx file format output into a dat format. Help m please.

i get the following results:





— Job dissertacão.gms Start 02/11/13 12:26:11 WEX-VS8 23.9.5 x86/MS Windows

GAMS Rev 239 Copyright (C) 1987-2012 GAMS Development. All rights reserved

Licensee: GAMS Development Corporation, Washington, DC G871201/0000CA-ANY

Free Demo, 202-342-0180, sales@gams.com, www.gams.com DC0000

— Starting compilation

— dissertacão.gms(148) 3 Mb

— call gdxxrw.exe 2003mozsam.xlsx par SAM rng=mtrx!A6:EK146 Rdim=1 Cdim=1



GDXXRW Jul 4, 2012 23.9.5 WIN 36376.36401 VS8 x86/MS Windows

Input file : C:\Users\Aspire4349\Documents\gamsdir\projdir\2003mozsam.xlsx

Output file: C:\Users\Aspire4349\Documents\gamsdir\projdir\2003mozsam.gdx

Total time = 967 Ms

— dissertacão.gms(151) 3 Mb

— Starting execution - empty program

*** Status: Normal completion

— Job dissertacão.gms Stop 02/11/13 12:26:12 elapsed 0:00:01.180



chees



Djemilo


\

To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+unsubscribe@googlegroups.com.
To post to this group, send email to gamsworld@googlegroups.com.
Visit this group at http://groups.google.com/group/gamsworld?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.


\

To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+unsubscribe@googlegroups.com.
To post to this group, send email to gamsworld@googlegroups.com.
Visit this group at http://groups.google.com/group/gamsworld?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

\