Search found 50 matches

by Jarenka
1 month ago
Forum: Syntax
Topic: Structuring of Excel output-file in GAMS
Replies: 26
Views: 537

Re: Structuring of Excel output-file in GAMS

Thank you very much for your help!

Best
Jarenka
by Jarenka
1 month ago
Forum: Syntax
Topic: Structuring of Excel output-file in GAMS
Replies: 26
Views: 537

Re: Structuring of Excel output-file in GAMS

Yes, I have already used gdxdump for csv-files and then open them in Access database.

So you mean that txt-files are not a good option as an export file for GAMS, right?

Best,
Jarenka
by Jarenka
1 month ago
Forum: Syntax
Topic: Error: overflow in + operation (addop)
Replies: 3
Views: 145

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
1 month ago
Forum: Syntax
Topic: Structuring of Excel output-file in GAMS
Replies: 26
Views: 537

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
1 month ago
Forum: Syntax
Topic: Structuring of Excel output-file in GAMS
Replies: 26
Views: 537

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
1 month ago
Forum: Syntax
Topic: Structuring of Excel output-file in GAMS
Replies: 26
Views: 537

Re: Structuring of Excel output-file in GAMS

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

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
1 month ago
Forum: Syntax
Topic: Structuring of Excel output-file in GAMS
Replies: 26
Views: 537

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
1 month ago
Forum: Syntax
Topic: Structuring of Excel output-file in GAMS
Replies: 26
Views: 537

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
1 month ago
Forum: Syntax
Topic: Structuring of Excel output-file in GAMS
Replies: 26
Views: 537

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