Search found 58 matches

by Jarenka
6 months ago
Forum: Syntax
Topic: Error: overflow in + operation (addop)
Replies: 3
Views: 356

Re: Error: overflow in + operation (addop)

Hi, it seems that the result of the assignment statement is > 1E300 which causes an overflow. Are you sure that you need such large numbers. And are you sure that you found the right line in your code? With include files this can be tricky, so I suggest to check the line number in the echo print of...
by Jarenka
6 months ago
Forum: Syntax
Topic: Structuring of Excel output-file in GAMS
Replies: 26
Views: 1428

Re: Structuring of Excel output-file in GAMS

Hi,

I succeeded with Access database, finally. Over 15 mln. rows.
I have no experience in Access. Is it possible to do summations or PivotTable-kind of analysis?

Do you know also, whether there is a possibility to export directly to a txt-file from gdx-file or a csv-file?

Best
Jarenka
by Jarenka
6 months ago
Forum: Syntax
Topic: Structuring of Excel output-file in GAMS
Replies: 26
Views: 1428

Re: Structuring of Excel output-file in GAMS

I have found "Data Query" in Excel 2016, see attachment (it did not succeed).
It stopped at around 10,000,000 rows.

I will try with Access, and others.

Thank YOU FOR YOUR HELP !!!
by Jarenka
6 months ago
Forum: Syntax
Topic: Structuring of Excel output-file in GAMS
Replies: 26
Views: 1428

Re: Structuring of Excel output-file in GAMS

Everything would be perfect if I had PowerPivot :-)
by Jarenka
6 months ago
Forum: Syntax
Topic: Structuring of Excel output-file in GAMS
Replies: 26
Views: 1428

Re: Structuring of Excel output-file in GAMS

Yes. I corrected the code. There are no errors.
But the problems appears when I want to look at results.csv file. It shows only 1,048,576 rows (I increased dimensions in test-parameter) and no more.
by Jarenka
6 months ago
Forum: Syntax
Topic: Structuring of Excel output-file in GAMS
Replies: 26
Views: 1428

Re: Structuring of Excel output-file in GAMS

Hi Renger,

I tried your code first and seems I have a problem with gdx-file. See attachment:

Jarenka
by Jarenka
6 months ago
Forum: Syntax
Topic: Structuring of Excel output-file in GAMS
Replies: 26
Views: 1428

Re: Structuring of Excel output-file in GAMS

Hi Renger,

1,000,000 rows is not a problem. The problem with csv starts when I have over 1,048,576 rows.
Can you try to extend you test-parameter to have over 1,048,576 rows?

Jarenka
by Jarenka
6 months ago
Forum: Syntax
Topic: Structuring of Excel output-file in GAMS
Replies: 26
Views: 1428

Re: Structuring of Excel output-file in GAMS

Hi Renger,

Yes, it works with a few lines for CSV-format.
So if I understand it correctly, csv-format has also limited number of rows. Right?

Jarenka
by Jarenka
6 months ago
Forum: Syntax
Topic: Structuring of Excel output-file in GAMS
Replies: 26
Views: 1428

Re: Structuring of Excel output-file in GAMS

Hi again, I have tried to open a *csv file with following commend (trying with different option with delimiter): $call gdxdump csv_output.gdx output=Employment_qaeg.csv delim=comma symb=qaegT format=csv And I always receive an uncompleted csv-file with error - see attachment. Do I do something wrong...
by Jarenka
6 months ago
Forum: Syntax
Topic: Structuring of Excel output-file in GAMS
Replies: 26
Views: 1428

Re: Structuring of Excel output-file in GAMS

Thank you Renger,

Concerning *csv files. Does it work in GAMS Studio?